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
