Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

GlassFish with MySQL

 
Ally Cavs
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Thanks
Alan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic