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----- > From: Aslak Helles�y [mailto:[EMAIL PROTECTED]] > 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. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of David > > 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). > > > > 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. > > > 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 > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > > ------------------------------------------------------- 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 [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
