CVP 12.6 Integration with Database

[Ahmed Adeyemi]

Integrating CVP with SQL Database and I've defined my JNDI parameters as well as context.xml. I have previously done this integration in other CVP versions and worked fine but with 12.6 tomcat changed and now it looks like its requiring some other parameters I am unaware of and I'm getting errors stating "INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified."

Attached are my context.xml and the error file of what I'm getting.

[bill.king1]

Can you actually paste the content on the forum vs the file as well (to make it easier to see if there's something unusual as far as hidden character vs. a syntax change/issue)?

[Ahmed Adeyemi]

Below is the entire content of the XML File

<

<!-- The contents of this file will be loaded for each web application -->
<Context>

<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Manager pathname=""/>
<!-- Microsoft SQL Begin-->
<Resource name="jdbc/Customer"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://mssql.voicelab.local:1433;DatabaseName=Cisco;user=sa;password=@DsaAdmin;encrypt=true;trustServerCertificate=true;multiSubnetFailover=true"/>
<!-- Microsoft SQL End -->
<!-- MySQL Begin -->
<Resource name="jdbc/MySQLDB"
auth="Container"
type="javax.sql.DataSource"
username="superadmin"
password="superadmin"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:sqlserver://mssql.voicelab.local:3306/Cisco"/>
<!-- MySQL Ends -->
<!-- Oracle DB Begin-->
<Resource name="jdbc/OracleDB"
auth="Container"
type="javax.sql.DataSource"
maxIdle="2"
maxWait="5000"
username="oSa"
password="@DsaAdmin"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@onl-oracledb.voicelab.local:1521"/>
<!-- Oracle DB Ends -->
<!-- PostgresSQL Begin -->
<Resource name="jdbc/PostgresSQL"
auth="Container"
driverClassName="org.postgresql.Driver"
maxActive="100"
maxIdle="20"
maxWait="5000"
minIdle="5"
username="sa"
password="@DsaAdmin"
type="javax.sql.DataSource"
url="jdbc:postgresql://onl-postgresSQL.voicelab.local:5432/Cisco"/>
<!-- PostgresSQL Ends -->
<!-- Email Setup Begins -->
<Resource name="mail/CVPMail"
type="javax.mail.Session"
mail.smtp.host="mail.voicelab.local"/>
<!-- Email Setup Ends -->
</Context>