So if I am using the Maven goal j2:quickStart is there a way of preventing the j2:portal.conf.sql goal from being called? As from what I see, this is the goal that generates the sql scripts each time the j2:quickStart goal is called. Do I need to call each of the j2:quickStart goals individually instead and avoiding calling the j2:portal.conf.sql goal???
Daniel Jackson BAE SYSTEMS Australia Limited -----Original Message----- From: Frank Villarreal [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 November 2005 11:11 PM To: Jetspeed Users List Subject: RE: MSSQL 2000 Script execution failed remove the constraints causing the problem ... MSSQL2000 does not allow circular references ... or even multiple foreign keys that can cause cascade delete/update! > -----Original Message----- > From: JACKSON, Daniel [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 15, 2005 11:25 PM > To: [email protected] > Subject: MSSQL 2000 Script execution failed > > > Assistance required, > > > > I am attempting to run Jetspeed 2 with a MSSQL 2000 database without > success. I have a fresh cut of J2 and my current build.properties file > contains the following > > > > org.apache.jetspeed.production.database.default.name = mssql > > org.apache.jetspeed.production.database.url > = jdbc:JSQLConnect://localhost > > org.apache.jetspeed.production.database.user = > sa > > org.apache.jetspeed.production.database.password = > xxxxxxx > > org.apache.jetspeed.production.database.driver = > com.jnetdirect.jsql.JSQLDriver > > org.apache.jetspeed.production.jdbc.drivers.path = > ${org.apache.jetspeed.server.home}/common/lib/JSQLConnect.jar > > > > When I attempt to run the maven goal maven j2:quickStart I receive the > following error... > > > > j2:_db.create: > > j2:_process.all.scripts.in.path: > > [echo] Checking for SQL scripts at path > C:/Jetspeed-svn//target/portal-sql/mssql/schema... > > [echo] Running SQL scripts in directory > C:/Jetspeed-svn//target/portal-sql/mssql/schema... > > j2:_db.execute: > > [sql] Executing file: > C:\Jetspeed-svn\target\portal-sql\mssql\schema\phase1-schema.sql > > [sql] 23 of 23 SQL statements executed successfully > > > > j2:_db.execute: > > [sql] Executing file: > C:\Jetspeed-svn\target\portal-sql\mssql\schema\phase2-schema.sql > > [sql] [ERROR] Failed to execute: /* > ---------------------------------------------------------------------- > */ > > /* CLUBS */ /* > ---------------------------------------------------------------------- > */ BEGIN ALTER TABLE FOLDER ADD CONSTRAINT FOLDER_FK_1 FOREI > > GN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE CASCADE END > > > > BUILD FAILED > > File...... C:\Documents and > Settings\djackson\.maven\cache\maven-jetspeed2-plugin-2.0-M4-SNAPSHOT\pl > ugin.jelly > > Element... sql > > Line...... 866 > > Column.... 44 > > com.jnetdirect.jsql.u: Introducing FOREIGN KEY constraint 'FOLDER_FK_1' > on table 'FOLDER' may cause cycles or multiple cascade paths. Specify ON > DELETE NO ACTION or ON UPDATE NO ACTION, or modify othe > > r FOREIGN KEY constraints. > > Total time: 17 seconds > > Finished at: Wed Nov 16 15:54:43 EST 2005 > > > > Any help would be greatly appreciated. > > > > Regards > > Daniel Jackson > Software Engineer > BAE SYSTEMS Australia Limited > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
