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]
