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

From: juleni(at)livetrade(dot)cz
To: pgsql-general(at)postgresql(dot)org
Subject: offtopic: Problem initialize postgres DataSource for WebSphere App. Server 6
Date: 2005-02-18 15:12:27
Message-ID: 122233797765.20050218161227@livetrade.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-02-18 15:24:57 Re: I'm newbie
Previous Message Mohsen Pahlevanzadeh 2005-02-18 15:06:27 I'm newbie