[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: [JBoss 4.2.2GA]Problem with PostgreSQL as DefaultDS
What does your datasource file look like? And also which jars did you copy to the server/ serverName/lib folder? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4160859#4160859 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4160859 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: [JBoss 4.2.2GA]Problem with PostgreSQL as DefaultDS
jaikiran wrote : What does your datasource file look like? And also which jars did you copy to the server/ serverName/lib folder? | My postgres-ds.xml looks: | ?xml version=1.0 encoding=UTF-8? | | !-- Datasource config for Postgres -- | | datasources | local-tx-datasource | jndi-nameDefaultDS/jndi-name | connection-urljdbc:postgresql://[servername]:[port]/[database name]/connection-url | driver-classorg.postgresql.Driver/driver-class | user-namejboss/user-name | passwordjboss/password | !-- sql to call when connection is created. Can be anything, select 1 is valid for PostgreSQL | new-connection-sqlselect 1/new-connection-sql | -- | | !-- sql to call on an existing pooled connection when it is obtained from pool. Can be anything, select 1 is valid for PostgreSQL | check-valid-connection-sqlselect 1/check-valid-connection-sql | -- | | !-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -- | metadata | type-mappingPostgreSQL 8.0/type-mapping | /metadata | /local-tx-datasource | | /datasources | I copied postgresql-8.1-412.jdbc3.jar into lib directory (I'm using PostgreSQL 8.1.11 on Solaris10) A DB connection with psql client works fine View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4160866#4160866 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4160866 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: [JBoss 4.2.2GA]Problem with PostgreSQL as DefaultDS
connection-urljdbc:postgresql://[servername]:[port]/[database name]/connection-url This is incorrect. You have replace the servername, port, database with the actual values corresponding to your database server. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4160869#4160869 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4160869 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: [JBoss 4.2.2GA]Problem with PostgreSQL as DefaultDS
jaikiran wrote : connection-urljdbc:postgresql://[servername]:[port]/[database name]/connection-url | | This is incorrect. You have replace the servername, port, database with the actual values corresponding to your database server. I'm so silly... OK, the connection is working but I'm still getting ERRORS: | WARN [ServiceController] Problem starting service jboss.mq:service | =PersistenceManager | org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Messag | e recovery may not be accurate; - nested throwable: (org.postgresql.util.PSQLExc | eption: ERROR: syntax error at or near TXID) | OK, probably I've to remove hsqldb-jdbc2-service.xml and hsqldb-jdbc2-service.xml from deploy/jms but what shall I put instead of them ? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4160882#4160882 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4160882 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: [JBoss 4.2.2GA]Problem with PostgreSQL as DefaultDS
OK, now everything is working In deploy/jms I had only: - rename hsqldb-jdbc-state-service.xml into jbossmq-destinations-service.xml - copy postgres-jdbc2-service.xml form $JBOSS_HOME/docs/examples/jms into deploy/jms and lightly adapt it. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4160893#4160893 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4160893 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user