Java api for Sybase Bulk Copy?

[PeteG]

Hi,
Is there a way of calling the Sybase bulk copy utility (bcp) from java? I am carrying out a lot of individual inserts and am aware that they would complete a lot quicker using bcp. Can this be invoked from java directly, ie not by writing sql statements to a file and then processing the file?
Cheers

 

[sedj]

JDBC is the standard interface to databases - and is non-vendor-specific - meaning there is no support in the JDBC spec for db-specific functions.

That said, the Sybase driver may implement some non-standard features - check your database documentation.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk