Gavin Sinclair
2003-10-01 06:17:02 UTC
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
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