Thanks dave,
I found the DB tables name in the DatabaseMapBuilder.java file.
So I rebuilt DB and I cound succeed to connect InstantDB just one time.
Only one time Turbine connect DB and record a log file and then currupted !!
(So acutally I failed to see the Welcome Screen of the Turbine)
And whenever Turbine init , the following error message occured.
" SIGSEGV received at be5ff734 in unknown. Processing terminated "
" Writing stack trace to javacore***.txt ... OK "
Still I can connect InstantDB(another tables) using another Servlet in
TOMCAT.
I am not sure it becomes from Turbine and related packages ( ecs , village .
...)
if you interests this javacore.txt report file , I will send it.
if you know which module report this error message , please let me know .
Thanks,
youngho
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dave
Sent: Wednesday, February 02, 2000 10:24 AM
To: Turbine
Subject: Re: Turbine with InstantDB
This is just a guess, but try changing the case on your tables.
in other words, change Visitor to visitor. Another quick check world be
to run the InstantDB command line sql utility to see if you can actually
see
the tables with InstantDB.
dave
Youngho Cho wrote:
>
> Hi,
>
> First of all , Let me apolozise my previous mail.
>
> I found the DB structure in the docs directory.
>
> So I could generate the Tables using SQL command.
> But Still I couldn't get a data from table yet.
> The system report 2 error message when I tried to send submit button at
the
> Turbine Login page.
>
> One is a log file message from InstantDB
>
> Thread-9 SELECT * FROM Visitor WHERE 1 = -10
> Thread-9 java.sql.SQLException: Table not found: Visitor
>
> It looks likes the Turbine coundn't touch the Table directory of the DB.
> I suspect my previous TurbineResources.properties setting about InstantDB
> url, database.default.url = etc/InstantDB.prp .
>
> And other one is javacore***.txt file
> ( I am not sure it is generated by TOMCAT or Turbine )
>
> If you have some experience with Turbine and InstantDB , and if you know
> what the problem is I need your help.
>
> Thanks .
>
> youngho
>
> Here is SQL command when I used with InstantDB
> ---------------------------------------------
> ; First load the JDBC driver and open a database.
>
> d jdbc.idbDriver;
> o jdbc:idb=turbine.prp;
>
> ; Record all results
> e SET EXPORT 'trace.log' FIXEDLENGTH COLNAMEHEADER ROWNUMBERS CONTROLCOL
> SUMMARYHEADER TRACE 2 CONSOLE;
>
> e DROP TABLE PERMISSION;
> e CREATE TABLE PERMISSION (
> PERMISSIONID INT AUTO INCREMENT PRIMARY KEY,
> PERMISSION CHAR(99) UNIQUE NOT NULL );
>
> e DROP TABLE USERROLE;
>
> e CREATE TABLE USERROLE (
> ROLEID INT AUTO INCREMENT PRIMARY KEY,
> ROLENAME CHAR(99) UNIQUE NOT NULL
> );
>
> e DROP TABLE ROLEPERMISSION;
>
> e CREATE TABLE ROLEPERMISSION (
> ROLEID INT PRIMARY KEY NOT NULL,
> PERMISSIONID INT PRIMARY KEY NOT NULL
> );
>
> e CREATE INDEX roleID_permissionID_index ON ROLEPERMISSION ( ROLEID,
> PERMISSIONID );
>
> e DROP TABLE Visitor;
>
> e CREATE TABLE Visitor (
> VISITORID INT AUTO INCREMENT PRIMARY KEY,
> LOGINID CHAR(32) NOT NULL UNIQUE,
> PASSWORD_VALUE CHAR(32),
> FIRST_NAME CHAR(99) NOT NULL,
> LAST_NAME CHAR(99) NOT NULL,
> ADDRESS1 CHAR(255),
> ADDRESS2 CHAR(255),
> CITY CHAR(255),
> STATE CHAR(32),
> POSTALCODE CHAR(32),
> COUNTRY CHAR(99),
> CITIZENSHIP CHAR(32),
> PHONE CHAR(32),
> ALTPHONE CHAR(32),
> FAX CHAR(32),
> CELL CHAR(32),
> PAGER CHAR(32),
> EMAIL CHAR(99),
> MODIFIED DATE,
> CREATED DATE,
> LASTLOGIN DATE,
> OBJECTDATA BINARY
> );
>
> e insert into Visitor (LOGINID, PASSWORD_VALUE, MODIFIED, CREATED ,
> FIRST_NAME , LAST_NAME ) values ('turbine', 'turbine', null, null ,
> 'turbine' , 'turbine');
>
> e DROP TABLE VISITORROLE;
>
> e CREATE TABLE VISITORROLE (
> VISITORID INT NOT NULL PRIMARY KEY,
> ROLEID INT NOT NULL PRIMARY KEY
> );
>
> e CREATE INDEX visitorID_roleID_index ON VISITORROLE ( VISITORID,
ROLEID );
>
> q SELECT * FROM Visitor;
>
> c close;
> -------------------------------------
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
