dev@glassfish.java.net

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

From: Lance J. Andersen <Lance.Andersen_at_Sun.COM>
Date: Thu, 30 Oct 2008 17:56:52 -0400

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._
>>
>>
>