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]
