Hi guys,
I’m facing a strange issue…configuring UCS I need to connect to a DB with a Named instance and failing to connect, my query is:
jdbc:jtds:sqlserver://s247va1\BDT:1433;DatabaseName=UCS
But I have been able to connect to Interaction Server DB, I do know UCS connects via Java and INX uses DBServer…so I wonder if any one has a tested query string to connect via JDBC?
DB guys are validating that TCP/IP is enabled on the MSSQL server, but they are 99% sure it is…
Thanks
Complete error is:
15:39:25.949 Std 21111 [Ucs-Main] The Database Access Point 'DAP_UCS_MesaDinero' has been configured with an infinite timeout. 15:39:25.980 Trc 29998 [Ucs-Main] DataSource configured with properties (password=****,delete-locking-hint=ROWLOCK,dbengine=mssql,user=SQLGENE,queryTimeout=0,select-locking-hint=NOLOCK,charset=Cp1252,loginTimeout=10,port=7006,jdbc-debug=TRUE,appname='UCS_Main_MesaDinero' on 'DAP_UCS_MesaDinero',dbname=UCS,inactive-connection-timeout=0,insert-locking-hint=ROWLOCK,host=s286va3,update-locking-hint=ROWLOCK,username=SQLGENE,role=Main,query-timeout=0,dbcase=any,dbserver=s286va3,connection-failed-retry=2,database=UCS) 15:39:25.980 Dbg 29999 [Ucs-Main] JDBC debug is on 15:39:25.980 Trc 29998 [Ucs-Main] Datasource connection pool initialized with maximum size set to 40 connections, maximum login time set to 10000s, and maximum connection idle time set to 310s. 15:39:25.996 Trc 21284 [Ucs-Main] JDBC: registerDriver: driver[className=com.inet.pool.PoolDriver,com.inet.pool.PoolDriver@c8376b] 15:39:26.011 Trc 21284 [Ucs-Main] JDBC: registerDriver: driver[className=com.inet.ora.OraDriver,com.inet.ora.OraDriver@6e4365] 15:39:26.027 Trc 21284 [Ucs-Main] JDBC: [TDS Driver]Try: s286va3:7006 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: SQLException: SQLState(08S01) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: com.inet.tds.at: java.net.ConnectException: Connection refused: connect 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.aq.a(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.a(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.TdsDriver.connect(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.TdsDataSource.getConnection(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.PDataSource.getPooledConnection(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.g.b(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.PoolManager.a(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.PoolManager.getConnection(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.PDataSource.getConnection(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.DataSource.getDatabaseInfo(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.OptaDataSource.(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.NewDataSourceFactory.createDataSource(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.NewDataSourceFactory.createDataSource(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.byte(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.a(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.access$400(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine$5.run(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.lang.Thread.run(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: Caused by: java.net.ConnectException: Connection refused: connect 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.socketConnect(Native Method) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.doConnect(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.connectToAddress(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.connect(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.SocksSocketImpl.connect(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.connect(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.connect(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.a(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.a(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.run(Unknown Source) 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: ... 1 more 15:39:27.089 Trc 21284 [Ucs-Main] JDBC: [TDS Driver]{password=#######, insert-locking-hint=ROWLOCK, dbcase=any, charset=Cp1252, sql7=true, url=jdbc:inetdae, dbserver=s286va3, loginTimeout=10, port=7006, connection-failed-retry=2, delete-locking-hint=ROWLOCK, inactive-connection-timeout=0, dbengine=mssql, database=UCS, select-locking-hint=NOLOCK, host=s286va3, appname='UCS_Main_MesaDinero' on 'DAP_UCS_MesaDinero', query-timeout=0, queryTimeout=0, jdbc-debug=TRUE, db=UCS, role=Main, update-locking-hint=ROWLOCK, user=SQLGENE} 15:39:27.089 Std 05066 Initialization of UCS DAP failed, reason 'DataAccessPoint registration failed: java.net.ConnectException: Connection refused: connect' 15:39:27.089 Trc 21007 [Ucs-Main] LCA Status changed to 'Service Unavailable'. 15:39:35.949 Dbg 29999 [LogMon] Log reconfiguring task running 15:39:35.949 Dbg 29999 [LogMon] Log reconfiguring task period = 30000 ms
Hi Cav,
Try to use this connection string:
jdbc:jtds:sqlserver://s247va1:1433/BDT;instance=<instance name>
You can find more details about the JTDS driver for MS SQL Server here - http://jtds.sourceforge.net/
R.
Yup already tried before René, thanks for the point. I think the fact they haven’t answer about the TCP connection seems to be the 1% missing…