Flyway sql server on windows xp with windows authentification -


i work on windows xp, sql server 2008 r2(express) installed , jdk 7 i've tried flyway migrate database windows authentification every time run migrate command error message appear

grave: l'environnement d'exÚcution java (jre, java runtime environment) version 1.7 n'est pas pris en charge par ce pilote. utilisez la bibliothÞque de classes sqljdbc4.jar, qui permet la prise en charge de jdbc 4.0.  error: java.lang.unsupportedoperationexception: l'environnement d'exÚcution java (jre, java runtime environment) version 1.7 n'est pas pris en charge par ce pilote. utilisez la bibliothèque de classes sqljdbc4.jar, qui permet la prise en charge de jdbc 4.0. 

what should do? i've try flyway oracle , mysql , worksvery well

resolved
started use jtds instead of microsoft jdbc driver
url connection used connect local server windows authentification

flyway.url=jdbc:jtds:sqlserver://localhost:1434;databasename=basetest;integratedsecurity=true; 

and distant server

flyway.url=jdbc:jtds:sqlserver://myserver/basetest;instance=sqlexpress; 

the port optional advice not set it,that generate errors if don't know correct port.
in case trying 1433 port (the default sql server) generating connection's errors every time ran command until verified sql server configuration manager tcp/ip port set @ 1434 not 1433


, works
thanks


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -