RE: Problems with CMP/MySQL

2001-09-30 Thread Troy Wong
I had a similar problem but found a fix for it. I assume you are using mm.mysql as your jdbc driver: create table Article ( articleId varchar(100) not null primary key, churchId varchar(100), userId varchar(100), title varchar(100), content longtext,

RE: RE: Stored procedures and J2EE

2001-09-08 Thread Troy Wong
The whole point of n-tier distributed programming is to keep business logic outside of the database layer. Stored Procedures do have performance benefits, but it's much better from a design perspective to keep all logic in the middle layer and leave the database as a dumb persistence layer.