I really need some pointers or suggestions. If anyone has any kind of information for me that could help, I would be very grateful. Please respond if you know more about this topic.
sorry I have only the config-files for changing from Hypersonic to mysql. if need this files i can send u.
sisepago, I won't need the MySQL config files. Thank you though for your offer.
It seems to be that my data is being stored in a public schema in my Postgres database which for some reason I had not noticed. I was looking at a different schema and not seeing any changes. So this means I've got things working correctly.
However, this still leaves me with the question of the syntax error I get when an attempt is made to create a cached table. Is this of any consequence or can it safely be ignored? I do see the JMS_MESSAGES table in the database but I am not sure if it can be used as required by the transaction manager. Can anyone tell me?