Right now with connections obtained from a Driver implementation (jdbc 1/Local Transaction wrapper) you have to set all such properties in the url. If you were using mysql standalone how would you specify these properties?
I'm not sure if I understand your question well, but the URL should be
This works eg. when I connect from iSQL etc. But JBoss doesn't accept URL in this form. It throws an exception:
[12:09:33,941,AutoDeployer] Deployment failed:file:/E:/java/jboss/deploy/mysqldb
org.jboss.deployment.DeploymentException: No valid service.xml file foundNext ch
aracter must be ";" terminating reference to entity "useUnicode".
Can you please propose some solution?
It's just a stab in the dark, but have you tried this:
The & sign always needs to be escaped in XMl, but using the & entity.
Oops, my advice didn't quite come out properly on the forum.
The entity is & amp ; only without the spaces: so your URL would be
jdbc:mysql://localhost/gis?characterEncoding=Cp1250& amp ;useUnicode=true
(only remove the spaces) :-)