{"id":730,"date":"2012-10-25T14:11:08","date_gmt":"2012-10-25T18:11:08","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=730"},"modified":"2012-10-25T15:17:14","modified_gmt":"2012-10-25T19:17:14","slug":"conectar-java-jdbc-a-oracle-rac","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2012\/10\/25\/conectar-java-jdbc-a-oracle-rac\/","title":{"rendered":"Conectar Java (JDBC) a Oracle RAC"},"content":{"rendered":"<p>Lo normal es que nuestras conexiones JDBC esten dadas a trav\u00e9s del String URL de la siguiente forma<\/p>\n<pre class=\"brush:bash\">\r\njdbc:oracle:thin:@HOST:1521:SID\r\n<\/pre>\n<p>En Oracle 10g me dio buenos resultados (ante el error ORA-12505)<\/p>\n<pre class=\"brush:bash\">\r\njdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)\r\n(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))\r\n(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))\r\n(CONNECT_DATA=(SERVICE_NAME=service)))\r\n<\/pre>\n<p>Pero en 11g la documentaci\u00f3n dice<\/p>\n<pre class=\"brush:bash\">\r\njdbc:oracle:thin:@HOST:1521\/SID\r\n<\/pre>\n<p>Con lo que ha funcionado completamente (notese que antes del SID los dos puntos cambia por slash).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lo normal es que nuestras conexiones JDBC esten dadas a trav\u00e9s del String URL de la siguiente forma jdbc:oracle:thin:@HOST:1521:SID En Oracle 10g me dio buenos resultados (ante el error ORA-12505) jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service))) Pero en 11g la documentaci\u00f3n dice jdbc:oracle:thin:@HOST:1521\/SID Con lo que ha funcionado completamente (notese que antes del SID los [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,14,7,9],"tags":[],"class_list":["post-730","post","type-post","status-publish","format-standard","hentry","category-desarrollo","category-jboss","category-jee","category-oracle"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/730"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=730"}],"version-history":[{"count":6,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/730\/revisions"}],"predecessor-version":[{"id":736,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/730\/revisions\/736"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}