Hi, I've fixed my create table problem (mentioned below), by setting the Jboss createTable attribute to false. Now the deployed jar is giving me problems with the SELECT. It throws the following exception:
[ObjectName: jboss.j2ee:jndiName=MyBeanLocalHome,service=EJB state: FAILED I Depend On: Depends On Me: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT DISTINCT OBJECT(o) FROM MyBean o WHERE o.budget = ?1' ; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encounter ed "o.budget" at line 1, column 57. Was expecting one of: "NOT" ... "(" ... <COLLECTION_VALUED_PATH> ... <STRING_VALUED_PATH> ... It's important to note that in my server log file it lists all of my localHome classes as started except for this one. This is quite strange because I think there's not much of a difference between my tables. > > > Hi all, I think I've finally minimized my > > middlegen > > > build file but I'm still having problems > deploying > > > the > > > generated .jar in Jboss. > > > > > > The thing is that I thought it might have been a > > > problem with a recursive relationship that I had > > due > > > to the fact that this was the only bean that was > > > giving me trouble. I eliminated this > relationship > > in > > > my database (using MSSQL 2000), for testing > > purposes > > > and it still throws exceptions while deploying. > > > > > > The error is: > > > > > > [ObjectName: > > jboss.j2ee:jndiName=myName,service=EJB > > > state: FAILED > > > I Depend On: > > > Depends On Me: > > > org.jboss.deployment.DeploymentException: Error > > > while > > > creating table; - nested throwable: > > > (java.sql.SQLException: [Microsoft][SQLServer > 2000 > > > Dri > > > ver for JDBC][SQLServer]Line 1: Incorrect syntax > > > near > > > '.'.)] > > > > > > I have no clue as to why it tries to create the > > > table, > > > my build file doesn't include anything of the > > sort. > > > > > > I would truly truly appreciate any help. > > > > > > Thanx. __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ------------------------------------------------------- This SF.net email is sponsored by: eBay Get office equipment for less on eBay! http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user