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
_______________________________________________
Tapestry-developer mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/tapestry-developer
