`

莫名获取不到jdbc sid的解决办法

    博客分类:
  • jdbc
 
阅读更多

问题描述:

 >
2019-04-17 10:26:21,093 ERROR [com.wiwj.sso.server.ExtraAuthenticationHandler] - <用户名密码认证处理:Could not get JDBC Connection; nested exception is java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 >
2019-04-17 10:26:21,093 INFO [org.jasig.cas.authentication.AuthenticationManagerImpl] - 

 数据库配置:

 <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>

        <property name="url" value="jdbc:oracle:thin:@3.2.2.2:1521:cbssit"/>

        <property name="username" value="abc"/>

        <property name="password" value="123"/>

    </bean>

而数据重启之后仍然报错

后来怀疑是windows和linux的区别,改成结果如下

 <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin://@3.2.2.2:1521/cbssit"/>
        <property name="username" value="abc"/>
        <property name="password" value="123"/>
    </bean>

结果成功连上数据库

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics