• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Hibernate: Performance issue

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm working on a java servlet application that uses hibernate with oracle.
This issue concerns with hibernate transaction (between session.beginTransaction() and commit).

I'm running a 30 transaction per second load in which all transactions are updating a single column of a specific row of table.
Say, column is C, Row is R and table is T.
The time taken to run this update command is very high via hibernate.

I did an experiment, in which I used pure jdbc instead of Hibernate and results were awesome.

So first question is that, Can I make a pure jdbc hit using hibernate ?
(I tested with Hibernate 3.2 native SQL API (createSQLQuery) but results were pretty bad)

If yes, Can I use hibernate query as well as pure jdbc hit in a single session of Hibernate.

--------------------------------
Example:

objTransactionManager = session.beginTransaction();
session.update(TransactionCountDTO); --> This is a hibernate object
session.save(MoneyTransactionDTO); --> This is a hibernate object
session.executeUpdate(sqlQuery); --> This is a pure jdbc hit
objTransactionManager.commit();
-------------------------------

Please help. I'm stuck in a mess here.
 
Space pants. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic