Hi,
simply take the Derby DDLs and change the index names (they are longer
than supported by DB2).
If you want comfort, you can simply put them in the same maven plugin
directory where the others database scripts are. Then simply add
<j:when test="${dbase == 'db2'}">
<j:set var="org.apache.jetspeed.target.rdbms.name" value="db2"/>
<j:set var="org.apache.jetspeed.target.rdbms.dropdrops"
value="true"/>
</j:when>
to plugin.jelly .
now edit build.properties like this:
org.apache.jetspeed.test.database.url =
jdbc:db2://localhost:50000/tdbname
org.apache.jetspeed.test.database.driver = com.ibm.db2.jcc.DB2Driver
org.apache.jetspeed.test.database.user = tdbuser
org.apache.jetspeed.test.database.password = tdbpwd
org.apache.jetspeed.test.jdbc.drivers.path=c:/Programme/IBM/SQLLIB/java/db2jcc.jar;c:/Programme/IBM/SQLLIB/java/db2jcc_javax.jar;c:/Programme/IBM/SQLLIB/java/db2jcc_license_cu.jar
org.apache.jetspeed.test.database.default.name=db2
org.apache.jetspeed.production.database.url =
jdbc:db2://localhost:50000/pdbname
org.apache.jetspeed.production.database.driver =
com.ibm.db2.jcc.DB2Driver
org.apache.jetspeed.production.database.user = pdbuser
org.apache.jetspeed.production.database.password = pdbpwd
org.apache.jetspeed.production.jdbc.drivers.path=c:/Programme/IBM/SQLLIB/java/db2jcc.jar;c:/Programme/IBM/SQLLIB/java/db2jcc_javax.jar;c:/Programme/IBM/SQLLIB/java/db2jcc_license_cu.jar
org.apache.jetspeed.production.database.default.name=db2
Frank
Michel Jonker wrote:
Hi,
I am looking for tips and samples on how to configure jetspeed-2 to
use DB2 (Express-C).
I found that this link :
http://portals.apache.org/jetspeed-2/guide-database.html is unavailable.
And in de mutliDB distribution there are DDL's for Oracle, mssql and
MySql but not for DB2 ....
If someone could point me to the right spot/doc/build that would be
great...
tia
Michel
De informatie in dit e-mailbericht (inclusief aanhangsels) is
vertrouwelijk en is alleen bestemd voor de beoogde ontvanger(s).
Indien u dit bericht onterecht heeft ontvangen, wordt u verzocht het
bericht te retourneren en de ontvangen informatie op geen enkele wijze
te gebruiken.
The information contained in this e-mail (attachments included) may be
confidential and is intended solely for the person(s) indicated in the
message. Should you have received this e-mail unintentionally, please
return it to the sender and do not use the content of the message in
any way.
Michel Jonker wrote:
Hi,
I am looking for tips and samples on how to configure jetspeed-2 to use
DB2 (Express-C).
I found that this link :
http://portals.apache.org/jetspeed-2/guide-database.html is unavailable.
And in de mutliDB distribution there are DDL's for Oracle, mssql and MySql
but not for DB2 ....
If someone could point me to the right spot/doc/build that would be
great...
tia
Michel
De informatie in dit e-mailbericht (inclusief aanhangsels) is vertrouwelijk en is alleen bestemd voor de beoogde ontvanger(s). Indien u dit bericht onterecht heeft ontvangen, wordt u verzocht het bericht te retourneren en de ontvangen informatie op geen enkele wijze te gebruiken.
The information contained in this e-mail (attachments included) may be
confidential and is intended solely for the person(s) indicated in the message.
Should you have received this e-mail unintentionally, please return it to the
sender and do not use the content of the message in any way.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
