Load data (local) infile

[Andreas Nyhrén]

Hi

trying to perform an import using LOAD DATA LOCAL INFILE ... but getting
Error: This command is not supported in the prepared statement protocol yet

Any info of future support for this?

[Andrey Sidorov]

It's MySQL server restriction, prepared statements don't support LOAD DATA LOCAL INFILE.
Solution is not to use prepared statements (i.e use query instead of execute)

[Andreas Nyhrén]

Ah! did not get that (query v execute) from the docs - thanks, will try that!

Any info on how to do batch inserts/updates, like jdbc?
pstmt = conn.prepareStatement(stmt)
loop
  pstmt.set...
  ...
  pstmt.addBatch
int[] count = pstmt.executeBatch()

[Andrey Sidorov]

I suspect jdbc in the case of mysql just calls insert statements in a
loop. It's relatively inexpensive from wire data point of view: 4
bytes prepared statement it + packet header + command type + data.

Try to inspect jdbc with wireshark and if required mysql command is
missing it's easy to add