Postgresql and JBoss on linux

newone Jun 27, 2002 1:08 AM

Now Postgresql and JBoss both are running on Linux. How can I connect them?
Thanks a lot
Peter

1. Re: Postgresql and JBoss on linux

joelvogt Jun 27, 2002 1:11 AM (in response to newone)

Which version of jboss are you setting up?
Actions
2. Re: Postgresql and JBoss on linux

crozierm Jun 27, 2002 2:50 PM (in response to newone)

Look at the example file in JBOSSHOME/docs/examples/jca/postgres-service.xml

And read this post in the forums:

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ the example and the instructions in the forum, I was able to get it up and running fairly quickly.
Actions
3. Re: Postgresql and JBoss on linux

newone Jun 27, 2002 3:07 PM (in response to newone)

JBoss-2.4.6
Actions
4. Re: Postgresql and JBoss on linux

joelvogt Jun 27, 2002 8:28 PM (in response to newone)

If your using 2.4.6 then the jca stuff won't help you.
Typically to set up the datasource,

Set up a datasource in jboss.jcml. There should be a default DS that you can copy/paste with your postgress details filled in.

Make sure your jdbc driver is in jboss/lib/ext

Configure your jaws.xml to point at your datasource
http://www.jboss.org/online-manual/HTML/ch05.html

And then restart. The key lines of debug to look for are :

[INFO,JdbcProvider] Loaded JDBC-driver:<postgress driver>

And

[INFO,yourDS] XA Connection Pool yourDS bound to java:/yourDS

If you see these two guys, should be going pretty well. Let me know if you get stuck wih any steps.
Actions