Hi Mathieu, thanks for your fast reply!
> We use XDoclet annotations in the source code to generate the mapping. So > you'll have to change those if you want to alter it. Alternatively you can > run on the generated mappings but that's probably a pain (updates). But > why > do you want to change the mapping? Furthermore, thank you for outlining the "where to find" - this helps us a lot!!! We unfortunately have to alter the tables to conform our partner's requirements: (1) project specific tablename prefix (2) "ID" column not allowed -> "tablename_ID" (3) Reserved words (DB2) such as "TYPE" are not allowed as column name Question: shall I post/upload the changes we have made within the simple scheduler? Thanks, Stefan Matthieu Riou-5 wrote: > > On Fri, Apr 25, 2008 at 4:26 AM, Stefan Jakoubi < > [EMAIL PROTECTED]> wrote: > >> Dear ODE community, >> >> >> >> in this mail I (a) follow up a topic raised from a colleague >> (http://ode.markmail.org/message/gyoxq5cz3uruizoc?q=tjoa) of mine and >> (b) raise myself a question concerning configuring ODE for DB2. >> >> >> >> @ (a): >> >> When migrating ODE to DB2 there is a problem within the simple >> scheduler. In particular, the scalar function MOD(x, y) within a >> prepared statement throws an awful exception. >> >> The solution is to replace the MOD(x, y) within the prepared statement >> with: x - y * (x / y). This is according to how DB2 internally >> determines the result for the scalar function MOD. >> >> > Thanks for letting us know. > > >> >> >> @ (b): >> >> Can anybody please provide a complete table schema ODE requires? >> > > You'll get several ones for different databases in dao-hibernate-db/target > after a build. > > >> >> Does anybody know where to configure all required Hibernate mappings so >> that ODE table names may be altered? >> > > We use XDoclet annotations in the source code to generate the mapping. So > you'll have to change those if you want to alter it. Alternatively you can > run on the generated mappings but that's probably a pain (updates). But > why > do you want to change the mapping? > > >> >> When switching persistence to Hibernate, is it true that openjpa is not >> used any more (and thus, no jpa mappings have to be modified in case >> that I alter table names?) >> >> > Right, it's either Hibernate of OpenJPA, they don't coexist. > > >> >> >> Finally I want to tell that as soon as we get a solution for >> JBOSS/ODE/DB2 we will contribute at Jira! >> >> > Thanks! > > Matthieu > > >> >> >> Thanks in advance & cheers, >> >> Stefan >> >> >> >> >> >> > > -- View this message in context: http://www.nabble.com/Hibernate-mappings-tp16899339p16930965.html Sent from the Apache Ode User mailing list archive at Nabble.com.
