dev@glassfish.java.net

Re: Anyone else try using the admin gui to create a MySQL DataSource in prelude GA

From: Yifeng <Yifeng.Luo_at_Sun.COM>
Date: Thu, 30 Oct 2008 14:55:50 -0700

Thanks Lance, I didn't have jdbc driver in
glassfish\domains\domain1\lib\ext directory, hence I can get to the next
screen. And I can see the same stacktrace in server.log.

Could you file an issue for your original problem?

Lance J. Andersen wrote:

> Hi Yifeng,
>
> thanks for the note.
>
>
>
> That is what I am running as well. I just did a fresh install after
> blowing away prelude completely and i am able to get to the next
> screen if and only if I do not have the mysql jdbc driver in
> glassfish\domains\domain1\lib\ext directory. If the mysql jdbc driver
> is in glassfish\domains\domain1\lib\ext, i get the stacktrace in the
> servlet gui as i sent previously. I am using the 5.1.6 driver which
> we use for MySQL testing for CTS.
>
> Here is the stacktrace i get when the driver is not in
> glassfish\domains\domain1\lib\ext
>
> SEVERE: java.lang.ClassNotFoundException:
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource
> SEVERE: at
> org.glassfish.web.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1509)
>
> SEVERE: at
> com.sun.enterprise.connectors.util.ConnectionDefinitionUtils.getConnectionDefinitionProperties(ConnectionDefinitionUtils.java:69)
>
> SEVERE: at
> com.sun.enterprise.connectors.util.ConnectionDefinitionUtils.getConnectionDefinitionPropertiesAndDefaults(ConnectionDefinitionUtils.java:166)
>
> SEVERE: at
> com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getConnectionDefinitionPropertiesAndDefaults(ConnectorConnectionPoolAdminServiceImpl.java:408)
>
> SEVERE: at
> com.sun.enterprise.connectors.ConnectorRuntime.getConnectionDefinitionPropertiesAndDefaults(ConnectorRuntime.java:386)
>
> SEVERE: at
> org.glassfish.admin.amx.mbean.KitchenSinkImpl.getConnectionDefinitionPropertiesAndDefaults(KitchenSinkImpl.java:72)
>
> SEVERE: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> SEVERE: at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> SEVERE: at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> SEVERE: at java.lang.reflect.Method.invoke(Method.java:597)
> SEVERE: at
> org.glassfish.admin.amx.mbean.AMXImplBase.invoke(AMXImplBase.java:1836)
> SEVERE: at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
>
> SEVERE: at
> com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
> SEVERE: at
> javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288)
>
> SEVERE: at
> com.sun.appserv.management.util.jmx.MBeanProxyHandler.invoke(MBeanProxyHandler.java:650)
>
> SEVERE: at
> com.sun.appserv.management.client.handler.AMXProxyHandler._invoke(AMXProxyHandler.java:1091)
>
> SEVERE: at
> com.sun.appserv.management.client.handler.AMXProxyHandler.invoke(AMXProxyHandler.java:1002)
>
> SEVERE: at
> $Proxy96.getConnectionDefinitionPropertiesAndDefaults(Unknown Source)
> SEVERE: at
> org.glassfish.admingui.handlers.JdbcHandlers.updateJDBCPoolWizard(JdbcHandlers.java:616)
>
> SEVERE: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> SEVERE: at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> SEVERE: at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> SEVERE: at java.lang.reflect.Method.invoke(Method.java:597)
> SEVERE: at
> com.sun.jsftemplating.layout.descriptors.handler.Handler.invoke(Handler.java:422)
>
> SEVERE: at
> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:420)
>
> SEVERE: at
> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:394)
>
> SEVERE: at
> com.sun.jsftemplating.layout.event.CommandActionListener.invokeCommandHandlers(CommandActionListener.java:132)
>
> SEVERE: at
> com.sun.jsftemplating.layout.event.CommandActionListener.processAction(CommandActionListener.java:80)
>
> SEVERE: at
> javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
> SEVERE: at
> javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:771)
> SEVERE: at
> javax.faces.component.UICommand.broadcast(UICommand.java:372)
> SEVERE: at
> com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)
> SEVERE: at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
> SEVERE: at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
> SEVERE: at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
>
> SEVERE: at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
> SEVERE: at
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
> SEVERE: at
> com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:80)
>
> SEVERE: at
> javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
>
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
>
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
>
> SEVERE: at
> com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
>
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
>
> SEVERE: at
> org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
>
> SEVERE: at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
>
> SEVERE: at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>
> SEVERE: at
> com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
> SEVERE: at
> com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
>
> SEVERE: at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
>
> SEVERE: at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
> SEVERE: at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
>
> SEVERE: at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
> SEVERE: at
> org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)
>
> SEVERE: at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:242)
>
> SEVERE: at
> com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:633)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:570)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:827)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
>
> SEVERE: at
> com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
>
> SEVERE: at
> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
>
> SEVERE: at
> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
>
> SEVERE: at
> com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
> SEVERE: at
> com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
>
> SEVERE: at
> com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
>
> SEVERE: at
> com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
>
> SEVERE: at
> com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)
> SEVERE: Exception while trying to find properties
> SEVERE: java.lang.ClassNotFoundException:
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource
> SEVERE: at
> org.glassfish.web.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1509)
>
> SEVERE: at
> com.sun.enterprise.connectors.util.ConnectionDefinitionUtils.getConnectionDefinitionPropertiesAndDefaults(ConnectionDefinitionUtils.java:170)
>
> SEVERE: at
> com.sun.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getConnectionDefinitionPropertiesAndDefaults(ConnectorConnectionPoolAdminServiceImpl.java:408)
>
> SEVERE: at
> com.sun.enterprise.connectors.ConnectorRuntime.getConnectionDefinitionPropertiesAndDefaults(ConnectorRuntime.java:386)
>
> SEVERE: at
> org.glassfish.admin.amx.mbean.KitchenSinkImpl.getConnectionDefinitionPropertiesAndDefaults(KitchenSinkImpl.java:72)
>
> SEVERE: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> SEVERE: at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> SEVERE: at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> SEVERE: at java.lang.reflect.Method.invoke(Method.java:597)
> SEVERE: at
> org.glassfish.admin.amx.mbean.AMXImplBase.invoke(AMXImplBase.java:1836)
> SEVERE: at
> com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
>
> SEVERE: at
> com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
> SEVERE: at
> javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288)
>
> SEVERE: at
> com.sun.appserv.management.util.jmx.MBeanProxyHandler.invoke(MBeanProxyHandler.java:650)
>
> SEVERE: at
> com.sun.appserv.management.client.handler.AMXProxyHandler._invoke(AMXProxyHandler.java:1091)
>
> SEVERE: at
> com.sun.appserv.management.client.handler.AMXProxyHandler.invoke(AMXProxyHandler.java:1002)
>
> SEVERE: at
> $Proxy96.getConnectionDefinitionPropertiesAndDefaults(Unknown Source)
> SEVERE: at
> org.glassfish.admingui.handlers.JdbcHandlers.updateJDBCPoolWizard(JdbcHandlers.java:616)
>
> SEVERE: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> SEVERE: at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> SEVERE: at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> SEVERE: at java.lang.reflect.Method.invoke(Method.java:597)
> SEVERE: at
> com.sun.jsftemplating.layout.descriptors.handler.Handler.invoke(Handler.java:422)
>
> SEVERE: at
> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:420)
>
> SEVERE: at
> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:394)
>
> SEVERE: at
> com.sun.jsftemplating.layout.event.CommandActionListener.invokeCommandHandlers(CommandActionListener.java:132)
>
> SEVERE: at
> com.sun.jsftemplating.layout.event.CommandActionListener.processAction(CommandActionListener.java:80)
>
> SEVERE: at
> javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
> SEVERE: at
> javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:771)
> SEVERE: at
> javax.faces.component.UICommand.broadcast(UICommand.java:372)
> SEVERE: at
> com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)
> SEVERE: at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
> SEVERE: at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
> SEVERE: at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
>
> SEVERE: at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
> SEVERE: at
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
> SEVERE: at
> com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:80)
>
> SEVERE: at
> javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
>
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
>
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
>
> SEVERE: at
> com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
>
> SEVERE: at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
>
> SEVERE: at
> org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
>
> SEVERE: at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
>
> SEVERE: at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>
> SEVERE: at
> com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
> SEVERE: at
> com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
>
> SEVERE: at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
>
> SEVERE: at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
> SEVERE: at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>
> SEVERE: at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
>
> SEVERE: at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
> SEVERE: at
> org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)
>
> SEVERE: at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:242)
>
> SEVERE: at
> com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:633)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:570)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:827)
>
> SEVERE: at
> com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
>
> SEVERE: at
> com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
>
> SEVERE: at
> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
>
> SEVERE: at
> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
>
> SEVERE: at
> com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
> SEVERE: at
> com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
>
> SEVERE: at
> com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
>
> SEVERE: at
> com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
>
> SEVERE: at
> com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)
> SEVERE: Exception while trying to find properties
>
> Yifeng wrote:
>
>> Lance,
>>
>> Using b28c, I am not able to reproduce.
>>
>> Configuration:
>>
>> server installed on solaris 10 sparc, client browser is mozilla
>> 1.7.12 (the minimum version we support)
>>
>> -Yifeng
>>
>> Lance J. Andersen wrote:
>>
>>> Just wondering if I am the only person encountering a problem
>>> creating a MySQL connection pool as I am getting an Exception on
>>> prelude GA (I am on XP) via the admin gui
>>>
>>>
>>> Via the admin gui, I added the following entries for the Connection
>>> pool
>>>
>>> Name: Mysql-testdb-pool
>>> Resource: javax.sql.DataSource
>>> DataBase Vendor: MySQL
>>>
>>> And when I hit the next button, i get the following error
>>>
>>>
>>> Note I do not see this for a JavaDB pool.
>>>
>>> -lance
>>>
>>>
>>> HTTP Status 500 -
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> *type* Exception report
>>>
>>> *message*
>>>
>>> *description*The server encountered an internal error () that
>>> prevented it from fulfilling this request.
>>>
>>> *exception*
>>>
>>> javax.servlet.ServletException:
>>> java.lang.reflect.InvocationTargetException while attempting to
>>> process a 'command' event for 'nextButton'.
>>>
>>> *root cause*
>>>
>>> java.lang.RuntimeException:
>>> java.lang.reflect.InvocationTargetException while attempting to
>>> process a 'command' event for 'nextButton'.
>>>
>>> *root cause*
>>>
>>> java.lang.reflect.InvocationTargetException
>>>
>>> *root cause*
>>>
>>> java.lang.RuntimeException:
>>> java.lang.reflect.InvocationTargetException while attempting to
>>> process a 'beforeCreate' event for 'page1'.
>>>
>>> *root cause*
>>>
>>> java.lang.reflect.InvocationTargetException
>>>
>>> *root cause*
>>>
>>> java.lang.ClassCastException: java.lang.Boolean cannot be cast to
>>> com.sun.appserv.management.config.PropertyConfig
>>>
>>> *note* _The full stack traces of the exception and its root causes
>>> are available in the GlassFish/v3 logs._
>>>
>>>
>>