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

Submitted by mco on Mon, 02/08/2016 - 14:19
1
0
-1

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.

Comments

Submitted by Quentin Choulet on Wed, 02/10/2016 - 09:22

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

Permalink
Submitted by mco on Wed, 02/10/2016 - 10:03

When I configure , during the test connector

Permalink
Submitted by Quentin Choulet on Wed, 02/10/2016 - 10:32

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

Permalink
Submitted by mco on Wed, 02/10/2016 - 11:19

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

Permalink
Submitted by Quentin Choulet on Wed, 02/10/2016 - 11:36

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.

Permalink
Submitted by mco on Wed, 02/10/2016 - 12:17

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 ???

Permalink
Submitted by Quentin Choulet on Wed, 02/10/2016 - 13:47

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

Permalink
4 answers

Submitted by Sean McP on Mon, 02/08/2016 - 18:03
1
+1
-1

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. *

Submitted by marktoddy on Mon, 06/21/2021 - 09:06
1
0
-1

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.

Submitted by mco on Tue, 02/09/2016 - 15:35
1
0
-1

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

Submitted by mco on Tue, 02/09/2016 - 14:50
1
0
-1

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

Comments

Submitted by Quentin Choulet on Tue, 02/09/2016 - 15:28

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

Permalink
Notifications