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 Mysql problem with attached files: Interbase?
Date Thu, 15 Feb 2001 13:10:52 GMT
Hi List,

   I encountered the following problem with the mm JDBC driver for Mysql:

	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(TownSpoolRepository.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?


         Joan Carles Núñez


View raw message