在hibernate中配置时jdbc连接被拒绝

Question

org.hibernate.exception.jdbc.c.connections.internal.basicConnectionCreator$1$1.Convert（basicConnectionCreator.java:122)在org.hibernate.engine.jdbc.connections.internal.driverConnection.java:140)在org.hibernate.engine.jdbc.internal.basicConnectionCreator.MakeConnection（driverConnectionCreator.MakeConnection（在org.hibernate.engine.jdbc.connections.internal.driverManagerConnectionProviderImpl.configur(driverManagerConnectionProviderImpl.java:106)在org.hibernate.boot.registry.internal.standardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:89)在在org.hibernate.engine.jdbc.internal.jdbcServicesImpl.buildJDBCConnectionAccess(jdbcServicesImpl.java:260)在org.hibernate.engine.jdbc.internal.jdbc.internal.jdbcServicesImpl.configure(jdbcServicesImpl.java:94)在org.hibernate.boot.registry.internal.standardServicesImpl.java:94)在yimpl.java:206)在org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:178)在org.hibernate.cfg.comfiguration.buildTypereGistrations（configuration.java:1885)在org.hibernate.cfg.comfiguration.buildSessionFactory（configuration.java:1843)在g错误：ORA-12505,TNS：侦听器当前不知道连接描述符中给出的SID

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:55)
... 14 more

原因：oracle.net.ns.netException：侦听器拒绝连接，错误如下：ORA-12505,TNS：侦听器当前不知道连接描述符中给出的SID

at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:272)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
... 19 more

我的hibernate.cfg.xml如下:oracle.jdbc.driver.oracleDriver jdbc:oracle:thin:localhost:1522/devdb SYSTEM oracle123

    <!-- JDBC connection pool (use the built-in) -->
    <property name="connection.pool_size">1</property>

    <!-- SQL dialect -->
    <property name="dialect">org.hibernate.dialect.OracleDialect</property>

    <!-- Disable the second-level cache  -->
    <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider</property>

    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">true</property>

    <!-- Drop and re-create the database schema on startup -->
    <property name="hbm2ddl.auto">create</property>

有人能帮我解决这个问题吗。

我给出的SID是正确的。

Answer 1

您的jdbc连接字符串几乎是正确的

oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:localhost:1522/DevDb 

这是正确的

oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@//localhost:1522/DevDb

此外，在尝试ORM方式之前，请确保尝试使用sqlplus登录。