Cannot load JDBC driver class 'com.mysql.jdbc  

By: mnio8210 - mnio8210
Cannot load JDBC driver class 'com.mysql.jdbc Â
2006-05-14 20:49
i've installed jasper server using minimal installation and it works fine. when i login using jasperAdmin username it shows an http status 500 error page which says:Â
Â
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionÂ
org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:543) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:283) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:234) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:93) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)Â
$Proxy2.loadUserByUsername(Unknown Source) org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:88) org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:134) org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:208) org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:49) org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:90) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:228) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)Â
Â
when i look at tomcat catalina.out logÂ
Â
May 15, 2006 10:26:30 AM org.apache.catalina.core.StandardHost startÂ
INFO: XML validation disabledÂ
10:26:38,879 WARN JDBCExceptionReporter,main:71 - SQL Error: 0, SQLState: nullÂ
10:26:38,903 ERROR JDBCExceptionReporter,main:72 - Cannot load JDBC driver class 'com.mysql.jdbc.Driver'Â
10:26:38,908 WARN SettingsFactory,main:103 - Could not obtain connection metadataÂ
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'Â
Â
it seems that it can't load a mysql driver. pls helpÂ
Â
mnio




By: Sherman Wood - sgwood
RE: Cannot load JDBC driver class 'com.mysql. Â
2006-05-15 03:58
Â
When you say you did a "minimal installation", what do you mean? The installers can create a Tomcat with the MySQL driver jar in the right place. If you used a pre-existing Tomcat installation, you will need to put the MySQL driver jar in <Tomcat>/common/lib.Â
Â
Â
ShermanÂ
JasperSoft