[SQLiteJDBC] using sqlitejdbc-v056 with ant build file

[kyle.kimberley at thomsonreuters.com]

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

kyle.kimberley at thomsonreuters.com
thomsonreuters.com <http://thomsonreuters.com/>