connection always drop.. when pump in huge data into the MSSSQL DB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: msone (msone_at_discussions.microsoft.com)
Date: 10/08/04 

Date: Thu, 7 Oct 2004 20:09:03 -0700

hi all..

Currently... i;m using windows 2003, MSSQL 2000 standard edition for the
database and also the castor JDO to create the object to make the socket
connection via JDBC.

My problem is.. the connection is always drop when i pump in a huge data
such as 5000 records in the MSSQL database. It gives me this error:

org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
establishing socket.

When i try to re-connect and the connection is successful made...after
certain duration, the connection will drop again and it will continuously
dropping.

But when i pump in a small amount of records such 500 into the database... i
got no problem. I also got no problem pump in a huge data into MSSQL by
using windows 2000 platform.

My question is... is the platform do matters .....

Can anyone help me with this problem.. or have any idea to solve it.
Thanks.

Relevant Pages

  • Connection Drop..
    ... the connection is always drop when i pump in a huge data ... such as 5000 records in the MSSQL database. ... establishing socket. ...
    (microsoft.public.windows.server.sbs)
  • [Microsoft][SQLServer 2000 Driver for JDBC]net dll not initi
    ... when attempting to query the database. ... Also, once the exception ... Successive calls to get a connection from the ... dll not initialized: socket write error ...
    (microsoft.public.sqlserver.jdbcdriver)
  • MSSQL 2000 Developer connection limit & boolean connection
    ... I've been searching the MSDN web for the MSSQL 2000 Developer connection ... We do have user connecting to this database through http/asp, ...
    (microsoft.public.sqlserver.connect)
  • NT Service and Sockets
    ... I'm wondering if someone can help me out with a socketty problem within an ... away to a database. ... The service app connects to the database via an IP address and socket. ... connection is only ever open for a brief preiod of time. ...
    (alt.comp.lang.borland-delphi)
  • Re: mssql_query not returning
    ... I have been using MySQL in connection with PHP for fun for several ... that uses MS SQL server 2005. ... and to database, but the mssql_query isnt returning anything. ... I had trouble with mssql too, and switched to odbc connection to mssql, which solved a lot of strange things for me. ...
    (comp.lang.php)