The ordinary way to configure hibernate link oracle database is just like this: jdbc:oracle:thin:@192.100.99.103:1521:Orcl But some times the database server using double network-cards or using rac. Then the configure will be: jdbc:oracle:thin:@ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.100.99.103)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.100.99.104)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVICE_NAME = Orcl) ) ) The segment of connection url is copied from oracle configuration file(usually under Oracle_Home\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\ tnsnames.ora ). //////////////// example ///////////////////
Think big, start small, move fast.