users@glassfish.java.net

Re: Mysql on GFv2 on linux -- can't load driver

From: Johnny Tolliver <jxt_at_ornl.gov>
Date: Mon, 24 Mar 2008 13:30:20 -0400 (EDT)

On Mon, 24 Mar 2008, Sahoo wrote:

> I believe the server.log contains the list of jars added to server
> classpath. Please check the log to ensure that your driver jar is indeed
> picked up by server.

I don't see it. Here is the start of server.log, with a couple annotations.
By the way, I also tried putting the mysql jar into
glassfish/domains/domain1/lib. No change. Any other ideas?

Jan 10, 2008 11:31:38 AM
com.sun.enterprise.admin.servermgmt.launch.ASLauncher buildCommand
INFO:
/usr/local/jdk1.6.0_03/jre/../bin/java
-Dcom.sun.aas.instanceRoot=/usr/local/glassfish/domains/domain1
-Dcom.sun.aas.ClassPathPrefix=
-Dcom.sun.aas.ClassPathSuffix=
-Dcom.sun.aas.ServerClassPath=
-Dcom.sun.aas.classloader.appserverChainJars.ee=
-Dcom.sun.aas.classloader.appserverChainJars=admin-cli.jar,admin-cli-ee.jar,j2ee-svc.jar
-Dcom.sun.aas.classloader.excludesList=admin-cli.jar,appserv-upgrade.jar,sun-appserv-ant.jar
-Dcom.sun.aas.classloader.optionalOverrideableChain.ee=
-Dcom.sun.aas.classloader.optionalOverrideableChain=webservices-rt.jar,webservices-tools.jar
-Dcom.sun.aas.classloader.serverClassPath.ee=/lib/hadbjdbc4.jar,/usr/local/glassfish/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,/lib/dbstate.jar,/lib/hadbm
.jar,/lib/hadbmgt.jar,/lib/mfwk_instrum_tk.jar
-Dcom.sun.aas.classloader.serverClassPath=/usr/local/glassfish/lib/install/applications/jmsra/imqjmsra.jar,/usr/local/glassfish/imq/lib/jaxm-api
.jar,/usr/local/glassfish/imq/lib/fscontext.jar,/usr/local/glassfish/imq/lib/imqbroker.jar,/usr/local/glassfish/imq/lib/imqjmx.jar,/usr/local/gl
assfish/lib/ant/lib/ant.jar,/usr/local/glassfish/lib/SUNWjdmk/5.1/lib/jdmkrt.jar
-Dcom.sun.aas.classloader.sharedChainJars.ee=appserv-se.jar,appserv-ee.jar,jesmf-plugin.jar,/lib/dbstate.jar,/lib/hadbjdbc4.jar,jgroups-all.jar,
/lib/mfwk_instrum_tk.jar
-Dcom.sun.aas.classloader.sharedChainJars=javaee.jar,/usr/local/jdk1.6.0_03/jre/../lib/tools.jar,install/applications/jmsra/imqjmsra.jar,com-sun
-commons-launcher.jar,com-sun-commons-logging.jar,/usr/local/glassfish/imq/lib/jaxm-api.jar,/usr/local/glassfish/imq/lib/fscontext.jar,/usr/loca
l/glassfish/imq/lib/imqbroker.jar,/usr/local/glassfish/imq/lib/imqjmx.jar,/usr/local/glassfish/imq/lib/imqxm.jar,webservices-rt.jar,webservices-
tools.jar,mail.jar,appserv-jstl.jar,jmxremote_optional.jar,/usr/local/glassfish/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,activation.jar,appserv-rt.jar,ap
pserv-admin.jar,appserv-cmp.jar,/usr/local/glassfish/updatecenter/lib/updatecenter.jar,/usr/local/glassfish/jbi/lib/jbi.jar,/usr/local/glassfish
/imq/lib/imqjmx.jar,/usr/local/glassfish/lib/ant/lib/ant.jar,dbschema.jar
-Dcom.sun.aas.configName=server-config
-Dcom.sun.aas.configRoot=/usr/local/glassfish/config
-Dcom.sun.aas.defaultLogFile=/usr/local/glassfish/domains/domain1/logs/server.log
-Dcom.sun.aas.domainName=domain1
-Dcom.sun.aas.installRoot=/usr/local/glassfish
-Dcom.sun.aas.instanceName=server
-Dcom.sun.aas.processLauncher=SE
-Dcom.sun.aas.promptForIdentity=true
-Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory
-Dcom.sun.enterprise.overrideablejavaxpackages=javax.help,javax.portlet
-Dcom.sun.enterprise.taglibs=appserv-jstl.jar,jsf-impl.jar
-Dcom.sun.enterprise.taglisteners=jsf-impl.jar
-Dcom.sun.updatecenter.home=/usr/local/glassfish/updatecenter
-Ddomain.name=domain1
-Djava.endorsed.dirs=/usr/local/glassfish/lib/endorsed
-Djava.ext.dirs=/usr/local/jdk1.6.0_03/jre/../lib/ext:/usr/local/jdk1.6.0_03/jre/../jre/lib/ext:/usr/local/glassfish/domains/domain1/lib/ext:/us
r/local/glassfish/javadb/lib
-Djava.library.path=/usr/local/glassfish/lib:/usr/local/glassfish/lib:/usr/local/glassfish/lib

[ NOTE: the above path is where I put the mysql connector jar ]

-Djava.security.auth.login.config=/usr/local/glassfish/domains/domain1/config/login.conf
-Djava.security.policy=/usr/local/glassfish/domains/domain1/config/server.policy
-Djava.util.logging.manager=com.sun.enterprise.server.logging.ServerLogManager
-Djavax.management.builder.initial=com.sun.enterprise.admin.server.core.jmx.AppServerMBeanServerBuilder
-Djavax.net.ssl.keyStore=/usr/local/glassfish/domains/domain1/config/keystore.jks
-Djavax.net.ssl.trustStore=/usr/local/glassfish/domains/domain1/config/cacerts.jks
-Djdbc.drivers=org.apache.derby.jdbc.ClientDriver

[ HMMMM... I don't see MySQL there. Wonder why. ]

-Djmx.invoke.getters=true
-Dsun.rmi.dgc.client.gcInterval=3600000
-Dsun.rmi.dgc.server.gcInterval=3600000
-client
-XX:+UnlockDiagnosticVMOptions
-XX:MaxPermSize=192m
-Xmx512m
-XX:NewRatio=2
-XX:+LogVMOutput



Johnny S. Tolliver
Oak Ridge National Laboratory
tolliverjs_at_ornl.gov, 865-574-1305