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