Links

Lists

Latest Updates

Ruby On Rails List
Python list
Advanced Java
The JavaScript List
Apache Users
Full Disclosure
Linux Security

Search the archives!
Having a development problem? Ask eDevelopment.org forums!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQLException : Protocol Exception

  • From: Pratap.Malani@xxxxxxxx (Pratap Malani (EHPT))
  • Subject: SQLException : Protocol Exception
  • Date: Fri, 29 Dec 2000 13:46:58 +0100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07195.6E915D20
Content-Type: text/plain;
	charset="iso-8859-1"

Hello all,
I have a very strange requirement. I have to insert 9999999999 records in
oracle(8) database. The situation is either commit all or roll back all.
At around 85000th insert statement it gives SQLException : Protocol
Exception. 
I m setting all the values which are not useful( usually towards the end of
the for loop) as null.
I m also calling System.gc() and Runtime.getInstance().gc();

Has any one faced with such a problem before.
Can any one guide me?
Regards,
Pratap


------_=_NextPart_001_01C07195.6E915D20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>SQLException : Protocol Exception</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hello all,</FONT>
<BR><FONT SIZE=3D2>I have a very strange requirement. I have to insert =
9999999999 records in oracle(8) database. The situation is either =
commit all or roll back all.</FONT></P>

<P><FONT SIZE=3D2>At around 85000<SUP>th</SUP> insert statement it =
gives SQLException : Protocol Exception. </FONT>
<BR><FONT SIZE=3D2>I m setting all the values which are not useful( =
usually towards the end of the for loop) as null.</FONT>
<BR><FONT SIZE=3D2>I m also calling System.gc() and =
Runtime.getInstance().gc();</FONT>
</P>

<P><FONT SIZE=3D2>Has any one faced with such a problem before.</FONT>
<BR><FONT SIZE=3D2>Can any one guide me?</FONT>
<BR><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Pratap</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C07195.6E915D20--

---
To unsubscribe, mail advanced-java-unsubscribe@xxxxxxxxxxxxxxxx
To get help, mail advanced-java-help@xxxxxxxxxxxxxxxx