Re: Vlib example

Well, you can patch the code make MySQL happy, which is what you already
have done.  Praise open-source.  You can go on the Wiki and create a page
describing this so that others will be able to do the same.

Please remember that the focus of the Vlib is to provide a shake-and-bake
demo for Tapestry (i.e., download JBoss, Tapestry, configure Tapestry,
execute one command, up and running).  It isn't supposed to demonstrate
vendor-neutral database access or any of that.

----- Original Message -----
From: "Stefan Wachter" <[email protected]>
To: <[email protected]>
Sent: Sunday, November 17, 2002 1:14 PM
Subject: [Tapestry-developer] Vlib example


> Hi all.
>
> I am currently evaluating Tapestry. I like very much what I saw until now.
>
> However, I had some difficulties in running the Vlib example. I am using
> JBoss with a MySQL database. In the method
OperationsBean.validateUniquePerson
> two SQL statements are constructed that are not valid for MySQL. The
problem
> is simply the spaces after the LOWER keyword. In MySQL no spaces must
appear
> between the LOWER keyword and the following parenthesis. The lines to
change
> are:
>
>             ...
>             assembly.addParameter("LOWER  (EMAIL) = ?", trimmedEmail);
>             ...
> and
>             ...
>             assembly.addParameter("LOWER (FIRST_NAME) = ?",
> trimmedFirstName);
>             ...
>             assembly.addParameter("LOWER (LAST_NAME) = ?",
trimmedLastName);
>             ...
>
> The second problem that I encountered is that the VARCHAR data type can
have
> at most 255 characters for the MySQL database. Therefore I had to adjust
the
> jbosscmp-jdbc.xml file.
>
> After these two changes the application runs great.
>
> --Stefan
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: To learn the basics of securing
> your web site with SSL, click here to get a FREE TRIAL of a Thawte
> Server Certificate: http://www.gothawte.com/rd524.html
> _______________________________________________
> Tapestry-developer mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tapestry-developer
>



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf