1. SQL Exception with hibernate 3.6.4 final with oracle 11g RAC forum.hibernate.orgHi , We are facing some issues with our new upgraded application. Hibernate : 3.2.6.ga Oracle : 10g Weblogic :10.0 to : Hibernate : 3.6.4.Final Oracle :11g RAC Weblogic : 10.3.4 When running the application we are encountering the following issue with hibernate org.springframework.jdbc.UncategorizedSQLException: Hibernate-related JDBC operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [17001]; Internal Error: Cannot ... |
2. Has anyone used Hibernate with Oracle RAC? forum.hibernate.org |
3. hibernate and oracle RAC forum.hibernate.orgI'm using hibernate 3.0 and oracle DB 10g R2 in a RAC architecture. in order to enable the FCF (fast connection failover), oracle suggests to use the following code in a classic JDBC application: OracleDataSource ods = new OracleDataSource() ods.setUser("Scott"); ... ods.setPassword("tiger"); ods.setConnectionCachingEnabled(True); ods.setFastConnectionFailoverEnabled(True); ods.setConnectionCacheName("MyCache"); ods.setConnectionCacheProperties(cp); ods.setURL("jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=VIP1)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=VIP2)(PORT=1521)) (CONNECT_DATA=(service_name=service_name)))"); As I'm using hibernate I can't use this code. I ... |
4. Oracle RAC & Hibernate forum.hibernate.orgdonno about all situations, but we are using ejb3 (its hibernate w/o all the external xml config files:-) ) with jboss. All of our db connections to the rac are defined in jboss datasources which is in the end is where the ejbs are getting their connections. I dont think that we have had any issues. The only tricky thing for ... |
5. Oracle RAC - TAF support in hibernate forum.hibernate.orgHi Hibernate-experts, We are using Oracle RAC 10g (with 2 nodes) in our application which internally uses hibernate to call Oracle. Using TAF feature in Oracle RAC, we can handle fail-over using oracle OCI driver. But TAF has one limitation. It doesn't handle fail-over for DML transaction, it will simply rolled back the uncommitted transactions, application needs to take care of ... |
6. How to handle Oracle RAC failover using TAF in Hibernate forum.hibernate.orgHi, We are using Oracle RAC 10g (with 2 nodes) in our application which internally uses hibernate to call Oracle. Using TAF feature in Oracle RAC, we can handle fail-over using oracle OCI driver. But TAF has one limitation. It doesn't handle fail-over for DML transaction, it will simply rolled back the uncommitted transactions, application needs to take care of process ... |