Hi guys
I'm new at this forum, hope this is the right place to post my issues... ;-)
I have made a website with this tools:
Flex Builder 3.2
Hibernate 3
spring
MySQL 5.0.51-a
And this is my problem:
Everything works fine after rebooting the webserver. But just for some hours. After about 8 hours every access to the DB ends up with this error:
Code:
[RPC Fault faultString="org.hibernate.exception.JDBCConnectionException : could not execute query" faultCode="Server.Processing" faultDetail="null"]
at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::faultHandler()
at mx.rpc::Responder/fault()
at mx.rpc::AsyncRequest/fault()
at NetConnectionMessageResponder/statusHandler()
at mx.messaging::MessageResponder/status()
I think the problem is, that mySQL disconnects the hibernate-session. Maby this is because of my code...
I always get the hibernate-session like this:
Code:
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session sess = sessionFactory.getCurrentSession();
And I never close the session... -> that's how i learned it in a book... so...
take a look at the whole source code at
http://www.behindyoursmile.ch right mouse button -> view source...
my hibernate implementation you will find here -> src>bys>data>dao>BehindYourSmileDaoImplHibernate.java
hope anybody can help me...
thanks in advance...
best regards