Doesn't JBoss create the tables if it can't find them? Could it be that your jdbc connection in JBoss is not set up with the same schema etc. as the one Middlegen uses?
Just guessing here really, have not had this problem myself. .eivind On Wed, 1 Oct 2003, Gavin Sinclair wrote: > Hi, > > I have spent a lot of time playing with the Middlegen demo, and am > grateful for the effort that has been put into it. > > I have spent even more time trying to adapt it to the EJB situation I have > at work, where about 10 tables in an Oracle database need to have entity > beans modelled on them. So I have adapted the sample's build.xml, as is > intended, and have been mostly successful. However, when I run JBoss, I > get the following error message: > > org.jboss.deployment.DeploymentException: Error while creating table; - > nested throwable: (java.sql. > SQLException: [DataDirect][Oracle JDBC Driver][Oracle]ORA-00904: invalid > column name > ) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:178) > ..... > > > Now I understand that in the demo, hsqldb is used and it creates tables > all the time. Well, I think I understand. Anyway, I don't see why this > would carry over to Oracle. And having scoured the build script, > configuration files, generated code, etc., I don't see what is directing > JBoss (3.2.1) to exhibit this behaviour. > > Does anyone have a possible explanation for this? I haven't given much > detailed information, because it appears to be an artifact of the demo > that hopefully someone will recognise. However, if build.xml or anything > else is required, I'll be happy to provide it. Some baseline information: > - I have removed the airline.ear file and the hsqldb-ds.xml files > from the deploy directory, so there should be no influence from them > - I'm using middlegen v2.0-b1 > > Thanks very much for any help provided, > Gavin > > > > > ------------------------------------------------------- > 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 > ------------------------------------------------------- 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
