1 2 Previous Next 18 Replies Latest reply on Jun 21, 2006 10:37 AM by silicio Go to original post
      • 15. Re: JBoss Portal & MySql
        theute

        Danny, stick with the installation instruction.

        Keep the predefined hsqldb-ds.xml
        Add the portal-ds.xml i gave you.

        You tried to install 2 PortalDS datasources. That's what the message is telling you

        • 16. Re: JBoss Portal & MySql
          dgaethofs

          Thomas,

          Steps I took now are:
          1. Removed the mysql-connector-java-3.1.12-bin-g.jar from the bin directory.

          2. Put back the mysql-ds.xml which I found in the docs/examples/jca directory.

          3. Made sure the portal-mysql-ds.xml is correct

          Now I notice some schematables and schema indices are created in the database. However when I try to start the portal.
          http://localhost:8080/portal
          I get a Java nullpointer error.


          What is wrong here?


          mysql-ds.xml
          =========
          <?xml version="1.0" encoding="UTF-8"?>

          <!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver 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>DefaultDS</jndi-name>
          <connection-url>jdbc:mysql://localhost:3306/jbossportal</connection-url>
          <driver-class>com.mysql.jdbc.Driver</driver-class>
          <user-name>jboss</user-name>
          portal
          <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
          <!-- should only be used on drivers after 3.22.1 with "ping" support
          <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-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 - MySQLValidConnectionChecker is preferred for newer drivers
          <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>



          portal-mysql-ds.xml
          =============
          <?xml version="1.0" encoding="UTF-8"?>

          <local-tx-datasource>
          <jndi-name>portalDS</jndi-name>
          <connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false</connection-url>
          <driver-class>org.gjt.mm.mysql.Driver</driver-class>
          <user-name>jboss</user-name>
          portal
          </local-tx-datasource>

          • 17. Re: JBoss Portal & MySql
            dgaethofs

            Dear all,

            I FINALLY GOT IT WORKING! THANKS TO ALL OF YOU. Especially Thomas, cause I believe your last remarks made the difference.

            Regards,
            Danny

            • 18. Re: JBoss Portal & MySql
              silicio

              I'm interested in this topic. Where was the problem dgaethofs?

              1 2 Previous Next