Simper and MySQL - building database error.

[Matt Raible <ma...@yahoo.com>]

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:husted@apache.org]
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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Simper and MySQL - building database error.

[Matt Raible <ma...@yahoo.com>]

Yep, I downloaded the .02 release last night - and tried running the load
script.  If anyone has successfully been able to do this - please let me
know (and send your modified script ;)

I've seen dbXML, and have it installed, I'm just wondering how difficult it
would be to "adapt" simper to talk to it...

Thanks,

Matt

-----Original Message-----
From: Ted Husted [mailto:husted@apache.org]
Sent: Wednesday, January 16, 2002 2:11 PM
To: Struts Developers List
Subject: Re: Simper and MySQL - building database error.


Are you using the .02 release? Bryan made some changes to accomodate
MySQL.

http://netmeme.org/simper/

For an XML database, have you seen this?

http://www.dbxml.org/

This is part of xml.apache.org now.


Matt Raible wrote:
>
> 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

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Simper and MySQL - building database error.

[Ted Husted <hu...@apache.org>]

Are you using the .02 release? Bryan made some changes to accomodate
MySQL. 

http://netmeme.org/simper/

For an XML database, have you seen this?

http://www.dbxml.org/

This is part of xml.apache.org now.


Matt Raible wrote:
> 
> 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

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>