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

I was able to run your sql and view results. I replaced the example sql.txt
file with your geo file and modified the paths in the SQL files for my
system. I then ran the sample.java app and it created the database and
tables just fine with the exception of Shapes.sql which used a reserved
word"width".

I was then able to view tables using the JDBCmain application.

I did all this on NT using jdk 1.2.2.

Double check the files paths you are using to make sure they are correct.
You also might try recompiling the instantDB example java apps. You can't be
too far off track since I could get it to work on my system.

Hope this helps.

----- Original Message -----
From: "CHARRON, Myriam (Kanata)" <MCHARRON@MDS.Nordion.com>
To: "'instantDB@Enhydra.ORG'" <instantDB@enhydra.org>
Sent: Tuesday, June 27, 2000 11:57 AM
Subject: RE: InstantDB: Building a DB -


> Good morning Jason,
>
> >We need more information to figure out what the problem is.
> >What version of Java are you running?
>
> I am running JDK1.2.2
>
> >What changes did you make the the sample sql files? (Please attach)
>
> sample calls sql1.txt which in turns runs (calls) customer.sql
> see files attached
> the sql1.txt is geo.txt (I made the change in the file sample and replaced
> it) and within that file I call Shapes.sql instead of customer.sql
>
> >You must be getting some sort of error? is their no messages at all?
>
> No really I don't when I compile it...nothing! I get the prompt back.
(that
> is in cygwin) I also tried in Forte for Java which I have set up on my
> machine as well...no luck but after I run it I get an error on 2 classes:
> TestObject and SampleThread.
>
> >How do you know its not creating a thread?
>
> Well I came to that conclusion because the thread is running the sql code
> (or executing) but it doesn't get executed.  When I ran sample it showed
me
> everything it did (sqlstatement ...) on the screen. this time nothing
> happens!
>
> >When you say the are using it from cygwin, do you mean a bash cmd promt?
If
> >so have you tried it from a DOS CMD prompt?
>
> Well I had not tried it but I just did and the same thing happens. It
brings
> me back to promt and no sql execution!! also if I go check the folders
> (tables...) they are intact! Nothing has been created.
>
> >Hey what OS are your trying it
> >on anyways?
>
> Hey I am trying it on Windslow's NT!!! Hey are you a canadian??!!!
hahahaha
>
> I was under the impression that I could use the sample.java to create my
own
> environment! It just doesn't seem to want to work but it should! I also
> tried to cheat and modify the database "mydb.prp" that came with it by
> adding tables and deleting others...! but no luck there either!
>
>
> Hopefully it is a little more clear and you can give me a few tips,
>
> Thank you kindly for your time and effort,
>
> Myriam
>
> ----- Original Message -----
> From: "CHARRON, Myriam (Kanata)" <MCHARRON@MDS.Nordion.com>
> To: "'instantDB@Enhydra.ORG'" <instantDB@enhydra.org>
> Sent: Monday, June 26, 2000 8:33 AM
> Subject: RE: InstantDB: Building a DB
>
>
> > Hello Alok,
> >
> > I am still trying to make things happen here!  I am using cygwin so I
> don't
> > have the problem of running things together because it simply won't let
> me.
> > I gave up on commsql and I am desperatly trying to run sample.java with
a
> > modified sql1.txt file and also a modified customer.sql
> >
> > Now when I run sample I don't get an error but nothing happens...like it
> > can't find the file??? the thread won't start and it won't execute the
sql
> > stuff that would create my db.
> >
> > so if you have a suggestion on how to create a new instant database let
me
> > know!!
> >
> > friendly,
> >
> > Myriam D. Charron
> > MDS Nordion
> > Computer Products Group
> > Kanata, Ontario
> > phone: 613-592-3400 ext. 2705
> > fax: 613-592-6559
> > -----Original Message-----
> > From: Alok Daipuria [mailto:alok@yack.com]
> > Sent: Friday, June 23, 2000 11:37 AM
> > To: instantDB@enhydra.org
> > Subject: Re: InstantDB: Building a DB
> >
> >
> > hi Myriam,
> > You can run only one thing at a time. If you are running commsql &
> > creating your DB & then try to view thru JDBCmain, you might not see the
> > tables. Exit from commsql & then open JDBCmain. You'll find the tables.
> > You can access the DB only thru one application at a time. To verify
> > wether the tables are created, you can go to the dir where
> > your_db_app.prp file is kept.  It'll have a dir "tables" which will have
> > a file by the table name you create if table creation is succesful.
> >  see if it helps
> >
> > -alok
> > alok@yack.com
> >
> > "CHARRON, Myriam (Kanata)" wrote:
> > >
> > > Hello there,
> > >
> > > I am currently working on a layer project which talks to instantdb.  I
> am
> > > not familiar with it and I need to create my own database.  Should I
be
> > > running the example with my own .txt and .sql files (modifying the run
> > > script) or is there a tool or a better way to talk to instantdb???  I
am
> > > looking for some sort of application that would accept sql commands
and
> > let
> > > me create my database.  So far I have tried commsql and running sample
> but
> > > with no luck.  Commsql It takes all the statements but when I go into
> > > JDBCmain to view it nothing is there??? The sample application worked
> when
> > I
> > > ran it as it is, but after modifying it and attempting to run my own
> > script
> > > it doesn't seem to work!!  I don't know what I am doing wrong? But I
> need
> > to
> > > create one, any ways will do!
> > >
> > > thanks for your help
> > >
> > > Myriam D. Charron
> > > MDS Nordion
> > > Computer Products Group
> > > Kanata, Ontario
> > > phone: 613-592-3400 ext. 2705
> > > fax: 613-592-6559
> > >
> > >
>
> --------------------------------------------------------------------------
> --
> > -
> > > 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.
>
> --------------------------------------------------------------------------
> ---
> > 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.
>
>

-----------------------------------------------------------------------------
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.