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: Newbie Q: name of driver et al


howdy!

i'm getting this mail from you, and don't know why!

could you please check it out!?

thanks!
Luis Burnay

martin.husted@notes.electrolux.dk wrote:
> 
> 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
> ----------------------------------