>Last I
>checked, I don't think we can use Postgres for the spool repository though
>because it can't hold large binary messages (I think MySQL is limited to 1
>meg messages, but that's pretty reasonable).
Has it ever been considered to store the attachments in the file system
rather than the DB so this limitation wouldn't be a problem?
What exactly happens if you use MySQL and you get/send a message with a 2
meg attachment?
David
>Serge Knystautas
>Loki Technologies
>http://www.lokitech.com/
>----- Original Message -----
>From: "Darrell DeBoer" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, June 16, 2001 4:29 AM
>Subject: Re: RDBMS support
>
>
> > Hi Serge,
> >
> > > I've been refamiliarizing myself with some of the code, and would like
>to
> > > get the RDBMS stuff working in the new Avalon/Phoenix architecture. I
> > > believe someone has already started working on the user repository
>version
> > > of this, so I'd be curious how he/she was planning to do this.
> > >
> >
> > I wrote a UsersJDBCRepository recently, using direct JDBC connections.
>It's
> > been incorporated into CVS. This first iteration uses an ineffiecient
>"open a
> > new connection every time" setup, but I'm now looking at incorporating the
> > Excalibur connection pooling funcionality.
> >
> > I've taken the path of using generic vanilla SQL, and the code's been
>tested
> > against M$SQL Server 7, Oracle 8i, and MySQL. It's simple and works for
>now,
> > but we'll probably need to look at incorporating vendor-specific SQL
> > (particularly column types) in order to support more DB vendors.
> >
> > > .... While I think Turbine would be great for
> > > letting James automatically create the appropriate table structure, ...
> >
> > I got automatic table generation working simply enough. I just check the
> > DatabaseMetaData to see if the table exists, and if not, execute a "CREATE
> > TABLE" statement.
> >
> > Let me know if I can help with the testing of SQL on different database
> > engines - I've got M$SQL Server 7, Oracle 8.1.6, MySQL 3.23 and PostgreSQL
> > 7.0.3 installs available for testing.
> >
> > ciao
> > Daz
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
