Hi,
I'm trying to install JBoss Portal 2.2.1RC2 on JBoss 4.0.4RC1 (needed for EJB3) using MySQL 5.0.15 as a data source. My portal-mysql-ds.xml file looks like this
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>MySQLPortalDS</jndi-name> <connection-url>jdbc:mysql://LGB201002:3306/jbossportal?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>jboss</user-name>
portal
</local-tx-datasource>
the database is created correctly and the user jboss has full privileges on it. MySQL is running on my machine (LGB201002) on port 3306, so I assume this is the correct configuration. Also I modified all the instances of PortalDs to be MySQLPortalDS. The mySQL connector (ver 3.1.12) is stored in /server/default/lib.
When I start the JBoss server I keep on getting this error:
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:service=DataSourceBinding,name=MySQLPortalDS
State: NOTYETINSTALLED
Depends On Me:
portal:service=CMS
portal:service=TreeCache,type=persistent
portal:service=Hibernate
portal:service=Hibernate,type=globalinstance
portal:service=Hibernate,type=globalportal
ObjectName: portal:policy=PortalPolicyConfigStore,type=Component
State: FAILED
Reason: java.lang.IllegalArgumentException: No transaction manager provided
I Depend On:
portal:policy=JaccPortalPolicyConfigurator
portal:service=TreeCacheProvider,type=transient
portal:policy=PortalPolicyConfigService
Depends On Me:
portal:deploymentFactory=PortletApp
I've gone through the forum, tried a couple of things that seemed to apply to my problem, but I still get the same problem.
Any help?
thanks
Dan
Solved!
A bit more of searching and I found this
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=76867&postdays=0&postorder=asc&start=10
also, the & in the <connection-url> of my datasource xml file has changed to be &
That's it, it worked for me.
Dan