I was definitely intrigued when I saw this package and have been trying to
install it.
However, when I try to create the tables in MySQL, I get the error below:
Also, I'm wondering how this fits in with standard DAO and other recommended
design patterns published by Sun. I'm thinking that I might need to use an
XML database for persistence in some areas of my application - can I use
this for that too? If not, how hard would it be to "adapt" it.
Please advise of any pros/cons with using this as a persistence mechanism.
It LOOKS great, I just don't want to jump the gun.
Thanks,
Matt
$cat simperdemo.sql | mysql simper;
ERROR 1064 at line 12: You have an error in your SQL syntax near 'with time
zone,
Constraint books_pkey Primary Key (id)
)' at line 5
The SQL I'm using is below.
--
-- SQL commands to generate the simperdemo database
--
CREATE TABLE authors (
id integer NOT NULL,
name text,
email text,
Constraint authors_pkey Primary Key (id)
);
CREATE TABLE books (
id integer NOT NULL,
id_author integer,
title text,
publishdate timestamp with time zone,
Constraint books_pkey Primary Key (id)
);
CREATE TABLE next_id_table (
table_name text,
next_id integer
);
INSERT INTO next_id_table (table_name, next_id) values ('authors', 0);
INSERT INTO next_id_table (table_name, next_id) values ('books', 0);
alter table books add constraint fk_books_authors foreign key (id_author)
references authors (id)
-----Original Message-----
From: Ted Husted [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 2:41 PM
To: Struts Developers List
Subject: Re: Comptability of JSR 127 and Struts [Was: SHORT TERM PLANS]
"Craig R. McClanahan" wrote:
> I've got one more useful new goody on my workbench - an ActionForm
> implementation that uses the new DynaBean APIs in the Commons version of
> BeanUtils that let you define form beans without having to write all the
> properties in individual bean classes.
Bryan Field-Elliot is also doing some interesting, seminal work with the
(very kewl) DynaBeans as part of a persistence layer framework.
http://netmeme.org/simper/
We're hoping to polish this up and propose it to the Commons. Bryan
doesn't have a Jakarta account right now, otherwise we'd check it into
the sandbox.
The example uses Struts, and the DynaBeans look very sweet when called
from an Action :)
It's also filter-based, and so requires a "leading edge" container, like
Tomcat 4.0.1.
-- Ted Husted, Husted dot Com, Fairport NY USA.
-- Building Java web applications with Struts.
-- Tel +1 585 737-3463.
-- Web http://www.husted.com/struts/
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
