Problem with hibernate

[Tobias Tangfelt]

I am new to hibernate and I am trying to to make inserts with storere procedures on my MySQL database. I have no problem to get information from it, the problem become when I am trying to insert data to it.
Here is my code in the hbm.xml file (It is only the part where I am trying to implement my store procedure that are going to insert values in database):

<sql-query name="insertCarsSP" callable="true">
    <return alias="cars" class="labb6Hibernate.bil"> 

    </return>
    { call insertCars(?,?,?) }
</sql-query>

Here is a part of the Java code:

Session session = MyHibernateUtil.getSessionFactory().openSession();
       org.hibernate.Query q = session.getNamedQuery("insertCarsSP");       
       q.setParameter(0, "Saab");
       q.setParameter(1, "9000");
       q.setParameter(2, "1999");
       session.getTransaction().commit();
       session.close();

The store procedure is working fine.
I got following error message when I am trying to execute:
"Exception in thread "AWT-EventQueue-0" org.hibernate.TransactionException: Transaction not successfully started"

Does anyone have any suggestion?

[vani venkat]

hi,
not sure what the problem is but did you try using this

getCurrentSession();

instead of openSession?

[Tobias Tangfelt]

I actually solved my problem with INSERT.
But I have problem with UPDATE and INSERT.

This is my hbm.xml file:

<hibernate-mapping>
  <class catalog="Cars" name="labb6Hibernate.bil" table="Bil">
    <id name="idNum" type="java.lang.Integer">
      <column name="idNum"/>
      <generator class="identity"/>
    </id>
    <property name="marke" type="string">
      <column length="10" name="Marke" not-null="true"/>
    </property>
    <property name="modell" type="string">
      <column length="10" name="Modell" not-null="true"/>
    </property>
    <property name="arsmodell" type="string">
      <column length="4" name="Arsmodell" not-null="true"/>
    </property>
    <sql-insert callable="true"> { call insertCars(?,?,?) }  </sql-insert>
    <sql-update callable="true"> { call updateCars(?,?,?,?) </sql-update>
    <sql-delete callable="true"> { call deleteCars(?) }  </sql-delete>
  </class>

This is my delete method:

Session session = MyHibernateUtil.getSessionFactory().openSession();
       session.beginTransaction();
       int s = Integer.parseInt(idTxt.getText());
       Object Bil = session.load(bil.class, s);
       session.delete(Bil);
       session.getTransaction().commit();
       session.close();

This is my update method:

Session session = MyHibernateUtil.getSessionFactory().openSession();
       session.beginTransaction();
       int s = Integer.parseInt(idTxt.getText());
       bil Bil = (bil) session.get(bil.class, s);
       Bil.setMarke(markeTxt.getText());
       Bil.setModell(markeTxt.getText());
       Bil.setArsmodell(arsmodellTxt.getText());
       session.close();

All the stored procedure is working, and I have try the exact sam thing without the stored procedure and it´s working. And my INSERT operation also working.
But when I can´t get it to work, and I have no idea why.

[Paul Sturrock]

I have to ask: why are you using stored procedures and Hibernate together? Do the stored procedures do something Hibernate can't?

[Jan Cumps]

... and do you commit inside your stored procedure?

[Tobias Tangfelt]

I use stored procedure because I am reading a course there we now got a task where we are trying to use stored procedure in Hibernate.
I haven´t done commit in my store procedure but i have it in my Java code.