John:
Also, try increasing size of memory used by JVM. Check JServ docs.
Antonio
----- Original Message -----
From: Ted Neward <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 06, 1999 5:13 AM
Subject: Re: JDBC, help me ASAP!
> John--
>
> OutOfMemoryErrors are thrown when the JVM cannot satisfy a memory request;
> you might try increasing the available memory to the JVM on startup--use
> the '-m' option on the command-line. From within JServ, though, I'm not
> sure how to do that--I'm not a JServ expert.
>
> Ted Neward
> http://www.javageeks.com/~tneward
>
>
> On Mon, 6 Dec 1999, John John Tobias wrote:
>
> > Good day!
> >
> > I'm trying to insert 17.5MB of data in my database using the code below,
I
> > used the setBinaryStream() method in PreparedStatement class, but the
errors
> > occured (see "ERROR" section). Then, I tried to insert 940kb of data
then
> > it's work. Any idea on how to implement and support the large data
insertion
> > in db? is there a need to reconfigure the Sybase? if so, how? or what
> > additional settings that i need? I'm using Sybase as my database,
JDBC2.0,
> > JDK1.2 and ApacheJserv.
> >
> > pls kindly help....
> >
> > Thank's in advance,
> >
> > John John Tobias
> >
> >
> > ----------------------------------------------------------------------
> >
> > public class SqlInsert {
> >
> > Connection conn = null;
> >
> > SqlInsert() {
> > try {
> > Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
> >
> >
conn=DriverManager.getConnection("jdbc:sybase:Tds:dev1:4100/pass","pass","pa
ss");
> >
> > }
> >
> > catch(Exception e){
> > System.out.println( e );
> > }
> > }
> >
> > public void Insert() {
> >
> > Statement stmt = null;
> > ResultSet rs = null;
> > InputStream istream = null;
> >
> > try {
> >
> > FileInputStream f = new FileInputStream( "filedata.txt" );
> > PreparedStatement pstmt = conn.prepareStatement("insert into
> > attachments(attID,msgID,filename,"
> > + "contentType,encoding,attBody) values
> > (10,'Dummy'," +"'dummy.dat','text/plain','7bit',?)" );
> >
> > pstmt.setBinaryStream(1, f, (int)f.available() );
> > pstmt.execute();
> > pstmt.close();
> > f.close();
> > }
> > catch (Exception e){
> > System.out.println( e );
> > }
> > }
> >
> > public static void main( String []args ) {
> >
> > SqlInsert svr = new SqlInsert();
> > svr.Insert();
> > svr.close();
> > }
> > }
> >
> >
> > ----------------------------------------------------------------------
> > ERROR:
> >
> >
> > Exception in thread "main" java.lang.OutOfMemoryError
> > at com.sybase.jdbc2.tds.TdsParam.literalValue(Compiled Code)
> > at
com.sybase.jdbc2.jdbc.ParamManager.processParamMarkers(Compiled
> > Code)
> > at com.sybase.jdbc2.tds.Tds.language(Compiled Code)
> > at com.sybase.jdbc2.jdbc.SybStatement.sendQuery(Compiled Code)
> > at com.sybase.jdbc2.jdbc.SybPreparedStatement.sendQuery(Compiled
> > Code)
> > at com.sybase.jdbc2.jdbc.SybStatement.execute(Compiled Code)
> > at com.sybase.jdbc2.jdbc.SybPreparedStatement.execute(Compiled
> > Code)
> > at SqlInsert.getStream(Compiled Code)
> > at SqlInsert.main(Compiled Code)
> >
> >
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com
> >
> >
___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
