Configuring a JDBC Connection to oracle

Hi,

I was trying to make a JDBC connection to Oracle.The following is error is thrown when I try to enable it.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource OmSaiRam.adapterConnections:testing.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.200] The JDBC DataSource class "oracle.jdbc.pool.OracleDataSource " cannot be located.oracle.jdbc.pool.OracleDataSource

I have included the a)classes12.zip b)ojdbc14.jar in the IS\lib\jars c)I have j2sdk1.4.2_05 and have set the environment variables.

The following are the details I have entered
serverName :systest
user* :scott
databaseName : ORCL
portNumber : 2030 ( This was the port it showed when I was installing oracle)
networkProtocol :tcp

Please let me know if anything else is needed.

Hi Teja,

      Am just giving you the brief description about setting up Oracle Connection.
      Please have a look at this and follow this : 

I just configured for Oracle Thin Driver.

i) Select the package Name , folder name and give the Connection Name.
ii) Select Transaction Type as No_TRANSACTION or LOCAL_TRANSACTION
iii) Give the DataSource Class as : oracle.jdbc.pool.OracleDataSource
iv) serverName : localhost (give your host)
v) user : scott
vi) password : tiger
vii) databaseName : ORCL(The SID value which you had given while installing ORACLE)
viii) portNumber : 1521 (which is default for ORACLE)
ix) networkProtocol : tcp
x) Other Properties : driverType = thin

 And then Click Save Connection button.

 You will get the Error which you mentioned and to get rid of this,make sure that     
 you copy classes12.jar into the IS\lib\jars folder and restart the server.
 Then definitely you would be able to configure the connection.

Further any issues please post here.

Thanks & Regards,
Sudheer Martha.

If you are using jvm 1.4 or great, use ojdbc14.jar instead of classes12.zip.
ojdbc14.jar — here 14 refers to the jvm version 1.4
same as classes12.zip ---- 12 refers to jvm version 1.2