I've some strange behavior with HSQL like a jndi datasource. I'm able to run the create script via a jdbc based sql tool, however it fails with syntax errors after i edit the script file. How come it interpret sql in a different way in the script in tomcat compared to a jdbc based sql editor?

Also after i make use of a hsql url for file based database then appears to still create an in memory only version. I favor to become utilizing a filesystem based database.