BUILD FAILED with following error: Could not read the schema from the specified
database: java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not
set, index: 0
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DDLUTILS-261
URL: https://issues.apache.org/jira/browse/DDLUTILS-261
Project: DdlUtils
Issue Type: Bug
Components: Core - Sybase
Environment: Solaris 9, apache-2.2.15, Sun JDK 1.6.0, Sybase 12.5.3,
ant 1.8.1 ,subversion-1.6.9, jconnect 5.5, db driver:
com.sybase.jdbc2.jdbc.SybDriver
Reporter: luis Avila
Assignee: Thomas Dudziak
Utilizing the ant task as described on the Apache site to export structure and
data from a sybase db, the build fails as shown below:
Apache Ant version 1.8.1 compiled on April 30 2010
Trying the default build file: build.xml
Buildfile: /scratch/DdlUtils-test/build.xml
Detected Java version: 1.6 in: /scratch/usr/jdk/instances/jdk1.6.0_20/jre
Detected OS: SunOS
parsing buildfile /scratch/DdlUtils-test/build.xml with URI =
file:/scratch/DdlUtils-test/build.xml
Project base dir set to: /scratch/DdlUtils-test
parsing buildfile
jar:file:/local/src/apache-ant-1.8.1/lib/ant.jar!/org/apache/tools/ant/antlib.xml
with URI =
jar:file:/local/src/apache-ant-1.8.1/lib/ant.jar!/org/apache/tools/ant/antlib.xml
from a zip file
Build sequence for target(s) `export-source-db' is [export-source-db]
Complete build sequence is [export-source-db, ]
export-source-db:
BUILD FAILED
/scratch/DdlUtils-test/build.xml:17: Could not read the schema from the
specified database: java.sql.SQLException: JZ0SA: Prepared Statement: Input
parameter not set, index: 0.
at
org.apache.ddlutils.task.DatabaseToDdlTask.readModel(DatabaseToDdlTask.java:308)
at
org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:381)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397)
at org.apache.tools.ant.Project.executeTarget(Project.java:1366)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1249)
at org.apache.tools.ant.Main.runBuild(Main.java:801)
at org.apache.tools.ant.Main.startAnt(Main.java:218)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
Caused by: org.apache.ddlutils.DatabaseOperationException:
java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set,
index: 0.
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:2808)
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:2781)
at
org.apache.ddlutils.task.DatabaseToDdlTask.readModel(DatabaseToDdlTask.java:265)
... 18 more
Caused by: java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter
not set, index: 0.
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:487)
at com.sybase.jdbc2.tds.TdsParam.prepareForSend(TdsParam.java:107)
at com.sybase.jdbc2.jdbc.ParamManager.checkParams(ParamManager.java:646)
at com.sybase.jdbc2.tds.Tds.language(Tds.java:674)
at com.sybase.jdbc2.jdbc.SybStatement.sendQuery(SybStatement.java:1424)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.sendQuery(SybPreparedStatement.java:1025)
at
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1494)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:70)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.ddlutils.platform.sybase.SybaseModelReader.readForeignKeys(SybaseModelReader.java:197)
at
org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:595)
at
org.apache.ddlutils.platform.sybase.SybaseModelReader.readTable(SybaseModelReader.java:87)
at
org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:548)
at
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:504)
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:2797)
... 20 more
Total time: 11 seconds
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
