Ads (what is this?)

Ads (what is this?)

#1 2008-05-13 10:47:56

suzchr
Member
Registered: 2008-04-30
Posts: 142

Oracle - classe12.zip

I need to extract data from Oracle 8.0.5.
So the driver classe12.zip offered by Oracle is necessary. How I can integrate it in TOS 2.3.3 to use it when I want to extract my data ?

Thx

Offline

#2 2008-05-14 09:56:54

shong
Talend team
Registered: 2007-08-29
Posts: 5148
Website

Re: Oracle - classe12.zip

Hello

1)Go to \plugins\org.talend.designer.components.localprovider_2.4.0.RC1_r13964\components\tOracleInput under install folder and instead of ojdbc5.jar with classe12.zip, you need to rename classe12.zip as ojdbc5.jar.

2)Using the tLibraryLoad to load the jar file, then using the tJDBCInput to connecte to database.

Best regards

        shong


Choose Talend, Enjoy Talend!
Talend-->Data Integration Solution!

Offline

#3 2008-05-14 11:04:23

suzchr
Member
Registered: 2008-04-30
Posts: 142

Re: Oracle - classe12.zip

Thanks !
I just replace all the ojdbc4.jar by classe12.zip rename.
It's ok.
Thanks for your help.

Offline

#4 2008-05-26 16:19:51

jmbourguignon
New member
Registered: 2008-05-26
Posts: 3

Re: Oracle - classe12.zip

I doesn't work for me.

I've got a similar problem with Oracle 7.3.4, until ojdbc14.jar is replaced by classes12.zip .

When I check my parameters, TOS (2.3.3) returns : Connection failure. You must change the Database Settings.  Exception d'E/S: The Network Adapter could not establish the connection.

My parameters are OK because I use them with Toad.

Can anyone help me ?

Offline

#5 2008-05-26 17:22:39

suzchr
Member
Registered: 2008-04-30
Posts: 142

Re: Oracle - classe12.zip

What dou you want by ojdbc14.jar is replaced by classes12.zip ?
In fact, you rename classe12.zip to ojdbc14.jar and you paste it in the folder which contains ojdbc14.jar in the Talend folder. Ojdbc14.jar is 3 times in Talend folder. Use the search fonction of your OS.

If you need more precisions ask me.

Offline

#6 2008-05-26 18:39:21

jmbourguignon
New member
Registered: 2008-05-26
Posts: 3

Re: Oracle - classe12.zip

Thank's for your response.
Yes, I've already saved ojdbc14.jar and renamed classes12.zip (in ojdbc14.jar) into the 3 locations, and used tLibraryLoad.

Error message is always the same.

Offline

#7 2008-05-26 18:51:07

mhirt
Talend team
Registered: 2006-09-19
Posts: 1199

Re: Oracle - classe12.zip

I think that Oracle 7.3.4 can not be accessed by JDBC, even with classes12
JDBC was added by Oracle with version 8.1.7 (http://www.oracle.com/technology/softwa … index.html)

You have to use ODBC.

Regards,

Offline

#8 2008-05-27 11:19:24

jmbourguignon
New member
Registered: 2008-05-26
Posts: 3

Re: Oracle - classe12.zip

I know that Sunopsis can be connected to an Oracle 7.3.4 database using classes12, so I think it should be OK with TOS too. But I've finally installed an Oracle 8 version on my computer and created a dblink on the Oracle 7 database => It's OK like this, for testing TOS in a first time.

Thank's for your support.

Offline

#9 2008-05-28 00:26:37

mhirt
Talend team
Registered: 2006-09-19
Posts: 1199

Re: Oracle - classe12.zip

I only gave you a link from Oracle. This is not related to Talend.
After a little more research, it looks like a JDBC driver exists for Oracle 7. Maybe it was classes11.zip ?

Nevertheless, you can test Talend now.

Regards,

Offline

Board footer

Powered by FluxBB

Copyright © 2006 - 2010 Talend. All rights reserved. Talend Contributor Agreement