-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
wips
 Post subject: Database connection failure
PostPosted: Fri Aug 07, 2009 6:08 am 
Newbie

Joined: Fri Aug 07, 2009 5:52 am
Posts: 3
In my hibernate web application the connection between the database and the application is frequently getting failed.
this needs a server restart every 3-4 hours .Please advice how to get a permanent fix.
I am using hibernate 3.1 rc2
This is my hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<!-- Database connection settings -->
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@dlxkrc2db7.lex.lexmark.com:1534:dwitg</property>
<property name="connection.username">itb</property>
<property name="connection.password">itb</property>
<!-- property name="connection.url">jdbc:oracle:thin:@l2froradvp.emea.lexmark.com:1531:GTRBIDEV</property>
<property name="connection.username">itb</property>
<property name="connection.password">itb</property -->
<property name="hibernate.connection.aggressive_release">true</property>
<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.min_size">10</property>
<property name="hibernate.c3p0.max_size">100</property>
<property name="hibernate.c3p0.timeout">10</property>
<property name="hibernate.c3p0.acquireRetryAttempts">30</property>

<property name="hibernate.c3p0.acquireIncrement">5</property>

<property name="hibernate.c3p0.idleConnectionTestPeriod">300</property>

<property name="hibernate.c3p0.initialPoolSize">20</property>
<property name="hibernate.c3p0.maxPoolSize">100</property>
<property name="hibernate.c3p0.maxIdleTime">300</property>
<property name="hibernate.c3p0.maxStatements">50</property>
<property name="hibernate.c3p0.minPoolSize">10</property>
<property name="hibernate.c3p0.testConnectionOnCheckout">true</property>


<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.OracleDialect</property>

<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>

<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>

<!-- Drop and re-create the database schema on startup -->
<!--<property name="hbm2ddl.auto">create</property>-->
<mapping resource="Expense.hbm.xml" />
<mapping resource="Organization.hbm.xml" />
<mapping resource="Period.hbm.xml" />
<mapping resource="Project.hbm.xml" />
<mapping resource="User.hbm.xml" />

</session-factory>

</hibernate-configuration>



And
I am getting the following error :

The Session is null
The Session Factory is null false
Current State of Session :- false
Before calling Load , The session==null false
After calling Load , The session==null false
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select geography0_.GEOGRAPHY_ID as GEOGRAPHY1_7_0_, geography0_.GEOGRAPHY_DESC as GEOGRAPHY2_7_0_, geography0_.CREATED_DATE as CREATED3_7_0_, geography0_.CREATED_BY as CREATED4_7_0_, geography0_.UPDATED_BY as UPDATED5_7_0_, geography0_.UPDATED_DATE as UPDATED6_7_0_, 0 as formula7_0_ from GEOGRAPHY_D geography0_ where geography0_.GEOGRAPHY_ID=?
Hibernate: select department0_.GEOGRAPHY_ID as GEOGRAPHY3_1_, department0_.IT_DEPARTMENT_ID as IT1_1_, department0_.IT_DEPARTMENT_ID as IT1_6_0_, department0_.IT_DEPARTMENT_DESC as IT2_6_0_, department0_.GEOGRAPHY_ID as GEOGRAPHY3_6_0_, department0_.MANAGER_ID as MANAGER4_6_0_, department0_.CREATED_DATE as CREATED5_6_0_, department0_.CREATED_BY as CREATED6_6_0_, department0_.UPDATED_BY as UPDATED7_6_0_, department0_.UPDATED_DATE as UPDATED8_6_0_, 0 as formula6_0_ from IT_DEPARTMENT_D department0_ where department0_.GEOGRAPHY_ID=? order by department0_.IT_DEPARTMENT_DESC ASC
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
BudgetMgt - 08/07/2009 13:08:32 [http-8080-Processor24] - INFO - mmunian connected
BudgetMgt - 08/07/2009 14:41:43 [http-8080-Processor24] - INFO - LoginSubmitAction
The Session is null
The Session Factory is null false
Current State of Session :- false
Before calling Load , The session==null false
After calling Load , The session==null false
Hibernate: select user0_.USER_ID as USER1_12_0_, user0_.USER_FIRST_NAME as USER2_12_0_, user0_.USER_LAST_NAME as USER3_12_0_, user0_.GEOGRAPHY_ID as GEOGRAPHY4_12_0_, user0_.IS_MANAGER as IS5_12_0_, user0_.IS_ADMIN as IS6_12_0_, user0_.IS_ACTIVE as IS7_12_0_, user0_.CREATED_DATE as CREATED8_12_0_, user0_.CREATED_BY as CREATED9_12_0_, user0_.UPDATED_BY as UPDATED10_12_0_, user0_.UPDATED_DATE as UPDATED11_12_0_, 0 as formula12_0_ from USER_D user0_ where user0_.USER_ID=?
BudgetMgt - 08/07/2009 14:41:52 [http-8080-Processor24] - WARN - SQL Error: 17002, SQLState: null
BudgetMgt - 08/07/2009 14:41:52 [http-8080-Processor24] - ERROR - Io exception: Connection reset
BudgetMgt - 08/07/2009 14:41:52 [http-8080-Processor24] - INFO - Error performing load command
org.hibernate.exception.GenericJDBCException: could not load an entity: [com.lexmark.budgetmgt.business.user.User#mmunian]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1796)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:93)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2729)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:82)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:809)
at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:771)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:62)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:98)
at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:133)
at com.lexmark.budgetmgt.business.user.User$$EnhancerByCGLIB$$6a22a740.getFirstName(<generated>)
at com.lexmark.budgetmgt.business.user.User.load(User.java:179)
at com.lexmark.budgetmgt.gui.struts.login.LoginSubmitAction.execute(LoginSubmitAction.java:87)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.lexmark.budgetmgt.tool.CharsetFilter.doFilter(CharsetFilter.java:25)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:815)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1782)
... 38 more
BudgetMgt - 08/07/2009 14:41:53 [http-8080-Processor24] - ERROR - Exception in load(), message=could not load an entity: [com.lexmark.budgetmgt.business.user.User#mmunian]
org.hibernate.exception.GenericJDBCException: could not load an entity: [com.lexmark.budgetmgt.business.user.User#mmunian]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1796)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:93)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2729)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:82)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:809)
at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:771)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:62)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:98)
at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:133)
at com.lexmark.budgetmgt.business.user.User$$EnhancerByCGLIB$$6a22a740.getFirstName(<generated>)
at com.lexmark.budgetmgt.business.user.User.load(User.java:179)
at com.lexmark.budgetmgt.gui.struts.login.LoginSubmitAction.execute(LoginSubmitAction.java:87)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.lexmark.budgetmgt.tool.CharsetFilter.doFilter(CharsetFilter.java:25)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:815)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1782)
... 38 more
BudgetMgt - 08/07/2009 14:41:53 [http-8080-Processor24] - ERROR - Access Denied
Top
 Profile  
 
Cameron McKenzie
 Post subject: Re: Database connection failure
PostPosted: Mon Aug 10, 2009 7:21 am 
Expert
Expert

Joined: Tue May 13, 2008 3:42 pm
Posts: 919
Location: Toronto & Ajax Ontario www.hibernatemadeeasy.com
Does the object with this identifier actually exist in the database?

com.lexmark.budgetmgt.business.user.User#mmunian

_________________
Cameron McKenzie - Author of "Hibernate Made Easy" and "What is WebSphere?"
http://www.TheBookOnHibernate.com Check out my 'easy to follow' Hibernate & JPA Tutorials

Top
 Profile  
 
wips
 Post subject: Re: Database connection failure
PostPosted: Mon Aug 10, 2009 7:50 am 
Newbie

Joined: Fri Aug 07, 2009 5:52 am
Posts: 3
yes it is a valid user .
It is accepting the userid.But usually after 2-3 hrs it is giving an error.After i restart the server ,access is again given.

I want a permanent soution for this.
Top
 Profile  
 
thatmikewilliams
 Post subject: Re: Database connection failure
PostPosted: Mon Aug 10, 2009 8:03 am 
Expert
Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london
I have a feeling that testConnectionOnCheckout only works if you define the actual test query to run via preferredTestQuery. Try adding this to your config:
Code:
<property name="hibernate.c3p0.preferredTestQuery">select 1 from dual<property>

This post maybe helpful. Its mysql but essentially the same problem.
https://forum.hibernate.org/viewtopic.php?t=943079&highlight=c3p0+connection+timeout
Top
 Profile  
 
wips
 Post subject: Re: Database connection failure
PostPosted: Wed Aug 12, 2009 5:13 am 
Newbie

Joined: Fri Aug 07, 2009 5:52 am
Posts: 3
I tried it ....but its still not working.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

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.