Insert data into sybase DB ?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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