JBoss plus PostgreSQL

[pavel_c]

Hi,

I tried to follow the available docs [online manual mainly] on how to add a new data source to JBoss, but apparently I'm just plain stupid. Is there any step-by-step document on how to use PostgreSQL with JBoss?

Thanks,
Pavel

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[gbarrett]

[pai_deepak]

Check this document out. This gave me a fiar idea on how to do it.

http://main.jboss.org/thread.jsp?forum=52&thread=1493&message=112718&q=cygwin+ipc-daemon#112718

[niko]

Hi,

i'm using JBoss 2.4.4 (together with Tomcat 4.0.1) on Sun's JDK 1.3.0 (on Linux 2.4.7) and tried to configure PostgreSQL 7.0 as a datasource entry like you proposed. If i use jboss.jcml and standardjaws.xml you posted the startup just hangs for me :( Than i set the debug property to true and it seems like the PostgreSQL driver class cannot instantiate a new connection object.

[INFO,PostgresDS] Starting
[INFO,PostgresDS] XA Connection pool PostgresDS bound to java:/PostgresDS
[INFO,PostgresDS] The password property is missing. It is mandatory.
[INFO,PostgresDS] at org.postgresql.Connection.openConnection(Connection.java:104)
[INFO,PostgresDS] at org.postgresql.Driver.connect(Driver.java:116)
[INFO,PostgresDS] at java.sql.DriverManager.getConnection(DriverManager.java:517)
[INFO,PostgresDS] at java.sql.DriverManager.getConnection(DriverManager.java:177)
[INFO,PostgresDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Source)
...

--
added in jboss.jcml (beside the addition of the driver class):


PostgresDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

password=sa

jdbc:postgresql:jboss
1200000
sa
10
sa
false
false
false
true
120000
1800000
false
true
1.0
0


Note: The user "sa" was created via "createuser sa" and has no specific password, not needed if access from localhost as the PostgreSQL default access setting told me. The database was created with "createdb jboss". Do i have to change the any of the default PostgreSQL configuration files?

--
modified lines in standardjaws.xml:

java:/PostgresDS
<type-mapping>PostgreSQL</type-mapping>
--

Thanks for help in advance.
Greetings,
Niko