---------- Initial Header ----------- >From : "Peter F." [EMAIL PROTECTED] To : "Jetspeed Users List" jetspeed-user@jakarta.apache.org Cc : Date : Tue, 21 Dec 2004 14:07:39 +0200 Subject : Re: [SPAM] Changing db
> 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. Hello Peter.... thanks for your tip; now it seems to work. Do you know how i can use JBoss Datasource? I.e i want to use jetspeed under JBoss; now in JBoss are defined some datasources..... how can i use them in jetspeed? Thanks > > > 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] ____________________________________________________________ Regala e regalati Libero ADSL: 3 mesi gratis e navighi veloce. 1.2 Mega di musica, film, video e sport. Abbonati subito senza costi di attivazione su http://www.libero.it --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
