1

I follow the steps of this thread :

when I try to start the domain (jasperserver) I got this error in Tomcat Manager :

FAIL - Application at context path /jasperserver could not be started

hereunder the Catalina.out log

2010-11-29 12:39:12,842 ERROR [/jasperserver],http-8080-Processor22:3767 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher org.springframework.beans.factory.BeanCreationException org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' [See nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver']]

skaffman
  • 398,947
  • 96
  • 818
  • 769
karimhammoda
  • 11
  • 1
  • 3

3 Answers3

1

You need to add JDBC driver in your classpath .

jmj
  • 237,923
  • 42
  • 401
  • 438
  • but I already reconfigure it to work on oracle Database & Oracle Driver , why I need Mysql Driver ? – karimhammoda Nov 29 '10 at 13:02
  • 1
    @karimhammoda there might be some misconfiguration ,error message says it is searching for JDBC-MySQL Driver – jmj Nov 29 '10 at 13:05
  • 1
    @karimhammoda there is some might be some network issue, check your firewall, try connecting your DB from its client,try figure out the issue. – jmj Nov 29 '10 at 16:36
0

It can't load your JDBC driver, make suer that the JAR file representing your driver (mySQL in this case) is on your CLASSPATH (probably in the lib directory of the web/application server you are running)

Martijn Verburg
  • 3,287
  • 21
  • 26
  • 2010-11-29 19:12:53,569 ERROR JDBCExceptionReporter,main:101 - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) 2010-11-29 19:12:53,582 WARN SettingsFactory,main:133 - Could not obtain connection to query metadata org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) – karimhammoda Nov 29 '10 at 16:17
  • Raise that as a new question with the full stack trace please. – Martijn Verburg Nov 29 '10 at 16:48
0

Resolved :

I must reconfigure jasperserver.xml file found in apache-tomcat-5.5.20/conf/Catalina/localhost folder the same way I reconfigure context.xml file in jasperserver META-INF folder

karimhammoda
  • 81
  • 1
  • 2
  • 4