June 23, 2016 at 8:32 am
Hello All,
I'm having the below intermittent issue when the java batch program tries connecting to SQL server. I have checked ports and network protocol and DB everything is enabled. Could you help me out to fix it.
JDBC URL: jdbc:sqlserver://DBServer.dbms.server.com:10000;SelectMethod=Direct;DatabaseName=XXXX
Database Instance : server.dbms.server.com
Database Server Name : XXX\XXXX
Database : XXXX
Getting the SQL server errors when the java batch program tries connecting to SQL server
Below are the errors from our application log file
GenerateEnvKPIFile: storeContent() error while trying store content [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
storeContent(): error when trying to store the content for waste [Microsoft][SQLServer 2000 Driver for JDBC]A remote host did not respond within the timeout period.
storeContent(): error when trying to store the content for waste [Microsoft][SQLServer 2000 Driver for JDBC]A remote host did not respond within the timeout period.
June 23, 2016 at 8:36 am
for the database server name try specifying the name and port number. For example
Server1,1433
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2016 at 8:41 am
You mean to say like this.
JDBC URL: jdbc:sqlserver://srvrname.dbms.sqlservercentralcom:10000;SelectMethod=Direct;DatabaseName=TEST
??
June 28, 2016 at 12:26 am
Hi,
Use below like..
DB INSTANCE NAME :- 10.120.X.X,1433
or
DB INSTANCE NAME :- HOSTNAME,1433 (If you use default instance)
DB INSTANCE NAME :- HOSTNAME\INSTANCENAME,1433 (If you use named instance)
Regards
Satish
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply