Thanks for the clarification. Do you know who the author of the jdbc driver is?
Kyle Kimberley Software Engineer 919-474-6041 -----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:38 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] using sqlitejdbc-v056 with ant build file > I'll ask directly to SQLite support and see if I can get an answer. I hope you meant SQLite JDBC support, because SQLite support itself is here. And we can't tell anything about JDBC implementation unless its author is reading this. Pavel On Mon, Jul 26, 2010 at 12:22 PM, <kyle.kimber...@thomsonreuters.com> wrote: > 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 > _______________________________________________ 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
