[Middlegen-user] How to define the names of entity beans ?

Discussion:

David Nouls

2002-08-18 05:29:03 UTC

Hello,

I'm using MySQL as a database and use middlegen to generate the code for
CMP2.0 entity beans, that
need to be deployed on JBoss 3.0.1.

When I generate the entitybeans, the resulting classnames are all lowercase.
This is very unreadable in my code.
If I manually specify <table name="PartnerFuction"/> then I get the correct
PartnerFunctionBean class, but the container managed relations can not be
detected correctly. (no relations are found although I correctly define them
with REFERENCES syntax).

I first tried with an older CVS version of middlegen (3 weeks old). I
noticed in the mailinglist that somebody reported a similar problem and that
this is supposed to be fixed in the latest CVS version. So I downloaded the
very latest CVS version (18/08/2002 at 9:15am CET).

Now I got a little bit further: I can see messages that the relations are
found, but then if fails because he says that the other side of the relation
is not in the tables (and it certainly is). So I guess this is yet another
issue of case-dependency (MySQL doesn't seem to remember the correct case
when I create the tables).

Here is a little log when I call the middlegen Ant task:
generate.jdbc:
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
java->
middlegen.java.JavaPlugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
bmp20-

middlegen.plugins.entitybean.BMP20Plugin

[middlegen] (middlegen.Middlegen 379 ) Registering plugin
cmp20-

middlegen.plugins.entitybean.CMP20Plugin

[middlegen] (middlegen.Middlegen 379 ) Registering plugin
html->
middlegen.plugins.html.HTMLReportPlugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
sunjdo
10->middlegen.plugins.jdo.sun.SunJDO10Plugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
servle
t->middlegen.plugins.servlet.ServletPlugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
struts
->middlegen.plugins.struts.StrutsPlugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
jsp->m
iddlegen.plugins.struts.JspPlugin
[middlegen] Database URL:jdbc:mysql://localhost/3s
[middlegen] (entitybean.CMP20Plugin ? ) WARNING: When
fkcmp="fals
e", you will not be able to use compound primary keys where some of the
columns
are also foreign keys. This is because all columns of a primary key must be
CMP
fields. See EJB 2.0. spec section 10.8.2
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and contact. Skippin it since contact isn't among the
specified ta
bles.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldtokeywordlist and soldto. Skippin it since soldto isn't among the
specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
relateto and contact. Skippin it since contact isn't among the specified
tables.

[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
relateto and relatetorelationtype. Skippin it since relatetorelationtype
isn't a
mong the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
partnerfunction and customer. Skippin it since customer isn't among the
specifie
d tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and department. Skippin it since department isn't among the
specified ta
bles.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and division. Skippin it since division isn't among the specified
tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and jobtitle. Skippin it since jobtitle isn't among the specified
tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and title. Skippin it since title isn't among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and customer. Skippin it since customer isn't among the specified
tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldtocustom and state. Skippin it since state isn't among the specified
tables.

[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shiptokeywordlist and shipto. Skippin it since shipto isn't among the
specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
locationrelation and location. Skippin it since location isn't among the
specifi
ed tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
billto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldto and sector. Skippin it since sector isn't among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shiptocustom and linescustom. Skippin it since linescustom isn't among the
speci
fied tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
locationrelationhistory and locationhistory. Skippin it since
locationhistory is
n't among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
businessgift and contact. Skippin it since contact isn't among the specified
tab
les.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contactkeywordlist and contact. Skippin it since contact isn't among the
specifi
ed tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shipto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 220 ) WARNING: Middlegen
couldn
't find any relations between any tables. This may be intentional from the
desig
n of the database, but it may also be because you have incorrectly defined
the r
elationships. It could also be because the JDBC driver you're using doesn't
corr
ectly implement DatabaseMetaData. See the samples (for an example on how to
defi
ne relationships) and verify that your driver correctly implements
DatabaseMetaD
ata.
[middlegen] (middlegen.Middlegen 409 ) Validating cmp20
[middlegen] (middlegen.Middlegen 427 ) Invoking plugin cmp20
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageskillBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtokeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelatetoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\PartnerfunctionBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ContactBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationhistoryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtocustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptokeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\NoteBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\CustomerBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SectorBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LinescustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationrelationBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\TitleBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BilltoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgifttypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\KeywordmasterlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptocustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageskillgradeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\JobtitleBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelationtypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DictionaryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgiftreasonBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DepartmentBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelatetorelationtypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationrelationhistoryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgiftBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ContactkeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SequenceblockBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DivisionBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\EntitytypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\StateBean.java
[middlegen] Updated preferences in C:\Dev\3s\java\s3-prefs.properties

Aslak Hellesøy

2002-08-18 09:04:02 UTC

Permalink

Short solution: delete your prefs files and don't use <table/> in your build
file.
Long solution: read on.

-----Original Message-----
Nouls
Sent: 18. august 2002 09:34
To: Middlegen Users Mailing List
Subject: [Middlegen-user] How to define the names of entity beans ?
Hello,
I'm using MySQL as a database and use middlegen to generate the code for
CMP2.0 entity beans, that
need to be deployed on JBoss 3.0.1.
When I generate the entitybeans, the resulting classnames are all
lowercase.

Strange. The class names must be specified in lowercase in your prefs file
for some funny reason. Delete the file. (We recently switched from XML to
properties based prefs as default. You can safely delete both the
blabla-prefs.xml and blabla-prefs.properties). If you don't know where the
files are, Middlegen tells you when you exit the GUI.

This is very unreadable in my code.
If I manually specify <table name="PartnerFuction"/> then I get

The purpose of the <table/> element is *not* to specify what class name you
want for your beans (The middlegen task doesn't even know anything about
beans, it's the cmp20 plugin/subtask that does).

The purpose of the <table/> element is to tell Middlegen what database
tables it should generate code for. The name attribute assigns the name of
the database table.

the correct
PartnerFunctionBean class, but the container managed relations can not be
detected correctly. (no relations are found although I correctly
define them
with REFERENCES syntax).

Well, I think they are found, but since the table on the other side is not
among your <table/> declarations, it ignores it. (There's more at the
bottom).

I first tried with an older CVS version of middlegen (3 weeks old). I
noticed in the mailinglist that somebody reported a similar
problem and that
this is supposed to be fixed in the latest CVS version. So I
downloaded the
very latest CVS version (18/08/2002 at 9:15am CET).
Now I got a little bit further: I can see messages that the relations are
found, but then if fails because he says that the other side of
the relation
is not in the tables (and it certainly is). So I guess this is yet another
issue of case-dependency (MySQL doesn't seem to remember the correct case
when I create the tables).
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
java->
middlegen.java.JavaPlugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 ) Registering plugin
bmp20-

middlegen.plugins.entitybean.BMP20Plugin

[middlegen] (middlegen.Middlegen 379 ) Registering plugin
cmp20-

middlegen.plugins.entitybean.CMP20Plugin

I'm doing my best to make Middlegen emit meaningful error and warning
messages.
Obviously this message didn't make any sense to you. How would a meaningful
wording be?

[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since languageskillgrade
isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldtokeywordlist and soldto. Skippin it since soldto isn't among the
specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
relateto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
relateto and relatetorelationtype. Skippin it since relatetorelationtype
isn't a
mong the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
partnerfunction and customer. Skippin it since customer isn't among the
specifie
d tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and department. Skippin it since department isn't among the
specified ta
bles.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and division. Skippin it since division isn't among the specified
tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and jobtitle. Skippin it since jobtitle isn't among the specified
tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and title. Skippin it since title isn't among the
specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and customer. Skippin it since customer isn't among the specified
tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldtocustom and state. Skippin it since state isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shiptokeywordlist and shipto. Skippin it since shipto isn't among the
specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
locationrelation and location. Skippin it since location isn't among the
specifi
ed tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
billto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldto and sector. Skippin it since sector isn't among the
specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shiptocustom and linescustom. Skippin it since linescustom isn't among the
speci
fied tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
locationrelationhistory and locationhistory. Skippin it since
locationhistory is
n't among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
businessgift and contact. Skippin it since contact isn't among
the specified
tab
les.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contactkeywordlist and contact. Skippin it since contact isn't among the
specifi
ed tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shipto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 220 ) WARNING: Middlegen
couldn
't find any relations between any tables. This may be intentional from the
desig
n of the database, but it may also be because you have incorrectly defined
the r
elationships. It could also be because the JDBC driver you're
using doesn't
corr
ectly implement DatabaseMetaData. See the samples (for an example
on how to
defi
ne relationships) and verify that your driver correctly implements
DatabaseMetaD
ata.
[middlegen] (middlegen.Middlegen 409 ) Validating cmp20
[middlegen] (middlegen.Middlegen 427 ) Invoking
plugin cmp20
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageskillBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtokeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelatetoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\PartnerfunctionBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ContactBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationhistoryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtocustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptokeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\NoteBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\CustomerBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SectorBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LinescustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationrelationBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\TitleBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BilltoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgifttypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\KeywordmasterlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptocustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageskillgradeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\JobtitleBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelationtypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DictionaryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgiftreasonBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DepartmentBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelatetorelationtypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationrelationhistoryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgiftBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ContactkeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SequenceblockBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DivisionBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\EntitytypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\StateBean.java
[middlegen] Updated preferences in C:\Dev\3s\java\s3-prefs.properties
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

David Nouls

2002-08-19 03:15:02 UTC

Permalink

Hello Aslak,

I don't think you need to rephrase the error message. I understood what I
was doing wrong.

The fact is: my table had a name 'PartnerFunction' but MySQL (on win2000)
seems to make everything
lowercase. I read somewhere that I need to set a variable to avoid this
problem, but it won't work.

Thanks for the help, I'll try your suggestions later on.

/)avid

-----Original Message-----
Sent: Sunday, August 18, 2002 12:57 PM
To: David Nouls; Middlegen Users Mailing List
Subject: RE: [Middlegen-user] How to define the names of entity beans ?
Short solution: delete your prefs files and don't use <table/> in
your build
file.
Long solution: read on.

This is very unreadable in my code.
If I manually specify <table name="PartnerFuction"/> then I get

The purpose of the <table/> element is *not* to specify what
class name you
want for your beans (The middlegen task doesn't even know anything about
beans, it's the cmp20 plugin/subtask that does).
The purpose of the <table/> element is to tell Middlegen what database
tables it should generate code for. The name attribute assigns the name of
the database table.

the correct
PartnerFunctionBean class, but the container managed relations

can not be

detected correctly. (no relations are found although I correctly
define them
with REFERENCES syntax).

Well, I think they are found, but since the table on the other side is not
among your <table/> declarations, it ignores it. (There's more at the
bottom).

relations are

found, but then if fails because he says that the other side of
the relation
is not in the tables (and it certainly is). So I guess this is

yet another

issue of case-dependency (MySQL doesn't seem to remember the

correct case

when I create the tables).
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

java->
middlegen.java.JavaPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

bmp20-

middlegen.plugins.entitybean.BMP20Plugin

[middlegen] (middlegen.Middlegen 379 )

Registering plugin

cmp20-

middlegen.plugins.entitybean.CMP20Plugin

[middlegen] (middlegen.Middlegen 379 )

Registering plugin

html->
middlegen.plugins.html.HTMLReportPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

sunjdo
10->middlegen.plugins.jdo.sun.SunJDO10Plugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

servle
t->middlegen.plugins.servlet.ServletPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

struts
->middlegen.plugins.struts.StrutsPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

jsp->m
iddlegen.plugins.struts.JspPlugin
[middlegen] Database URL:jdbc:mysql://localhost/3s
[middlegen] (entitybean.CMP20Plugin ? ) WARNING: When
fkcmp="fals
e", you will not be able to use compound primary keys where some of the
columns
are also foreign keys. This is because all columns of a primary
key must be
CMP
fields. See EJB 2.0. spec section 10.8.2
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and contact. Skippin it since contact isn't among the
specified ta
bles.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

isn't
among the specified tables.

I'm doing my best to make Middlegen emit meaningful error and warning
messages.
Obviously this message didn't make any sense to you. How would a
meaningful
wording be?

[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldtokeywordlist and soldto. Skippin it since soldto isn't among the
specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
relateto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
relateto and relatetorelationtype. Skippin it since relatetorelationtype
isn't a
mong the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
partnerfunction and customer. Skippin it since customer isn't among the
specifie
d tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and department. Skippin it since department isn't among the
specified ta
bles.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and division. Skippin it since division isn't among the

specified

tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and jobtitle. Skippin it since jobtitle isn't among the

specified

tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and title. Skippin it since title isn't among the
specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and customer. Skippin it since customer isn't among the

specified

tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldtocustom and state. Skippin it since state isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shiptokeywordlist and shipto. Skippin it since shipto isn't among the
specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
locationrelation and location. Skippin it since location isn't among the
specifi
ed tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
billto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldto and contact. Skippin it since contact isn't among the specified
tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
soldto and sector. Skippin it since sector isn't among the
specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shiptocustom and linescustom. Skippin it since linescustom

isn't among the

speci
fied tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
locationrelationhistory and locationhistory. Skippin it since
locationhistory is
n't among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
businessgift and contact. Skippin it since contact isn't among
the specified
tab
les.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contactkeywordlist and contact. Skippin it since contact isn't among the
specifi
ed tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
shipto and contact. Skippin it since contact isn't among the specified
tables.

Middlegen

couldn
't find any relations between any tables. This may be

intentional from the

desig
n of the database, but it may also be because you have

incorrectly defined

the r
elationships. It could also be because the JDBC driver you're
using doesn't
corr
ectly implement DatabaseMetaData. See the samples (for an example
on how to
defi
ne relationships) and verify that your driver correctly implements
DatabaseMetaD
ata.
[middlegen] (middlegen.Middlegen 409 ) Validating cmp20
[middlegen] (middlegen.Middlegen 427 ) Invoking
plugin cmp20
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageskillBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtokeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelatetoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\PartnerfunctionBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ContactBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationhistoryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtocustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptokeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\NoteBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\CustomerBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SectorBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LinescustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationrelationBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\TitleBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BilltoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgifttypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SoldtoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\KeywordmasterlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptocustomBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LanguageskillgradeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\JobtitleBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelationtypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DictionaryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgiftreasonBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DepartmentBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\RelatetorelationtypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\LocationrelationhistoryBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\BusinessgiftBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ContactkeywordlistBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\SequenceblockBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\DivisionBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\EntitytypeBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\ShiptoBean.java
[middlegen] (middlegen.Plugin 736 ) Generating
C:\Dev\3s\test
\be\synsol\s3\server\entity\StateBean.java
[middlegen] Updated preferences in C:\Dev\3s\java\s3-prefs.properties
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

M-Leander Reimer

2002-08-19 04:45:04 UTC

Permalink

Hi there,
I am using MySQL under Win2000 as well, and the naming works fine if you
define you table names all upper case.
So to get a bean name like PartnerFunction you would have to call the
table PARTNER_FUNCTION.

Try this and it should work.

Leander

Post by David Nouls
Hello Aslak,
I don't think you need to rephrase the error message. I understood what I
was doing wrong.
The fact is: my table had a name 'PartnerFunction' but MySQL (on win2000)
seems to make everything
lowercase. I read somewhere that I need to set a variable to avoid this
problem, but it won't work.
Thanks for the help, I'll try your suggestions later on.
/)avid

This is very unreadable in my code.
If I manually specify <table name="PartnerFuction"/> then I get

The purpose of the <table/> element is *not* to specify what
class name you
want for your beans (The middlegen task doesn't even know anything about
beans, it's the cmp20 plugin/subtask that does).
The purpose of the <table/> element is to tell Middlegen what database
tables it should generate code for. The name attribute assigns the name of
the database table.

the correct
PartnerFunctionBean class, but the container managed relations

can not be

detected correctly. (no relations are found although I correctly
define them
with REFERENCES syntax).

Well, I think they are found, but since the table on the other side is not
among your <table/> declarations, it ignores it. (There's more at the
bottom).

relations are

found, but then if fails because he says that the other side of
the relation
is not in the tables (and it certainly is). So I guess this is

yet another

issue of case-dependency (MySQL doesn't seem to remember the

correct case

when I create the tables).
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

java->
middlegen.java.JavaPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

bmp20-

middlegen.plugins.entitybean.BMP20Plugin

[middlegen] (middlegen.Middlegen 379 )

Registering plugin

cmp20-

middlegen.plugins.entitybean.CMP20Plugin

[middlegen] (middlegen.Middlegen 379 )

Registering plugin

html->
middlegen.plugins.html.HTMLReportPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

sunjdo
10->middlegen.plugins.jdo.sun.SunJDO10Plugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

servle
t->middlegen.plugins.servlet.ServletPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

struts
->middlegen.plugins.struts.StrutsPlugin
[middlegen] (middlegen.Middlegen 379 )

Registering plugin

languageskillgrade

isn't
among the specified tables.

I'm doing my best to make Middlegen emit meaningful error and warning
messages.
Obviously this message didn't make any sense to you. How would a
meaningful
wording be?

[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

isn't
among the specified tables.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
languageskill and languageskillgrade. Skippin it since

languageskillgrade

specified

tables
.
[middlegen] (middlegen.MiddlegenPopulator 316 ) Found a relation
between
contact and jobtitle. Skippin it since jobtitle isn't among the

specified

isn't among the

Middlegen

couldn
't find any relations between any tables. This may be

intentional from the

desig
n of the database, but it may also be because you have

incorrectly defined

-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

--
M.-Leander Reimer
Dipl.-Inf. (FH)

Techdivision
Kunstmühlstr. 17
83022 Rosenheim

Fon: (08031) 356 38 32
Fax: (08031) 356 38 48
Mail: ***@techdivision.com