Hi,
I am using XA datasource and trying to connect to Postgresql database over SSL. Application server being used is Jboss eap 4.3. I am getting error like:
Caused by: org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: org.postgresql.xa.PGXADataSource.setSsl(java.lang.String))
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:284)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:136)
... 84 more
Caused by: java.lang.NoSuchMethodException: org.postgresql.xa.PGXADataSource.setSsl(java.lang.String)
at java.lang.Class.getMethod(Class.java:1581)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:254)
... 85 more
2008-08-18 16:27:17,091 WARN [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: org.postgresql.xa.PGXADataSource.setSsl(java.lang.String))); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: org.postgresql.xa.PGXADataSource.setSsl(java.lang.String))))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
Details of postgresql:
Version: 8.2
jdbc jar used: postgresql-8.2-506.jdbc3
I have configured the certificates on database server side and have made necessary changes in postgresql.conf and pg_hba.conf. Server was restarted after making changes. Server certs were imported in client keystore and application server pointed to use this keystore on startup.
Below is the content of datasource file used:
<xa-datasource>
<jndi-name>Res1</jndi-name>
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">148.147.162.57</xa-datasource-property>
<xa-datasource-property name="PortNumber">5432</xa-datasource-property>
<xa-datasource-property name="DatabaseName">postgres</xa-datasource-property>
<xa-datasource-property name="Ssl">true</xa-datasource-property>
<xa-datasource-property name="User">postgres</xa-datasource-property>
<xa-datasource-property name="Password">postgres</xa-datasource-property>
<track-connection-by-tx/>
</xa-datasource>
Kindly help.
Regards,
Anand.