Howto Oracle 9i Connection Pooling with Sun One application Server 7

[Harish Tam]

Hello,

I am using jsdk1.4, Oracle 9i and sun One spplication Server 7. can any body here can tell me how to create connection pooling using the Sun One server, i have tried the following methods....
Placed the ojdbc14.jar in the lib of the domain1
Creating the Connection Pool with the
Datasource Classname: oracle.jdbc.pool.OracleDataSource
username:<something>
pasword:< somehting>
url:<some url>

Code to access the JDBC resource as follows...

InitialContext objInitialContext = new InitialContext();
DataSource datasource = (DataSource) objInitialContext.lookup(<jndi-name>;
Connection objConnection = datasource.getConnection();

Next I created the JDBC Resource using the above connection pool, but i am getting the following error message.........
java.lang.ClassCastException


I am not getting this right somehow, can anybody help me out with this....Please. Is there any other way to create connection pooling with SOAS7

Regards

[Bear Bibeault]

"Harish",

You have already been warned on previous occasions to change your display name to conform to JavaRanch standards.

This is not optional! Accounts with invalid display names are closed.

Take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

bear
Forum Bartender
[ December 15, 2005: Message edited by: Bear Bibeault ]