JDBC connection with Oracle 9i

, ,
1

:mad:
I am using following
Operating system - Windows XP SP-2
Databse - Oracle 9i (version-9.0.1.0.0)
JVM version - 1.4
driverType -thin

extra:- I have already copied ojdbc14.jar file into
1. C:\Program Files\webMethods61\IntegrationServer\lib\jars\ojdbc14.jar
2. C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.zip

MYJDBC:MYCON Details
Connection _____________JDBC Adapter Connection
Package________________NEWORACLE

Connection Properties
Transaction Type ________NO_TRANSACTION
DataSource Class ________oracle.jdbc.pool.OracleConnectionPoolDataSource
serverName _____________localhost5555
user ___________________system
password _______________******
databaseName __________WMDB
portNumber _____________1433
networkProtocol _________tcp
Other Properties _________driverType=thin

Connection Management Properties
Enable Connection Pooling __true
Minimum Pool Size ________1
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10

And last whwn i goes to enable the connection than i find following error

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MYJDBC:MYCON.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.Io exception: The Network Adapter could not establish the connection

Plz help me out from this problem plz …thanx :uhoh:

2

Have you reviewed the wM JDBC Adapter documentation? If not, please do so. If so, is there a specific step/issue on which you are stuck?

3

can u tell me how can i find out “classes12.zip” file.
thanx :confused:

4

The classes12.zip file is available from Oracle. It is intended for use with 1.2 JVMs. If you’re using a 1.4 JVM, then you should use ojdbc14.jar file instead. [URL=“http://forum.java.sun.com/thread.jspa?threadID=688414&messageID=4004973”]http://forum.java.sun.com/thread.jspa?threadID=688414&messageID=4004973[/URL]

5

THANX REAMON -
CAN ANY ONE PROVIDE ME “OJDBC14.JAR” FILE OR ANY LINK RELATED TO THIS. :eek:

6

:slight_smile: Finally i have solved my problem thanx to Rob(Emon) and other persion who helped me directaly or indirectaly.:p:

7

Hi Harish,

BTW,what was the resolution is it placing of the ojdbc14.jar file??…It would be great if you can share the resolution here!! It will help everyone incase they go thru the same issue.

HTH,
RMG

8

:happy: I have solved conn problem .Here is my solution For u people enjoy it. :wink:

I am using following
Operating system - Windows XP SP-2
Databse - Oracle 9i (version-9.0.1.0.0)
JVM version - 1.4
driverType -thin

* copy ojdbc14.jar and classes12.zip(unzip it and place) file into
1. C:\Program Files\webMethods61\IntegrationServer\lib\jars\ojdbc14.jar
2. C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.zip

*set envoirment variable in computer- property’s- advanced tab
in system variabel areia’s variables column select path(double click) and past the acuurate path of both above files.

NOTE :- Restart ur system

than set following details -----------------fill this with extra care

MYJDBC:MYCON Details:-

Connection _____________JDBC Adapter Connection
Package________________NEWORACLE (ur pakage name)

Connection Properties
Transaction Type ________NO_TRANSACTION
(or LOCAL_TRANSACTION)
DataSource Class ________oracle.jdbc.pool.OracleConnectionPoolDataSource
(or oracle.jdbc.pool.OracleDataSource) choose any one
serverName _____________localhost (or UR IP ADDRE like 192.168.1.100)
user ___________________system(oracle DB user)
password _______________****** (DB user releted Password)
databaseName __________WMDB(DB which madeby u in oracle)
portNumber _____________1521(not 1433 and 2030)
networkProtocol _________tcp (dont use TCP/IP or FTP)
Other Properties _________driverType=thin(dont use OCI am working on OCI now, tell u latter)

Connection Management Properties:-

Enable Connection Pooling __true
Minimum Pool Size ________1
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10

9

Its better always to set this setting as Minimum Pool Size ________0

This setting will help when the backend db is down and came back later due to problems/maintenance window.so that there will no connection pool issues on the JDBCAdapter connectivity side when AS uses it.

There are some pros/discussions held about on this setting, you can search it in the forum for more information.

Thanks to harish for putting this thread with your resolution and referring this thread!!!

HTH,
RMG

10

Hello Friends;

Go to this link u will find more to do with ur JDBC driver:-

[B][url]wmusers.com