5 Replies Latest reply on Oct 5, 2005 3:40 PM by Robert Hunter

    mysql connection to portal

    Robert Hunter Newbie

      I'm getting the following error:

      -- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      bjectName: jboss.jca:service=DataSourceBinding,name=PortalDS
      State: NOTYETINSTALLED
      Depends On Me:
      portal:service=CMS
      portal:service=Hibernate

      Both services show as state:configured.

      I'm using the default jboss 4.0.2 install and mysql 5.0 on win xp pro.
      It's preventing the portal from deploying. Where do I start looking to fix this?

      Thanks in advance.
      Robert




        • 1. Re: mysql connection to portal
          Scott Dawson Apprentice

          Please show the contents of your portal datasource file.

          Scott Dawson
          Unisys

          • 2. Re: mysql connection to portal
            Robert Hunter Newbie

            Here it is.

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

            <local-tx-datasource>
            <jndi-name>PortalDS</jndi-name>
            <connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection-url>
            <driver-class>com.mysql.jdbc.Driver</driver-class>
            <user-name>username</user-name>
            userpassword
            </local-tx-datasource>


            Thanks,
            Robert

            • 3. Re: mysql connection to portal
              Scott Dawson Apprentice

              Put the password inside a password element:
              userpassword

              That may fix it.

              Regards,
              Scott Dawson
              Unisys

              • 4. Re: mysql connection to portal
                Scott Dawson Apprentice

                Never mind. As soon as I posted my reply, I see that the password element gets hidden by the forum, so you probably already have it. (Look at your post and you'll see what I mean. Anyway, your ds file looks just like mine.

                • 5. Re: mysql connection to portal
                  Robert Hunter Newbie

                  After I restarted the AS server a few times the portal deployed. I'm not sure why. But it doesn't run the setup.txt script correctly to set the admin password. The error is below. Any idea's?

                  Thanks,
                  Robert

                  12:08:54,242 INFO [NamingHelper] JNDI InitialContext properties:{}
                  12:08:54,242 INFO [DatasourceConnectionProvider] Using datasource: java:PortalD
                  S
                  12:09:01,112 INFO [SchemaExport] schema export complete
                  12:09:01,112 INFO [SessionFactoryBinder] Creating database content
                  12:09:01,303 WARN [JDBCExceptionReporter] SQL Error: 1406, SQLState: 22001
                  12:09:01,303 ERROR [JDBCExceptionReporter] Data too long for column 'jbp_viewrea
                  lemail' at row 1
                  12:09:01,303 ERROR [SessionFactoryBinder] Error in the bsh script
                  Sourced file: inline evaluation of: ``// This bsh script setup the default conte
                  nt of the portal. // It is called whe . . . '' : Method Invocation session.save
                  : at Line: 41 : in file: inline evaluation of: ``// This bsh script setup the d
                  efault content of the portal. // It is called whe . . . '' : session .save ( ad
                  min )

                  Target exception: org.hibernate.exception.GenericJDBCException: could not insert
                  : [org.jboss.portal.core.impl.user.UserImpl]

                  at bsh.BSHMethodInvocation.eval(Unknown Source)
                  at bsh.BSHPrimaryExpression.eval(Unknown Source)
                  at bsh.BSHPrimaryExpression.eval(Unknown Source)
                  at bsh.BSHBlock.evalBlock(Unknown Source)
                  at bsh.BSHBlock.eval(Unknown Source)
                  at bsh.BSHBlock.eval(Unknown Source)