Hello angeloimm,
Where did you get this scripts? Try to get the latest versions of MySQL-related scripts from CVS. They must be fixed under CVS. Tuesday, December 21, 2004, 1:51:14 PM, you wrote: a> Hi all; i'm very newbie in Jetspeed(i have downloaded it this a> morning italian time :-) ). I want to change form Hsql to MySql a> (version 4.0.16-nt); in order to do this thing i have tried to a> launch turbine-mysql.properties scripts.... but i have this error: a> You have an error in your SQL syntax. Check the manual that a> corresponds to your MySQL server version for the right syntax to a> use near 'IDENTITY, PERMISSION_NAME VARCHAR (99) NOT NULL, a> OBJECTDATA BIN a> The table i want to create is: a> CREATE TABLE TURBINE_PERMISSION a> ( a> PERMISSION_ID integer NOT NULL IDENTITY, a> PERMISSION_NAME VARCHAR (99) NOT NULL, a> OBJECTDATA BINARY, a> PRIMARY KEY(PERMISSION_ID), a> UNIQUE (PERMISSION_NAME) a> ); a> If i don't insert PRIMARY KEY and UNIQUE and change from BINARY a> to BLOB the table is created... can anybody help me? a> Moreover... i use JBoss 3.2.5 and jetspeed 1.5; now if i want a> to use in jetspeed a JBoss datasource... how can i do? I think i a> must change the Torque.properties file, but how? a> Thanks to all a> ____________________________________________________________ a> Regala e regalati Libero ADSL: 3 mesi gratis e navighi veloce. a> 1.2 Mega di musica, film, video e sport. a> Abbonati subito senza costi di attivazione su http://www.libero.it a> --------------------------------------------------------------------- a> To unsubscribe, e-mail: a> [EMAIL PROTECTED] a> For additional commands, e-mail: a> [EMAIL PROTECTED] -- Best regards, Peter mailto:[EMAIL PROTECTED]
