JDBC - MultiStatement with the "execute" method

Connectivity
Fan

JDBC - MultiStatement with the "execute" method

I have to execute several SQL request in parrallel.
Can you confirm me if the "execute" JDBC Method (with all my requests in parameter) will execute all the requests in parrallel or in sequential ?

-Fabien
2 REPLIES
Teradata Employee

Re: JDBC - MultiStatement with the "execute" method

When your application uses the Statement/PreparedStatement execute method to execute a multi-statement request, the Teradata JDBC Driver sends the entire multi-statement request to the Teradata Database.

It is entirely up to the Teradata Database whether the individual statements are executed in parallel or not. It is not under the control of the Teradata JDBC Driver at all.

Re: JDBC - MultiStatement with the "execute" method

To avoid the issue of sending very large sql statements I just used multiple threads, then teradata will handle them as seperate connections and it runs alot faster. Using xp though I seem to slow down at 10 connections.