[jira] Resolved: (JS2-552) DB2 configuration not included

["David Sean Taylor (JIRA)" <je...@portals.apache.org>]

     [ http://issues.apache.org/jira/browse/JS2-552?page=all ]

David Sean Taylor resolved JS2-552.
-----------------------------------

    Resolution: Fixed

DB2 official support for Jetspeed-2

* minor adjustment to DB PSML schema for DB2 support via Torque
* specific DB population script
* ran allTest, dbpm importer, interactive testing

To change to DB2
(1) Apply patch or get latest source with schema changes 
(2) place db2-jdbc driver jars in directory readable from build processes
(3) change build.properties with db settings as shown in sample - ensure that db2 instance listens to the right port number 
rebuild

(4)
place db2 jars into tomcat/common/endorsed

# -------------------------------------------------------------------------
# J2 configure DB2 Production DB
# -------------------------------------------------------------------------
org.apache.jetspeed.production.database.default.name=db2
org.apache.jetspeed.production.database.url = jdbc:db2://your.db2_server.com:50000/j2
org.apache.jetspeed.production.database.driver = com.ibm.db2.jcc.DB2Driver
org.apache.jetspeed.production.database.user = db2admin
org.apache.jetspeed.production.database.password = xxxxxxx
org.apache.jetspeed.production.jdbc.drivers.path=<path_to_db2_driver>/db2jcc.jar;<path_to_db2_driver>/db2jcc_license_cu.jar

org.apache.jetspeed.test.database.default.name=db2
org.apache.jetspeed.test.database.url = jdbc:db2://your.db2_server.com:50000/j2test
org.apache.jetspeed.test.database.driver = com.ibm.db2.jcc.DB2Driver
org.apache.jetspeed.test.database.user = db2admin
org.apache.jetspeed.test.database.password = xxxxx
org.apache.jetspeed.test.jdbc.drivers.path=<path_to_db2_driver>/db2jcc.jar;<path_to_db2_driver>/db2jcc_license_cu.jar


> DB2 configuration not included
> ------------------------------
>
>                 Key: JS2-552
>                 URL: http://issues.apache.org/jira/browse/JS2-552
>             Project: Jetspeed 2
>          Issue Type: Improvement
>          Components: Persistence and DAO
>    Affects Versions: 2.0-FINAL
>            Reporter: Tod Matola
>         Assigned To: David Sean Taylor
>
> Decriptive information about the portal describe DB2 as an option, but the installer and the source bundles do not support DB2 sql generation.
> There are no instructions included that describe the process of using DB2 (although it claims to have been tested). 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org