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
Post a Comment