Issue while upgrading Jasperser from 4.5 to 5.1

We are using the community version of JasperServer 4.5.0.
Currently we are in the process of upgrading the JasperServer to 5.1 While performing the upgrade i am getting the following error.
[java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jasperserver.jivirtualdatasource' doesn't exist
     [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(
     [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
     [java] at java.lang.reflect.Constructor.newInstance(
     [java] at com.mysql.jdbc.Util.handleNewInstance(
     [java] at com.mysql.jdbc.Util.getInstance(
     [java] at com.mysql.jdbc.SQLError.createSQLException(
     [java] at com.mysql.jdbc.SQLError.createSQLException(
     [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(
     [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(
     [java] at com.mysql.jdbc.MysqlIO.sendCommand(
     [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
     [java] at com.mysql.jdbc.ConnectionImpl.execSQL(
     [java] at com.mysql.jdbc.PreparedStatement.executeInternal(
     [java] at com.mysql.jdbc.PreparedStatement.executeQuery(
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
     [java] at org.hibernate.jdbc.AbstractBatcher.getResultSet(
     [java] at org.hibernate.loader.Loader.getResultSet(
     [java] at org.hibernate.loader.Loader.doQuery(
     [java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
     [java] at org.hibernate.loader.Loader.doList(
I am using for the upgrade and when run in the test mode the test is successful.
Any reason the upgrade is failing?
saket.gune's picture
Joined: Oct 3 2013 - 9:38am
Last seen: 9 years 11 months ago

1 Answer:


As per your error message problem is driver jar file

keep appropriate data base jar file in tomcat/lib folder.

Regards Saurabh consultant at Advanz101

sourabh.g's picture
Joined: Jul 20 2013 - 12:01am
Last seen: 9 years 10 months ago