[Hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-1750) Exception ORA-01000 too many open cursors by generated="insert"

[Scott M. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1750?page=all ]
     
Scott Marlow resolved HHH-1750:
-------------------------------

    Resolution: Fixed

The patch looks good, nice job!  I applied it to the 3.2 branch and head.

> Exception ORA-01000 too many open cursors by generated="insert"
> ---------------------------------------------------------------
>
>          Key: HHH-1750
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1750
>      Project: Hibernate3
>         Type: Bug

>  Environment: Hibernate3, Oracle10g
>     Reporter: Andreas Dornhof
>     Assignee: Scott Marlow
>      Fix For: 3.2.0.ga
>  Attachments: HHH-1750.patch
>
>
> When creating  more as 300 Object in Oracle with insert="false" and generated="insert" by property - Tag in Mapping-File
> causes an ORA-01000  "too many open cursors"...
> It is executed using the following Java code:
> SessionFactory sessionFactory;
>     	
>     	try {
>             // Create the SessionFactory from hibernate.cfg.xml
>             sessionFactory = new Configuration().
>             						configure().
>             						buildSessionFactory();
>         } catch (Throwable ex) {
>             // Make sure you log the exception, as it might be swallowed
>             System.err.println("Initial SessionFactory creation failed." + ex);
>             throw new ExceptionInInitializerError(ex);
>         }
>     
>         try{
>     
>         	for (int i = 0; i <= 301; i++) {
>         		
>         	Session session = sessionFactory.getCurrentSession();
>         	Transaction tx = session.beginTransaction();
> 							
> 	        Test test = new Test();
> 	        session.save(test);
> 	        
> 	        tx.commit();
> 	        
>         	}
>     
> 		    } catch (Exception e) {
> 				System.out.println(e.getMessage()+e.getClass().toString());
> 			}
>     
> And Mapping - File:
> <?xml version="1.0"?>
> <!DOCTYPE hibernate-mapping PUBLIC
> 	"-//Hibernate/Hibernate Mapping DTD//EN"
> 	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
> <hibernate-mapping>
> 	<class
> 		name="src.persistence.Test"
> 		table="TEST"
> 		
> 	>
> 		<id name="id" type="java.lang.Long" column="ID"
> 		>
> 			<generator class="sequence">
> 				<param name="sequence">TEST_SEQ</param>
> 			</generator>
> 		</id>
> 		<property
> 			name="created"
> 			column="CREATED"
> 			type="java.util.Date"
> 			not-null="true"
> 			insert="false"
> 			update="false"
> 			generated="insert"
> 		>
> 		</property>
> 	</class>	
> </hibernate-mapping>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira