Incidentally, why are you using an aggregate function in your test SQL
statement? Doesn't MySQL have a dummy table like Oracle dual, where you can
write a simple query like:
SELECT 1 FROM dual
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4072839#4072839
anonymous wrote : I upgraded the hibernate versions in Seam 1.2.1 to the latest
hibernate which definitely reduced the frequency however they are still there.
Any suggestions welcome.
Oops, sorry. It's 2:00AM here. Sleepy.
View the original post :
Check the manifest file in the hibernate3.jar file. If it's 3.2.0 GA, upgrade
it to 3.2.5GA. I just had this problem the other day.
reference:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2206
download:
http://www.hibernate.org/6.html
View the original post :
local-tx-datasource
| jndi-namenrg2Datasource/jndi-name
| connection-urljdbc:mysql://localhost:3306/db/connection-url
| driver-classcom.mysql.jdbc.Driver/driver-class
| user-namedb/user-name
| passwordpass/password
|
The real question is, how do you ever see the issue when using
check-valid-connection-sql? The connection is obviously bad but that fact
wasn't picked up by the check. Post the whole local-tx-datasource node,
minus the p/w, of course.
View the original post :
SELECT 1 is actually valid mysql syntax (although I have never understood why).
I will switch to that and save some cpu cycles.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4072925#4072925
Reply to the post :
anonymous wrote : I'm getting the same problem. I'm wondering whether it's
mySql because I've been told it's concurrent transaction handling is poor. I'm
going to move to Postgres today to see if there are any improvements.
|
| Thanks, AL.
I am pretty sure it isn't down to mysql's
this sounds strangely familiar... looking back at my -ds.xml ive got failed
attempts commented out all over the place, but the last two days tags seem to
have resolved the issue( configure by coincidence i always say):
| ...
|!-- 20march2007--
|
I'm getting the same problem. I'm wondering whether it's mySql because I've
been told it's concurrent transaction handling is poor. I'm going to move to
Postgres today to see if there are any improvements.
Thanks, AL.
View the original post :