Resolution:
Description:
= = = = = = =
Tasks like - DB-based Domain creation, adding a machine to such a domain, does not work:
-- when domain DB is MS SQL Server (MS SQL Server 2005 or 2008) and
-- DB driver is Microsoft JDBC 4.0 drivers(sqljdbc4.jar) or JDBC 4.0 Compliant driver and
-- JRE is 1.6.0 or higher


Environment:
= = = = = = =
All


Symptoms:
========
Whed adding a machine following error occurs:
==================================
2013 Aug 20 09:17:51:14 GMT -0400 DU Error [DomainUtility] AESDKJ-0000 java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out ClientConnectionId:62944ca5-cdaa-4576-bf8c-e3f5f7ad3474
      at com.tibco.administrator.domain.DomainConfiguration.a(DomainConfiguration.java:1728)
      at com.tibco.administrator.domain.DomainConfiguration.createDbDomainFiles(DomainConfiguration.java:1174)
      at com.tibco.administrator.domain.DomainConfiguration.joinDomain(DomainConfiguration.java:1065)
      at com.tibco.administrator.du.task.addmachine.JoinDomainTask.joinDomain(JoinDomainTask.java:263)
      at com.tibco.administrator.du.task.addmachine.JoinDomainTask.execute(JoinDomainTask.java:227)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at com.tibco.administrator.wizard.progress.Trampoline.invoke(Trampoline.java:96)
      at com.tibco.administrator.wizard.progress.BusyWait.run(BusyWait.java:267)
      at java.lang.Thread.run(Thread.java:722)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out ClientConnectionId:62944ca5-cdaa-4576-bf8c-e3f5f7ad3474
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654)
      at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1789)
      at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
      at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6154)
      at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6106)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2907)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
      at java.sql.DriverManager.getConnection(DriverManager.java:579)
      at java.sql.DriverManager.getConnection(DriverManager.java:221)
      at com.tibco.administrator.domain.DomainConfiguration.a(DomainConfiguration.java:1721)
      ... 11 more
==================================


Resolution:
= = = = = =
When using JRE 1.6 or higher with the vendor's JDBC 4.0 driver (or JDBC 4.0 Compliant driver), below Java property needs to be added in both domainutility.tra and tibcoadmin_&ltDoamin_Name>.tra files, and make sure both these files have JRE 1.6 or higher version specified.

      "java.property.TIBCO_SECURITY_VENDOR=j2se"