i need to change my jdbc connection from oracle to mssql and I'm using just JdbcTemplates to do my db calls
so that what i had
#spring.datasource.type=oracle.jdbc.pool.OracleDataSource
#spring.datasource.url=jdbc:oracle:thin:@//servername:port/dbname
#spring.datasource.username=username
#spring.datasource.password=userpassword
that's what i changed it to
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://servername:port;instanceName=shared;database=dbname;integratedSecurity=true;
spring.jpa.show-sql=true
and as a result i'm getting this
A fatal error has been detected by the Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000051e298f7, pid=9040, tid=9320
#
# JRE version: Java(TM) SE Runtime Environment (10.0.1+10) (build 10.0.1+10)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (10.0.1+10, mixed mode, tiered, compressed oops, g1 gc, windows-amd64)
# Problematic frame:
# V [jvm.dll+0x3b98f7]
when I open that log file, i'm not sure what to look for; it's basically a collection of some system stats about memory and threads and events
this one it highlighted in red at least but still not so helpful
j org.apache.catalina.valves.ErrorReportValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+6
so when I tested it with oracle evrything was good and worked but with mssql it doesn't
did I do a mistake in connection settings? or there is some changes that I need to do some changes in my db calls to fix mssql ?
edit
idk if i'm using a right driver
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>7.2.1.jre8</version>
</dependency>
User contributions licensed under CC BY-SA 3.0