topic Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone" in Talend Studio

Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

sagarbattin — Fri, 28 Feb 2014 14:56:42 GMT

I am getting below error while executing simple job. I am trying to connect to Oracle DB to capture result in xls file.
Starting job Test_Project at 09:47 28/02/2014.
connecting to socket on port 3339
connected
java.lang.NoSuchMethodError: oracle.jdbc.OracleConnection.setSessionTimeZone(Ljava/lang/String V
at test_project.test_project_0_1.Test_Project.tOracleInput_1Process(Test_Project.java:756)
at test_project.test_project_0_1.Test_Project$2.run(Test_Project.java:1259)
disconnected
disconnected
Job Test_Project ended at 09:47 28/02/2014.
Code
====
conn_tOracleInput_1 = java.sql.DriverManager.getConnection(
url_tOracleInput_1, atnParamsPrope_tOracleInput_1);
java.sql.Statement stmtGetTZ_tOracleInput_1 = conn_tOracleInput_1
.createStatement();
java.sql.ResultSet rsGetTZ_tOracleInput_1 = stmtGetTZ_tOracleInput_1
.executeQuery("select sessiontimezone from dual");
String sessionTimezone_tOracleInput_1 = java.util.TimeZone
.getDefault().getID();
while (rsGetTZ_tOracleInput_1.next()) {
sessionTimezone_tOracleInput_1 = rsGetTZ_tOracleInput_1
.getString(1);
}
((oracle.jdbc.OracleConnection) conn_tOracleInput_1)
Line 756 - .setSessionTimeZone(sessionTimezone_tOracleInput_1);
java.sql.Statement stmt_tOracleInput_1 = conn_tOracleInput_1
.createStatement();

Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

willm1 — Fri, 28 Feb 2014 17:21:03 GMT

This may be a moot point but have you been able to simply connect to your database, use a tOracleInput, select a field from a table and spit it out in the tLogRow component? Looks like you have a connection issue

Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

sagarbattin — Sun, 02 Mar 2014 08:12:52 GMT

I am able to connect to database. I am able to query DB tables, however when I run job it throws same error. I tried your suggestion, but same result.

Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

sagarbattin — Thu, 13 Mar 2014 09:17:31 GMT

Any help on this?? I can connect to DB and query for table using toracleconnection

Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

Anonymous — Thu, 13 Mar 2014 09:51:55 GMT

Hi sagarbattin,
Could you please indicate the build version you're using.
Best regards
Sabrina

Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

sagarbattin — Thu, 13 Mar 2014 10:28:28 GMT

Version: 5.4.1
Build id: r111943-20131212-1133

Re: Job throwing error "oracle.jdbc.OracleConnection.setSessionTimeZone"

Anonymous — Tue, 01 Jul 2014 14:06:55 GMT

Hi,
i have the same Talend Version like you and got the same error. Any suggestions how to solve that problem?
Thanks,
Michael