Hi,
I am receiveing the following error message when starting Jboss 4.0.2, under Windows XP (Service Pack 2) in regards to making an SSL connection to my postgreSQL 8.x database:
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Under the exact same solution I have running under OS X I have created an untrusted certificate which resides in my java cacerts store and I have both a certificate and a key place in the data directory of my postgresql database. In my Jboss deploy directroy I have defined my postgres-ds.xml document as follows:
<datasources>
<local-tx-datasource>
<jndi-name>PostgresDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/myDatabase?ssl=true</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>x</user-name>
<password>y</password>
<max-pool-size>10</max-pool-size>
<metadata>
<type-mapping>PostgreSQL 7.2</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
I am able to start the postgresql service with SSL and can connect to it from other clients. What am I not doing correctly for this windows XP setup?
regards
beya