Hi Pavel, I'm thinking the same thing - probably some kind of defect or, at this version, the driver doesn't implement not returning a recordset. I'll ask directly to SQLite support and see if I can get an answer.
Thanks Kyle Kimberley -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday, July 26, 2010 12:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] using sqlitejdbc-v056 with ant build file > I'd still like > to know what I can pass to the jdbc driver to make it know I don't > expect a recordset. I haven't found any information on this. Since According to documentation on Ant's sql task you don't have to show it explicitly whether you expect recordset to be returned or not. So apparently there's some problem in communication between Ant and SQLite JDBC driver, probably incorrect implementation of JDBC driver in some rarely used method. I'd suggest to ask about that JDBC driver developers if they are available. Pavel On Mon, Jul 26, 2010 at 11:55 AM, <kyle.kimber...@thomsonreuters.com> wrote: > Hi Swithum, > > Ant is talking directly to the jdbc driver. > > I figured out how to make the ant exec task work for me. I'd still like > to know what I can pass to the jdbc driver to make it know I don't > expect a recordset. I haven't found any information on this. Since > none of the statements are SELECT statements, maybe the exec task is the > only solution. > > Thanks for your reply. > > Kyle Kimberley > > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Swithun Crowe > Sent: Monday, July 26, 2010 11:49 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] using sqlitejdbc-v056 with ant build file > > Hello > >> When I run a script, using sqlitejdbc-v056, with DROP, CREATE, and >> INSERT statements I get this error message "java.sql.SQLException: no >> ResultSet available". The statement actually is successful as the > data >> does appear in the database. > > It will be something to do with these statements not being queries. I > don't know how you are calling these statements, but often there are two > > different methods/functions: > > - an exec function which doesn't expect a result set to be returned > (DELETE, INSERT, UPDATE etc.) > > - a query function which does expect a result set (SELECT) > > It looks like the statement is being called with a query type function > or > method, where as the exec type one would be more suited to the > statements > you are calling. > > Maybe that will help, maybe not. Is ant talking directly to sqlite-jdbc, > > or is there some of your Java code in between (which you could modify)? > > Swithun. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
