Actually the "db" directory by default is in TOMCAT_HOME not TOMCAT_HOME/webapps. (you can change this via store.cfg.
In case you did that: We're using HSQLDB in "in-process" mode, so it initialises when you start your app server. Have you restarted Tomcat? When you restart Tomcat, HSQLDB should by default create catalog.lck and catalog.log files in the db directory. Does your catalog.script file actually create a user "CAIRNGORMSTORE". Is the content matching the content of the supplied catalog.script? Best, Alex -- Alex Uhlmann Software Engineer iteration::two -----Original Message----- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Tom Fitzpatrick Sent: 25 May 2005 18:02 To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] Cairngorm store products Hi Alex - Thanks to you and Steven for staying with me on this. I did set it up that way, and it's still not working. My directory structure is: jakarta-tomcat-5.0.25 > webapps > db jakarta-tomcat-5.0.25 > webapps > cairngormstore Inside the db directory are catalog.properties, catalog.script, and mysql_store.sql I did find this error message from Tomcat: java.sql.SQLException: User not found: CAIRNGORMSTORE Does that help? - Tom At 12:25 PM 5/25/2005, you wrote: >if you used the default settings of store.cfg, make sure you have a "db" >directory in the parent of your WEBAPP_DIR. On Tomcat that's >TOMCAT_HOME/webapps. In "db" you have to place your catalog.proteries >and catalog.script files. See install docs for more. Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/