You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



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

suzchr
Member
149 posts

suzchr said:

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 08:56:54

shong
Talend Team


shong said:

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

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

suzchr
Member
149 posts

suzchr said:

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 15:19:51

jmbourguignon
Member
3 posts

jmbourguignon said:

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 16:22:39

suzchr
Member
149 posts

suzchr said:

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 17:39:21

jmbourguignon
Member
3 posts

jmbourguignon said:

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 17:51:07

mhirt
Talend Team


mhirt said:

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 10:19:24

jmbourguignon
Member
3 posts

jmbourguignon said:

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-27 23:26:37

mhirt
Talend Team


mhirt said:

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

#10 2011-07-20 08:13:33

HOERTZ
Member
1 post

HOERTZ said:

Re: Oracle - classe12.zip

Hi all,
I've a problem with an old 7.1.3 Oracle Database and TOS 4.1. The connection to my database is successfull, but I'm not able to read the schema. Now I've tried the same connection with a TOS 3.0... and everything works fine. And as a plus TOS 3.0 recognize after connecting, that's a Oracle7-Connection, even if I choosed the Oracle_8-Database. Any idea's what's wrong in TOS 4.1?
Thanks, Jörg

Offline

#11 2011-07-20 08:28:37

shong
Talend Team


shong said:

Re: Oracle - classe12.zip

HOERTZ wrote:

Hi all,
I've a problem with an old 7.1.3 Oracle Database and TOS 4.1. The connection to my database is successfull, but I'm not able to read the schema. Now I've tried the same connection with a TOS 3.0... and everything works fine. And as a plus TOS 3.0 recognize after connecting, that's a Oracle7-Connection, even if I choosed the Oracle_8-Database. Any idea's what's wrong in TOS 4.1?
Thanks, Jörg

Hi
I suggest you to report this kind of problem as a bug on our bugtracker.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy