One Star

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

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/StringSmiley WinkV
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();
6 REPLIES
One Star

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

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
One Star

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

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.
One Star

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

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

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

Hi sagarbattin,
Could you please indicate the build version you're using.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

Version: 5.4.1
Build id: r111943-20131212-1133
One Star

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

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