paras jain
2005-08-19 08:46:03 UTC
Hi All,
When I run Middlegen for my local database it is working perfectly. But when I use it for some remote DB I am getting the following error
middlegen.MiddlegenException: Middlegen successfully connected to the database, but couldn't find any
tables. Perhaps the specified schema or catalog is wrong? -Or maybe there aren't
any tables in the database at all?
Configured schema:myschema
Configured catalog:
Available schemas:
?? Couldn't get schemas ??
Available catalogs:
My DB settings are
<property name="database.script.file" value="${src.dir}/sql/${name}-db2.sql"/>
<property name="database.driver.file" value=" D://Program Files//IBM//SQLLIB//java//db2java.zip"/>
<property name="database.driver.classpath" value="${database.driver.file}"/>
<property name=" database.driver" value="COM.ibm.db2.jdbc.app.DB2Driver"/>
<property name="database.url" value="jdbc:db2:mydb"/>
<property name=" database.userid" value="paras"/>
<property name="database.password" value="jain$"/>
<property name="database.schema" value="myschema"/>
<property name="database.catalog" value=""/>
I am using DB2 OS/390 8.1.5
Thanks in advance for any help
I am also giving the full stack trace for your information
[middlegen] 2005-08-19 15:46:42,976 [main] WARN middlegen.MiddlegenPopulator -
Couldn't get schemas
[middlegen] COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E Invalid
column name. SQLSTATE=S0022
[middlegen] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.rsException(Unknow
n Source)
[middlegen] at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn(Unknown Source)
[middlegen] at COM.ibm.db2.jdbc.app.DB2ResultSet.getString(Unknown Source)
[middlegen] at middlegen.MiddlegenPopulator.getDatabaseStructure(MiddlegenPo
pulator.java:506)
[middlegen] at middlegen.MiddlegenPopulator.addRegularTableElements(Middlege
nPopulator.java:165)
[middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:440)
[middlegen] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
va:275)
[middlegen] at org.apache.tools.ant.Task.perform(Task.java:364)
[middlegen] at org.apache.tools.ant.Target.execute(Target.java:341)
[middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[middlegen] at org.apache.tools.ant.Project.executeSortedTargets(Project.jav
a:1216)
[middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[middlegen] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(De
faultExecutor.java:40)
[middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java:1068
)
[middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[middlegen] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[middlegen] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[middlegen] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
-
Paras Jain