Hello Forum...

I'm an absolute newbie with lots of dumb questions. I installed the 5.01RC+glassfish bundle and it loads OK.

When I follow the instructions on how to modify the setup to run on a local MySQL db, I run into problems. The homepage doesn't load (remains blank) and the server.log in domain1 is full of stack traces.

I then installed glassfish standalone, and followed the instructions to add the 5.01RC .WAR file - with the same result.
It's a windows 2003 machine/2GB ram.

I've copied below a portion of the first stack trace in server.log.

[#|2008-06-08T20:00:52.796+0200|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=Timer-7;|20:00:52,796 ERROR [HibernateUtil:207] Caught unexpected exception java.lang.IllegalArgumentException
[#|2008-06-08T20:00:52.812+0200|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=Timer-7;|20:00:52,812 ERROR [HibernateUtil:210] java.lang.IllegalArgumentException: null source
java.lang.IllegalArgumentException: null source
at java.util.EventObject.<init>(EventObject.java:38)
at javax.sql.StatementEvent.<init>(StatementEvent.java:39)
at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:285)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:212)
at org.hibernate.loader.Loader.doQuery(Loader.java:726)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:912)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.liferay.util.dao.hibernate.QueryUtil.list(QueryUtil.java:59)
at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findAll(CompanyPersistenceImpl.java:730)
at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findAll(CompanyPersistenceImpl.java:686)
at com.liferay.portal.service.impl.CompanyLocalServiceImpl.getCompanies(CompanyLocalServiceImpl.java:379)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy37.getCompanies(Unknown Source)
at com.liferay.portal.service.CompanyLocalServiceUtil.getCompanies(CompanyLocalServiceUtil.java:142)
at com.liferay.portal.lucene.IndexWriterFactory.<init>(IndexWriterFactory.java:80)

... and so on.

I'd be most appreciative of any suggestions to help get me over this initial hump.

Many thanks
/j-p.

t appears the JDBC datasource for MySQL was incorrectly configured. The Wiki page does not list the exact steps/commands to setup the MySQL datasources. I will correct the Wiki tomorrow. In the mean time following is how it should look like in your glassfish/domains/domain1/config/domain.xml

<jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="LiferayPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
<property name="Password" value="dbpassword"/>
<property name="User" value="dbusername"/>
<property name="databaseName" value="lportal"/>
</jdbc-connection-pool>

Tomorrow I will post the exact asadmin command that will create the JDBC sources.

_raju

Raju... wow, that was just perfect advice! I'm back in business.

Many thanks,
/j-p.

Hi J-P
Can you add a resolved tag to the subject header of your OP?
Thanks!
-jr

Oops sorry, JR...
I wasn't aware of this action. Will do in future.

thanks
/j-p.

No worries J-P! Forgive me for not being more specific with my words - I meant to edit the subject of your original post with [Resolved] so that users who are having issues with glassfish+MySQL can see the subject and see that its been resolved and know that there's a possible answer in here for people looking.
-jr

Hello JR...
OK Gotchya... tag added to subjectline (I suppose that's what I get for not reading the forum HowTo).

Thanks for your patience.

regards
/j-p.