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/[EMAIL
PROTECTED]/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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
