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 Maruthi <ma...@yahoo.com> on 2004/06/18 12:16:41 UTC
Hello Stijn..again problems with .sql scripts ( Re: JSP Portlet ->Mysql ->Connection Problem)
Hello Stijn,
First of all Thanks for your reply and suggestions.As per your suggestion i ran .sql scripts.I got some problems with IDENTITY.I think you too got the same problem once upon a time as i saw your question regarding this one in the mailing list.And as per Michael Muller's Suggestion in the list (see .. http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg12369.html ) i changed IDENTITY to AUTO_INCREMENT and BINARY to BLOB.After that i am getting these errors::
Errors for turbine-mysql ::
ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key
Errors for Populate-mysql.sql ::
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
I am attaching the list :::
==========================================================================
Before replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in turbine-mysql.sql
==========================================================================
ERROR 1064: 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,
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDAT
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1064: 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,
LOGIN_NAME VARCHAR (32) NOT NULL,
PASSWORD_
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
ERROR 1064: 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,
COFFEE_NAME VARCHAR (50),
SUPPLIER_ID integ
Query OK, 0 rows affected (0.01 sec)
mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
==========================================================================
After replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in turbine-mysql.sql
==========================================================================
mysql> \. c:\jetspeed-1.5-src\src\sql\external\turbine-mysql.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.05 sec)
ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key
Query OK, 0 rows affected (0.00 sec)
mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
ERROR 1146: Table 'jetspeed.coffees' doesn't exist
Please suggest me what to do in this regard.
Thanks for your help,
Maruthi.
Stijn de Witt <St...@bergland-it.nl> wrote:
Hello Maruthi,
It seems that the turbine tables do not exist, as the logging shows: "Table
'thesiswork.turbine_user' doesn't exist". Have you ran the .sql scripts
needed to create and populate the turbine tables?
Check out src/sql/external/turbine-mysql.sql and
src/sql/external/populate-mysql.sql. Also look here:
http://portals.apache.org/jetspeed-1/database.html
Hope it helps,
-Stijn
----- Original Message -----
From: Maruthi
To: jetspeed-user@jakarta.apache.org
Sent: Thursday, June 17, 2004 7:09 PM
Subject: JSP Portlet ->Mysql ->Connection Problem
Hello Everybody,
I want to connect to JSP portlet to mysql database.......when i deployed i
am getting the following error.I am using mysql database and the driver is
mysql Odbc 3.51 driver to connect to mysql from Java..My database name is
"Thesiswork".
_____________________________________________
Error::
_____________________________________________
17.06.2004 18:26:44 org.apache.torque.util.BasePeer initTableSchema
SCHWERWIEGEND: java.sql.SQLException: [MySQL][ODBC 3.51
Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist
17.06.2004 18:26:44
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer initClass
SCHWERWIEGEND: A FATAL ERROR has occurred which should not have happened
under any circumstance. Please notify the Torque developers
che.org> and give as many details as possible (including the error stack
trace).
java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table
'thesiswork.turbine_user' doesn't exist
_______________________________________________________________________
I am attaching my source code,registry file,Property files ....i tried all
the options that i know to solve the problem ...but i couldn't.Any help in
this regard will be greatly appreciated.
Thanks a lot for your time and patience,
Maruthi.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
Re: Hello Stijn..again problems with .sql scripts
Posted by Maruthi <ma...@yahoo.com>.
Hello Stijn,
Thanks for your mail and files.I copied the files you sent and i tried again but something wrong in the syntax seems to be in the table email_inbox..i am getting this error.I didn't modified anything just copy & pasted as it is what you sent.
ERROR 1064: 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 '-
-
CREATE TABLE EMAIL_INBOX (
EMAIL_INBOX_ID integer(11
Can you check once please.
Thank you.
Maruhti:
Stijn de Witt <St...@bergland-it.nl> wrote:
Hi Maruthi,
The best thing you can do probably is to get the latest version of Jetspeed
from the CVS, jetspeed-1.6-dev. That particular problem was fixed in 1.6. If
you don't want to use a development version, or if you don't have access to
CVS, here are the turbine-mysql.sql and populate-mysql.sql that are included
in 1.6. You can probably just use those.
-Stijn
P.S. I'm just pasting them in the message, so they'll also be available in
the list archives:
turbine-mysql.sql
-----
----------------------------------------------------------------------------
-
-- Copyright 2004 The Apache Software Foundation
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
----------------------------------------------------------------------------
-
# -----------------------------------------------------------------------
# TURBINE_USER
# -----------------------------------------------------------------------
drop table if exists TURBINE_USER;
CREATE TABLE TURBINE_USER
(
USER_ID INTEGER NOT NULL AUTO_INCREMENT,
LOGIN_NAME VARCHAR (32) NOT NULL,
PASSWORD_VALUE VARCHAR (32) NOT NULL,
FIRST_NAME VARCHAR (99) NOT NULL,
LAST_NAME VARCHAR (99) NOT NULL,
EMAIL VARCHAR (99),
CONFIRM_VALUE VARCHAR (99),
MODIFIED TIMESTAMP,
CREATED TIMESTAMP,
LAST_LOGIN TIMESTAMP,
DISABLED CHAR (1),
OBJECTDATA BLOB,
PASSWORD_CHANGED TIMESTAMP,
PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_ROLE
# -----------------------------------------------------------------------
drop table if exists TURBINE_ROLE;
CREATE TABLE TURBINE_ROLE
(
ROLE_ID INTEGER NOT NULL AUTO_INCREMENT,
ROLE_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BLOB,
PRIMARY KEY(ROLE_ID),
UNIQUE (ROLE_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_GROUP
# -----------------------------------------------------------------------
drop table if exists TURBINE_GROUP;
CREATE TABLE TURBINE_GROUP
(
GROUP_ID INTEGER NOT NULL AUTO_INCREMENT,
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BLOB,
PRIMARY KEY(GROUP_ID),
UNIQUE (GROUP_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_PERMISSION
# -----------------------------------------------------------------------
drop table if exists TURBINE_PERMISSION;
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID INTEGER NOT NULL AUTO_INCREMENT,
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BLOB,
PRIMARY KEY(PERMISSION_ID),
UNIQUE (PERMISSION_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_ROLE_PERMISSION
# -----------------------------------------------------------------------
drop table if exists TURBINE_ROLE_PERMISSION;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID INTEGER NOT NULL,
PERMISSION_ID INTEGER NOT NULL,
PRIMARY KEY(ROLE_ID,PERMISSION_ID),
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION
(PERMISSION_ID)
);
# -----------------------------------------------------------------------
# TURBINE_USER_GROUP_ROLE
# -----------------------------------------------------------------------
drop table if exists TURBINE_USER_GROUP_ROLE;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID INTEGER NOT NULL,
GROUP_ID INTEGER NOT NULL,
ROLE_ID INTEGER NOT NULL,
PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID),
FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID)
);
# -----------------------------------------------------------------------
# JETSPEED_USER_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_USER_PROFILE;
CREATE TABLE JETSPEED_USER_PROFILE
(
PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
USER_NAME VARCHAR (32) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE BLOB,
PRIMARY KEY(PSML_ID),
UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);
# -----------------------------------------------------------------------
# JETSPEED_GROUP_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_GROUP_PROFILE;
CREATE TABLE JETSPEED_GROUP_PROFILE
(
PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
GROUP_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE BLOB,
PRIMARY KEY(PSML_ID),
UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);
# -----------------------------------------------------------------------
# JETSPEED_ROLE_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_ROLE_PROFILE;
CREATE TABLE JETSPEED_ROLE_PROFILE
(
PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
ROLE_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE BLOB,
PRIMARY KEY(PSML_ID),
UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);
# -----------------------------------------------------------------------
# COFFEES
# -----------------------------------------------------------------------
drop table if exists COFFEES;
CREATE TABLE COFFEES
(
COFFEE_ID INTEGER NOT NULL AUTO_INCREMENT,
COFFEE_NAME VARCHAR (50),
SUPPLIER_ID INTEGER,
PRICE FLOAT,
SALES INTEGER,
TOTAL INTEGER,
PRIMARY KEY(COFFEE_ID)
);
----------------------------------------------------------------------------
-
-- EMAIL
----------------------------------------------------------------------------
-
CREATE TABLE EMAIL_INBOX (
EMAIL_INBOX_ID integer(11) NOT NULL auto_increment,
MESSAGE_ID varchar(255) default NULL,
FILENAME varchar(255) default NULL,
ATTACHMENT longblob,
READFLAG int(11) default NULL,
PRIMARY KEY (EMAIL_INBOX_ID)
);
-----
populate-mysql.sql
-----
INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Jetspeed','Admin','admin@jakarta-jetspeed.com',
'CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER
VALUES(2,'turbine','turbine','Tommy','Turbine','tommy@jakarta-jetspeed.com',
'CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER
VALUES(3,'anon','anon','Anonymous','User','anon@jakarta-jetspeed.com','CONFI
RMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3);
INSERT INTO COFFEES VALUES(1,'ColombianGrade',5,7.99,1,2);
INSERT INTO COFFEES VALUES(2,'KonaGrade',6,7.99,1,2);
INSERT INTO COFFEES VALUES(3,'FrenchRoastGrade',7,7.99,1,2);
INSERT INTO COFFEES VALUES(4,'HazelNutGrade',8,7.99,1,2);
INSERT INTO COFFEES VALUES(5,'VanillaGrade',9,7.99,1,2);
INSERT INTO COFFEES VALUES(6,'JavaGrade',10,7.99,1,2);
INSERT INTO COFFEES VALUES(7,'IndonesianGrade',11,7.99,1,2);
INSERT INTO COFFEES VALUES(8,'OotyGrade',1,7.99,1,2);
INSERT INTO COFFEES VALUES(9,'KenyanGrade',2,7.99,1,2);
INSERT INTO COFFEES VALUES(10,'JoeGrade',3,7.99,1,2);
INSERT INTO COFFEES VALUES(11,'CantThinkOfAnymoreGrade',4,7.99,1,2);
-----
----- Original Message -----
From: "Maruthi"
To: "Jetspeed Users List"
Sent: Friday, June 18, 2004 12:16 PM
Subject: Hello Stijn..again problems with .sql scripts ( Re: JSP
Portlet ->Mysql ->Connection Problem)
> Hello Stijn,
>
> First of all Thanks for your reply and suggestions.As per your suggestion
i ran .sql scripts.I got some problems with IDENTITY.I think you too got the
same problem once upon a time as i saw your question regarding this one in
the mailing list.And as per Michael Muller's Suggestion in the list (see ..
http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg12369.html )
i changed IDENTITY to AUTO_INCREMENT and BINARY to BLOB.After that i am
getting these errors::
>
> Errors for turbine-mysql ::
>
> ERROR 1075: Incorrect table definition; There can only be one auto column
and it must be defined as a key
>
> Errors for Populate-mysql.sql ::
>
> ERROR 1136: Column count doesn't match value count at row 1
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
>
> I am attaching the list :::
> ==========================================================================
> Before replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in
turbine-mysql.sql
> ==========================================================================
>
> ERROR 1064: 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,
> GROUP_NAME VARCHAR (99) NOT NULL,
> OBJECTDAT
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.01 sec)
> Records: 0 Duplicates: 0 Warnings: 0
> ERROR 1064: 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,
> LOGIN_NAME VARCHAR (32) NOT NULL,
> PASSWORD_
> Query OK, 0 rows affected (0.01 sec)
> Query OK, 0 rows affected (0.02 sec)
> Records: 0 Duplicates: 0 Warnings: 0
> Query OK, 0 rows affected (0.01 sec)
> ERROR 1064: 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,
> COFFEE_NAME VARCHAR (50),
> SUPPLIER_ID integ
> Query OK, 0 rows affected (0.01 sec)
> mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.01 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
>
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ==========================================================================
> After replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in
turbine-mysql.sql
> ==========================================================================
>
> mysql> \. c:\jetspeed-1.5-src\src\sql\external\turbine-mysql.sql
>
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.01 sec)
>
> Records: 0 Duplicates: 0 Warnings: 0
>
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.03 sec)
> Records: 0 Duplicates: 0 Warnings: 0
> Query OK, 0 rows affected (0.05 sec)
>
> ERROR 1075: Incorrect table definition; There can only be one auto column
and it must be defined as a key
>
> Query OK, 0 rows affected (0.00 sec)
>
>
> mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql
>
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
>
> ERROR 1136: Column count doesn't match value count at row 1
> ERROR 1136: Column count doesn't match value count at row 1
> ERROR 1136: Column count doesn't match value count at row 1
>
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.01 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.01 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
>
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
>
> Please suggest me what to do in this regard.
> Thanks for your help,
> Maruthi.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Stijn de Witt wrote:
> Hello Maruthi,
>
> It seems that the turbine tables do not exist, as the logging shows:
"Table
> 'thesiswork.turbine_user' doesn't exist". Have you ran the .sql scripts
> needed to create and populate the turbine tables?
> Check out src/sql/external/turbine-mysql.sql and
> src/sql/external/populate-mysql.sql. Also look here:
> http://portals.apache.org/jetspeed-1/database.html
>
> Hope it helps,
> -Stijn
>
> ----- Original Message -----
> From: Maruthi
> To: jetspeed-user@jakarta.apache.org
> Sent: Thursday, June 17, 2004 7:09 PM
> Subject: JSP Portlet ->Mysql ->Connection Problem
>
>
> Hello Everybody,
>
> I want to connect to JSP portlet to mysql database.......when i deployed i
> am getting the following error.I am using mysql database and the driver is
> mysql Odbc 3.51 driver to connect to mysql from Java..My database name is
> "Thesiswork".
> _____________________________________________
>
> Error::
> _____________________________________________
>
> 17.06.2004 18:26:44 org.apache.torque.util.BasePeer initTableSchema
> SCHWERWIEGEND: java.sql.SQLException: [MySQL][ODBC 3.51
> Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist
> 17.06.2004 18:26:44
> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer initClass
> SCHWERWIEGEND: A FATAL ERROR has occurred which should not have happened
> under any circumstance. Please notify the Torque developers
> che.org> and give as many details as possible (including the error stack
> trace).
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
> [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table
> 'thesiswork.turbine_user' doesn't exist
> _______________________________________________________________________
>
> I am attaching my source code,registry file,Property files ....i tried all
> the options that i know to solve the problem ...but i couldn't.Any help in
> this regard will be greatly appreciated.
>
> Thanks a lot for your time and patience,
> Maruthi.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
=== message truncated ===
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
Re: Hello Stijn..again problems with .sql scripts ( Re: JSP Portlet ->Mysql ->Connection Problem)
Posted by Stijn de Witt <St...@bergland-it.nl>.
Hi Maruthi,
The best thing you can do probably is to get the latest version of Jetspeed
from the CVS, jetspeed-1.6-dev. That particular problem was fixed in 1.6. If
you don't want to use a development version, or if you don't have access to
CVS, here are the turbine-mysql.sql and populate-mysql.sql that are included
in 1.6. You can probably just use those.
-Stijn
P.S. I'm just pasting them in the message, so they'll also be available in
the list archives:
turbine-mysql.sql
-----
----------------------------------------------------------------------------
-
-- Copyright 2004 The Apache Software Foundation
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
----------------------------------------------------------------------------
-
# -----------------------------------------------------------------------
# TURBINE_USER
# -----------------------------------------------------------------------
drop table if exists TURBINE_USER;
CREATE TABLE TURBINE_USER
(
USER_ID INTEGER NOT NULL AUTO_INCREMENT,
LOGIN_NAME VARCHAR (32) NOT NULL,
PASSWORD_VALUE VARCHAR (32) NOT NULL,
FIRST_NAME VARCHAR (99) NOT NULL,
LAST_NAME VARCHAR (99) NOT NULL,
EMAIL VARCHAR (99),
CONFIRM_VALUE VARCHAR (99),
MODIFIED TIMESTAMP,
CREATED TIMESTAMP,
LAST_LOGIN TIMESTAMP,
DISABLED CHAR (1),
OBJECTDATA BLOB,
PASSWORD_CHANGED TIMESTAMP,
PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_ROLE
# -----------------------------------------------------------------------
drop table if exists TURBINE_ROLE;
CREATE TABLE TURBINE_ROLE
(
ROLE_ID INTEGER NOT NULL AUTO_INCREMENT,
ROLE_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BLOB,
PRIMARY KEY(ROLE_ID),
UNIQUE (ROLE_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_GROUP
# -----------------------------------------------------------------------
drop table if exists TURBINE_GROUP;
CREATE TABLE TURBINE_GROUP
(
GROUP_ID INTEGER NOT NULL AUTO_INCREMENT,
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BLOB,
PRIMARY KEY(GROUP_ID),
UNIQUE (GROUP_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_PERMISSION
# -----------------------------------------------------------------------
drop table if exists TURBINE_PERMISSION;
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID INTEGER NOT NULL AUTO_INCREMENT,
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BLOB,
PRIMARY KEY(PERMISSION_ID),
UNIQUE (PERMISSION_NAME)
);
# -----------------------------------------------------------------------
# TURBINE_ROLE_PERMISSION
# -----------------------------------------------------------------------
drop table if exists TURBINE_ROLE_PERMISSION;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID INTEGER NOT NULL,
PERMISSION_ID INTEGER NOT NULL,
PRIMARY KEY(ROLE_ID,PERMISSION_ID),
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION
(PERMISSION_ID)
);
# -----------------------------------------------------------------------
# TURBINE_USER_GROUP_ROLE
# -----------------------------------------------------------------------
drop table if exists TURBINE_USER_GROUP_ROLE;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID INTEGER NOT NULL,
GROUP_ID INTEGER NOT NULL,
ROLE_ID INTEGER NOT NULL,
PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID),
FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID)
);
# -----------------------------------------------------------------------
# JETSPEED_USER_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_USER_PROFILE;
CREATE TABLE JETSPEED_USER_PROFILE
(
PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
USER_NAME VARCHAR (32) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE BLOB,
PRIMARY KEY(PSML_ID),
UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);
# -----------------------------------------------------------------------
# JETSPEED_GROUP_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_GROUP_PROFILE;
CREATE TABLE JETSPEED_GROUP_PROFILE
(
PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
GROUP_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE BLOB,
PRIMARY KEY(PSML_ID),
UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);
# -----------------------------------------------------------------------
# JETSPEED_ROLE_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_ROLE_PROFILE;
CREATE TABLE JETSPEED_ROLE_PROFILE
(
PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
ROLE_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE BLOB,
PRIMARY KEY(PSML_ID),
UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);
# -----------------------------------------------------------------------
# COFFEES
# -----------------------------------------------------------------------
drop table if exists COFFEES;
CREATE TABLE COFFEES
(
COFFEE_ID INTEGER NOT NULL AUTO_INCREMENT,
COFFEE_NAME VARCHAR (50),
SUPPLIER_ID INTEGER,
PRICE FLOAT,
SALES INTEGER,
TOTAL INTEGER,
PRIMARY KEY(COFFEE_ID)
);
----------------------------------------------------------------------------
-
-- EMAIL
----------------------------------------------------------------------------
-
CREATE TABLE EMAIL_INBOX (
EMAIL_INBOX_ID integer(11) NOT NULL auto_increment,
MESSAGE_ID varchar(255) default NULL,
FILENAME varchar(255) default NULL,
ATTACHMENT longblob,
READFLAG int(11) default NULL,
PRIMARY KEY (EMAIL_INBOX_ID)
);
-----
populate-mysql.sql
-----
INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Jetspeed','Admin','admin@jakarta-jetspeed.com',
'CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER
VALUES(2,'turbine','turbine','Tommy','Turbine','tommy@jakarta-jetspeed.com',
'CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER
VALUES(3,'anon','anon','Anonymous','User','anon@jakarta-jetspeed.com','CONFI
RMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3);
INSERT INTO COFFEES VALUES(1,'ColombianGrade',5,7.99,1,2);
INSERT INTO COFFEES VALUES(2,'KonaGrade',6,7.99,1,2);
INSERT INTO COFFEES VALUES(3,'FrenchRoastGrade',7,7.99,1,2);
INSERT INTO COFFEES VALUES(4,'HazelNutGrade',8,7.99,1,2);
INSERT INTO COFFEES VALUES(5,'VanillaGrade',9,7.99,1,2);
INSERT INTO COFFEES VALUES(6,'JavaGrade',10,7.99,1,2);
INSERT INTO COFFEES VALUES(7,'IndonesianGrade',11,7.99,1,2);
INSERT INTO COFFEES VALUES(8,'OotyGrade',1,7.99,1,2);
INSERT INTO COFFEES VALUES(9,'KenyanGrade',2,7.99,1,2);
INSERT INTO COFFEES VALUES(10,'JoeGrade',3,7.99,1,2);
INSERT INTO COFFEES VALUES(11,'CantThinkOfAnymoreGrade',4,7.99,1,2);
-----
----- Original Message -----
From: "Maruthi" <ma...@yahoo.com>
To: "Jetspeed Users List" <je...@jakarta.apache.org>
Sent: Friday, June 18, 2004 12:16 PM
Subject: Hello Stijn..again problems with .sql scripts ( Re: JSP
Portlet ->Mysql ->Connection Problem)
> Hello Stijn,
>
> First of all Thanks for your reply and suggestions.As per your suggestion
i ran .sql scripts.I got some problems with IDENTITY.I think you too got the
same problem once upon a time as i saw your question regarding this one in
the mailing list.And as per Michael Muller's Suggestion in the list (see ..
http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg12369.html )
i changed IDENTITY to AUTO_INCREMENT and BINARY to BLOB.After that i am
getting these errors::
>
> Errors for turbine-mysql ::
>
> ERROR 1075: Incorrect table definition; There can only be one auto column
and it must be defined as a key
>
> Errors for Populate-mysql.sql ::
>
> ERROR 1136: Column count doesn't match value count at row 1
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
>
> I am attaching the list :::
> ==========================================================================
> Before replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in
turbine-mysql.sql
> ==========================================================================
>
> ERROR 1064: 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,
> GROUP_NAME VARCHAR (99) NOT NULL,
> OBJECTDAT
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.01 sec)
> Records: 0 Duplicates: 0 Warnings: 0
> ERROR 1064: 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,
> LOGIN_NAME VARCHAR (32) NOT NULL,
> PASSWORD_
> Query OK, 0 rows affected (0.01 sec)
> Query OK, 0 rows affected (0.02 sec)
> Records: 0 Duplicates: 0 Warnings: 0
> Query OK, 0 rows affected (0.01 sec)
> ERROR 1064: 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,
> COFFEE_NAME VARCHAR (50),
> SUPPLIER_ID integ
> Query OK, 0 rows affected (0.01 sec)
> mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_permission' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_role' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_group' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
> ERROR 1146: Table 'jetspeed.turbine_user' doesn't exist
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.01 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
>
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ==========================================================================
> After replacing IDENTITY by AUTO_INCREMENT and BINARY by BLOB in
turbine-mysql.sql
> ==========================================================================
>
> mysql> \. c:\jetspeed-1.5-src\src\sql\external\turbine-mysql.sql
>
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.01 sec)
>
> Records: 0 Duplicates: 0 Warnings: 0
>
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.00 sec)
> Query OK, 0 rows affected (0.03 sec)
> Records: 0 Duplicates: 0 Warnings: 0
> Query OK, 0 rows affected (0.05 sec)
>
> ERROR 1075: Incorrect table definition; There can only be one auto column
and it must be defined as a key
>
> Query OK, 0 rows affected (0.00 sec)
>
>
> mysql> \. c:\jetspeed-1.5-src\src\sql\external\populate-mysql.sql
>
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
>
> ERROR 1136: Column count doesn't match value count at row 1
> ERROR 1136: Column count doesn't match value count at row 1
> ERROR 1136: Column count doesn't match value count at row 1
>
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.01 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.01 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
> Query OK, 1 row affected (0.00 sec)
>
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
> ERROR 1146: Table 'jetspeed.coffees' doesn't exist
>
> Please suggest me what to do in this regard.
> Thanks for your help,
> Maruthi.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Stijn de Witt <St...@bergland-it.nl> wrote:
> Hello Maruthi,
>
> It seems that the turbine tables do not exist, as the logging shows:
"Table
> 'thesiswork.turbine_user' doesn't exist". Have you ran the .sql scripts
> needed to create and populate the turbine tables?
> Check out src/sql/external/turbine-mysql.sql and
> src/sql/external/populate-mysql.sql. Also look here:
> http://portals.apache.org/jetspeed-1/database.html
>
> Hope it helps,
> -Stijn
>
> ----- Original Message -----
> From: Maruthi
> To: jetspeed-user@jakarta.apache.org
> Sent: Thursday, June 17, 2004 7:09 PM
> Subject: JSP Portlet ->Mysql ->Connection Problem
>
>
> Hello Everybody,
>
> I want to connect to JSP portlet to mysql database.......when i deployed i
> am getting the following error.I am using mysql database and the driver is
> mysql Odbc 3.51 driver to connect to mysql from Java..My database name is
> "Thesiswork".
> _____________________________________________
>
> Error::
> _____________________________________________
>
> 17.06.2004 18:26:44 org.apache.torque.util.BasePeer initTableSchema
> SCHWERWIEGEND: java.sql.SQLException: [MySQL][ODBC 3.51
> Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist
> 17.06.2004 18:26:44
> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer initClass
> SCHWERWIEGEND: A FATAL ERROR has occurred which should not have happened
> under any circumstance. Please notify the Torque developers
> che.org> and give as many details as possible (including the error stack
> trace).
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
> [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table
> 'thesiswork.turbine_user' doesn't exist
> _______________________________________________________________________
>
> I am attaching my source code,registry file,Property files ....i tried all
> the options that i know to solve the problem ...but i couldn't.Any help in
> this regard will be greatly appreciated.
>
> Thanks a lot for your time and patience,
> Maruthi.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org