Hi All,
I am using
1. Hibernate 3.1
2. Oracle 10g
I am facing the following problems.
1. In my entire application I am only retrieving data from the database tables. I am not inserting or updating any data from the Java Code. My DBA has at times reported locking of tables and that the locks are released. I think ideally if I am firing an Select query, this should not happen. Can anybody please tell me a possible cause of this?
2. I carry out a search operation from a Materialized View of two separate tables. This is a simple conditional select operation. I get this exception a number of times.
This does not happen consistently.
Code:
java.sql.BatchUpdateException: ORA-01732: data manipulation operation not legal on this view
The Hibernate configuration file is as followsCode:
<hibernate-configuration>
<session-factory>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<property name="connection.url">
jdbc:oracle:thin:@xxx.xxx.com:1521:asdb
</property>
<property name="connection.username">owner</property>
<property name="connection.password">owner</property>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="myeclipse.connection.profile">
OracleThinDriver
</property>
<property name="hibernate.show_sql">true</property>
<property name="connection.autocommit">false</property>
<property name="format_sql">true</property>
......................Table Mappings.........................
</session-factory>
</hibernate-configuration>
Also, my Java code does not use Transactions as it is not required.
Looking for help.
Regards,
Shardul.
Login
FAQ
Search
