The Answer to Life, the Universe, and Everything

Tuesday, December 23, 2008

SQL Error: 0, SQLState: 08S01

If you see the such a error by using hibernate3, you need the following to avoid it.
JDBCExceptionReporter SQL Error: 0, SQLState: 08S01


In hibernate.cfg.xml, write

<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">1800</property>
<property name="c3p0.max_statements">50</property>


Then create "c3p0.properties" in your root classpath folder and write
c3p0.testConnectionOnCheckout=true
c3p0.acquireRetryDelay=1000
c3p0.acquireRetryAttempts=1

9 comments:

Guilherme said...

Thank you!
It probably saved me a lot of time.
God bless you!
:)

Anonymous said...

Thanks for quick help. Can you explain what is to root cause of this issue? Is is connection timing out from MySQL or hibernate explicitly closing the connection?

Thanks
Kamal

Anonymous said...

Using c3p0.testConnectionOnCheckout=true
is not recommended according to documentation
http://tom.tharrisx.homedns.org/javalib/c3p0-0.8.4.5/doc/apidocs/com/mchange/v2/c3p0/PoolConfig.html

VickyFlyer said...

I have tried your solution it is not working for me.. when a conection goes stale it still returns it for reuse to application .. and when application uses it .. it crashes ..

Anonymous said...

Just wish to say your article is as surprising.

The clearness in your post is simply excellent and i can
assume you are an expert on this subject.
Fine with your permission let me to grab your feed to keep
updated with forthcoming post. Thanks a million and please carry on the rewarding work.



My weblog :: Visit Website

Anonymous said...

Its not my first time to pay a quick visit this web
site, i am browsing this web site dailly and obtain nice data from here all the time.


Feel free to visit my page: section 8 notice form

Anonymous said...

Thanks on your marvelous posting! I certainly enjoyed reading
it, you can be a great author.I will remember to bookmark your blog and definitely will come back in
the foreseeable future. I want to encourage
you to definitely continue your great posts, have a nice day!



my webpage ... Visit Website

Anonymous said...

My developer is trying to persuade me to move to .
net from PHP. I have always disliked the idea because of the expenses.
But he's tryiong none the less. I've been using WordPress on
numerous websites for about a year and am anxious about
switching to another platform. I have heard fantastic things
about blogengine.net. Is there a way I can import all my wordpress
posts into it? Any kind of help would be greatly appreciated!


Also visit my blog post: section 21 notice form pdf

Anonymous said...

It's remarkable to pay a quick visit this web site and reading the views of all friends on the topic of this article, while I am also zealous of getting know-how.

My webpage; sample section 21 notice