-
-
-
-
-
-
-
-
-
-
-
-
-
13. Re: JBoss plus PostgreSQL
pai_deepak Jan 23, 2002 4:41 PM (in response to pavel_c)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 -
14. Re: JBoss plus PostgreSQL
niko Jan 27, 2002 4:01 PM (in response to pavel_c)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