...
Opening /uPortal/pom.xml there is a section about 92 lines down that reads:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<!-- The JDBC Driver used by uPortal -->
<jdbc.groupId>hsqldb</jdbc.groupId>
<jdbc.artifactId>hsqldb</jdbc.artifactId>
<jdbc.version>${hsqldb.version}</jdbc.version>
|
We will add the Oracle driver here using the group, artifact and version information from the mvn install:install-file command above.
| Code Block | ||||
|---|---|---|---|---|
| ||||
<!-- The JDBC Driver used by uPortal --> <jdbc.groupId>com.oracle</jdbc.groupId> <jdbc.artifactId>ojdbc14</jdbc.artifactId> <jdbc.version>10.2.0.3.0</jdbc.version> |
...
| Code Block |
|---|
##### Oracle 10g - example
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@my.school.edu:1521:PROJECTS
hibernate.connection.username=test
hibernate.connection.password=mypass
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
|
...
If it works correct you should see something like:
| Code Block |
|---|
[java] Connected To: jdbc:oracle:thin:@yourserver:1521:uportal
[java] Supports:
[java] Outer Joins: true
[java] Transactions: true
[java] {ts metasyntax: true
[java] TO_DATE(): false
[java] Database name: 'Oracle'
[java] Database version: 'Oracle Database 11g Release 11.1.0.0.0 - Production'
[java] Driver name: 'Oracle JDBC driver'
[java] Driver version: '10.2.0.3.0'
[java] Driver class: 'Oracle JDBC driver'
[java] Connection URL: 'jdbc:oracle:thin:@yourserver:1521:uportal'
[java] User: 'USERNAME'
[java] Type Mappings: [Type[genericType=TIMESTAMP,local=DATE]]
[java] supportsANSI92EntryLevelSQL: true
[java] supportsANSI92FullSQL: false
[java] supportsCoreSQLGrammar: true
[java] supportsExtendedSQLGrammar: true
[java] supportsTransactions: true
[java] supportsMultipleTransactions: true
[java] supportsOpenCursorsAcrossCommit: false
[java] supportsOpenCursorsAcrossRollback: false
[java] supportsOpenStatementsAcrossCommit: false
[java] supportsOpenStatementsAcrossRollback: false
[java] supportsStoredProcedures: true
[java] supportsOuterJoins: true
[java] supportsFullOuterJoins: true
[java] supportsLimitedOuterJoins: true
[java] supportsBatchUpdates: true
[java] supportsColumnAliasing: true
[java] supportsExpressionsInOrderBy: true
[java] supportsOrderByUnrelated: true
[java] supportsPositionedDelete: false
[java] supportsSelectForUpdate: true
[java] supportsUnion: true
[java] supportsUnionAll: true
[java] getMaxColumnNameLength: 30
[java] getMaxColumnsInIndex: 32
[java] getMaxColumnsInOrderBy: 0
[java] getMaxColumnsInSelect: 0
[java] getMaxColumnsInTable: 1000
[java] getMaxConnections: 0
[java] getMaxCursorNameLength: 0
[java] getMaxIndexLength: 0
[java] getMaxRowSize: 2000
[java] getMaxStatements: 0
[java] getMaxTableNameLength: 30
[java] getMaxTablesInSelect: 0
[java] getMaxUserNameLength: 30
[java] getSearchStringEscape: //
[java] getStringFunctions: ASCII,CHAR,CONCAT,LCASE,LENGTH,LTRIM,REPLACE,RTRIM,SOUNDEX,SUBSTRING,UCASE
[java] getSystemFunctions: USER
[java] getTimeDateFunctions: HOUR,MINUTE,SECOND,MONTH,YEAR
[java] Table Types: SYNONYM,TABLE,VIEW
[java] SQL Types: INTERVALDS,INTERVALYM,TIMESTAMP WITH LOCAL TIME ZONE,TIMESTAMP WITH TIME ZONE,
NUMBER,NUMBER,NUMBER,LONG RAW,RAW,LONG,CHAR,NUMBER,NUMBER,NUMBER,FLOAT,REAL,VARCHAR2,DATE,DATE,
TIMESTAMP,STRUCT,ARRAY,BLOB,CLOB,REF
BUILD SUCCESSFUL
|
Edit /uPortal/uportal-impl/src/main/resources/properties/db/dbloader.xml and verify that there is an entry just like the database version you displayed in the last step:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<db-type-mapping>
<db-name>Oracle</db-name>
<db-version>Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining options</db-version>
<driver-name>Oracle JDBC driver</driver-name>
<driver-version>10.2.0.3.0</driver-version>
<type><generic>TIMESTAMP</generic><local>DATE</local></type>
<!-- map more types here -->
</db-type-mapping>
|
...