Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > Different character sets cause connection errors

Different character sets cause connection errors

Table of contents

Overview

SQL Server and Sybase - JTDS

When attempting to monitor a database that has a different character set than the Ignite server and/or Ignite Repository database, you may see an error that looks similar to this:

  • An unknown error has occurred. The provided message is "Could not get JDBC Connection; nested exception is java.sql.SQLException: Could not find a Java charset equivalent to DB charset iso_1."

Cause

This occurs when the Ignite Server and Repository are using a different character set than the one used by the monitored database and the jdbc driver java is unable to load the correct character set. For example:

Ignite Server: Cp1252

Repository DB: ISO_1
Monitored DB : ISO-8859-9 (Turkish)

Resolution

The ideal solution is to have all three using the same character set. If this isn't possible, you may be able to specify a character set that should be used instead. This is done by specifying a JDBC property in the Advanced Connection Properties of the Register Database Wizard.

For Example:

JTDS = charset=ISO-8859-9

 

Updates to the SQL Server JTDS Driver

There was a change in DPA version 10.0 to the jTDS drive for this issue. (The release notes are here. http://www.solarwinds.com/documentation/dpa/docs/releasenotes/releasenotes.htm?

CMPSource=THW&CMP=DIRECT)

DPA 10.0 updates the JTDS driver from 1.2.2 to 1.3.1. Improvements include:

  • SSL with BEAST detection
  • Java 1.8
  • Alternative data conversions for issues such as Turkish character recognition
  • Multi-subnet failover
  • ApplicationIntent=ReadOnly for read-only instances

 

Last modified
19:08, 22 Jun 2016

Tags

Classifications

Public