> Hello,
> I am working on a homebrew DBMS and need to prepare both a type 3 and
> type 4 driver on my own. I check the tutorial on JavaWorld on type 3
> driver design but lack information on that of type 4. Any one can
> suggest valuable tips? Thank you!
You haven't provided enough details to give anything more than a general answer.
You can do a type 4 JDBC driver if: 1) your DBMS provides a sufficient (lower-level)
Java API, or 2) your DBMS provides a standard I/O interface at a level supported by
Java, for instance, TCP/IP. Otherwise, you won't be able to write a Type 4 driver.
If you are asking for another type of information, please provide more details.

Signature
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
Sam Hwang - 15 May 2005 02:09 GMT
Hello,
I check back the documentation on
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/intro.html#1008589,
and have no idea what the DBMS-proprietary protocol is, how can I
implement my own protocol?
David Harper - 15 May 2005 07:22 GMT
> Hello,
> I check back the documentation on
> http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/intro.html#1008589,
> and have no idea what the DBMS-proprietary protocol is, how can I
> implement my own protocol?
The "DBMS-proprietary protocol" is the protocol which client software
must use to communicate with the database server i.e. to send queries
and commands to the server and to receive status information and result
sets from the server.
You said in your original post that you were creating a "homebrew DBMS",
so one of the first things you must do is design the client/server
protocol. You can do it any way you like -- this is *your* DBMS system
after all.
If you're a little hazy on the concept of a protocol, you might want to
read up on client/server systems first. Any of the online tutorials on
the SMTP protocol would be a good place to start, since SMTP is a simple
client/server protocol that is easy to understand.
David Harper
Cambridge, England
Hi Sam,
I think you have not understand the difference between a type 3 driver and a
type 4 driver.
A type 3 driver requied a separate middle ware server. You have a homebrew
DBMS and not a homebrew middle ware server if I understand your email
correctly.
To answer your question I need the follow infos:
- In which language do you have written your DBMS? In Java or any other
language like c?
- Does you want a server with network interface? Or is it only a local
database?
Volker

Signature
http://www.smallsql.de - the 100% pure Java Desktop Database with JDBC
> Hello,
> I am working on a homebrew DBMS and need to prepare both a type 3 and
> type 4 driver on my own. I check the tutorial on JavaWorld on type 3
> driver design but lack information on that of type 4. Any one can
> suggest valuable tips? Thank you!