I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Problem trying to insert 10,000 records under Red

Problem trying to insert 10,000 records under Red in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: Problem   records   Problem trying   Problem trying insert   10 000   records under   Red   
Most Recent Post
JCarlos
Guadalajara,Mexico
I try to insert 10,000 records using an application (my client is under windows and my server is under Linux and my current version is InterBase_WI-V6.0.1-server.). and my application can insert 8187 records without problem but when my application tries to insert records from 8188 to 10,000 the following errors appear:

INSERT INTO tarjeta

INSERT OK...

NS Current: 0000000000001FFA

Lenght 3

INSERT INTO tarjeta

INSERT OK...

NS Current: 0000000000001FFB

Lenght 3

INSERT INTO tarjeta

INSERT OK...

NS Current: 0000000000001FFC

Lenght 3

INSERT INTO tarjeta

Error: [interclient][interbase] Unable to complete network request to host "localhost".

Error reading data from the connection.

Tabla tarjeta

Campos [nserie, id_ptoventa]

Valores ( [0000000000001FFC, 0] )

DataBase.java

insert2( String table, Vector fields, Vector values )

INSERT FAILED...

NS Current: 0000000000001FFD

Lenght 3

INSERT INTO tarjeta

SQL [interclient][interbase] Unable to complete network request to host "localhost".

Error reading data from the connection.

Error: [interclient] Client/Server protocol error: Unrecognized network message received from InterServer.

See API reference for exception interbase.interclient.RemoteProtocolException

Tabla tarjeta

Campos [nserie, id_ptoventa]

Valores ( [0000000000001FFD, 0] )

DataBase.java

insert2( String table, Vector fields, Vector values )

INSERT FAILED...

NS Current: 0000000000001FFE

Lenght 3

INSERT INTO tarjeta

SQL [interclient] Client/Server protocol error: Unrecognized network message received from InterServer.

See API reference for exception interbase.interclient.RemoteProtocolException

Error: [interclient] Communication error: An IO exception occurred while trying to send data to server 192.168.0.10.

The message of the IOException is "Software caused connection abort: socket write error".

See API reference for exception interbase.interclient.CommunicationException

Tabla tarjeta

Campos [nserie, id_ptoventa]

Valores ( [0000000000001FFE, 0] )

DataBase.java

insert2( String table, Vector fields, Vector values )

INSERT FAILED...

The funnies thing is that I tried with another computer as a second server and I installed interbase under this computer too, and the problem does not appear ( I mean, client under windoes and client under windows and I can insert 10,000 records without problems).

Do you know what the problem is?

Regards
 Posted 17 years ago (Thread Starter)
Comment Quote
About JCarlos -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #10566, No Replies Be the first!
Thread Started 6/29/2004 4:01:00 PM
View Counter=4532
Last Reply Posted 6/20/2017 2:55:34 AM)
Location=Guadalajara,Mexico  
Joined=17 years ago   MB Posts=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P167A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #10566 Counter
4532
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech