First of all I am glad to have the new version at my hands. I can not get the CVS versions so I need to wait before a new release is brought out.
I worked for 3 days with MySQL 4.0 and JBoss 3.0/Tomcat 4.0.4. This combination gave me errors on the EJB-QL for the flight.reservation SQL. I have no idea to go around it. I also tried it with 1 simple 3 fields table (PK which is an autosequence and 2 character fields not null). The insert struts form gave me the error that the create was not present. It was the create with only the 2 character fields.
Fortunately I also can use Oracle/Weblogic. Here I got the example working after a long while. I have, besides questions on the MySQL/JBoss/Tomcat side, a few remarks.
- In my opinion the ${unique.name} should be the one that you use for your java classes (com.java.something) and the ${name} for the name of the application components (ear, jar, war). In the build file they are not used that way. Maybe this can change.
- If I want to generate multiple applications I always need to have a full set of JARs in the lib directory. Maybe it is better to put this directory in the middlegen root. This way only one set is needed.
- Perhaps the same thing can be said for the build.properties.
- In the cmp20-<EJB>-class-comments.txt the class is hard-coded. Is there a way that it can be set to the interfacepackage?
- In the middlegen task in the middlegen tag the schema attribute is empty. Shouldn't this be ${database.schema}?
- In the ejbdoclet task in the weblogic and jboss tag the datasource attribute is 'hard-coded'. Shouldn't this be set in the weblogic.xml and jboss.xml config file? The datasource is also used in the middlegen task/middlegen tag.
- Can you put in an example for an Oracle Sequence or an autoincrement primary key?
- A byte is used for a tiny int in MySQL. This causes problems when the field contains a NULL value. Can this be set to an other type?
- When I have a date as a primary key there is a problem with some methods. They use the predecated method java.sql.Date(String) and the compilation stops. Why isn' t the same function used as for the 'normal' date fields?
Marco de Booy
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user