Menu
▾
▴
RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC driver didn't report any primary key column...
|
From: <asl...@ne...> - 2002-10-29 01:05:24
|
Are you sure you have set the correct schema and catalog values in <middlegen> ? You can access the CVS sources via HTTP with http://cvsgrab.sf.net/ You want to turn on debug for MiddlegenPopulator. You need this in log4j.properties: log4j.category.middlegen.MiddlegenPopulator=debug Then one of: ant -Dlog4j.configuration=file:/log4j.properties ant -Dlog4j.configuration=file://log4j.properties ant -Dlog4j.configuration=file:log4j.properties ant -Dlog4j.configuration=log4j.properties should work (it should work without the -D stuff too). The latest CVS version will list all available schemas and catalogs to stdout if it can't find any tables as in your case. HTH, Aslak > -----Original Message----- > From: mid...@li... > [mailto:mid...@li...]On Behalf Of Gavin > Hughes > Sent: 29. oktober 2002 01:43 > To: mid...@li... > Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC > driver didn't report any primary key column... > > > > I'm having a similar problem, in my case I'm using Oracle 9i (9.2) - the > error message I get is shown below - "Middlegen successfully connected > to the > database, but couldn't find any tables". > > I have tables created, Middlegen is connecting successfully to Oracle, > and > I've tried it with both the schema name specified and without it. > > I'm using the Middlegen 2.0 beta 1 sample project, which I've modified > to use > the oracle config file, and I've removed the <table> definitions from > the > Ant file. > > I've tried changing log4j.properties to set the log level to debug for > all classes, > but this doesn't result in ant more debug information being produced > (nor did it > in the unchanged sample application). > > Unfortunately I can't access CVS, so I can't look at the source to see > what is > going on - is there somewhere I can download the source for Middelgen > from without > going through CVS ? > > Any pointers would be appreciated - I'm confused as to why the debug > information > doesn't appear, and to why Middlegen can't find my tables... > > Thanks, > Gavin. > > ========================================= > > Buildfile: build.xml > > check-driver-present: > > panic-if-driver-not-present: > > middlegen: > [echo] Running middlegen > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin simple > ->middlegen.Plugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin java-> > middlegen.java.JavaPlugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin plugin > ->middlegen.Plugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin cmp20- > >middlegen.plugins.entitybean.CMP20Plugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin bmp20- > >middlegen.plugins.entitybean.BMP20Plugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin html-> > middlegen.plugins.html.HTMLReportPlugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin sunjdo > 10->middlegen.plugins.jdo.sun.SunJDO10Plugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin servle > t->middlegen.plugins.servlet.ServletPlugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin struts > ->middlegen.plugins.struts.StrutsPlugin > [middlegen] (middlegen.Middlegen 352 ) Registering > plugin jsp->m > iddlegen.plugins.struts.JspPlugin > [middlegen] Database URL:jdbc:oracle:thin:@localhost:1521:NRMA > [middlegen] No <table> elements specified. Reading all tables. This > might take a > while... > > BUILD FAILED > file:c:/projects/code/middlegen/build.xml:125: > middlegen.MiddlegenException: Mid > dlegen successfully connected to the database, but couldn't find any > tables. Per > haps the specified schema or catalog is wrong? -Or maybe there aren't > any tables > in the database at all? > > Total time: 3 seconds > > > -----Original Message----- > From: Aslak Hellesoy [mailto:asl...@ne...] > Sent: Tuesday, 29 October 2002 11:04 AM > To: Chu...@ma...; mid...@li... > Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC > driver didn't report any primary key column... > > > It's all in the error message. Either your JDBC driver is buggy and > doesn't correctly report primary keys, or your database tables are > defined without primary keys. Perhaps they are views? (although from the > names they look like tables). JDBC will - AFAIK, never verifed it myself > - report views as tables. -And views don't have primary keys. > > There is an FR about this here: http://tinyurl.com/29xs > > So how could you debug this? You can turn on logging by setting the > debug level for various classes to debug in > middlegen/samples/log4j.properties. If you are working in "your own" > project, just copy that file, and make sure you pass it to the VM as it > is explained in log4j's doumentation. IIRC it's > -Dlog4j.configuration=path/to/your/log4j.properties. > > If you get any closer, pleaselet us know. Maybe Middlegen has entered > into an infinite loop somewhere? I mean, does it hang, or exit or... > -And I hope you're using gui="true" ;-) > > HTH, > Aslak > > > > -----Original Message----- > > From: mid...@li... > > [mailto:mid...@li...]On Behalf Of > > Chu...@ma... > > Sent: 29. oktober 2002 00:43 > > To: mid...@li... > > Subject: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC driver > > didn't report any primary key column... > > > > > > I'm trying to get Middlegen to generate entity bean classes from my > > db2 database. After successfully getting the sample project to build, > > i.e. create entity bean classes, I adapted it for my db2 database. > > When I invoke my middlegen build target, the attached error messages > > get output and that's about it. The middlegen gui never comes up. I > > could sure use a little help. Thanks in advance. > > > > Chuck > > > > ================================================================ > > > > middlegen: > > [middlegen] Database URL:jdbc:db2:DB2I > > [middlegen] No <table> elements specified. Reading all tables. This > > might take a while... > > [middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The > JDBC > > driver didn't report any primary key columns in DSN_STATEMNT_TABLE > > [middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The > JDBC > > driver didn't report any primary key columns in STRUCTURE_TABLE > > [middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The > JDBC > > driver didn't report any primary key columns in PREDICATE_TABLE > > [middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The > JDBC > > driver didn't report any primary key columns in PLAN_TABLE > > [middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The > JDBC > > driver didn't report any primary key columns in COST_TABLE > > C:\chuck\cvshome\fmsGenerateEntityBeans> > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > middlegen-user mailing list mid...@li... > > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > middlegen-user mailing list > mid...@li... > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > middlegen-user mailing list > mid...@li... > https://lists.sourceforge.net/lists/listinfo/middlegen-user |