SQL Express 2008 R2

Forum User

July 11, 2013 13:47

I cannot get the database connector to work with SQL Express 2008 R2. This error is logged in my frevvo.log file:
Dec 29, 2011 9:55:58 AM com.frevvo.connectors.database.QueryResource getRepresentation
SEVERE: Unable to handle GET. Got exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server version is not supported. The target server must be SQL Server 2000 or later.) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)

0

• 

  Nancy Esposito

  July 11, 2013 13:49

  The error in your log file is produced by the driver and is a little misleading. The cause of this error is that the driver being picked up by the database connector is not compatible with SQL Server 2008. This problem could be happening because there are two SQL Server drivers in the classpath. One is being picked up by the frevvo web application, that would be the correct driver. The other is being picked up by the database connector and is the incompatible one.
  
  Try the following:

  1. Navigate to the expanded database connector web application folder under Tomcat.
  2. Under WEB-INF/lib check if you have the jar file: com.microsoft.sqlserver.jdbc-1.1.3.jar.
  3. Remove that jar file, restart and try again.

  
  The correct driver used by frevvo should be present under tomcat/lib. Since the database connector won't find the driver in WEB-INF/lib it should end up using the same as the one frevvo is using.

  0

Please sign in to leave a comment.