You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by angeloimm <an...@libero.it> on 2004/12/21 12:51:14 UTC
Changing db
Hi all; i'm very newbie in Jetspeed(i have downloaded it this morning italian time :-) ). I want to change form Hsql to MySql (version 4.0.16-nt); in order to do this thing i have tried to launch turbine-mysql.properties scripts.... but i have this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY, PERMISSION_NAME VARCHAR (99) NOT NULL, OBJECTDATA BIN
The table i want to create is:
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID integer NOT NULL IDENTITY,
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BINARY,
PRIMARY KEY(PERMISSION_ID),
UNIQUE (PERMISSION_NAME)
);
If i don't insert PRIMARY KEY and UNIQUE and change from BINARY to BLOB the table is created... can anybody help me?
Moreover... i use JBoss 3.2.5 and jetspeed 1.5; now if i want to use in jetspeed a JBoss datasource... how can i do? I think i must change the Torque.properties file, but how?
Thanks to all
____________________________________________________________
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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: [SPAM] Changing db
Posted by "Peter F." <Pe...@solutionstorent.com>.
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> jetspeed-user-unsubscribe@jakarta.apache.org
a> For additional commands, e-mail:
a> jetspeed-user-help@jakarta.apache.org
--
Best regards,
Peter mailto:Peter.Fen@solutionstorent.com