Basic HTML version of Foils prepared 7 October 97

Foil 28 mSQl jdbc driver for mSQl database

From Overview of JDBC and its use with Microsoft Access ARL Database Tutorial -- February 98. by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal)
1 mSQl is a minimal implementation of a RDBMS.
2 For the mSQL implementation of JDBC, it looks for URL's in the form of
  • jdbc:msql://[host_addr]:[port]/[db_name]
3 Example URL jdbc:msql://lion.cat.syr.edu:4333/test
4 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.
in Table To:

© on Mon Oct 13 1997