-
1. Re: Problems with JBoss POrtal and DB2
jschmi Jun 16, 2006 10:40 AM (in response to merz!)hallo,
your <connection-url> has been set up incorrectly! It should be:
"<connection-url>jdbc:db2://ip-addr:port/PORTALDB</connection-url> "
Port should be 50000 (you can check with netstat).
Additionally you will have you to code DB Dialect settings for the portal core - see User's Guide chapter 3.3. (DB-Dialect is "DB2Dialect"). I'm
using userid "db2inst1" which has DBADM. But you could use any other user which has DBADM on your database. ("grant dbadm on database to youruserid").
I'm currently using DB2 with Portal 2.2.1 - so far I've not seen any Problems. -
2. Re: Problems with JBoss POrtal and DB2
merz! Jun 16, 2006 11:33 AM (in response to merz!)Hey ...
So first thanks for ya help, but it still doesn't work ...
I am getting the following error:ObjectName: portal:service=CMS State: FAILED Reason: org.apache.jackrabbit.core.config.ConfigurationException: File system initialization failure.: failed to initialize file system: Could not find dataso urce: failed to initialize file system: Could not find datasource I Depend On: jboss.jca:service=DataSourceBinding,name=DB2DS portal:service=JAASLoginModule Depends On Me: portal:mapper=CMSObject
I found a HOWTO at http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504vohra/index.html but that also does not work ...
So here is what I did:
(1) I deployed JBoss AS and JBoss Portal in a bundle, found this on JBoss.org
(2) I copied db2-ds.xml to server/deploy and changed the stuff I told before and the stuff u told me ...
(3) I creaeted the table referenced in db2-ds.xml
(4) I tried connecting to the database --> worked properly...
So do you have any additional tips for me ? what did I do wrong ?
Thanks once again ... Frank ... -
3. Re: Problems with JBoss POrtal and DB2
jschmi Jun 17, 2006 3:22 AM (in response to merz!)hey,
you should have a datasource "portal-db-ds.xml" which defines a datasource "PortalDS" (or you could change your db2-ds.xml accordingly):<?xml version="1.0" encoding="UTF-8"?> <!-- ===================================================================== --> <!-- --> <!-- JBoss Server Configuration --> <!-- --> <!-- ===================================================================== --> <!-- $Id: portal-db2-ds.xml,v 1.0 2006/06/15 14:37:40 jschmi@t-online.de $ --> <datasources> <local-tx-datasource> <jndi-name>PortalDS</jndi-name> <connection-url>jdbc:db2://localhost:50000/portalDB</connection-url> <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class> <user-name>db2inst1</user-name> <password>geheimpw</password> <min-pool-size>5</min-pool-size> <metadata> <type-mapping>DB2</type-mapping> </metadata> </local-tx-datasource> </datasources>
-
4. Re: Problems with JBoss POrtal and DB2
merz! Jun 19, 2006 5:22 AM (in response to merz!)Hey jschmi ...
Thanks a lot to you, my database connection is working properly now ...
Actually that is what i am thinkin ... when I start Jboss AS tables are created ... But still, my changes are not saved ... can you help me with this problem, too ???
explainations:
When I start JBoss Portal, there are some sample portlets, that I don't wanne keep in my portal ... So I manage portals by the management portlet ... but when I stop/start the server afterwards all deleted pages ("test" page) are shown again !!! when I delete simple portlets from a page, these are deleted after restart, too ... but deleted pages are not deleted after restart ...
what might be my fault ? I thought, changes are saved in the database ???
Thanks for ya help ... Frank ...