1 Reply Latest reply on Mar 10, 2006 7:57 AM by Daniele Stroppa

    JBoss Portal 2.2 with MySQL 5.0.15

    Daniele Stroppa Newbie

      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