I have problem to connect JBoss 3.2 to PostgreSQL 7.4 I have configured default ds in jbosscmp-jdbc.xml file
<jbosscmp-jdbc> java:/DefaultDS <datasource-mapping>DefaultDS</datasource-mapping> <create-table>true</create-table> <remove-table>false</remove-table> <read-only>false</read-only> <read-time-out>300000</read-time-out> <row-locking>false</row-locking> <pk-constraint>true</pk-constraint> <fk-constraint>true</fk-constraint> <preferred-relation-mapping>foreign-key</preferred-relation-mapping> and replaced the hyper-ds.xml file for the postgres-ds.xml: <local-tx-datasource> <jndi-name>DefaultDS</jndi-name> <connection-url>jdbc:postgresql://localhost:5432/MyDataBase</connection-url> <driver-class>org.postgresql.Driver</driver-class> <user-name>user</user-name> pass <check-valid-connection-sql>SELECT * FROM contacts</check-valid-connection-sql> </local-tx-datasource> Below is the output from logs and this is from database's logs: syntax error near "CACHED" "jms_messages" does not exist 2004-05-31 01:20:44,703 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=DefaultDS | 2004-05-31 01:20:45,114 ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed | org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.postgresql.util.PSQLException: ERROR: relation "jms_messages" does not exist | ) | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:336) | at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1356) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy6.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) | at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy5.deploy(Unknown Source) | at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384) | at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291) | at org.jboss.Main.boot(Main.java:150) | at org.jboss.Main$1.run(Main.java:395) | at java.lang.Thread.run(Thread.java:534) | Caused by: org.postgresql.util.PSQLException: ERROR: relation "jms_messages" does not exist | | at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) | at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) | at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) | at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) | at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) | at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321) | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:309) | ... 68 more | 2004-05-31 01:20:45,124 WARN [org.jboss.system.ServiceController] Problem starting service jboss.mq:service=PersistenceManager | org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.postgresql.util.PSQLException: ERROR: relation "jms_messages" does not exist | ) | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:336) | at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1356) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy6.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) | at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy5.deploy(Unknown Source) | at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384) | at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291) | at org.jboss.Main.boot(Main.java:150) | at org.jboss.Main$1.run(Main.java:395) | at java.lang.Thread.run(Thread.java:534) | Caused by: org.postgresql.util.PSQLException: ERROR: relation "jms_messages" does not exist | | at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) | at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) | at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) | at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) | at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) | at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321) | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:309) | ... 68 more | <jbosscmp-jdbc> | | <defaults> | <datasource>java:/DefaultDS</datasource> | <datasource-mapping>DefaultDS</datasource-mapping> | | <create-table>true</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | <read-time-out>300000</read-time-out> | <row-locking>false</row-locking> | <pk-constraint>true</pk-constraint> | <fk-constraint>false</fk-constraint> | <preferred-relation-mapping>foreign-key</preferred-relation-mapping> View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836909#3836909 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836909 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user