The problem of changing the database in sleep mode

I have a problem with hibernate and I don’t know exactly what is happening, I have this project at work, where I connect to the Oracle 10g database using the following settings:

Host Name: localhost
port:1521
SID:orcl
user:anfxi
password:password

Now I try to work with the same database remotely at home, I am connected via VPN, and now the database ip address 10.73.98.230, I imported WAR and changed the settings in my hibernate.cfg.xml from:

<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin://localhost:1521:orcl</property>
<property name="hibernate.connection.username">anfexi</property>
<property name="connection.password">password</property>
<property name="connection.pool_size">1</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">validate</property>
<property name="current_session_context_class">thread</property>

to:

<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin://10.73.98.230:1521:orcl</property>
<property name="hibernate.connection.username">anfexi</property>
<property name="connection.password">password</property>
<property name="connection.pool_size">1</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">validate</property>
<property name="current_session_context_class">thread</property>

but I keep getting this error:

ERROR [main] (SchemaValidator.java:135) - could not get database metadata
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
The Connection descriptor used by the client was:
localhost:1521:orcl

so it still uses localhost as the DB address, I cleared the project and rebuilt, still no luck, is there anything else I could skip? is the sleep configuration cached in some kind of file that I have to erase or something else?

, SQL-, , localhost:1521:orcl.

!

+3
4

, xml, Eclipse, . - , Eclipse , webapp.

Tomcat ( ), , WAR,

WORKSPACE/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/APPNAME/.../path/to/hibernate.cfg.xml

, , Eclipse, APPNAME .

, "localhost" , - .

+2

- . , , ,

/ target/build. ..

hibernate.cfg.xml localhost: 1521: orcl

, .

, , , persistence.xml. , .

? , , /j2ee?

+1

SID "orcl". , SID "localhost", "10.73.98.230". , SID, "10.73.98.230".

0

.

<property name="hibernate.connection.url">jdbc:oracle:thin:@10.73.98.230:1521:orcl</property>

// @

: http://www.cryer.co.uk/brian/oracle/ORA12505.htm

,

0

All Articles