Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

JDBC connect reset after 60 seconds

  
   Database Forums (Home) -> JDBC Driver RSS
Next:  There is no enough storage space available... err..  
Author Message
FARRUKH

External


Since: Aug 16, 2006
Posts: 7



(Msg. 1) Posted: Wed Jul 09, 2008 7:58 am
Post subject: JDBC connect reset after 60 seconds
Archived from groups: microsoft>public>sqlserver>jdbcdriver (more info?)
We have a java app connecvting to SQL 2005 SP2 via JDBC. The connect gets
established for the first 60 seconds or so. We test the connection pool after
120 seconds (Select 1) but the server sends a connection reset error. If we
change the test to occur every 30 second, the connection remains active.

Why is the connection being dropped after 60 seconds?

On the SQL server the remote query timeout is set to unlimited.

 >> Stay informed about: JDBC connect reset after 60 seconds 
Back to top
Login to vote
joe.weinstein

External


Since: Aug 10, 2005
Posts: 30



(Msg. 2) Posted: Wed Jul 09, 2008 4:13 pm
Post subject: Re: JDBC connect reset after 60 seconds [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Jul 9, 7:58 am, FARRUKH <farrscorpi....RemoveThis@hotmail.com> wrote:
> We have a java app connecvting to SQL 2005 SP2 via JDBC. The connect gets
> established for the first 60 seconds or so. We test the connection pool after
> 120 seconds (Select 1) but the server sends a connection reset error. If we
> change the test to occur every 30 second, the connection remains active.
>
> Why is the connection being dropped after 60 seconds?
>
> On the SQL server the remote query timeout is set to unlimited.

Hi. It's either a network/firewall issue or a DBMS setting, nothing
to do with the JDBC driver.

Joe Weinstein at Oracle.

 >> Stay informed about: JDBC connect reset after 60 seconds 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Connect to user instance via JDBC? - Is it possible to connect to a user instance of a SQL Server 2005 Express database via the JDBC driver?

Connection Reset Error with SQLState() = 08S01 - The stack trace is Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSWriter.flush(Unknown Source) a...

JDBC Driver for SQL 7.0 ? - Hi; I'm installing an application that requires a JDBC driver for SQL Server. The thing is I am running SQL Server 7.0 and a look at Microsoft seems to show there are lots of these drivers for SQL 2000 but not for 7.0 I know little about these things -...

JDBC or ODBC? - I am in the interesting position of having to choose between using an ODBC or JDBC connection for a high traffic site. We can develop on either environment though I prefer the Java based one. Database connectivity to our SQL 2000 server is our numbe...

jdbc & java 1.5? - I'm using the SQL Server 2005 jdbc connector beta, sqljdbc_1.0.419.102_enu.tar.gz, because I read somewhere that it's necessary if you're using java 1.5. Is that true? If I can use the SQL Server 200 jdbc connector with java 1.5, where can I downloa...
   Database Forums (Home) -> JDBC Driver All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]