Chris --
Noting something about MySQL in the existing scripts won't help,
because JSPWiki doesn't actually have any scripts for MySQL yet! At
present, we just have scripts for HSQL and PostgreSQL.
Interested in adapting the existing scripts for MySQL? The existing
scripts are in the source tarball, in etc/db. If this is something you
choose to do, you should then make sure all of the Ant tests run ok
(at shell, type: "ant tests"), and attach the scripts to a new JIRA
issue. The Ant build.xml file and build.properties file both have tips
on how to run JDBC tests.
If you don't want to go through all that trouble, I'd ask you to
create a JIRA issue anyway -- that way it'll get fixed. Just maybe not
as fast as if we had a user contribution. :)
Thanks for chasing this down!
Andrew
On Jul 31, 2008, at 6:09 PM, Chris Mein wrote:
Found the solution (got to love open source code). Anyway
When I ran the JDBCUserDatabaseTest.testFindByEmail() on my system I
got the following exception:
"java.sql.Exception: Value '0000-00-00' can not be represented as
'java.sql.Timestamp"
So it appears to me that the table definition doesn't work for
MySQL. If anyone is reading this maybe this needs to be noted in the
create_user.dll file.
Thanks for you input Andrew
Chris
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses
available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
