how to add a new datasource

[crosscourt]

in hsql, the defaultDS is jdbc:hsqldb:hsql://localhost:1701/

i notice that this is defined in hsqldb-ds.xml

how do i add my own datasource and use a new database?

where can i learn about these datasource related things?

[crosscourt]

ok, i added the MySql-ds.xml modified with my own settings,

changed all the java:defaultDS to java:MySqlDS in the .jdo files for the sample app but it still gives:

javax.jdo.JDOFatalDataStoreException: Failed to execute statement: SELECT COMMENT.OID FROM COMMENT COMMENT ORDER BY COMMENT.PUBLISHDATE ASC