I have no idea how this is ever supposed to work for Oracle as this schema definition looks to come from OJB itself!
More general, what does this schema definition do? And is the OJB_DMAP_ENTRIES table needed? It probably is required for OJB but is it dependent on how OJB is used or just always required (that would wonder me because then OBJ usage for Oracle would be impossible as such).
Another problem with Torque is the sql generated from security-schema.xml. It defines two foreign key constraints whose name is longer than 30 characters which is the limit for Oracle. As I don't have any experience with Torque I don't know if and then how this restriction can be configured. I would think some sort of Oracle specific implementation class should handle those but I couldn't find out where or how to enforce Torque to use it.
I temporarily handled these issues by patching the generated sql by hand. Which is not a good idea of course. The first time I did run allBuild again I lost my changes as to be expected. So I hacked the maven allBuild goal to not regenerate the sql every time allBuild is run. Which I think could be better overall. How often will the schema change anyhow. Only then, and for a first time build that would be required. I suggest adding a instruction in GETTING-STARTED.html for the first time users to manually first generate the sql before doing an allBuild just like they have to do a db.recreate before a fullDeployment.
One last question of more informative nature. I saw Torque generate a sqldb.map file. What is that supposed to do?
Regards,
Ate
Ate Douma wrote:
I've created Blocking issue JS2-18 last night after a long frustrated day trying to get J2 ready to use Oracle as db.
In that issue I identified (at least) 5 major problems I like to ask attention to.
Although JIRA is fine for issue tracking I think the mailing list is more interactive to discuss these issues.
Therefore I created this mail as a wrapper for the several problems which I will describe separately as reply to this mail.
I am very dependent on Oracle for running J2 as it is required for my client. Furthermore, in our project we will start developing portlets based on J2 any time now (I know its kind of early for that but we need some result before the summer and hopefully our development will provide lots of feedback to J2 to help it get out of the door sooner).
Regards, Ate
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
