From sergek@lokitech.com  Thu Feb 15 13:17:36 2001
Return-Path: <sergek@lokitech.com>
Mailing-List: contact james-dev-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list james-dev@jakarta.apache.org
Received: (qmail 93248 invoked from network); 15 Feb 2001 13:17:36 -0000
Received: from unknown (HELO beethoven.lokitech.com) (root@216.7.13.68)
  by h31.sny.collab.net with SMTP; 15 Feb 2001 13:17:36 -0000
Message-ID: <001101c09751$a8db8dc0$650d07d8@STACCATO>
From: "Serge Knystautas" <sergek@lokitech.com>
To: <james-dev@jakarta.apache.org>
References: <20010215141052.29de4d3d.joancarles@indibil.com>
Subject: Re: Mysql problem with attached files: Interbase?
Date: Thu, 15 Feb 2001 08:17:34 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Received: from 216.7.13.101 ([216.7.13.101])
          by mail.lokitech.com (JAMES SMTP Server 1.2) with SMTP ID 979
          for <james-dev@jakarta.apache.org>;
          Thu, 15 Feb 2001 08:17:35 -0500
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

Can you send me a structure of your tables?  I know at one point the mysql
script had one column type that was off, and while I thought it was
corrected, I wouldn't be surprised if the incorrect version is still out
there.  Thanks.

Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Joan Carles Núñez" <joancarles@indibil.com>
To: <james-dev@jakarta.apache.org>
Sent: Thursday, February 15, 2001 8:10 AM
Subject: Mysql problem with attached files: Interbase?


> Hi List,
>
>    I encountered the following problem with the mm JDBC driver for Mysql:
>
> java.lang.ArrayIndexOutOfBoundsException
> at java.lang.System.arraycopy(Native Method)
> at org.gjt.mm.mysql.Buffer.writeBytesNoNull(Buffer.java:352)
> at
org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:291)
> at com.workingdogs.town.Record.saveWithInsert(Record.java:1727)
> at com.workingdogs.town.Record.save(Record.java:1612)
> at com.workingdogs.town.Record.save(Record.java:1456)
> at com.workingdogs.town.Record.save(Record.java:1419)
> at
org.apache.james.mailrepository.TownSpoolRepository.store(TownSpoolRepositor
y.java:188)
> at org.apache.james.James.sendMail(James.java:298)
> at
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java:317)
> at org.apache.james.smtpserver.SMTPHandler.run(SMTPHandler.java:121)
> at org.apache.avalon.utils.recycle.pool.Worker.run(Worker.java:113)
>
> This implies that I either tinker with the JDBC driver to deal with large
blobs or
> use some other database (I didn't try www.caucho.com's JDBC driver...).
> I am considering the use of Interbase Super Server. Before I set myself to
do
> this, does anyone know a workaround the Mysql JDBC limitation?
> Using a database with transaction support like interbase would add extra
overhead
> to the machine that hosts James...
> Is migrating database a matter of finding the right column types for the
'Message' table?
>
> Thanks,
>
>          Joan Carles Núñez
>
> EBS S.L.
> Spain
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org
>
>