mco
8 February 2016 13:19
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.
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. *
mco
9 February 2016 13:50
3
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
mco
9 February 2016 14:35
4
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 ?
mco
10 February 2016 09:03
7
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.
mco
10 February 2016 10:19
9
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.
mco
10 February 2016 11:17
11
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