Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / May 2005

Tip: Looking for answers? Try searching our database.

How to build a custom type 4 driver?

Thread view: 
Sam Hwang - 14 May 2005 18:17 GMT
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!
Lee Fesperman - 14 May 2005 21:00 GMT
> 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
Volker - 21 May 2005 16:14 GMT
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!


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.