Insert long text into H2 database from SQL script

Question

I am trying to run sql script using H2 tag.

One of the tables contains a longtext type that stores an XML document (from an SAP database)

So the Insert statement contains long XML text (about 200 lines of XML), which is pretty ugly, but still expected to work.

H2 fails with ArrayOutOfBoundException during SQL parsing.

• Is there an alimit for the length that it will accept for the insert statement?
• In nsert, I share the value (xml) using ticks (as used in mysql) ... digits this will minimize the output. can this be part of the problem (works for other short fields).

I would rather use the simple runcript H2 tool here rather than make a Java program, although I see that it will be cleaner (can use steam methods)

Any insight?

Answer 1

Never mind

Did it work by using the correct delimiters ("for column names and" for values ​​") and dropping quotes in values ​​(doubling)