Re: [h2] Usage of 'classpath:/filename.csv' - SQLSyntax and IOExceptions

2017-12-07 Thread Alan Freeman
Hi,I'm using the syntax in the documentation, as mentioned: this is at http://www.h2database.com/html/functions.html.Under the section headed 'CSVREAD" it states: "Instead of a file, an URL may be used, for example jar:file:///c:/temp/example.zip!/org/example/nested.csv. To read a stream from

[h2] Re: Usage of 'classpath:/filename.csv' - SQLSyntax and IOExceptions

2017-12-07 Thread Alan Freeman
tion) SELECT TIMESTAMPID, PROJECTFK, DESCRIPTION FROM CSVREAD('"+url+ "');"; System.out.println("Query string is:"+queryString); executeQuery(queryString,s); On Wednesday, December 6, 2017 at 3:53:42 PM UTC-6, Alan Freeman wrote: > > Hi > I'm