Really? Create them if it can't find them? I wasn't aware of that, and don't like it at all. Hmmm... it's posible that I didn't specify a schema in the datasource descriptor in JBoss. Thanks!
Gavin On Wednesday, October 1, 2003, 6:39:17 PM, Eivind wrote: > 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
