Basic HTML version of Foils prepared April 15 1997

Foil 49 mSQl jdbc driver for mSQl database

From Examples of JDBC -- Microsoft Access CPS616 -- Information Track of CPS -- Spring Semester 97. by Sangeeta Aggarwal,Tom Pulikal,Udayan Pravate(Nancy McCracken) *

mSQl is a minimal implementation of a RDBMS.
For the mSQL implementation of JDBC, it looks for URL's in the form of
  • jdbc:msql://[host_addr]:[port]/[db_name]
Example URL jdbc:msql://lion.cat.syr.edu:4333/test
This is a Native-protocol all-Java driver.
  • In the implementation of the Driver interface for this driver a direct socket connection is opened at the given host_addr and at the specified port. On success a Connection object is returned.
  • Thus with this driver , a mSQL database on any machine can be accessed by any application running on any other machine provided that they are connected over the internet.



© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Aug 14 1997