The version posted at .JdbcFixtures was posted a few weeks before the 20041105 release of fitnesse. Unfortunately, those jdbc fixtures won't work with the 20041105 release. Here is a version (based on the code at .JdbcFixtures, but simplified a bit) updated to work w/ the current version of Fitnesse.

Download (code and .jar)

Here's a sample wiki page

---

classpath: fitnesse.jar
classpath: lib/mm.mysql-2.0.11.jar
classpath: lib/jdbcfixtures.jar

Import

fitnesse.jdbc

Jdbc Connection
driver	url	user	password
org.gjt.mm.mysql.Driver	jdbc:mysql://localhost:3306/someDatabase	me	secret

Delete

user

Select	user
firstName	lastName	email

Insert	user
firstName	lastName	email	gender	date_registered
John	Doe	john@doe.com	M	2005-01-18 11:01:53
Jane	Roe	jane@roe.com	F

Select	user
firstName	lastName	email	gender	date_registered
John	Doe	john@doe.com	M
Jane	Roe	jane@roe.com	F

Update	user
firstName	where	firstName
Jonathan		John
Jennifer		Jane

Select	user
firstName	lastName	email	gender	date_registered
Jonathan	Doe	john@doe.com	M
Jennifer	Roe	jane@roe.com	F

---

[.FrontPage] [.RecentChanges]
Last modified anonymously on May 15, 2008 at 06:12:45 PM