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
