| Author |
Message
|
| venky |
 Posted: Thu Jul 20, 2006 1:24 pm Post subject: JDBC Adapter - Oracle JDBC DriverPath & DriverLib |
 |
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Hi All,
Iam trying to configure the JDBC ODA to connect to Oracle 10G. I have the following questions:
DriverPath: Where Can I download the oracle 10G JDBC driver library ?
DriverLib: Where can I get the Native library used by the JDBC driver ? the .dll file ?
Thanks in advance. |
|
| Back to top |
|
 |
| dunesand |
| Posted: Fri Jul 21, 2006 7:15 am Post subject: |
|
|
Acolyte
Joined: 17 Nov 2003
Posts: 65
Location: Cambridgeshire, UK
|
first download the drive from oracle's website, all you need is the .jar file.
now you need to reference the jar file from the ODA's batch file in the DRIVERPATH batch variable.
when you run the ODA and create an object, make sure the ODA BO wizard references the driver and URL correctly.
remember to add reference to the batch file that is run for each JDBC connector accessing the Oracle database.
any probs let me know. |
|
| Back to top |
|
|
| venky |
| Posted: Fri Jul 21, 2006 4:26 pm Post subject: |
|
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Dunesand, Thanks for your response.
DRIVERPATH: I downloaded file(Says ojdbc14.jar) file from the Oracle website, but it is actually a Zip file. Will this work ? this does not have a jar file inside.
DRIVERLIB: for the ODA, I know that we need a .dll file, do you know where I can get this ?
Thanks. |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Jul 26, 2006 1:01 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
You can put .zip files also in the CLASSPATH and not just jars.
For example, db2java.zip for the DB2. |
|
| Back to top |
|
|
| shafi |
| Posted: Wed Aug 09, 2006 2:19 am Post subject: JDBCDriverClass - db2? |
|
|
Apprentice
Joined: 19 Mar 2006
Posts: 38
|
Vennela,
what's the appropriate value for the property - JDBCDriverClass that should be given in the config file of JDBC adapter for DB2>?
tHANKS 4 DA SAME!
Regards,
Shafi. |
|
| Back to top |
|
|
| djeripo |
| Posted: Wed Aug 23, 2006 9:24 am Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
Since you are using Oracle,
value for the property - JDBCDriverClass that should be oracle.jdbc.driver.OracleDriver
In your start_jdbc script,JDBCDRIVERPATH should look something like this
| Quote: |
| JDBCDRIVERPATH=/oracle/sftw/9.2.0/jdbc/lib/classes12.zip |
|
|
| Back to top |
|
|
|
|
