Discussion:
[Middlegen-user] middlegen unable to recognize relationships in MySQL 4.1.x
Panagiotis Kammas
2004-08-09 07:35:18 UTC
Permalink
<html><div style='background-color:'><DIV class=RTE>Hello all,</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>I have been trying for more than a week now (looked in forums sites, tried different combinations, drivers, uppercase-lowercase, identifying relationships-non identifying e.t.c) but nothing...</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>My intention is to generate EJB files and descriptors from a Database. I have used middlegen (1.x) version in the past with Oracle9 and JBoss 3.x and everything was fine.</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>I tried now to use it in MySql 4.1.x (with all possible mysql drivers i could find) and in all cases, middlegen reported that no relationships were found for my tables. I am pretty sure though that the constraints exist in the db. Also, InnoDB is enabled. </DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Does anyone have a clue?</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Is there any information i could sent to the mailing list that would help? </DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Did anyone have similar problems ever? </DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Please, help...</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Thank you in advance for any interest/answer</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Best Regards,</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Panos</DIV></div><br clear=all><hr>Add photos to your e-mail with <a href="http://g.msn.com/8HMBEN/2746??PS=47575">MSN 8.</a> Get 2 months FREE*.</html>
Eivind Waaler
2004-08-12 06:11:01 UTC
Permalink
Hi Panos,

Did you figure out anything on this one? I'm having the same problem with
the 4.x version of mysql.

Could this be a bug in mysql?

=2Eeivind
Post by Panagiotis Kammas
Hello all,
=A0
I have been trying for more than a week now (looked in forums sites,
tried different combinations, drivers, uppercase-lowercase, identifying
relationships-non identifying e.t.c) but nothing...
=A0
My intention is to generate EJB files and descriptors from a Database. I
have used middlegen (1.x) version in the past with Oracle9 and JBoss 3.x
and everything was fine.
=A0
I tried now to use it in MySql 4.1.x (with all possible mysql drivers i
could find) and in all cases, middlegen reported that no relationships
were found for my tables. I am pretty sure though that the constraints
exist in the db. Also, InnoDB is enabled.
=A0
Does anyone have a clue?
=A0
Is there any information i could sent to the mailing list that would
help?
=A0
Did anyone have similar problems ever?
=A0
Please, help...
=A0
Thank you in advance for any interest/answer
=A0
Best Regards,
=A0
Panos
_________________________________________________________________________=
_______
Post by Panagiotis Kammas
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
------------------------------------------------------- This SF.Net email
is sponsored by OSTG. Have you noticed the changes on Linux.com,
ITManagersJournal and NewsForge in the past few weeks? Now, one more big
change to announce. We are now OSTG- Open Source Technology Group. Come
see the changes on the new OSTG site. www.ostg.com
_______________________________________________ middlegen-user mailing
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Eivind Waaler
2004-08-12 07:10:04 UTC
Permalink
Ok, found out. Download the latest mysql connector. The old beta driver in
the middlegen distribution doesn't work with the newer mysql versions.
Also remember to use type innodb on your tables.

Cheers
=2Eeivind
Post by Eivind Waaler
Hi Panos,
Did you figure out anything on this one? I'm having the same problem with
the 4.x version of mysql.
Could this be a bug in mysql?
.eivind
Post by Panagiotis Kammas
Hello all,
=A0
I have been trying for more than a week now (looked in forums sites,
tried different combinations, drivers, uppercase-lowercase, identifying
relationships-non identifying e.t.c) but nothing...
=A0
My intention is to generate EJB files and descriptors from a Database. =
I
Post by Eivind Waaler
Post by Panagiotis Kammas
have used middlegen (1.x) version in the past with Oracle9 and JBoss 3.=
x
Post by Eivind Waaler
Post by Panagiotis Kammas
and everything was fine.
=A0
I tried now to use it in MySql 4.1.x (with all possible mysql drivers i
could find) and in all cases, middlegen reported that no relationships
were found for my tables. I am pretty sure though that the constraints
exist in the db. Also, InnoDB is enabled.
=A0
Does anyone have a clue?
=A0
Is there any information i could sent to the mailing list that would
help?
=A0
Did anyone have similar problems ever?
=A0
Please, help...
=A0
Thank you in advance for any interest/answer
=A0
Best Regards,
=A0
Panos
_______________________________________________________________________=
_________
Post by Eivind Waaler
Post by Panagiotis Kammas
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
------------------------------------------------------- This SF.Net ema=
il
Post by Eivind Waaler
Post by Panagiotis Kammas
is sponsored by OSTG. Have you noticed the changes on Linux.com,
ITManagersJournal and NewsForge in the past few weeks? Now, one more bi=
g
Post by Eivind Waaler
Post by Panagiotis Kammas
change to announce. We are now OSTG- Open Source Technology Group. Come
see the changes on the new OSTG site. www.ostg.com
_______________________________________________ middlegen-user mailing
https://lists.sourceforge.net/lists/listinfo/middlegen-user
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Wouter Boers
2004-08-13 06:01:01 UTC
Permalink
Hi,

I have a simular problem. The funny thing is that is I run the example and
change the database properties, the relations do get picked up. But If I
use the ejb20 plugin stand-alone, not releations seem to get picked up.
Perhaps you have simular behaviour?

I'm still looking to see where the problem is allthought is does not have
my priority.

Wouter
Hello all, I have been trying for more than a week now (looked in forums
sites, tried different combinations, drivers, uppercase-lowercase,
identifying relationships-non identifying e.t.c) but nothing... My
intention is to generate EJB files and descriptors from a Database. I have
used middlegen (1.x) version in the past with Oracle9 and JBoss 3.x and
everything was fine. I tried now to use it in MySql 4.1.x (with all
possible mysql drivers i could find) and in all cases, middlegen reported
that no relationships were found for my tables. I am pretty sure though
that the constraints exist in the db. Also, InnoDB is enabled. Does
anyone have a clue? Is there any information i could sent to the mailing
list that would help? Did anyone have similar problems ever? Please,
help... Thank you in advance for any interest/answer Best Regards,
PanosAdd photos to your e-mail with MSN 8. Get 2 months FREE*.
------------------------------------------------------- This SF.Net email
is sponsored by OSTG. Have you noticed the changes on Linux.com,
ITManagersJournal and NewsForge in the past few weeks? Now, one more big
change to announce. We are now OSTG- Open Source Technology Group. Come
see the changes on the new OSTG site. www.ostg.com
_______________________________________________ middlegen-user mailing
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Met vriendelijk groet, Wouter Boers

Loading...