DBIOException using hostname instead of IP address in DBSRV connection

Products

• Datacom/Server

Issue/Introduction

Change mad to the value of TCPIP_HOST startup parameter of Datacom Server (DBSRV) from IP address (e.g. 12.34.56.78) to DNS domain name (e.g. ABCD.FGH.COM).

Also changed the JDBC type 4 connection string, to use the hostname instead of the IP address:

jdbc:datacom://ABCD.FGH.COM:6463/ConnectType=TCP,ServerName=DBSRVT,ApplicationID=SYS1TST,SystemID=SYS1

Tried a type 4 connection via DbVisualizer but it fails:

An error occurred while establishing the connection:

Long Message:
IO error sending or receiving native data: ca.datacom.db.DBIOException: ca.datacom.db.DBIOException: java.net.ConnectException: Connection refused: connectin Network(Network)in Node(connect)

Details:
   Type: java.sql.SQLException
   SQL State: 08001

Resolution

Remove the domain name (FGH.COM) from the Type 4 connection string:

jdbc:datacom://ABCD:6463/ConnectType=TCP,ServerName=DBSRVT,ApplicationID=SYS1TST,SystemID=SYS1

So this is a network configuration problem, not a Datacom Server one.