Cannot load JDBC driver class 'com.mysql.jdbc Â

[ktrinad]

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