-
1. Re: JBoss Portal + JBoss AS 4.0.3SP1 question regarding MySQ
bdaw Feb 10, 2006 3:21 AM (in response to mathuran)Did you check docs for the information you are looking for?
http://docs.jboss.com/jbportal/v2.2/user-guide/en/html/installation.html
http://www.jboss.com/products/jbossportal/docs
There is a migration tool under developement but already usable:
http://wiki.jboss.org/wiki/Wiki.jsp?page=MigrationFromPortal20ToPortal22
Any feedback on this will be valuable.
Forums Portlet DB schema should be the same in 2.0 and 2.2 so migration doesn't cover it. You should simply move forums tables ("jbp_forums_*") into 2.2 database. Just remember to backup your DB before playing with this. -
2. Re: JBoss Portal + JBoss AS 4.0.3SP1 question regarding MySQ
mathuran Feb 10, 2006 10:14 AM (in response to mathuran)I will be migrating from Novell exteNd to JBoss, so I need to migrate my database created under that environment to the JBoss one. How do I do that?
-
3. Re: JBoss Portal + JBoss AS 4.0.3SP1 question regarding MySQ
mjohnpeter Feb 10, 2006 11:01 PM (in response to mathuran)you have to do two steps
1 copy msql-ds.xml from(C:\jboss-4.0.3SP1\docs\examples\jca\)
and past it in to deploy dir..
you have to spcifie the databse propertices
example
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->
<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossportal</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
*
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<type-mapping>mySQL</type-mapping>
</local-tx-datasource>
2 you have to make two chaneges in (C:\jboss-4.0.3SP1\server\default\conf)
standardjbosscmp-jdbc.xml
1)
<datasource-mapping>java:/MySqlDS</datasource-mapping>
2)
</type-mapping>
<type-mapping>
mySQL
regards
Peter