Hi,
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. I'm able to get the script to continue by including the
onerror="continue" parameter, but then the build script fails. I think I can
keep the script from failing by including the onerror parameter in the target,
but I would prefer to have the script run without generating the errors. Any
help would be greatly appreciated.
JDBC output example:
[sql] Failed to execute: insert into table (col1, col2) values (val1,
val2)
[sql] java.sql.SQLException: no ResultSet available
JDBC Code:
<path id="sqliteclasspath.id">
<fileset
dir="${basedir}\Utilities">
<include
name="sqlitejdbc-v056.jar"/>
</fileset>
</path>
<property name="sqliteclasspath"
refid="sqliteclasspath.id" />
<echo message="Classpath is
${sqliteclasspath}"/>
<!---output here - [echo] Classpath is
C:\Clean_TestExtract\Utilities\sqlitejdbc-v056.jar -à
<sql driver="org.sqlite.JDBC"
url="jdbc:sqlite:${dir.source}/${dest.db.name}"
userid="" password=""
classpathref="sqliteclasspath.id"
src="${ source.file }"
onerror="continue">
</sql>
· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·
Kyle Kimberley
Software Engineer
Thomson Reuters
O 919-474-6041
[email protected]
thomsonreuters.com <http://thomsonreuters.com/>
_______________________________________________
SQLiteJDBC mailing list
[email protected]
https://lists.hcoop.net/listinfo/sqlitejdbc
