On 9 Apr, 22:27, Thomas Kellerer <[email protected]> wrote: > On Apr 9, 4:30 pm, "[email protected]" > > <[email protected]> wrote: > > For instance, if I want to test my sql statement from the H2 GUI front- > > end before doing via my JDBC java code. > > > I tried to pass the path , i.e. INSERT INTO mytable (id,name,file) > > VALUES(1,'file.xml',/my/local/path/file.xml); > > but this fails. > > > Within the code (java for instance), it's easy to create a File object > > and pass that in, but directly from a sql script, I'm stuck... > > If you can change your SQL tool, you may want to have a look at SQL > Workbench/J. > > It extends regular SQL to support the following syntax > > INSERT INTO mytable (id,name,file) > VALUES(1,'file.xml', {$blobfile='/my/local/path/file.xml'} ); > > http://www.sql-workbench.net/manual/using.html#blob-support > > It can be downloaded from here:http://www.sql-workbench.net/downloads.html > > @Thomas Mueller: I hope you don't mind that I mention my tool here. As > you have listed it on your homepage, I assumed this is OK > > Regards > Thomas
Sounds cool, I'll have a go at it -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
