Problem in schema and catalog settings
"paras jain" <[email protected]> 19 Aug 2005 10:44:29 -0000
| Newsgroups | gmane.comp.java.ejb.middlegen.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multipart mime message
--Next_1124448269---0-202.54.124.216-16357
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
=A0=0AHi All, =0A When I run Middlegen for my local database it is wo=
rking perfectly. But when I use it for some remote DB I am getting the fol=
lowing error =0A =0Amiddlegen.MiddlegenException: Middlegen successfully co=
nnected to the database, but couldn't find any=0Atables. Perhaps the specif=
ied schema or catalog is wrong? -Or maybe there aren't=0Aany tables in the =
database at all? =0A =0AConfigured schema:myschema=0AConfigured catalog:=0A=
Available schemas:=0A ?? Couldn't get schemas ??=0AAvailable catalogs:=
=0A =0A =0AMy DB settings are =0A <property name=3D"database.script.file"=
value=3D"${src.dir}/sql/${name}-db2.sql"/>=0A <property name=
=3D"database.driver.file" value=3D" D://Program Files//IBM//SQLLI=
B//java//db2java.zip"/>=0A <property name=3D"database.driver.classpath" =
value=3D"${database.driver.file}"/>=0A <property name=3D" database.dr=
iver" value=3D"COM.ibm.db2.jdbc.app.DB2Driver"/>=0A <prope=
rty name=3D"database.url" value=3D"jdbc:db2:mydb"/>=0A =
<property name=3D" database.userid" value=3D"paras"/>=0A <=
property name=3D"database.password" value=3D"jain$"/>=0A <pr=
operty name=3D"database.schema" value=3D"myschema"/> =0A <=
property name=3D"database.catalog" value=3D""/>=0A =0AI am us=
ing DB2 OS/390 8.1.5=0A Thanks in advance for any help=0A=0A =0AI am also g=
iving the full stack trace for your information=0A[middlegen] 2005-08-19 15=
:46:42,976 [main] WARN middlegen.MiddlegenPopulator -=0ACouldn't get schem=
as=0A[middlegen] COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E=
Invalid=0Acolumn name. SQLSTATE=3DS0022=0A[middlegen] at COM.ibm.db2.=
jdbc.app.SQLExceptionGenerator.rsException(Unknow=0An Source)=0A[middlegen]=
at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn(Unknown Source)=0A[mid=
dlegen] at COM.ibm.db2.jdbc.app.DB2ResultSet.getString(Unknown Source)=
=0A[middlegen] at middlegen.MiddlegenPopulator.getDatabaseStructure(Mid=
dlegenPo=0Apulator.java:506)=0A[middlegen] at middlegen.MiddlegenPopula=
tor.addRegularTableElements(Middlege=0AnPopulator.java:165)=0A[middlegen] =
at middlegen.MiddlegenTask.execute(MiddlegenTask.java:440)=0A[middlegen]=
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja=0Ava:=
275)=0A[middlegen] at org.apache.tools.ant.Task.perform(Task.java:364)=
=0A[middlegen] at org.apache.tools.ant.Target.execute(Target.java:341)=
=0A[middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:=
369)=0A[middlegen] at org.apache.tools.ant.Project.executeSortedTargets=
(Project.jav=0Aa:1216)=0A[middlegen] at org.apache.tools.ant.Project.ex=
ecuteTarget(Project.java:1185)=0A=0A[middlegen] at org.apache.tools.ant=
.helper.DefaultExecutor.executeTargets(De=0AfaultExecutor.java:40)=0A[middl=
egen] at org.apache.tools.ant.Project.executeTargets(Project.java:1068=
=0A)=0A[middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:668)=
=0A[middlegen] at org.apache.tools.ant.Main.startAnt(Main.java:187)=0A[=
middlegen] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:24=
6)=0A[middlegen] at org.apache.tools.ant.launch.Launcher.main(Launcher.=
java:67) =0A=0A =0A- =0AParas Jain
--Next_1124448269---0-202.54.124.216-16357
Content-type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
<P>=0A <BR>=0AHi All, <BR>=0A When I run Middlege=
n for my local database it is working perfectly. But when I use it for some=
remote DB I am getting the following error <BR>=0A <BR>=0Amiddlegen.=
MiddlegenException: Middlegen successfully connected to the database, but c=
ouldn't find any<BR>=0Atables. Perhaps the specified schema or catalog is w=
rong? -Or maybe there aren't<BR>=0Aany tables in the database at all? <BR>=
=0A <BR>=0AConfigured schema:myschema<BR>=0AConfigured catalog:<BR>=0AAvail=
able schemas:<BR>=0A ?? Couldn't get schemas ??<BR>=0AAvailabl=
e catalogs:<BR>=0A <BR>=0A <BR>=0AMy DB settings are <BR>=0A <pro=
perty name=3D"database.script.file" &n=
bsp; value=3D"${src.dir}/sql/${name}-db2.sql"/><BR>=0A =
<property name=3D"database.driver.file" &=
nbsp; value=3D" D://Program Files//IBM//SQLLIB//java//db2java.=
zip"/><BR>=0A <property name=3D"database.driver.clas=
spath" value=3D"${database.driver.file}"=
/><BR>=0A <property name=3D" database.driver" =
value=3D"COM.ibm.db2.=
jdbc.app.DB2Driver"/><BR>=0A <property name=3D"datab=
ase.url" =
value=3D"jdbc:db2:mydb"/><BR>=0A <property name=3D=
" database.userid"  =
; value=3D"paras"/><BR>=0A <property name=3D&=
quot;database.password"  =
; value=3D"jain$"/><BR>=0A <property name=3D"da=
tabase.schema" =
value=3D"myschema"/> <BR>=0A <property name=3D"=
database.catalog" val=
ue=3D""/><BR>=0A <BR>=0AI am using DB2 OS/390 8.1.5<BR>=0A Tha=
nks in advance for any help<BR>=0A<BR>=0A <BR>=0AI am also giving the full =
stack trace for your information<BR>=0A[middlegen] 2005-08-19 15:46:42,976 =
[main] WARN middlegen.MiddlegenPopulator -<BR>=0ACouldn't get schemas=
<BR>=0A[middlegen] COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI061=
1E Invalid<BR>=0Acolumn name. SQLSTATE=3DS0022<BR>=0A[middlegen] =
; at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.rsException(Unknow<=
BR>=0An Source)<BR>=0A[middlegen] at COM.ibm.db2.jdbc.app.DB2=
ResultSet.findColumn(Unknown Source)<BR>=0A[middlegen] at COM=
.ibm.db2.jdbc.app.DB2ResultSet.getString(Unknown Source)<BR>=0A[middlegen]&=
nbsp; at middlegen.MiddlegenPopulator.getDatabaseStructure(Middlege=
nPo<BR>=0Apulator.java:506)<BR>=0A[middlegen] at middlegen.Mi=
ddlegenPopulator.addRegularTableElements(Middlege<BR>=0AnPopulator.java:165=
)<BR>=0A[middlegen] at middlegen.MiddlegenTask.execute(Middle=
genTask.java:440)<BR>=0A[middlegen] at org.apache.tools.ant.U=
nknownElement.execute(UnknownElement.ja<BR>=0Ava:275)<BR>=0A[middlegen]&nbs=
p; at org.apache.tools.ant.Task.perform(Task.java:364)<BR>=0A[middl=
egen] at org.apache.tools.ant.Target.execute(Target.java:341)=
<BR>=0A[middlegen] at org.apache.tools.ant.Target.performTask=
s(Target.java:369)<BR>=0A[middlegen] at org.apache.tools.ant.=
Project.executeSortedTargets(Project.jav<BR>=0Aa:1216)<BR>=0A[middlegen]&nb=
sp; at org.apache.tools.ant.Project.executeTarget(Project.java:1185=
)<BR>=0A<BR>=0A[middlegen] at org.apache.tools.ant.helper.Def=
aultExecutor.executeTargets(De<BR>=0AfaultExecutor.java:40)<BR>=0A[middlege=
n] at org.apache.tools.ant.Project.executeTargets(Project.jav=
a:1068<BR>=0A)<BR>=0A[middlegen] at org.apache.tools.ant.Main=
.runBuild(Main.java:668)<BR>=0A[middlegen] at org.apache.tool=
s.ant.Main.startAnt(Main.java:187)<BR>=0A[middlegen] at org.a=
pache.tools.ant.launch.Launcher.run(Launcher.java:246)<BR>=0A[middlegen]&nb=
sp; at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67) =
<BR>=0A<BR>=0A <BR>=0A- <BR>=0AParas Jain=0A</P>=0A<br><br>=0A<a href=3D"ht=
tp://adworks.rediff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signatu=
re-home.htm/1507191490@Middle5?PARTNER=3D3"><IMG SRC=3D"http://adworks.redi=
ff.com/cgi-bin/AdWorks/sigimpress.cgi/www.rediff.com/signature-home.htm/196=
3059423@Middle5?OAS_query=3Dnull&PARTNER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=
=3D0></a>=0A
--Next_1124448269---0-202.54.124.216-16357--
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf