my dog learned polymorphism
The moose likes Glassfish and the fly likes GlassFish with MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Glassfish
Bookmark "GlassFish with MySQL" Watch "GlassFish with MySQL" New topic

GlassFish with MySQL

Ally Cavs
Ranch Hand

Joined: Aug 25, 2008
Posts: 89
Hi Guys

I have a application made up of Spring/JPA/Hibernate. The JPA layer does the transaction handling. The application uses Glassfish jdbc connection pools.
In the logs there is an alarming amount of database calls setting autocommit to on then off. I believe this to be an issue between GF and mysql. Any pointers? Even if itcould be a problem with the applicatio any pointers for what to check for?

Im thinking should all webservice calls be annotated with @Transactional?

Even for selects the logs would show

the applicaton is clustered across a few instances of GF with 1 write database and a 5 readonly databases. If i can at least stop the autcommit changes on the readonly databases that would be a step forward. Im looking for pointers of what i could look into here as Im a bit confused
These setting on and off is takiing up alot of time on the database so if i can set readonly databases to default autocommit off (or on if needs be) databasse performance should improve

I agree. Here's the link:
subject: GlassFish with MySQL
It's not a secret anymore!