urgent issue: run glassfish on fedora with mysql, get connection failure
i am running glassfish-installer-v1_ur1-p01-b02.jar
on fedora core 6
with mysql 5.1
the device driver is already put on glasshfish/lib.
the same file was used by jboss and works fine.
i have created both the connection pool "mysqlPool" and datasource "TestDS". When i ping the connection,
./asadmin ping-connection-pool --user admin --passwordfile pwdfile mysqlPool
com.mysql.jdbc.CommunicationsException
CLI137 Command ping-connection-pool failed.
However, same configuration works very fine on Windows XP.
note1:
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Server VM (build 1.5.0_11-b03, mixed mode)
note2:
i can connect mysql on the command line.
Any idea to solve it?
[841 byte] By [
albertja] at [2007-11-27 5:37:22]
# 1
the call stack dump is
[#|2007-05-27T21:48:40.309+0800|WARNING|sun-appserver-pe9.0|javax.enterprise.sy stem.stream.err|_ThreadID=11;_ThreadName=httpWorkerThread-8080-0;_RequestID=2a7e 72e9-cf6d-4c0b-9ac1-1082bbdc4cec;|Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Communications link failure
Last packet sent to the server was 0 ms ago.Error Code: 0
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseExc eption.java:289)
at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:135)
at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(Datasour ceLogin.java:170)
at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectD atasource(DatabaseSessionImpl.java:537)
at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityMan agerFactoryProvider.java:180)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(Entit yManagerSetupImpl.java:230)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getSe rverSession(EntityManagerFactoryImpl.java:78)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.creat eEntityManagerImpl(EntityManagerFactoryImpl.java:113)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEnti tyManager(EntityManagerFactoryImpl.java:84)
at com.sun.enterprise.util.EntityManagerWrapper._getDelegate(EntityManagerWrapper. java:166)
at com.sun.enterprise.util.EntityManagerWrapper.createQuery(EntityManagerWrapper.j ava:271)
at com.ixisoft.test.CustomerManagerBean.getMyCustomer(CustomerManagerBean.java:47)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurit yManager.java:1050)
at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:165)
at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java: 2766)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3847)
# 2
your con. pool configurations might be wrong.
set the parameters as specified in the documentation:
http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklk?a=view#gbsok
If it still fails, please post
1) your con. pool configuration,
2) jdbc-driver version (or jar file name)
3) mysql server version
4) exception messages when you call "ping". [the stack trace you have posted does not correspond to ping call]
