-
1. Re: problems with jportal installation
scottlholmes Jul 4, 2005 9:38 PM (in response to g_nadia)I needed to read the following several times to figure out what was up with my configuration:
http://docs.jboss.com/jbportal/v2.0Final/user-guide/en/html/installation.html
I'm not sure if I needed to do this or not but I did seem to get ahead a little:
Edit jboss-portal.sar/conf/hibernate/hibernate.cfg.xml AND portal-forums.sar/conf/hibernate/hibernate.cfg.xml
<!-- Force the dialect instead of using autodetection -->
org.hibernate.dialect.MySQLDialect
Also, towards the bottom of the installation guide are instructions for destroying and then re-creating the schema and then loading the content. Going through these steps did the trick, I think.
I still get quite alot of errors everywhere but everything seems to sortta work. -
2. Re: problems with jportal installation
gontouf Jul 6, 2005 8:38 AM (in response to g_nadia)You can try this, it works for me with an Oracle9i database and last versions of JBoss AS and JBoss portal (not the bundled pack)...i'm not an expert so i'm not sure it's the best solution but now i have a great install of the portal with no errors.
I have modified these files:
- standardjaws.xml:
java:/OracleDS
<type-mapping>Oracle8</type-mapping>
- standardjboss-cmp-jdbc.xml:
<jbosscmp-jdbc>
java:/OracleDS
<datasource-mapping>Oracle8</datasource-mapping>
</jbosscmp-jdbc>
- oracle-ds.xml:
you can find an example in jboss-portal-home\docs\examples\jca and you just need to put your connection parameter.
- portal-oracle-ds.xml:
you can find an example in jboss-portal-home\docs\portal\setup and you just need to put your connection parameter.
- login-config.xml:
<application-policy name = "OracleDbRealm">
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">xxx</module-option>
<module-option name = "userName">xxx</module-option>
<module-option name = "password">yyy</module-option>
<module-option name ="managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=OracleDS
</module-option>
</login-module>
</application-policy>
...
<!-- Security domains for testing new jca framework -->
<application-policy name = "OracleDbRealm">
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">xxx</module-option>
<module-option name = "userName">xxx</module-option>
<module-option name = "password">yyy</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=OracleDS</module-option>
</login-module>
</application-policy>
- oracle-jdbc-state-service.xml:
( i have renamed the hsqldb file and modify the value DefaultDS in OracleDS)
<depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=OracleDS
- oracle-jdbc3-service.xml
you can find an example in jboss-portal-home/docs/examples/jms
- ejb-deployer.xml:
<depends optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=OracleDS
After that, you need to delete hsqldb.jar, and these files:
hsqldb-ds.xml, portal-hsqldb-ds.xml, and hsql-jdbc-service.xml
i think it's the same for you with MySQL parameter...
i wish it'll help... and tell me if it works for you too :) -
3. Re: problems with jportal installation
roy.russo Jul 6, 2005 4:18 PM (in response to g_nadia)Try recreating the tables and recreating the content as scott describes: http://docs.jboss.com/jbportal/v2.0Final/user-guide/en/html/installation.html#d0e657
-
4. Re: problems with jportal installation
g_nadia Jul 8, 2005 7:19 AM (in response to g_nadia)thanks to all to have helped me.
I recreated the tables and the content whit hibernate mbean ... a couple of times ... and now all is ok :-).
Nadia -
5. Re: problems with jportal installation
fritzwf Jan 3, 2006 2:14 PM (in response to g_nadia)You may want to update the JBoss Portal 2.2 User Guide pdf document. The things referenced in the message above that are in the html version are not in the pdf document. I would have saved a lot of time if I knew this.
Thanks -
6. Re: problems with jportal installation
roy.russo Jan 3, 2006 3:01 PM (in response to g_nadia)This thread is relevant to 2.0. Did this solve an Oracle deployment for you in 2.2?
-
7. Re: problems with jportal installation
fritzwf Jan 9, 2006 5:07 PM (in response to g_nadia)It turns out that only the online docs have section 2.5.3. The docs that are distributed with JBoss Portal source project don't have this section.