Posted: Wed Sep 10, 2014 6:23 am Post subject: Server Name string issue related to JDBC configuration
Novice
Joined: 10 Mar 2014 Posts: 19
I am working on a mapping node which connects to SQL server.
As Mapping node requires I configured JDBC4 type connection MYSQL and I have a server name like "TESTSQL\SERVER" and port as 0.
But my flow is failing with the below error :
Insert
Type:INTEGER:5
Text:CHARACTER:jdbc:sqlserver://TESTSQLSERVER:0
Insert
Type:INTEGER:5
Text:CHARACTER: error message: The TCP/IP connection to the host TESTSQLSERVER port 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."., SQLState value: 08S01, stack trace: [com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
For some reason \ is missing from the Server name string when mapping node is trying to connect.
Can someone please help me out in resolving this. Thanks.
Please try to escape the "\" between the server name and the instance name. If I recall correctly, you use "\" as an escape character, so go with TESTSQL\\SERVER.
I don't have access to a SQL Server instance here to check myself right now.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum