topic Re: tOracleConnection doe snot use SERVICE_NAME in Talend Studio

tOracleConnection doe snot use SERVICE_NAME

Anonymous — Wed, 14 May 2014 07:51:30 GMT

Hi,
I'm working on Windows 7 64 bits, with TOS DI 5.4.1, Java JDK 1.6.1_43 and Oracle 11gR2
I have a problem with the configuration of tOracleConnection.
See the attached documents for the job settings.
I cannot use the features "Guess Query" or "Guess Schema" because of an Oracle error:

Database connection is failed.
java.lang.RuntimeException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:179)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1034)
...

When I set manually the schema of tOracleInput, the job correctly connect to the database and return the output of the query.
Please help!!!
Seb

Re: tOracleConnection doe snot use SERVICE_NAME

Anonymous — Wed, 14 May 2014 08:02:47 GMT

Hi,
Did you use SID for Database value?
Can you make metadata oracle DB connection successfully?
Best regards
Sabrina

Re: tOracleConnection doe snot use SERVICE_NAME

Anonymous — Wed, 14 May 2014 08:09:18 GMT

I used Service name.
I can make a successful metadata connection but the error is still there.
Seb

Re: tOracleConnection doe snot use SERVICE_NAME

Anonymous — Wed, 14 May 2014 09:43:33 GMT

Mostly this happened if some context parameters are wrong. I work with Oracle 11g and Talend 5.4.1 and it works well - also the Guess Schema functionality.
You could change or inspect the used parameters if you click on Set parameter and continue

Re: tOracleConnection doe snot use SERVICE_NAME

Anonymous — Wed, 14 May 2014 10:02:42 GMT

The window "Configure Connection Parameters" complains about the empty string ("") AdditionalJDBC Parameters.
See attached screen.
What should i then put there?
Seb

Re: tOracleConnection doe snot use SERVICE_NAME

Muzy — Mon, 20 Aug 2018 15:24:20 GMT

Hi,

i know it's an old message but i have the same error with TOS DI 7.0.1 and a solution for it.

i guess you have a problem with DBInput Component or with some other component that uses an existing connection.

I had the same problem and i think it's a bug.

Here is the case :

I have a DB Connection component with Connection Type "Oracle Service Name"

dfgd

When i put a DB Input Component in my project the default values are like these. ( Connection Type is "Oracle SID" )

When i check "use an existing connection" "Connection Type" and other values are gone because these value will be used from an existing connection ( That's what user thinks, but in real it's not true).

If you don't want to define the schema manually you can slect a table from the DB. But if you click the "..." button you get this error.

The solution is to uncheck "use an existing connection" and set "Connection Type" to "Oracle Service Name". Then check "use an existing connection" again, now it works.

Best wishes

Mustafa Yasar