Creating a JDBC Package in Sybase

Question

I have a requirement to update a table containing about 5 million rows. Therefore, for this purpose, I want to create batch statements in java and update as a bulk operation.

Righht I now have 100 batches and it works great. But when I increase the number of batches to more than one hundred, I get an exception like: com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: error while executing batch statement: Message is empty.

How can I get more batch instructions in my CallableStatement object.

Answer 1

Not enough reputation to comment ... but what types are you doing? how many of these lines are you updating? Does the table have a primary key? How many columns are in the table and how many of these columns are you updating?

General answer: The JDBC framework in sybase is extremely fast. You could at least consider writing a simple procedure that receives the primary key information (or another) that you use to determine the string, as well as new values ​​that will be updated as input variables. this procedure will update only one row.

Wrap this procedure in your own java method that processes the callablestatement, logs your error number and error message parameters, etc.

Then you can scroll through all the constructs that you are using now to update the data, and use the same java method to call the procedure to update the values ​​row by row.

Again, I don’t know the volume of what you are trying to do ... but I know, if you are trying to do single-line updates, it will be VERY fast.