james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joan Carles Nez <joancar...@indibil.com>
Subject Re: Mysql problem with attached files: Interbase?
Date Thu, 15 Feb 2001 13:30:17 GMT
Hi Serge,

   That was quick! I have been reading thru the mm JDBC driver mailing 
lists and it looks like a known problem with this driver (currently the limit 
for a Blob is 1 Mb so this exception appears with attach files bigger than 1Mb).
Take a look at this message where this is discussed: 

http://db.geocrawler.com/mail/msg.php3?msg_id=4746024&list=193

By the way, the www.caucho.com driver is experimental, so not an option.

Thanks,

        J. Carles

------------------------------------------------------------------------
DROP DATABASE James;

CREATE DATABASE James;

use James;

CREATE TABLE Message (
	message_name varchar (200) NOT NULL PRIMARY KEY,
	repository_name varchar (200) NOT NULL ,
	message_state varchar (30) NOT NULL ,
	error_message varchar (200) NULL ,
	sender varchar (100) NOT NULL ,
	recipients text NOT NULL ,
	remote_host varchar (100) NOT NULL ,
	remote_addr varchar (20) NOT NULL ,
	message_body longblob NOT NULL ,
	last_updated datetime NOT NULL 
);
-------------------------------------------------------------------------

On Thu, 15 Feb 2001 08:17:34 -0500
"Serge Knystautas" <sergek@lokitech.com> wrote:

> 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
> >
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org

Mime
View raw message