1) When using oracle with Torque, we have come to the conclusion that when generating the java code, the Oracle service name (SID) is hard-coded into the java code itself. This means that we must re-compile the java classes for each new SID? Can anyone confirm if I am correct with this theory ?
Almost.
Torque writes a default database name (static final String DATABASE_NAME) in your peer classes. That database name is just a handle. The DB of it (SID etc.) is configured in your properties file.
You can configure more than one database names in that property file, and you can specify differen database names in Criteria constructors.
Check out another thread from a few days ago - some work on this needs to be done (or some documentation at least, maybe).
Have fun, Ekkehard
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
