Excellent! Glad you went to raw JDBC as well. I'm excited about the
excalibur code too since I'm was dreading another dependency as well. I'll
look at your code for table creation since I'm not sure how you can create
table in the different databases.
Hopefully today I'll throw it together and start some testing. I only have
M$ SQL 2k here, so additional platform testing would be great. 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).
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]
