Can't extract data from Derby db when table included in a schema
----------------------------------------------------------------
Key: DDLUTILS-95
URL: http://issues.apache.org/jira/browse/DDLUTILS-95
Project: DdlUtils
Type: Bug
Components: Ant Tasks
Environment: Derby database or any database with schema support and the userid
not matching the schema name
Reporter: jim vester
Assigned to: Thomas Dudziak
I have a derby Database named myDatabase.
The database contains a schema rentabike.
the schema contains a table named bikes.
when I use the DatabaseToDdlTask to try
and unload the schema and data, schema="rentabike" catalog=""
userid="user" password="pass", an error occurs.
The schema is extracted successfully however the data is not.
Here is a snippet of the stack trace:
org.apache.ddlutils.DynaSqlException : Error while performing a query
at org.apache.ddlutils.platform.PlatformImplBase.query(PlatformImplBase.
java:793)
at org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFi
leCommand.java :82)
at org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTas
kBase.java:198)
at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.ja
va:222)
at org.apache.tools.ant.UnknownElement.execute (UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java :369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets
(DefaultExe
cutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java :187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Caused by: org.apache.derby.client.am.SqlException: Schema 'user' does not exist
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unkno
wn Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply
(Unk
nown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutp
ut(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(
Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(U
nknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknow
n Source)
at org.apache.derby.client.am.Statement.flowExecute (Unknown Source)
at org.apache.derby.client.am.Statement.executeQueryX(Unknown Source)
at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery
(DelegatingSt
atement.java:205)
at org.apache.ddlutils.platform.PlatformImplBase.query(PlatformImplBase.
java:787)
I think it is occuring because the generated sql from the
WritDataToFileCommand.execute
does not take into account the schema name. Note userid is added in front of
table names by default.
writer.write(platform.query(model, "select * from "+tables[0].getName(),
tables));
The correct sql is select * from schema.table. or select * from rentabike.bikes
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
