Raible's Wiki: RunningOnOracle

At line 43 added 1 line.

database.schema=schemaname (case sensitive using 10g)

At line 44 changed 1 line.

hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

At line 49 changed 1 line.

<div class="note" style="margin: 10px">__NOTE:__ In the listings above, {{database.host}} should refer to the machine the Oracle database is running on. Also, the "mySID" at the end of the {{database.url}} value should refer to the SERVICE_NAME within the tnsnames.ora database file on the database server machine.</div>

You'll also need to add the "database.schema" property to build.xml - in the <dbunit> tasks. For example:

At line 51 changed 1 line.

<div class="note" style="margin: 10px">__NOTE:__ There is also a {{database.name}} parameter available, but usage of it should be avoided. This parameter's value is automatically overwritten by what you will provide in the next step as the {{-Ddb.name}} parameter to the __ant new__ task.</div>

{{{

<dbunit driver="${database.driver_class}" schema="${database.schema}"

supportBatchStatement="false" url="${database.url}"

userid="${database.username}" password="${database.password}">

}}}

At line 53 changed 1 line.

<div class="warning" style="margin: 10px">__WARNING:__ Avoid using "appfuse" as values for any of the parameters here. They will end up getting renamed when you run the "ant new" task below.</div>

<div class="note" style="margin: 10px; background-color: #fcc">__WARNING:__ Avoid the use of "appfuse" as values for any of the parameters here. They may end up getting modified when you run the "ant new" task below.</div>

At line 60 added 4 lines.

<div class="note" style="margin: 10px">__NOTE:__ In the listings above, {{database.host}} should refer to the machine the Oracle database is running on. Also, the "mySID" at the end of the {{database.url}} value should refer to the SERVICE_NAME within the tnsnames.ora database file on the database server machine.</div>

<div class="note" style="margin: 10px">__NOTE:__ There is also a {{database.name}} parameter available, but you should only add it to {{build.properties}} if you want to use a different database name than provided in the {{-Ddb.name}} parameter when you ran the __ant new__ task.</div>

Raible's Wiki

AppFuse

Other Applications

RunningOnOracle