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

Hey Dan,
Hope this will help:


1) Yes

3) Here is a small test program of mine:

import java.sql.*;
import jdbc.idbDriver;

public class testInstantDB{

  static Connection con;

  public testInstantDB2_32() throws Exception{

    idbDriver idb1=new idbDriver();
    Class.forName ("jdbc.idbDriver");                   // InstantDB
    String dsn = "jdbc:idb:boss.prp";                          // InstantDB  prp
 file

    con = DriverManager.getConnection(dsn);
    con.setAutoCommit(false);

    Statement stmt;
    ResultSet rs;

    stmt = con.createStatement();

    stmt.execute("drop table datetest");

    stmt.execute("create table datetest (data0 integer,data1 integer, data2
integer)");

    stmt.execute("insert into datetest values (0,1,2)");

    rs = stmt.executeQuery("select * from datetest");

    while (rs.next()){
      System.out.println("data0:"+rs.getString(1)+" data1:"+rs.getString(2)+"
data2:"+rs.getString(3));
    }


    rs.close();
    stmt.close();
    con.commit();
    con.close();
  }

  public static void main(String[] args){
    try{
      testInstantDB2_32 test= new testInstantDB2_32();
    }
    catch (Exception e){
      e.printStackTrace();
    }
  }
}



Martin







Dan Johnsson <dan.johnsson@frobozz.se> on 12-10-99 23:19:11

To:   instantdb@smartcard.co.uk
cc:
Subject:  Newbie Q: name of driver et al





Here comes some questions that probably are trivial (but not in the FAQ),
but I am on a heavy deadline and haven't got the time to wait. Please
forgive me for not having the time to "listen in" carefully before posting.

Just to check that I have got it right:

1) There is no ordinary "server process" in Instant DB. The JVM that opens
a connection to will do the job; and when it closes down all the data will
be written to the file system. So between uses of the database, the
database exsists fully on the file system. Right?

2) Databases are identified by their property file, and it is the property
file you give in the url when creating a connection. Right?

3) How does the DriverManager get my driver? Usually you force loading of
the driver with Class.forName(driverClassNameString). What is the name of
the Driver-class in InstantDB?

Thanks a lot in advance to whoever answers my questions!

        Dan Johnsson



----------------------------------
Dan Johnsson, Java Head Teacher
Frobozz AB;   Sweden

E-Mail: Dan Johnsson <dan.johnsson@frobozz.se>
Date: 13-Oct-99       Time: 00:03:27
----------------------------------