Hello Friends :);
I have already give the solution for thin driver in my privious thread this time I am giving total solution for both type of driver thin and thick(oci). so try it and let me know ur reply.
I am using following:-
Operating system - Windows XP SP-2
Databse - Oracle 9i (version-9.0.1.0.0)
JVM version - 1.6 (It will work in 1.4 and higher Version too)
It Required 3 jar files
1.ojdbc14.jar(U can find this from oracle official site)
2.classes12.jar & classes111.jar file from ur oracle installation directory
Remember dont use classes12.zip & classes111.zip.
Example:- C:\ORACLE-9i\jdbc\lib[COLOR=Black]classes12.jar
[/color]
* 1. copy ojdbc14.jar file for thin driver, into
C:\Program Files\webMethods61\IntegrationServer\lib\jars\ojdbc14.jar
* 2. copy classes12.jar & classes111.jar file for thick(oci) driver, into(same path like step 1)
C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.jar
C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes111.jar
The path will be same for these three jar files
* 3. 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 (Give once bcoz they are in same location/path).
NOTE :- Restart ur system or atleast ur IS.
* 4. In wM dev ariea always create new package and new folder , it will reduce complexcity.
Than set following details -----------------fill this all with extra care(Dont leave any blank space before or after the name)
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 made by u in oracle)
portNumber _____________1521(not 1433 and 2030)
networkProtocol _________tcp (dont use TCP/IP or FTP or in CAPITAL latters)
Other Properties _________driverType=thin (or oci dont write in Capital latters)
Connection Management Properties:-
Enable Connection Pooling __true
Minimum Pool Size ________0 (or 1, “0 is batter”)
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10
[COLOR=Purple]And last if u r facing any problem in JDBC connection with oracle 9i, let me know that, i will solve ur problem as per my level. [/color]
[SIZE=3]Thanx To
Mr.Vijay & Mr.Gupta Sir
And Dear Ajeet.
[/size]