Hi,
Report of PostgreSQL 6.5.2 test:
>>>
_____________________________________________
Welcome to the database test
_____________________________________________
Deploying the bean...done!
1- Looking up the home AllTypes...OK
2- Calling findByPrimaryKey on AllTypesHome with name seb...Object with primary key
seb not found in storage
not found OK
3- Calling create on AllTypesHome with name seb...
_____________________________________________
Sorry, test failed. Try again with different settings!
Thanks for your time...
>>>
>>>>jboss.conf
...
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,jdbc6.5-1.2.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="PostgreSQL">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
...
>>>>jboss.jcml
...
<mbean name="DefaultDomain:service=XADataSource,name=PostgreSQL">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:postgresql://192.168.10.18:3312/upsa</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">postgress</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">test</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
....
>>>>jaws.xml
...
<datasource>PostgreSQL</datasource>
<type-mapping>PostgreSQL</type-mapping>
...
>>>JBoss log
...
[Container factory] Deploying:file:/D:/temp/CVS/jbosstest/dist/bin/../deploy/dbtest.jar
[Container factory] Loading ejb-jar.xml :
jar:file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar18742.jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml :
jar:file:/D:/temp/CVS/jboss/dist/lib/ext/jboss.jar!/org/jboss/metadata/standardjboss.xml
[Verifier] Verifying file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar18742.jar
[Verifier] AllTypes: Verified.
[Verifier] Record: Verified.
[Container factory] Deploying AllTypes
[Container factory] Container Invoker Optimize='false'
[Container factory] Deploying Record
[Container factory] Container Invoker Optimize='false'
[JAWS] Initializing JAWS plugin for Record
[JAWS] Loading standardjaws.xml :
jar:file:/D:/temp/CVS/jboss/dist/lib/ext/jboss.jar!/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml
[JAWS]
jar:file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar18742.jar!/META-INF/jaws.xml
found. Overriding defaults
[JAWS] Table Record created
[JAWS] Initializing JAWS plugin for AllTypes
[JAWS] java.sql.SQLException: ERROR: Unable to locate type name 'bigint' in catalog
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:126)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:81)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:98)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:97)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:101)
[JAWS] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:191)
[JAWS] at org.jboss.ejb.Application.init(Application.java:158)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:635)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:227)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[JAWS] at org.jboss.jmx.server.JMXAdaptorImpl.invoke(JMXAdaptorImpl.java:69)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] Could not create table AllTypes: ERROR: Unable to locate type name 'bigint' in
catalog
[Container factory] Bound Record to Record
[Container factory] Bound AllTypes to AllTypes
[Container factory] Deployed application:
file:/D:/temp/CVS/jbosstest/dist/bin/../deploy/dbtest.jar
[AllTypes] EnterpriseContext.lock() 8345839 1
[AllTypes] TxCapsule.enlistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.startResource(XidImpl:junky/0) entered:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flags=0
[AllTypes] TxCapsule.startResource(XidImpl:junky/0) leaving:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flags=0
[AllTypes] TxCapsule.delistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.endResource(XidImpl:junky/0) entered:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flag=536870912
[AllTypes] TxCapsule.endResource(XidImpl:junky/0) leaving:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flag=536870912
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[AllTypes] EnterpriseContext.unlock() 8345839 0
[AllTypes] TxCapsule.rollback(): Entered, status=STATUS_MARKED_ROLLBACK
[AllTypes] EnterpriseContext.lock() 8345839 1
[AllTypes] TxCapsule.enlistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.startResource(XidImpl:junky/1) entered:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flags=0
[AllTypes] TxCapsule.startResource(XidImpl:junky/1) leaving:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flags=0
[AllTypes] TxCapsule.delistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.endResource(XidImpl:junky/1) entered:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flag=536870912
[AllTypes] TxCapsule.endResource(XidImpl:junky/1) leaving:
org.jboss.minerva.xa.XAResourceImpl@27dd39 flag=536870912
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:126)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:126)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] Unknown Types value.
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:492)
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:498)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.setObject(PreparedStatementInPool.java:281)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:310)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(JDBCCreateEntityCommand.java:165)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:153)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] Unknown Types value.
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:492)
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:498)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.setObject(PreparedStatementInPool.java:281)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:310)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(JDBCCreateEntityCommand.java:165)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:153)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[AllTypes] EnterpriseContext.unlock() 8345839 0
[AllTypes] TxCapsule.rollback(): Entered, status=STATUS_MARKED_ROLLBACK
...
I know PostgreSQL has problem with INTEGER. So I corrected jaws.xml :
short=INTEGER ->INT2
int=INTEGER->INT4
long=BIGINT->INT8
So, after this:
>>>>JBOSS log:
[Container factory] Deploying:file:/D:/temp/CVS/jbosstest/dist/bin/../deploy/dbtest.jar
[Container factory] Loading ejb-jar.xml :
jar:file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar51816.jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml :
jar:file:/D:/temp/CVS/jboss/dist/lib/ext/jboss.jar!/org/jboss/metadata/standardjboss.xml
[Verifier] Verifying file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar51816.jar
[Verifier] AllTypes: Verified.
[Verifier] Record: Verified.
[Container factory] Deploying AllTypes
[Container factory] Container Invoker Optimize='false'
[Container factory] Deploying Record
[Container factory] Container Invoker Optimize='false'
[JAWS] Initializing JAWS plugin for Record
[JAWS] Loading standardjaws.xml :
jar:file:/D:/temp/CVS/jboss/dist/lib/ext/jboss.jar!/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml
[JAWS]
jar:file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar51816.jar!/META-INF/jaws.xml
found. Overriding defaults
[JAWS] Table Record created
[JAWS] Initializing JAWS plugin for AllTypes
[JAWS] java.sql.SQLException: ERROR: Unable to locate type name 'blob' in catalog
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:126)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:81)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:98)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:97)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:101)
[JAWS] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:191)
[JAWS] at org.jboss.ejb.Application.init(Application.java:158)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:635)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:227)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[JAWS] at org.jboss.jmx.server.JMXAdaptorImpl.invoke(JMXAdaptorImpl.java:69)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] Could not create table AllTypes: ERROR: Unable to locate type name 'blob' in
catalog
[Container factory] Bound Record to Record
[Container factory] Bound AllTypes to AllTypes
[Container factory] Deployed application:
file:/D:/temp/CVS/jbosstest/dist/bin/../deploy/dbtest.jar
[AllTypes] EnterpriseContext.lock() 2940162 1
[AllTypes] TxCapsule.enlistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.startResource(XidImpl:junky/0) entered:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flags=0
[AllTypes] TxCapsule.startResource(XidImpl:junky/0) leaving:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flags=0
[AllTypes] TxCapsule.delistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.endResource(XidImpl:junky/0) entered:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flag=536870912
[AllTypes] TxCapsule.endResource(XidImpl:junky/0) leaving:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flag=536870912
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[AllTypes] EnterpriseContext.unlock() 2940162 0
[AllTypes] TxCapsule.rollback(): Entered, status=STATUS_MARKED_ROLLBACK
[AllTypes] EnterpriseContext.lock() 2940162 1
[AllTypes] TxCapsule.enlistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.startResource(XidImpl:junky/1) entered:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flags=0
[AllTypes] TxCapsule.startResource(XidImpl:junky/1) leaving:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flags=0
[AllTypes] TxCapsule.delistResource(): Entered, status=STATUS_ACTIVE
[AllTypes] TxCapsule.endResource(XidImpl:junky/1) entered:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flag=536870912
[AllTypes] TxCapsule.endResource(XidImpl:junky/1) leaving:
org.jboss.minerva.xa.XAResourceImpl@61dac2 flag=536870912
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:126)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] java.sql.SQLException: ERROR: alltypes: Table does not exist.
[JAWS]
[JAWS] at postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at postgresql.jdbc2.Statement.execute(Statement.java:270)
[JAWS] at postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
[JAWS] at postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:101)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:126)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] Unknown Types value.
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:492)
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:498)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.setObject(PreparedStatementInPool.java:281)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:310)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(JDBCCreateEntityCommand.java:165)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:153)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] Unknown Types value.
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:492)
[JAWS] at postgresql.jdbc2.PreparedStatement.setObject(PreparedStatement.java:498)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.setObject(PreparedStatementInPool.java:281)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:310)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(JDBCCreateEntityCommand.java:165)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:153)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:171)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:85)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:122)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[AllTypes] EnterpriseContext.unlock() 2940162 0
[AllTypes] TxCapsule.rollback(): Entered, status=STATUS_MARKED_ROLLBACK
....
Problem with BLOB as you see.
But seems to me more important PostgreSQL log
>>>>
ERROR: record: Table does not exist.
NOTICE: (transaction aborted): all queries ignored until end of transaction block
ERROR: alltypes: Table does not exist.
ERROR: Unable to locate type name 'blob' in catalog
ERROR: alltypes: Table does not exist.
ERROR: alltypes: Table does not exist.
>>>>
Table not created ;-(
thats all.
Any way JBoss great EJB-container (but fix it pleazzz ;-)))
Best regards,
Serhiy
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
