offtopic: Problem initialize postgres DataSource for WebSphere App. Server 6

Started by Nonameabout 21 years ago1 messagesgeneral
Jump to latest
#1Noname
juleni@livetrade.cz

Hello,

I have problem to configure postgers datasource for
WebSphere Application Server 6 (WAS6) from admin console.

1.) I have configured new JDBC Provider for PostgreSQL as
following:

Name: Postgres JDBC Provider
Class path: ${UNIVERSAL_JDBC_DRIVER_PATH}/postgresql.jar
Implementation class name: org.postgresql.jdbc2.optional.BaseDataSource

2.) Then I created new 'Data sources (Version 4)' as following:

Name: DS4Test
JNDI name: jndi/DS4Test
Database name: myDB
Default user ID: myUser
Default password: myPasswd

After saving all changes I have try to test connection to the
database by clicking on button 'Test connection', but following
exception occured:

Test connection failed for data source DS4Test on server server1 at node athlonxpNode01
with the following exception: java.lang.Exception: java.lang.InstantiationException

When I have try to change 'Implementation class name' property in
the 'JDBC Provider' definition page to:

a) org.postgresql.jdbc2.optional.SimpleDataSource
b) org.postgresql.jdbc2.optional.PoolingDataSource
c) org.postgresql.jdbc3.Jdbc3SimpleDataSource

There was following error occured (the same for each one):

Test connection failed for data source DS4Test on server server1 at node athlonxpNode01
with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be
used as one-phase: ClassCastException: org.postgresql.jdbc3.Jdbc3SimpleDataSource,
error code: NOT_A_1_PHASE_DS.

If anybody know, how to configure WAS6 for PostgreSQL 8 database,
please let mi know.

Thank you in advance,
with best regards,

Julian Legeny