[JBoss-user] [JBoss Portal] - Re: mysql connection to portal
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) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899411#3899411 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899411 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Re: mysql connection to portal
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. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899390#3899390 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899390 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Re: mysql connection to portal
Put the password inside a password element: userpassword That may fix it. Regards, Scott Dawson Unisys View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899389#3899389 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899389 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Re: mysql connection to portal
Here it is. PortalDS jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false com.mysql.jdbc.Driver username userpassword Thanks, Robert View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899292#3899292 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899292 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Re: mysql connection to portal
Please show the contents of your portal datasource file. Scott Dawson Unisys View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899145#3899145 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899145 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user