Make your own free website on Tripod.com

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Not finding my tables?


I think there may be a problem with Instant DB.  Becuase everything I do
seems to be consistent to what everyone seems to be recommending.  Again the
test I'm using to see if the database can be found is using SQLBuilder.  And
even SQL Builder fails.  Again it fails when i try to load the database from
a different directory but if I try to load it from the same directory it
loads ok ( I have a batch file that loads SQL Builder ).  I really think
that its a path issue.  If I use browse to find the prp it creates a
absolute path for the url and when I connect it succeeds, but when I try to
view the tables none of the once I create show up.  But if I ran the SQL
Builder at the same path as the where the prp files are then it connects
showing my tables.  I'm not even going to worry about the web app b/c if SQL
Builder fails then i dont even see going a step further until I figure it
out here.

I run the batch file to run SQL Builder in my c:\java\utils\SQLBuilder.bat

My batch file to load SQL Builder:

@echo off

set ProjectPath=c:\java\jar
set JarPath=c:\java\jar
set JarFiles=%JarPath%\idb.jar;%JarPath%\SQLBuilder.jar;
set Output=

set Classpath=.;%JarFiles%%ProjectPath%

@echo on
java -classpath %Classpath% SQLBuilder

@echo off


I just realized that when I run this and locate the prp file using the
browse option gives me the following url string:
jdbc:idb:C:\Projects\SupportCentral\Database\SupportCentral.prp

I seems to connect but not showing my tables,  But what i noticed is that if
I started the batch file in the same directory as
the prp file it stills gives me the same url string as
jdbc:idb:C:\Projects\SupportCentral\Database\SupportCentral.prp

but finds my tables.  So when SQL Builder loads the database it does create
the
$*.tbl's.  So if I start the SQL Builder from my utils directory it creates
the $*.tbl's there but when I run SQL Builder in the same directory it
creates the $*.tbl's there and shows my tables.

So could it be that the $*.tbl's are being created in the wrong directory.
Is there a setting that I can set so that it points to an absoulte path for
the files $*.tbl's?


Thanks


----- Original Message -----
From: "Peter Hearty" <peter.hearty@lutris.com>
To: <instantDB@enhydra.org>
Sent: Friday, September 15, 2000 8:43 AM
Subject: Re: InstantDB: Not finding my tables?


> Eric
>
> If you're using an absolute URL in all cases to access your database, as
you
> seem to be saying, then I don;t really understand what could be going
wrong.
> However, if you're using something like: jdbc:idb:SupportCentral.prp, i.e.
a
> relative URL, then you could be creating multiple copies of the database
in
> different locations.
>
> Regards
>
> Peter Hearty
> Lutris Technologies UK Ltd.
> -----Original Message-----
> From: Eric Advincula <eric07@earthlink.net>
> To: instantDB@enhydra.org <instantDB@enhydra.org>
> Date: 27 July 2000 14:45
> Subject: Re: InstantDB: Not finding my tables?
>
>
> >What I noticed thought is if I use my batch file to load the SQL Builder
is
> >in the same directory as the prp it loads and shows my tables
> >but if I put the batch file in another directory and run it from there it
> >still loads the database but is missing my tables.
> >
> >batch file to load SQLBuilder.bat:
> >
> >@echo off
> >
> >set ProjectPath=c:\Projects\SupportCentral\database
> >set JarPath=c:\java\jar
> >set JarFiles=%JarPath%\idb.jar;%JarPath%\SQLBuilder.jar;
> >set Output=c:\projects\supportcentral\database
> >
> >set Classpath=.;%JarFiles%%ProjectPath%
> >
> >@echo on
> >java -classpath %Classpath% SQLBuilder
> >
> >@echo off
> >
> >so i believe its really a path issue.
> >
> >Any ideas on this?
> >
>
>---------------------------------------------------------------------------
> --
> >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.