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

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.

; First load the JDBC driver and open a database.
d jdbc.idbDriver;
; @MDC
o jdbc:idb=c:\\Home\\code\\Cobra\\uk\\co\\kimble\\Geometry\\geo.prp;

; Record all results
; @MDC
e SET EXPORT "c:\\Home\\code\\Cobra\\uk\\co\\kimble\\Geometry\\export0.txt" FIXEDLENGTH COLNAMEHEADER ROWNUMBERS CONTROLCOL SUMMARYHEADER;

; Create the table and its index
e DROP TABLE databases;
e DROP TABLE data_dictionary;
e DROP TABLE class_dictionary;

e CREATE TABLE databases (
	database	char(20)	PRIMARY KEY,
	driver		varchar(100),
	locator		varchar(100),
	username	char(8),
	passwd		char(8),
	connections	integer,
	vendor		char(20)
);

e CREATE TABLE data_dictionary (
	class_name	char(128)	PRIMARY KEY,
	database	char(10),
	table_name	char(40)
);

e CREATE TABLE class_dictionary (
	table_name	char(40),
	class_attribute varchar(64),
	table_column	varchar(64),
	is_primary	char(1)
);

;
t c:\\Home\\code\\Cobra\\uk\\co\\kimble\\Geometry\\Shapes.sql;

c close;

Shapes.sql