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 Am Mon, 2002-08-19 um 07.19 schrieb 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 > > > -----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 -- M.-Leander Reimer Dipl.-Inf. (FH) Techdivision Kunstm�hlstr. 17 83022 Rosenheim Fon: (08031) 356 38 32 Fax: (08031) 356 38 48 Mail: [EMAIL PROTECTED] ------------------------------------------------------- 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
