...
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:
...
<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>
If there is not an exact match, then add it.
Execute "ant initportal" to build the database tables and copy files to your servlet container
...