Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Migrate to use Microsoft JDBC Driver

Description

gdt was looking into migrating Openfire to use the Microsoft JDBC driver over the JTDS one. The ignite forum had a message denoting an issue found while attempting to have these drivers live side-by-side

When I try to connect to SQL DB using the Microsoft JDBC driver, I got the following error

"com.microsoft.sqlserver.jdbc.ISQLServerConnection$$FastClassByProxool$$2b8cf6af "'s signer information does not match signer information of other classes in the same package

As a work around I did the following:

open the sqljdbc42.jar with winrar. in META-INF, delete MANIFEST.MF, MSFTSIG.SF and MSFTSIG.RSA

I have no idea if that was the correct way to get around this issue or not..

Environment

None

is blocked by

Activity

Show:

Greg Thomas October 13, 2017 at 2:48 PM

My thoughts;

a) It looks like Proxool is enhancing by inspection. The class created on the fly is not signed by Microsoft unlike the other MS specific classes, so an error message occurs.

b) Removing the signing information is a workaround, but can't be done readily when retrieving artefacts from Maven.

c) Proxool is unmaintained - https://github.com/proxool/proxool

I therefore propose to replace Proxool with Apache Commons DBCP - https://commons.apache.org/proper/commons-dbcp/ unless someone come can up with a good reason not to.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created October 13, 2017 at 2:41 PM
Updated December 22, 2017 at 8:57 AM
Resolved December 22, 2017 at 8:57 AM

Flag notifications