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
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 |