Raible's Wiki: RunningOnOracle

At line 40 removed 9 lines.

#database.admin.* info is for autogenerating schema account (works only with MySQL)

#database.admin.url=jdbc:${database.type}://${database.host}/template1

#database.admin.username=adminname

#database.admin.password=adminpwd

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

database.driver_class=oracle.jdbc.driver.OracleDriver

database.url=jdbc:oracle:thin:@localhost:1521:mySID

At line 43 added 5 lines.

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

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

database.driver_class=oracle.jdbc.driver.OracleDriver

database.url=jdbc:oracle:thin:@localhost:1521:mySID

At line 54 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 56 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 58 added 1 line.

<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