jconn4 instead of jconn3

One Star

jconn4 instead of jconn3

Hi 
I'm using talend Version: 5.6.2 which comes with jconn3 file for Sybase. I already have a job that is using sybase components such as tSypaseInput,tSybaseOutput,etc...I want to switch to jconn4 file but i cant figure out how. what is the way of doing it?
Thanx
Moderator

Re: jconn4 instead of jconn3

Hi,
Could you please try to rename your new .jar file with the old one(rename  jconn4  as  jconn3) to see if it works?
Usually, you should put the newer version into the component directory and edit the xml file tDBXXX_java.xml on the bottom (try to find the IMPORT declaration and change it to your newer version).
After doing that, please delete the file <studio-install-dir>/configuration/ComponentCache.javacache and restart studio.

Let  us know if it is Ok with  you.
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: jconn4 instead of jconn3

Hi,
First I renamed the file jconn4 to jconn3 and it didn't work.
I did the below but still having issues as per screenshot below. Pls advise if anything more is needed.

I put the new file "jconn4" in all directories of the components that I'm using (tSybaseConnection,tSybaseInput,tSybaseOutput,tSybaseSP) unde the below location "C:\TOS_BD-20150508_1414-V5.6.2\plugins\org.talend.designer.components.localprovider_5.6.2.20150508_1414\components"
I edited the files (tSybaseConnection_java.xml,tSybaseInput_java.xml, tSybaseOutput_java.xml,tSybaseSP_java.xml)  and changed the Imports declaration to point to jconn4
I deleted the file ComponentCache.javacache and restarted studio
The job is running and generating the messages in the screenshot below. No errors are generated in the error log and no data is transfered. 


Moderator

Re: jconn4 instead of jconn3

Hi,
Have you tried to check the javajet to change the jdbc driver class from: com.sybase.jdbc3.jdbc.SybDriver
to :com.sybase.jdbc4.jdbc.SybDriver?
After that, please open talend module view in talend product to add new module : jconn4.jar 
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: jconn4 instead of jconn3

Happy New Year.

I changed Javajet files for the compionents I'm using to point to jdbc4. I then re-installed jconn4 from modules however the same messages are appearing on the console.

Moderator

Re: jconn4 instead of jconn3

Hi,
Have you tried to delete the file ComponentCache.javacache and restarte studio  to see if it works? Are you using Sybase IQ 16?
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: jconn4 instead of jconn3

yes I deleted the file ComponentCache.javacache  and I'm not using Sybase IQ 16.
One Star

Re: jconn4 instead of jconn3

Is there a way to display the SQL statments generated to repliacate the data to teh destination table?
One Star

Re: jconn4 instead of jconn3

Hi,
Now I tried to deactivate all components and activate them one after another most of the components are working fine however when I activate 2 components of type tSybaseOutput I get the below error. Note that i tried to drop and re-create them however I'm getting the same.
Exception in component tSybaseOutput_19
java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 0.
at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.sendQuery(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.sendQuery(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_8Process(ITRSYB_test.java:15309)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_7Process(ITRSYB_test.java:14067)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_6Process(ITRSYB_test.java:12892)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_4Process(ITRSYB_test.java:11890)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_3Process(ITRSYB_test.java:11196)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_5Process(ITRSYB_test.java:9546)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_2Process(ITRSYB_test.java:7617)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_1Process(ITRSYB_test.java:6799)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseInput_17Process(ITRSYB_test.java:6127)
at itr.itrsyb_test_0_1.ITRSYB_test.tFixedFlowInput_1Process(ITRSYB_test.java:5572)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseConnection_2Process(ITRSYB_test.java:4972)
at itr.itrsyb_test_0_1.ITRSYB_test.tSybaseConnection_1Process(ITRSYB_test.java:4818)
at itr.itrsyb_test_0_1.ITRSYB_test.tFileInputProperties_1Process(ITRSYB_test.java:4647)
at itr.itrsyb_test_0_1.ITRSYB_test.runJobInTOS(ITRSYB_test.java:23687)
at itr.itrsyb_test_0_1.ITRSYB_test.main(ITRSYB_test.java:23441)
Subjob 'ITR_CIF_ADDRESS' Failed!!!
Subjob 'ITR_CIF_ADDRESS' Failed!!!
disconnected
Job ITRSYB_test ended at 11:57 05/01/2016.
One Star

Re: jconn4 instead of jconn3

Hi,
The problem is about a default setting change in jconn4. Can you please add the following props value to your connection string:
props.put("DYNAMIC_PREPARE",  "true")
Connection conn = DriverManager.getConnection(url,  props);
Good luck.
Serkan
One Star

Re: jconn4 instead of jconn3

If it doesn't work:
props.put("DYNAMIC_PREPARE",  "false")
Smiley Happy