Configurações jboss firebird

1 resposta
L

alguem tem um exemplo de um arquivo Data Source com a configuração do jboss com o firebird, pois estou tendo o seguinte problema coando tento criar um entity:

08:48:35,772 INFO  [JkMain] Jk running ID=0 time=0/40  config=null

08:48:53,688 ERROR [Category] Could not create entity

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, char 57

SELECT

at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:88)

at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:34)

at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:701)

at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:232)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:381)

at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:208)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.prepareStatement(JDBCAbstractCreateCommand.java:323)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:276)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:562)

at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:203)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)

at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:725)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1061)

at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)

at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:204)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)

at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)

at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)

at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)

at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)

at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)

at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)

at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:128)

at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:94)

at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)

at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)

at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:478)

at org.jboss.ejb.Container.invoke(Container.java:743)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)

at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)

at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)

at sun.rmi.transport.Transport$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at sun.rmi.transport.Transport.serviceCall(Unknown Source)

at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)

at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

at

org.firebirdsql.gds.GDSException: Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, char 57

SELECT

at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1816)

at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1769)

at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare(GDS_Impl.java:1267)

at org.firebirdsql.jca.FBManagedConnection.prepareSQL(FBManagedConnection.java:773)


Estou achando que pode ser o datasource, mas se alguem souber o que realmente é, fico agradecido por algum esclarecimento.

1 Resposta

lsouzabr

Sei que é meio tarde, mas aí vai:

<?xml version="1.0" encoding="UTF-8"?> jlabDatasource false jdbc:firebirdsql://192.168.0.1:3050//opt/firebird/database/banco.fdb org.firebirdsql.jdbc.FBDriver SYSDBA masterkey
Criado 30 de dezembro de 2004
Ultima resposta 19 de ago. de 2013
Respostas 1
Participantes 2