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]
