IDM 4.8 - Restricted characters in iManager Driver's password field
A few days ago I finished a migration to IDM 4.8 in one of our customers. All the process executed fine, except for one JDBC driver that did not started fine.
That JDBC Driver point to a Microsoft SQL Server 2012 database, and of course requires authentication at the start to connect to the required tables and views. But when we tried to start the driver, the following and "pretty obvious" error message appared on the driver Log:
DirXML Log Event -------------------
Message: <description>Unable to connect. Authentication failed.</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="18456" jdbc:sql-state="28000" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>Login failed for user 'integra'.</jdbc:message>
So of course we tested the user and password with SQL Studio, and the user logged in succesfuly on the database.
We reviewed the password and found that it contains a single quotation character ( ' ). And after changing the password by removing that character, the driver started fine. There was no question about it: that character was messing up the driver start procedure.
As of now, the issue has been solved, but my question is about a restricted list of characters in a driver's password. There is any? Or that issue might be related to the JDBC JAR driver itself?
Any suggestion or idea will be greatly appreciated.