Hi all,

I'm a java programmer using hibernate and i have an urgent problem (arn't they all).

The situation :
I'm using Hibernate together with DAO's while using MS SQL Server as database and i'm pretty happy with the way my program is working, so no problems here.
But i decided to migrate towards MySQL and i'm having the following problem :

If my businesslogic first tries to find to find a certain object in the database and does not find this object, it will create a new instance and try to persist it. But this is where things go wrong, i get an SQLException; The connection is a read-only connection, .... (something about the fact that this connection cannot be used for data-manipulation - seems logical to me...).

I am not sure if this problem is "Hibernate-MySQl" related or if this problem is "MySQL-only" related.

Could anyone please give me some more information on this problem ?
I've checked the web but i seem to be alone with this problem.

If it is hibernate-related, what and where do i have to change to get this right ?

Greetings, Kris

PS if this post is invalid or incomplete feel free to let me know. I'm at home at the moment so i cannot give sufficient detailed info, my apologies.

anyone please ?
This is a rather urgent problem
if more info is needed please say so, and i'll add it gladly !

please help, thanks in advance