Hi, Check that your id-table-schema.xml file (and your other schema files) has name="something" parameter in the <database> tag. I think the <database> tag is empty by default.
See issue TRQS35 in Scarab. Regards, -- Rodney On Fri, 15 Nov 2002 15:59, you wrote: > Hi, > I am using torque-3.0- rc1. I get following error message when I run > create-db > > [sql] Failed to execute: drop database if exists default > [sql] java.sql.SQLException: Syntax error or access violation: You > have an > error in your SQL syntax near 'default' at line 1 > [sql] Failed to execute: create database default > [sql] java.sql.SQLException: Syntax error or access violation: You > have an > error in your SQL syntax near 'default' at line 1 > [sql] 2 of 4 SQL statements executed successfully > > My create-db sql has following lines: > > drop database if exists UMail; > create database UMail; > drop database if exists default; > create database default; > > > My sqldb.map contains following line > #Sqlfile -> Database map > #Fri Nov 15 14:38:03 EST 2002 > project-schema.sql=UMail > id-table-schema.sql=default > > > From my search on torque/turbine archives I know that other ppl have had > this problem with earlier versions of torque. However, I did not find any > good solution for this problem. If I don't have to, then, I dont want to > delete certain lines from my sql file or path createdb.vm file so that it > ignores default database. > The fact that it worked for me with earlier versions and others have had > same problems with earlier version makes me think that its some > configuration that I have skipped. > > Does any one know how I can resolve it. > Thanks for ur time > > > Anm01 -- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
