Hi everyOne!
I need to get this connection:
("jdbc:mysql://localhost:3306/netinfoa_amt?characterEncoding=UTF-8&useUnicode=true", "root", "****");
using <data-sources> declared on my STRUTS-CONFIG.XML
no problem with:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver"/>
<set-property property="url" value="jdbc:mysql://localhost:3306/netinfoa_amt" />
<set-property property="username" value="root"/>
<set-property property="password" value="****"/>
</data-source>
</data-sources>
But i have this problem: org.xml.sax.SAXParseException: The reference to entity "useUnicode" must end with the ';' delimiter.
trying:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver"/>
<set-property property="url" value="jdbc:mysql://localhost:3306/netinfoa_amt?characterEncoding=UTF-8&useUnicode=true" />
<set-property property="username" value="root"/>
<set-property property="password" value="****"/>
</data-source>
</data-sources>
I also tried
<set-property property="useUnicode" value="true" />
<set-property property="characterEncoding" value="UTF-8" />
but it doesn't work... any idea?
thank!
I need to get this connection:
("jdbc:mysql://localhost:3306/netinfoa_amt?characterEncoding=UTF-8&useUnicode=true", "root", "****");
using <data-sources> declared on my STRUTS-CONFIG.XML
no problem with:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver"/>
<set-property property="url" value="jdbc:mysql://localhost:3306/netinfoa_amt" />
<set-property property="username" value="root"/>
<set-property property="password" value="****"/>
</data-source>
</data-sources>
But i have this problem: org.xml.sax.SAXParseException: The reference to entity "useUnicode" must end with the ';' delimiter.
trying:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver"/>
<set-property property="url" value="jdbc:mysql://localhost:3306/netinfoa_amt?characterEncoding=UTF-8&useUnicode=true" />
<set-property property="username" value="root"/>
<set-property property="password" value="****"/>
</data-source>
</data-sources>
I also tried
<set-property property="useUnicode" value="true" />
<set-property property="characterEncoding" value="UTF-8" />
but it doesn't work... any idea?
thank!