changing jdbc connection from oracle to mssql

0

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>
sql-server
spring
oracle
jdbctemplate
asked on Stack Overflow Apr 15, 2019 by Vladimir Zaguzin • edited Apr 15, 2019 by Vladimir Zaguzin

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0