Dear all,
I'm newbie of hibernate, please help me with this question.

I developed a java application and I use hibernate with derby database withou problem.
In any case derby performance doesn't satisfy me, also because database has too size with few data and it's also slow.
Which database (the best will be a database with only a file, like sqlite) do you think could be useful to try, that is which is best supported in hibernate?

1) I read good comments about hsqldb...could you provide me connection string to put in hibernate.cfg?
2) I tried to use sqlite...it seems to work but it gives me expection in any commit...error doing commit.
I downloaded a sqldialect developed by a user...is sqlite supported by hibernate or just nhibernate?
Could you say me how can I solve my issue with this?

Thanks,
Regards