No suitable driver found for jdbc:sqlserver:\\ocalhost\sqlexpress:1433;databaseName=****

I used bonitasoft 7.1.5 community.

I try to configure a connector for using my database ( sqlexpress 2014), but i does’nt works.

I have the following message : No suitable driver found for jdbc:sqlserver :

someone would have the process for adding a new JDBC drivers or having the same issue ?

Thanks for your help.

the name of your server is wrong,… ocalhost instead of localhost…

however have you got the jdbc driver in the tomcat lib folder?

You should download it and copy it there from here:

https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

regards
Seán

*PS: If this reply answers your question, please mark a resolved. *

Hi Sean,

Thanks for your reply.

Sorry for ocalhost it was an write error.

I’ve downloaded the JDBC driver but I don’t see exactly where I save it .

I’ve been try to put *jar file on C:\BonitaBPMCommunity-7.1.3\workspace\tomcat\lib

but it doesn’t works .

Thanks in advance for your reply

I’ve been restarted the tomcat , but the problem it’s still the same

The reason you got this error is because you forgot to register your java mysql jdbc driver with the application.

Should be like  this:

Class.forName("com.mysql.jdbc.Driver");

This forces the driver to register itself, so that Java knows how to handle those database connection strings.

You'll have to read the manual on your specific mysql jdbc driver to find the exact string to place inside the the Class.forName("...") parameter.

 

Does the problem appear when you configure the connector or when you execute it ?

When I configure , during the test connector

I guess the studio is missing the library then. Try adding the jar to
BONITA_HOME/workspace/default/lib
Then restart the studio.

Now I’ve the following error :
ExecutionException: java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0

It looks like the version of the driver is incompatible with your version of Java, try to download an older version of the driver and replace the jar.

When I use an older version I’ve have again No suitable driver found for jdbc:sqlserver …

Is it impossible to create connector with MS SQL 2012 ???

It is possible, I did it a few months ago without troubles. I can’t help you at this point

You need to restart tomcat. From the studio : Server → restart web server