I have a TNS Entry url to connect to the Oracle Database
jdbcracle:thin:\\\@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST= oracdevelopment1-vip.dev.bbbb.ooo)(PORT=9886))(ADDRESS=(PROTOCOL=TCP)(HOST= oracdevelopment2-vip.dev.bing.ooo)(PORT=9886))) (CONNECT_DATA=(SERVICE_NAME=orgservice.dev.bing.ooo)))
i am using hibernate to connect from my application to the oracle database
so i tired with this url :
jdbc:oracle:thin:@oracdevelopment1-vip.dev.bbbb.ooo:9886:orgservice.dev.bing.ooo
this of this
pattern :
jdbc:oracle:thin:@host:port:service name
But i am not able to connect,getting this exception:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource':
any help?