-
1. Re: Example for Jboss 3.0 + Postgres [on Linux]?
one_each Apr 2, 2002 9:09 PM (in response to thomas02)Here is what I have done to get JBoss and PostgreSQL to work together.
In jboss.jcml, make sure you have added the driver 'org.postgresql.Driver' to the JdbcProvider mbean and that the PostgreSQL jdbc driver is in the classpath when jboss starts.
For the database I want to access, I cut-and-paste one of the XADataSourceLoader beans and modify:
DefaultDS
jdbc: postgresql://localhost:5432/jboss
jboss
jboss
(NOTE: There is no space after jdbc: in the URL, but if I don't put one there in this forum, you will see :p instead)
I've left out some of the attributes you will need to keep and only listed those I change. The name attribute of the mbean tag needs a new name. The pool name needs a new name. URL needs to be changed. User and password need to be set, even if you don't use passwords, it won't work if you leave this out or leave it blank (I.E. put something in there!)
There was a change I made to the standardjaws.xml file to make boolean values work as well.
<java-type>java.lang.Boolean</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>BOOL</sql-type>
This worked for me, but YMMV. -
2. Re: Example for Jboss 3.0 + Postgres [on Linux]?
thomas02 Apr 3, 2002 4:46 PM (in response to thomas02)Thanks! I got things working a few hours after posting that, but it's nice to have confirmation of what to pay attention to.
I have a working "Person" entity bean now and am adding new finder methods and features to it to help me learn more about its use. I'll be posting the whole example with notes here soon.
I guess I'm assuming I'm not the only one who had troubles building and understanding the supplied examples, primarily because of the undocumented difficulties with DB integration. It's the little things that trip me up, like not setting my commit options to B or C and then wondering where my data went.