Thank you for helping me get this information. 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 1:02 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] using sqlitejdbc-v056 with ant build file http://lmgtfy.com/?q=sqlitejdbc-v056&l=1 It looks like official site of the driver with the link to appropriate mailing list. Pavel On Mon, Jul 26, 2010 at 12:56 PM, <kyle.kimber...@thomsonreuters.com> wrote: > 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 > _______________________________________________ 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
