Dear Kyle; I'm starting to use the XERIAL driver (derivated from the ZENTUS one). http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC http://groups.google.com/group/xerial?hl=en&pli=1
I'm choosing it because it supports the extension load (http://groups.google.com/group/xerial/browse_thread/thread/a242effa31d216fd#) Regards LM kyle.kimber...@thomsonreuters.com a écrit : > 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 -- !! BOTH MAIL AND PHONE NUMBER CHANGED!! ---- Laurent MICHEL Tel (33 0) 3 68 85 24 37 Observatoire de Strasbourg Fax (33 0) 3 68 85 24 32 11 Rue de l'Universite Mail laurent.mic...@astro.unistra.fr 67000 Strasbourg (France) Web http://astro.u-strasbg.fr/~michel --- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
