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:aslak.hellesoy@;netcom.no]
Sent: Tuesday, 29 October 2002 11:04 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
> [mailto:middlegen-user-admin@;lists.sourceforge.net]On Behalf Of
> [EMAIL PROTECTED]
> Sent: 29. oktober 2002 00:43
> To: [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED]
> 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
[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user
