-
1. Re: interfacing JBoss with postgres
beyarecords Nov 26, 2004 8:59 AM (in response to puneetkapahi)what version of jboss are you using?
Andrew -
2. Re: interfacing JBoss with postgres
puneetkapahi Nov 28, 2004 11:33 PM (in response to puneetkapahi)I am using JBoss 3.2.5 and PostgreSQL 7.4.5.
-
3. Re: interfacing JBoss with postgres
kalyan120 Nov 29, 2004 10:29 AM (in response to puneetkapahi)Look at this thread
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=31894
Thanks,
Kalyan. -
4. Re: interfacing JBoss with postgres
puneetkapahi Nov 30, 2004 1:36 AM (in response to puneetkapahi)Hi,
I made the changes in jboss.xml and ejb-jar.xml accordinglyBut I forgot to mention that I was getting :
ObjectName: jboss.mq:service= StateManager state: NOTYETINSTALLED
Also when I start run.sh I get messages on my postgres console(on a remote system).
It tries to create tables jms_messages and jms_transaction ....but if I try to restart the server it gives:
relation "jms_messages"already exists
current transaction is aborted,command ignored until end of transaction block
which is understandable though because of the
CREATE_TABLES_ON_STARTUP = TRUE
in postgres-jdbc2-service.xml in deploy/jms.I have set it to false .no communication seems to happen thereafter.
Please give some steps on how to go about this.
I have made the following changes already:
1) standardjbosscmp-jdbc.xml and standardjaws.xml
<jbosscmp-jdbc>
jdbc/Acws
<datasource-mapping>PostgreSQL 7.4.5</datasource-mapping>
<create-table>true</create-table>
</jbosscmp-jdbc>
jdbc/Acws
<type-mapping>PostgreSQL 7.4.5</type-mapping>
<create-table>true</create-table>
.
.
. .
.
2)postgres-ds.xml
<local-tx-datasource>
<jndi-name>jdbc/Acws</jndi-name>
<connection-url>jdbc:postgresql://172.19.16.135:5432/ACWS</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
satyam
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
</local-tx-datasource>
and...
3) the following entry in login-config.xml
<application-policy name = "PostgreSQLDbRealm">
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">postgres</module-option>
<module-option name = "userName">postgres</module-option>
<module-option name = "password"></module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=java:/jdbc/Acws</module-option>
</login-module>
</application-policy>
Please reply...