Hi ,

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 construct ARRAY instance,invalid connection; nested exception is java.sql.SQLException: Internal Error: Cannot construct ARRAY instance,invalid connection

I did put a log level as debug for hibernate and got the one below

[color=#FF8040][[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG Loader - bindNamedParameters() Hibernate-related JDBC operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [17001]; Internal Error: Cannot construct ARRAY instance,invalid connection; nested exception is java.sql.SQLException: Internal Error: Cannot construct -> arg_message [9][/color]

We have configured a multidata source with 2 instances of Oracle RAC in the server (for failover)

To know whether its a code related issue , I reverted the datasource to point to oracle 10g and did a test . It worked fine .

Then i tried to run only one instance of oracle RAC in the server and tested the application , then too it worked fine.

The problem comes when i try to use 2 instances of RAC and run the application.

Does this relate to an hibernate issue . Any findings would be really helpful


Thanks,
Kaushik