Question about myself MySQL database

Question about myself MySQL database

Dear team,

I want use myself MySQL database.
Refer help file,In database_params.conf,
I change URL to url jdbc:mysql://localhost:13326/AMDB?useUnicode=true&characterEncoding=GB2312 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

Then I restart AppManager,It fail.
The log said that Error occured while parsing the uri file:C: /AdventNet/ME/AppManager6/working/./apache/tomcat/conf/server.xml。

I check server.xml. I found that AppManager auto change server.xml.
In the server.xml,There are
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:13326/AMDB?useUnicode=true&characterEncoding=GB2312&autoReconnect=true?autoReconnect=true</value>
</parameter>

Because there are & in the url value.So the error occur.

In WebNMS,I can change URL to url jdbc:mysql://localhost/webnmsdb?useUnicode=true&characterEncoding=GB2312 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
There are no error occur.

I think if server.xml auto create to
...
<parameter>
<name>url</name>
<value><![CDATA[jdbc:mysql://localhost:13326/AMDB?useUnicode=true&characterEncoding=GB2312&autoReconnect=true]]></value>
</parameter>
...
Then App will parse server.xml correctly.
But in database_params.conf, I can not change URL to url <![CDATA[jdbc:mysql://localhost:13326/AMDB?useUnicode=true&characterEncoding=GB2312]]> AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

The problem are:
When & sige be included in URL string.How to start AppManager with no error?I need include useUnicode=true&characterEncoding=GB2312 in the URL.

Can you tell me when App start,How to control process of modify or create server.xml?
Or other method to resolve this problem.

You can refer the database_params.conf and server.xml with error in attached files.

Thank you,

Zhanglong
AdventNet China









































                New to ADSelfService Plus?