Re: Why is JBoss *creating* tables?

--- Gavin Sinclair <[email protected]> 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

Loko at the error message carefully - it says that it
does not like DB column name. Most probably is that 
some property name is reserved word in oracle. 

regards,

=====
----[ Konstantin Pribluda ( ko5tik ) ]----------------
Zu Verstärkung meines Teams suche ich ab Sofort einen
Softwareentwickler[In] für die Festanstellung. 
Arbeitsort: Mainz 
Skills:  Programieren, Kentnisse in OpenSource-Bereich
----[ http://www.pribluda.de ]------------------------

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf