InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Thanks to Peter and Merci for repsonding!

This is what I did, because it made most sense to me (which doesn't mean
much ;-):

   if (curLine == null) continue;
   curLine = curLine.trim();
   if (curLine.length()==0) continue;

The script now finishes (Hurrah!) but I get an error at the end:

==============
C:\Devel\java\tomcat\webapps\jive\WEB-INF\database>java -cp
.;idb.jar;jta.jar org.enhydra.instantdb.ScriptTool Jive_instant_DB.sql
Enhydra InstantDB - Version 3.26
The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2001 Lutris Technologies,
Inc.
All Rights Reserved.

Connected to
jdbc:idb:c:\\devel\\java\\tomcat\\webapps\\jive\\WEB-INF\\database\\Jive_ins
tant_db.properties
Driver   InstantDB JDBC Driver
Version  Version 3.26

Jive_instant_DB.sql CREATE TABLE jiveFilter ( filterObject   BINARY, forumID
INT  NOT NULL, filterIndex    INT  NOT NULL, PRIMARY KEY
(forumID,filterIndex) )
Jive_instant_DB.sql CREATE INDEX filterIndexIdx ON jiveFilter ( filterIndex
ASC )
Jive_instant_DB.sql CREATE TABLE jiveForum ( forumID        INT  NOT NULL,
name           VARCHAR(255), description    VARCHAR(2000), modifiedDate
VARCHAR(15), creationDate   VARCHAR(15), moderated      INT  NOT NULL,
PRIMARY KEY (forumID
) )
Jive_instant_DB.sql CREATE TABLE jiveForumProp ( forumID     INT  NOT NULL,
name        VARCHAR(30) NOT NULL, propValue   VARCHAR(255) NOT NULL, PRIMARY
KEY (forumID,name) )
Jive_instant_DB.sql CREATE TABLE jiveGroup ( groupID       INT  NOT NULL,
name          VARCHAR(50) NOT NULL, description   VARCHAR(255), PRIMARY KEY
(groupID) )
Jive_instant_DB.sql CREATE TABLE jiveGroupPerm ( forumID       INT  NOT
NULL, groupID       INT  NOT NULL, permission    INT  NOT NULL, PRIMARY KEY
(forumID,groupID,permission) )
Jive_instant_DB.sql CREATE INDEX groupGroupIdx ON jiveGroupPerm ( groupID
ASC )
Jive_instant_DB.sql CREATE TABLE jiveGroupUser ( groupID          INT  NOT
NULL, userID           INT  NOT NULL, administrator    INT  NOT NULL,
PRIMARY KEY (groupID,userID) )
Jive_instant_DB.sql CREATE INDEX groupIdx ON jiveGroupUser ( userID
    ASC )
Jive_instant_DB.sql CREATE TABLE jiveMessage ( messageID          INT NOT
NULL, threadID         INT DEFAULT 0, subject            VARCHAR(255),
userID             INT  NOT NULL, body               LONGCHAR, modifiedDate
VARCHAR(15),
creationDate       VARCHAR(15), approved           INT  NOT NULL, PRIMARY
KEY           (messageID) )
Jive_instant_DB.sql CREATE INDEX messageApprovedIdx ON jiveMessage (
approved    ASC )
Jive_instant_DB.sql CREATE INDEX messageThreadIDIdx ON jiveMessage (
threadID    ASC )
Jive_instant_DB.sql CREATE TABLE jiveMessageTree ( parentID     INT  NOT
NULL, childID      INT  NOT NULL, PRIMARY KEY (parentID,childID) )
Jive_instant_DB.sql CREATE INDEX childIdx ON jiveMessageTree ( childID
ASC )
Jive_instant_DB.sql CREATE TABLE jiveMessageProp ( messageID     INT  NOT
NULL, name          VARCHAR(50) NOT NULL, propValue     VARCHAR(255) NOT
NULL, PRIMARY KEY (messageID,name) )
Jive_instant_DB.sql CREATE TABLE jiveThread ( threadID            INT  NOT
NULL, forumID             INT, rootMessageID       INT  NOT NULL,
creationDate        VARCHAR(15), modifiedDate        VARCHAR(15), approved
INT  NOT NULL
, PRIMARY KEY (threadID) )
Jive_instant_DB.sql CREATE TABLE jiveUser ( userID               INT  NOT
NULL, name                 VARCHAR(50), username             VARCHAR(30) NOT
NULL, passwordHash         VARCHAR(32) NOT NULL, email
VARCHAR(30) NOT NUL
L, emailVisible         INT  NOT NULL, nameVisible          INT  NOT NULL,
PRIMARY KEY (userID) )
Jive_instant_DB.sql CREATE TABLE jiveUserPerm ( forumID          INT  NOT
NULL, userID           INT  NOT NULL, permission       INT  NOT NULL,
PRIMARY KEY (forumID,userID,permission) )
Jive_instant_DB.sql CREATE INDEX userUserIdx ON jiveUserPerm ( userID
   ASC )
Jive_instant_DB.sql CREATE TABLE jiveUserProp ( userID      INT  NOT NULL,
name        VARCHAR(30) NOT NULL, propValue   VARCHAR(255) NOT NULL, PRIMARY
KEY (userID,name) )
Database Jive_instant_db is shutting down...
Database Jive_instant_db shutdown complete.
java.lang.NullPointerException
        at org.enhydra.instantdb.SampleThread.getSQL(ScriptTool.java:187)
        at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:267)
        at java.lang.Thread.run(Unknown Source)
==============


Line 187 corresponds to the first line above. Any ideas?


TIA

Marcel






















> -----Oorspronkelijk bericht-----
> Van: owner-instantDB@enhydra.org
> [mailto:owner-instantDB@enhydra.org]Namens Peter Hearty
> Verzonden: maandag 5 maart 2001 18:34
> Aan: instantDB@enhydra.org
> Onderwerp: Re: InstantDB: Bug in InstantDB 3.26 (that wasn't there in
> 3.25)
>
>
> Marcel
>
> Switch the two lines 186,187 in ScriptTool.java from:
>
> 	if (curLine == null) continue;
> 	curLine = curLine.trim();
>
> to:
>
> 	curLine = curLine.trim();
> 	if (curLine == null) continue;
>
> Regards
>
> Pete
> ----- Original Message -----
> From: Marcel Mari <mjmare@webtothemax.com>
> Date: Monday, March 5, 2001 4:49 pm
> Subject: InstantDB: Bug in InstantDB 3.26 (that wasn't there in 3.25)
>
> > I've run into a problem with 3.26.
> >
> > I want to use InstantDB as the database for Jive (als extremely cool
> > open-source project). They provide a ScriptTool script to create
> > all the
> > tables. This works flawlessly with v3.25. With 3.26 I get this error:
> >
> >
> > =====================
> > C:\Devel\java\tomcat\webapps\jive\WEB-INF\database>java
> > org.enhydra.instantdb.ScriptTool Jive_instant_db.sql
> > Enhydra InstantDB - Version 3.26
> > The Initial Developer of the Original Code is Lutris Technologies Inc.
> > Portions created by Lutris are Copyright (C) 1997-2001 Lutris
> > Technologies,Inc.
> > All Rights Reserved.
> >
> > Connected to
> > jdbc:idb:c:\\devel\\java\\tomcat\\webapps\\jive\\WEB-
> > INF\\database\\Jive_instant_db.properties
> > Driver   InstantDB JDBC Driver
> > Version  Version 3.26
> >
> > Jive_instant_db.sql CREATE TABLE jiveFilter ( filterObject
> > BINARY, forumID
> > INT  NOT NULL, filterIndex    INT  NOT NULL, PRIMARY KEY
> > (forumID,filterIndex) )
> > Jive_instant_db.sql CREATE INDEX filterIndexIdx ON jiveFilter (
> > filterIndexASC )
> > Jive_instant_db.sql CREATE TABLE jiveForum ( forumID        INT
> > NOT NULL,
> > name           VARCHAR(255), description    VARCHAR(2000),
> > modifiedDateVARCHAR(15), creationDate   VARCHAR(15), moderated
> > INT  NOT NULL,
> > PRIMARY KEY (forumID
> > ) )
> > Jive_instant_db.sql CREATE TABLE jiveForumProp ( forumID     INT
> > NOT NULL,
> > name        VARCHAR(30) NOT NULL, propValue   VARCHAR(255) NOT
> > NULL, PRIMARY
> > KEY (forumID,name) )
> > Jive_instant_db.sql CREATE TABLE jiveGroup ( groupID       INT
> > NOT NULL,
> > name          VARCHAR(50) NOT NULL, description   VARCHAR(255),
> > PRIMARY KEY
> > (groupID) )
> > Jive_instant_db.sql CREATE TABLE jiveGroupPerm ( forumID       INT
> > NOT
> > NULL, groupID       INT  NOT NULL, permission    INT  NOT NULL,
> > PRIMARY KEY
> > (forumID,groupID,permission) )
> > Jive_instant_db.sql CREATE INDEX groupGroupIdx ON jiveGroupPerm (
> > groupIDASC )
> > Jive_instant_db.sql CREATE TABLE jiveGroupUser ( groupID
> > INT  NOT
> > NULL, userID           INT  NOT NULL, administrator    INT  NOT NULL,
> > PRIMARY KEY (groupID,userID) )
> > Jive_instant_db.sql CREATE INDEX groupIdx ON jiveGroupUser ( userID
> >    ASC )
> > java.lang.StringIndexOutOfBoundsException: String index out of
> > range: 0
> >        at java.lang.String.charAt(Unknown Source)
> >        at
> > org.enhydra.instantdb.SampleThread.getSQL(ScriptTool.java:189)
> >   at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:265)
> >        at java.lang.Thread.run(Unknown Source)
> >
> >
> > ========================
> >
> > Any ideas someone?
> >
> > TIA
> >
> > Marcel
> >
> > -------------------------------------------------------------------
> > ----------
> > To unsubscribe from this mailing list, send email to
> > majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the
> > body of the email.
> > If you have other questions regarding this mailing list, send
> > email to
> > the list admin at owner-instantdb@enhydra.org.
> >
>
> ------------------------------------------------------------------
> -----------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.