Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: HibernateException when deployed in Prod ! Pls Help
PostPosted: Thu Jul 13, 2006 12:13 pm 
Beginner
Beginner

Joined: Sun Jan 22, 2006 8:47 pm
Posts: 31
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Full stack trace of any exception that occurs:

From , Method getPatDetails() HibernateException , could not execute query using iterate

Name and version of the database you are using:

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
Microsoft SQL Server 2000 - 8.00.760



Hi ,

To display info in the browser when a link is clicked i have four queries to be exceuted and finally the o/p of the last qry is displayed.My 1st & 3rd Qrrys are for MsSql server ..2nd & 4th query Oracle DB ..

Testing went fine ..
But when i deployed in prod last week , after few hrs iam having above hibernate exception which is occuring randomly..sometimes when we click refresh its gone , but sometimes i have to restart the application in the server (We are using Tibco ...)

When i restart it works fine for a couple of hrs and again same problem..

Mostly the exception is from Oracle Qry..

Going thru the forums , i changed my c3p0 properties to


#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1



###########################
### C3P0 Connection Pool###
###########################

hibernate.c3p0.min_size 5
hibernate.c3p0.max_size 100
hibernate.c3p0.timeout 300
hibernate.c3p0.max_statements 0
hibernate.c3p0.idle_test_period 600



But iam having this problem for evry few hrs..Can any one pls help..
Do i need to update the c3p0 jar file ? or what else may be the problem..

Any suggestions will be highly appreciated..

Thnx


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.