topic Re: Insert data into sybase DB ? in Talend Studio

Insert data into sybase DB ?

Anonymous — Wed, 30 Aug 2017 18:13:21 GMT

Hi,

I am trying to insert data into sybase DB using a file, I am getting the below error. Can you please help me with this

Exception in component tSybaseOutput_1 (testing_SPIN_Server)
java.lang.NullPointerException
at com.sybase.jdbc3.jdbc.SybBCP.<init>(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.a(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.<init>(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
at local_project.testing_spin_server_0_1.testing_SPIN_Server.tFileInputDelimited_1Process(testing_SPIN_Server.java:817)
at local_project.testing_spin_server_0_1.testing_SPIN_Server.runJobInTOS(testing_SPIN_Server.java:1601)
at local_project.testing_spin_server_0_1.testing_SPIN_Server.main(testing_SPIN_Server.java:1390)

Thanks & Regards

Akshay

Re: Insert data into sybase DB ?

Anonymous — Thu, 31 Aug 2017 03:32:09 GMT

Hello,

Did you use tSybaseConnection component in your job design? Could you please post your work flow screenshot into forum which will be helpful for us to address your issue.

Best regards

Sabrina

Re: Insert data into sybase DB ?

Anonymous — Thu, 31 Aug 2017 08:05:30 GMT

Hello,

Feel free to let us know if there is any problem for you to upload screenshots into forum.

Best regards

Sabrina

Re: Insert data into sybase DB ?

Anonymous — Thu, 31 Aug 2017 11:10:00 GMT

Hi Sabrina,

I have attached file with screenshot. I have added tsybaseconnection now. my job is like below

tsybaseconnection ----->onSubjobOK--->tfileinputdelimited--->tmap---->tsybaseoutput.

I am just trying to insert one single record with 2 values.

The connection details are correct.

Thanks & Regards

Akshay

job_screenshot.PNG

Re: Insert data into sybase DB ?

Anonymous — Thu, 31 Aug 2017 11:37:59 GMT

Hi Sabrina,

The issue is with tsybaseoutput component, if I use tlogrow instead of tsybaseoutput I am able to see the output on screen .

I tried to run a insert query manually and it works so no issue with the DB.

Thanks & Regards

Akshay

Re: Insert data into sybase DB ?

Anonymous — Fri, 01 Sep 2017 03:47:22 GMT

Hi,

Would you mind posting your tsybaseoutput component setting screenshot into forum? Please mask your sensitive data.

In addition, have you tried to check out "Die on error" option on basic settings of tsybaseoutput component to see if there is any error message printed on console?

Best regards

Sabrina

Re: Insert data into sybase DB ?

Anonymous — Mon, 04 Sep 2017 16:00:12 GMT

Hi Sabrina,

This issue is solved, it was a small datatype issue from end . Can you please guide me as to how can we update or insert using tsybasebulkexec component. I see there is either update or insert option only . I want the records to be updated if it is already present in the database else it should be inserted if not present.

Thanks & Regards

Akshay

Re: Insert data into sybase DB ?

Anonymous — Tue, 28 Nov 2017 10:54:42 GMT

Hi Sabrina,

My job is taking too much time to update records in a SQL Server table whereas insert is quicker. How do I solve this and improve the update speed.

Thanks & Regards

Akshay

Re: Insert data into sybase DB ?

Anonymous — Wed, 29 Nov 2017 13:53:53 GMT

Hi,

I have a job which has two output components ( SQL server table ) , one o/p component inserts data and the other updates the data depending on the condition in tmap ( A- insert, C- update ) . When I first ran the job with source containing action as 'A' , around 7034000 records got inserted in quick time . When I tried to run the job second time with around 1740000 records with action as C i.e update , it is a taking too much time . If insert took 30 min , the update process is taking almost 10 hours and the job is not completed. Can you please tell me how to improve the speed of update.

Thanks & Regards

Akshay

Re: Insert data into sybase DB ?

Anonymous — Fri, 01 Dec 2017 07:43:44 GMT

Hello,

For your performance issue, please post your job design screenshots on forum which will be helpful for us to understand your work flow.

Best regards

Sabrina

Re: Insert data into sybase DB ?

Anonymous — Fri, 01 Dec 2017 10:47:50 GMT

Hi Sabrina,

Please find the attached screenshot of job flow and mapping in tmap. Please let me know if more information is required.

Thanks & Regards

Akshay

Job_flow.pdf

Re: Insert data into sybase DB ?

Anonymous — Mon, 11 Dec 2017 10:10:45 GMT

Hi Sabrina,

Can I please get an update on this.

Thanks & Regards

Akshay