[Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC driver didn't report any primary key column...

Discussion:

C***@mail.sprint.com

2002-10-28 21:44:01 UTC

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>

Aslak Hellesoy

2002-10-28 22:06:02 UTC

Permalink

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-----
Sent: 29. oktober 2002 00:43
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] 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
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Gavin Hughes

2002-10-28 22:42:02 UTC

Permalink

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:***@netcom.no]
Sent: Tuesday, 29 October 2002 11:04 AM
To: ***@mail.sprint.com; middlegen-***@lists.sourceforge.net
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

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
_______________________________________________
https://lists.sourceforge.net/lists/listinfo/middlegen-user

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf

Aslak Hellesoy

2002-10-28 23:06:09 UTC

Permalink

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-----
Hughes
Sent: 29. oktober 2002 01:43
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
[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] No <table> elements specified. Reading all tables. This
might take a
while...
BUILD FAILED
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-----
Sent: Tuesday, 29 October 2002 11:04 AM
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

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

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
middlegen-user mailing list
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
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Gavin Hughes

2002-10-29 01:16:02 UTC

Permalink

Thanks for that Aslak.

With the new version of Middlegen from CVS the tables are found
correctly,
so I can generate my bean classes now.

I still couldn't get any extra debug information from log4j though -
none
of the permutations had any effect - but it doesn't matter so much
now...

Thanks,
Gavin.

-----Original Message-----
From: Aslak Hellesoy [mailto:***@netcom.no]
Sent: Tuesday, 29 October 2002 12:04 PM
To: Gavin Hughes; middlegen-***@lists.sourceforge.net
Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC
driver didn't report any primary key column...

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-----
Hughes
Sent: 29. oktober 2002 01:43
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
[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

C***@mail.sprint.com

2002-10-29 13:11:10 UTC

Permalink

I turned on logging (excerpt of logfile attached below) and I see that
all of my tables are being referenced. Middlegen gets to the end of the
tables and just exists - it doesn't hang. I do have gui set to yes.

I am approaching this by copying the sample project and adapting it to
my database. I'm wondering if I have correctly edited the build.xml file
as necessary. I'm attaching the middlegen task from my build file.

I've got lots of tables to generate bean files for so I'm very hopeful
that I can get this to work. I would be very grateful for a little more
help. Many thanks.

Chuck

======================= logfile excerpt
=====================================

Buildfile: build.xml

check-driver-present:

panic-if-driver-not-present:

middlegen:
[mkdir] Created dir:
C:\chuck\cvshome\fmsGenerateEntityBeans\build\gen-src
[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 sunjdo10->middlegen.plugins.jdo.sun.SunJDO10Plugin
[middlegen] (middlegen.Middlegen 352 ) Registering
plugin servlet->middlegen.plugins.servlet.ServletPlugin
[middlegen] (middlegen.Middlegen 352 ) Registering
plugin struts->middlegen.plugins.struts.StrutsPlugin
[middlegen] (middlegen.Middlegen 352 ) Registering
plugin jsp->middlegen.plugins.struts.JspPlugin
[middlegen] Database URL:jdbc:db2:DB2I
[middlegen] (middlegen.MiddlegenPopulator 725 )
databaseProductName=DB2
[middlegen] (middlegen.MiddlegenPopulator 726 )
databaseProductVersion=07.01.0001
[middlegen] (middlegen.MiddlegenPopulator 727 ) driverName=IBM
DB2 JDBC 1.2 Type 2
[middlegen] (middlegen.MiddlegenPopulator 728 )
driverVersion=07.02.0000
[middlegen] (middlegen.MiddlegenPopulator 729 ) schema=NW2FM
[middlegen] (middlegen.MiddlegenPopulator 730 ) catalog=null
<deleted output>
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(DSN_STATEMNT_TABLE)
[middlegen] (middlegen.DbColumn 148 ) QUERYNO isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) APPLNAME isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) PROGNAME isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) COLLID isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) GROUP_MEMBER isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) EXPLAIN_TIME isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) STMT_TYPE isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) COST_CATEGORY
isPk -> false
[middlegen] (middlegen.DbColumn 148 ) PROCMS isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) PROCSU isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) REASON isPk ->
false
[middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The JDBC
driver didn't report any primary key columns in DSN_STATEMNT_TABLE
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(TFM_SW_TYPE_REF)
[middlegen] (middlegen.MiddlegenPopulator 640 ) primary
key:SW_TYPE_CD
[middlegen] (middlegen.MiddlegenPopulator 653 ) index:SW_TYPE_CD
[middlegen] (middlegen.DbColumn 148 ) SW_TYPE_CD isPk
-> true
[middlegen] (middlegen.DbColumn 148 ) SW_TYPE_DES isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) SW_TYPE_SHRT_DES
isPk -> false
[middlegen] (middlegen.DbColumn 148 ) SW_SYS_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) INTL_DMSTC_CD
isPk -> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_USER_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_TRAN_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_DT isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) MNTC_FNCTN_CD
isPk -> false
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(TFM_RSRC)
[middlegen] (middlegen.MiddlegenPopulator 640 ) primary
key:RSRC_ID
[middlegen] (middlegen.MiddlegenPopulator 653 ) index:RSRC_ID
[middlegen] (middlegen.DbColumn 148 ) RSRC_ID isPk ->
true
[middlegen] (middlegen.DbColumn 148 ) RSRC_TYPE_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) SPRINT_OWND_CD
isPk -> false
[middlegen] (middlegen.DbColumn 148 ) RSRC_STUS_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_USER_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_TRAN_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_DT isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) MNTC_FNCTN_CD
isPk -> false
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(TFM_EQPT_LOC_LIT)
[middlegen] (middlegen.MiddlegenPopulator 640 ) primary
key:LIT_ID
[middlegen] (middlegen.MiddlegenPopulator 640 ) primary
key:RSRC_TYPE_ID
[middlegen] (middlegen.MiddlegenPopulator 653 ) index:LIT_ID
[middlegen] (middlegen.MiddlegenPopulator 653 )
index:RSRC_TYPE_ID
[middlegen] (middlegen.DbColumn 148 ) LIT_ID isPk ->
true
[middlegen] (middlegen.DbColumn 148 ) RSRC_TYPE_ID isPk
-> true
[middlegen] (middlegen.DbColumn 148 ) REQR_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) LIT_SEQ_CNT isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_USER_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_TRAN_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_DT isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) MNTC_FNCTN_CD
isPk -> false
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(TFM_KEY_GEN)
[middlegen] (middlegen.MiddlegenPopulator 640 ) primary
key:COL_NME
[middlegen] (middlegen.MiddlegenPopulator 653 ) index:COL_NME
[middlegen] (middlegen.DbColumn 148 ) COL_NME isPk ->
true
[middlegen] (middlegen.DbColumn 148 ) KEY_VALUE_NBR
isPk -> false
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(STRUCTURE_TABLE)
[middlegen] (middlegen.DbColumn 148 ) QUERYNO isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) QBLOCKNO isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) APPLNAME isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) PROGNAME isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) PARENT isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) TIMES isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) ROWCOUNT isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) ATOPEN isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) TIMESTAMP isPk ->
false
[middlegen] (middlegen.MiddlegenPopulator 697 ) WARNING: The JDBC
driver didn't report any primary key columns in STRUCTURE_TABLE
[middlegen] (middlegen.MiddlegenPopulator 633 )
-------setColumns(TFM_CARD_TYPE)
[middlegen] (middlegen.MiddlegenPopulator 640 ) primary
key:RSRC_TYPE_ID
[middlegen] (middlegen.MiddlegenPopulator 653 )
index:RSRC_TYPE_ID
[middlegen] (middlegen.MiddlegenPopulator 653 )
index:EQPT_TYPE_CD
[middlegen] (middlegen.MiddlegenPopulator 653 ) index:MFR_CD
[middlegen] (middlegen.MiddlegenPopulator 653 ) index:MODEL_CD
[middlegen] (middlegen.MiddlegenPopulator 653 )
index:RSRC_TYPE_ID
[middlegen] (middlegen.DbColumn 148 ) RSRC_TYPE_ID isPk
-> true
[middlegen] (middlegen.DbColumn 148 ) MFR_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) MODEL_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) CLEI_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) CARD_TYPE_CD isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) DS3_QTY isPk ->
false
[middlegen] (middlegen.DbColumn 148 )
REQR_PROTECTION_CD isPk -> false
[middlegen] (middlegen.DbColumn 148 ) PASTHRU_TRMT_CD
isPk -> false
[middlegen] (middlegen.DbColumn 148 )
PASTHRU_TRMT_CH_CD isPk -> false
[middlegen] (middlegen.DbColumn 148 ) REQR_EQPT_XC_CD
isPk -> false
[middlegen] (middlegen.DbColumn 148 ) STC_MUX_CD isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) AUTO_GEN_CD isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) REQR_CHN_CD isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) SWAP_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 )
REQR_MONTR_PORT_CD isPk -> false
[middlegen] (middlegen.DbColumn 148 ) EQPT_TYPE_CD isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MAPNG_CD isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) MNTC_USER_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_TRAN_ID isPk
-> false
[middlegen] (middlegen.DbColumn 148 ) MNTC_DT isPk ->
false
[middlegen] (middlegen.DbColumn 148 ) MNTC_FNCTN_CD
isPk -> false

============================= end logfile
===================================================

============================== build.xml file excerpt
================================================




<target
name="middlegen"
description="Run Middlegen"
unless="middlegen.skip"
depends="check-driver-present,panic-if-driver-not-present"
<mkdir dir="${build.gen-src.dir}"/>

<taskdef
name="middlegen"
classname="middlegen.MiddlegenTask"
classpathref="lib.class.path"
/>

<middlegen
appname="${name}"
prefsdir="${src.dir}"
gui="${gui}"
databaseurl="${database.url}"
initialContextFactory="${java.naming.factory.initial}"
providerURL="${java.naming.provider.url}"
datasourceJNDIName="${name}.database"
driver="${database.driver}"
username="${database.userid}"
password="${database.password}"
schema="${database.schema}"
<cmp20
destination="${build.gen-src.dir}"
package="${name}.ejb"
interfacepackage="${name}.interfaces"
jndiprefix="${unique.name}"
pkclass="false"
dataobject="false"
viewtype="local"
readonly="false"
fkcmp="true"
guid="true"
<weblogic/>
</cmp20>

</middlegen>

<mkdir dir="${build.classes.dir}"/>
</target>

Aslak Hellesoy

2002-10-29 14:03:05 UTC

Permalink

-----Original Message-----
Sent: 29. oktober 2002 16:11
Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC
driver didn't report any primary key column...
I turned on logging (excerpt of logfile attached below) and I see that
all of my tables are being referenced. Middlegen gets to the end of the
tables and just exists - it doesn't hang. I do have gui set to yes.

So Ant exits. Ant can exit in three ways.
1) BUILD SUCCESSFUL
2) BUILD FAILED
3) The VM simply dies.

Which one is your case?
Could you provide me with Ant's log? (pass -debug to ant) -And don't send
the entire log, only the last parts, so I can see how Ant exits.

Maybe you should try the CVS version of Middlegen too? (In case you're
behind a firewall/proxy, try http://cvsgrab.sf.net/).

Aslak

I am approaching this by copying the sample project and adapting it to
my database. I'm wondering if I have correctly edited the build.xml file
as necessary. I'm attaching the middlegen task from my build file.
I've got lots of tables to generate bean files for so I'm very hopeful
that I can get this to work. I would be very grateful for a little more
help. Many thanks.
Chuck

C***@mail.sprint.com

2002-10-29 23:42:04 UTC

Permalink

Aslak,

Post by C***@mail.sprint.com

Post by C***@mail.sprint.com
I turned on logging (excerpt of logfile attached below) and

I see that

Post by C***@mail.sprint.com
all of my tables are being referenced. Middlegen gets to the

end of the

Post by C***@mail.sprint.com
tables and just exists - it doesn't hang. I do have gui set to yes.

Hmm, to me it looks like the case may be "The VM simply dies". There is
no indication in the ant trace of build failure, or of any kind of error
condition that I can see. The tail of the log is:
=============================================== ant log
=========================================================
[middlegen] Database URL:jdbc:db2:DB2I
Class sun.reflect.MethodAccessorImpl loaded from parent loader
Finding class middlegen.Prefs
Class middlegen.Prefs loaded from ant loader
Class java.io.PrintWriter loaded from parent loader
Class java.util.SortedMap loaded from parent loader
Class java.util.TreeMap loaded from parent loader
[middlegen] Getting database connection via standard JDBC
Class java.sql.SQLException loaded from parent loader
Class java.lang.InstantiationException loaded from parent loader
Finding class middlegen.MiddlegenPopulator
Class middlegen.MiddlegenPopulator loaded from ant loader
Class java.lang.NullPointerException loaded from parent loader
Class COM.ibm.db2.jdbc.app.DB2Driver loaded from parent loader
Class java.sql.DriverManager loaded from parent loader
Class java.sql.Connection loaded from parent loader
Class java.sql.DatabaseMetaData loaded from parent loader
Finding class middlegen.DatabaseInfo
Class middlegen.DatabaseInfo loaded from ant loader
[middlegen] No <table> elements specified. Reading all tables. This
might take a while...
Class java.sql.ResultSet loaded from parent loader
Finding class middlegen.DbTable
Class middlegen.DbTable loaded from ant loader
Finding class middlegen.DbColumn
Class middlegen.DbColumn loaded from ant loader
Finding class org.apache.log4j.spi.LocationInfo
Class org.apache.log4j.spi.LocationInfo loaded from ant loader
Class java.io.StringWriter loaded from parent loader
Finding class com.ibm.uvm.tools.DebugSupport
[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>
========================================================================
===========

That's it! Ant retires to the command line with no further message. Any
ideas on how to further isolate?

Post by C***@mail.sprint.com
Maybe you should try the CVS version of Middlegen too? (In case you're
behind a firewall/proxy, try http://cvsgrab.sf.net/).

Do I want the trunk or a branch?

Post by C***@mail.sprint.com
Aslak

Post by C***@mail.sprint.com
I am approaching this by copying the sample project and

adapting it to

Post by C***@mail.sprint.com
my database. I'm wondering if I have correctly edited the

build.xml file

Post by C***@mail.sprint.com
as necessary. I'm attaching the middlegen task from my build file.
I've got lots of tables to generate bean files for so I'm

very hopeful

Post by C***@mail.sprint.com
that I can get this to work. I would be very grateful for a

little more

Post by C***@mail.sprint.com
help. Many thanks.
Chuck

Aslak Hellesoy

2002-10-29 23:49:03 UTC

Permalink

It beats me. Some more options:

1) Try to run it from an IDE with a nice debugger
2) Get the CVS version and insert more log statements
3) Try a different driver if you can
4) Try a different JDK if you can

There is no System.exit() in my code. Maybe some fishy JNI stuff in the IBM
driver kills the VM? You know, JDBC drivers are *always* buggy in the meta
data parts. -At least all the ones I have tried.

Aslak

-----Original Message-----
Sent: 30. oktober 2002 02:42
Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC
driver didn't report any primary key column...
Aslak,

Post by C***@mail.sprint.com

Post by C***@mail.sprint.com
I turned on logging (excerpt of logfile attached below) and

I see that

Post by C***@mail.sprint.com
all of my tables are being referenced. Middlegen gets to the

end of the

Post by C***@mail.sprint.com
tables and just exists - it doesn't hang. I do have gui set to yes.

Hmm, to me it looks like the case may be "The VM simply dies". There is
no indication in the ant trace of build failure, or of any kind of error
=============================================== ant log
=========================================================
[middlegen] Database URL:jdbc:db2:DB2I
Class sun.reflect.MethodAccessorImpl loaded from parent loader
Finding class middlegen.Prefs
Class middlegen.Prefs loaded from ant loader
Class java.io.PrintWriter loaded from parent loader
Class java.util.SortedMap loaded from parent loader
Class java.util.TreeMap loaded from parent loader
[middlegen] Getting database connection via standard JDBC
Class java.sql.SQLException loaded from parent loader
Class java.lang.InstantiationException loaded from parent loader
Finding class middlegen.MiddlegenPopulator
Class middlegen.MiddlegenPopulator loaded from ant loader
Class java.lang.NullPointerException loaded from parent loader
Class COM.ibm.db2.jdbc.app.DB2Driver loaded from parent loader
Class java.sql.DriverManager loaded from parent loader
Class java.sql.Connection loaded from parent loader
Class java.sql.DatabaseMetaData loaded from parent loader
Finding class middlegen.DatabaseInfo
Class middlegen.DatabaseInfo loaded from ant loader
[middlegen] No <table> elements specified. Reading all tables. This
might take a while...
Class java.sql.ResultSet loaded from parent loader
Finding class middlegen.DbTable
Class middlegen.DbTable loaded from ant loader
Finding class middlegen.DbColumn
Class middlegen.DbColumn loaded from ant loader
Finding class org.apache.log4j.spi.LocationInfo
Class org.apache.log4j.spi.LocationInfo loaded from ant loader
Class java.io.StringWriter loaded from parent loader
Finding class com.ibm.uvm.tools.DebugSupport
[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>
========================================================================
===========
That's it! Ant retires to the command line with no further message. Any
ideas on how to further isolate?

Post by C***@mail.sprint.com
Maybe you should try the CVS version of Middlegen too? (In case you're
behind a firewall/proxy, try http://cvsgrab.sf.net/).

Do I want the trunk or a branch?

Post by C***@mail.sprint.com
Aslak

Post by C***@mail.sprint.com
I am approaching this by copying the sample project and

adapting it to

Post by C***@mail.sprint.com
my database. I'm wondering if I have correctly edited the

build.xml file

Post by C***@mail.sprint.com
as necessary. I'm attaching the middlegen task from my build file.
I've got lots of tables to generate bean files for so I'm

very hopeful

Post by C***@mail.sprint.com
that I can get this to work. I would be very grateful for a

little more

Post by C***@mail.sprint.com
help. Many thanks.
Chuck

C***@mail.sprint.com

2002-10-29 23:55:02 UTC

Permalink

Aslak,

For CVS access, do I just checkout the trunk or a branch?

Chuck

-----Original Message-----
Sent: Tuesday, October 29, 2002 7:47 PM
To: Chuck.R.Irvine; middlegen-user
Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC
driver didn't report any primary key column...
1) Try to run it from an IDE with a nice debugger
2) Get the CVS version and insert more log statements
3) Try a different driver if you can
4) Try a different JDK if you can
There is no System.exit() in my code. Maybe some fishy JNI
stuff in the IBM
driver kills the VM? You know, JDBC drivers are *always* buggy
in the meta
data parts. -At least all the ones I have tried.
Aslak

-----Original Message-----
Sent: 30. oktober 2002 02:42
Subject: RE: [Middlegen-user] DB2 / Middlegen -> WARNING: The JDBC
driver didn't report any primary key column...
Aslak,

Post by C***@mail.sprint.com

Post by C***@mail.sprint.com
I turned on logging (excerpt of logfile attached below) and

I see that

Post by C***@mail.sprint.com
all of my tables are being referenced. Middlegen gets to the

end of the

Post by C***@mail.sprint.com
tables and just exists - it doesn't hang. I do have gui

set to yes.

Post by C***@mail.sprint.com
So Ant exits. Ant can exit in three ways.
1) BUILD SUCCESSFUL
2) BUILD FAILED
3) The VM simply dies.
Which one is your case?
Could you provide me with Ant's log? (pass -debug to ant) -And
don't send
the entire log, only the last parts, so I can see how Ant exits.

Hmm, to me it looks like the case may be "The VM simply

dies". There is

no indication in the ant trace of build failure, or of any

kind of error

=============================================== ant log
=========================================================
[middlegen] Database URL:jdbc:db2:DB2I
Class sun.reflect.MethodAccessorImpl loaded from parent loader
Finding class middlegen.Prefs
Class middlegen.Prefs loaded from ant loader
Class java.io.PrintWriter loaded from parent loader
Class java.util.SortedMap loaded from parent loader
Class java.util.TreeMap loaded from parent loader
[middlegen] Getting database connection via standard JDBC
Class java.sql.SQLException loaded from parent loader
Class java.lang.InstantiationException loaded from parent loader
Finding class middlegen.MiddlegenPopulator
Class middlegen.MiddlegenPopulator loaded from ant loader
Class java.lang.NullPointerException loaded from parent loader
Class COM.ibm.db2.jdbc.app.DB2Driver loaded from parent loader
Class java.sql.DriverManager loaded from parent loader
Class java.sql.Connection loaded from parent loader
Class java.sql.DatabaseMetaData loaded from parent loader
Finding class middlegen.DatabaseInfo
Class middlegen.DatabaseInfo loaded from ant loader
[middlegen] No <table> elements specified. Reading all tables. This
might take a while...
Class java.sql.ResultSet loaded from parent loader
Finding class middlegen.DbTable
Class middlegen.DbTable loaded from ant loader
Finding class middlegen.DbColumn
Class middlegen.DbColumn loaded from ant loader
Finding class org.apache.log4j.spi.LocationInfo
Class org.apache.log4j.spi.LocationInfo loaded from ant loader
Class java.io.StringWriter loaded from parent loader
Finding class com.ibm.uvm.tools.DebugSupport
[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>

===============================================================
=========

===========
That's it! Ant retires to the command line with no further

message. Any

ideas on how to further isolate?

Post by C***@mail.sprint.com
Maybe you should try the CVS version of Middlegen too? (In

case you're

Post by C***@mail.sprint.com
behind a firewall/proxy, try http://cvsgrab.sf.net/).

Do I want the trunk or a branch?

Post by C***@mail.sprint.com
Aslak

Post by C***@mail.sprint.com
I am approaching this by copying the sample project and

adapting it to

Post by C***@mail.sprint.com
my database. I'm wondering if I have correctly edited the

build.xml file

Post by C***@mail.sprint.com
as necessary. I'm attaching the middlegen task from my build file.
I've got lots of tables to generate bean files for so I'm

very hopeful

Post by C***@mail.sprint.com
that I can get this to work. I would be very grateful for a

little more

Post by C***@mail.sprint.com
help. Many thanks.
Chuck

Aslak Hellesoy

2002-10-29 23:58:02 UTC

Permalink

Post by C***@mail.sprint.com

Post by Aslak Hellesoy
Maybe you should try the CVS version of Middlegen too? (In case you're
behind a firewall/proxy, try http://cvsgrab.sf.net/).

Do I want the trunk or a branch?

the regular MAIN branch, or trunk if you will.
You must install maven - http://jakarta.apache.org/turbine/maven/ to build.
Just type:

maven

in the middlegen directory. Then you'll get new jars.