CSE 515: DB TPS Hints

[Announcements] [Experiments] [Hints] [Home]

·  Experiment 4:

·  Experiment 3:

·  Experiment 2:


·  Experiment 1:



Important: When you are doing experiments, DO REMEMBER TO CLOSE THE CONNECTION EXPLICITLY. Or it will remain active. If there are too many connections the server will crash.


For JDBC: remember to close your connection using sth like: myconnection.close(); it should appear in your code paired with DriverManager.getConnection like ‘(‘ and ‘)’.


For JISQL: If you just close the window, your connection will remain active. Please disconnect before closing the window. Click on Connection/Close Connection.

----Read the textbook and the appropriate Sybase manuals carefully.  You can find Sybase documents here. Among them, Java in Adaptive Server Enterprise describes how to write Java programs that interact with Sybase.  Transact-SQL User's Guide describes the implemenation of SQL in Sybase, read Chapter 14 and 18, especially Chapter 18 that describes the implementation of transactions and their restrictions in Sybase.

----Here is some good JDBC Reference Sites:

Learning JDBC[tm] Programming

JDBC Short Course

Getting Started With JDBC

JDBC(TM) Database Access

Duke's Bakery - A JDBC TM Order Entry Prototype - Part I

---- (modified!) Visit the website of the Transaction Lab to get information about JDBC usage in the lab.  The following are the connection parameters that you should use:
            static String mysJDBCDriver = "com.sybase.jdbc2.jdbc.SybDriver";
            static String mysURL = "jdbc:sybase:Tds:rdb.translab.cs.sunysb.edu:5000";
            static String proxy=  "http://www.translab.cs.sunysb.edu/proxy/servlet/TDSTunnelServlet";
            static String mysUserID = "your Id";
            static String mysPassword = "your password";

---- (new!) Remember to do as instructed in http://www.translab.cs.sunysb.edu/jdbc.html:

Copy the com folder under c:\program files\sybase\jConnect-4_5\classes ( you can find in machines in translab), and include the directory which the com folder resides in into your CLASSPATH variable.

  Or, to make things easier, add driver jconn2.jar to CLASSPATH.

---- (new!) You will need for your experiment2! To run Transaction Processing Performance Tool (TPPT), you can download Tppt.jar, to execute, double click it.

---- (new!) A manual describing the Transaction Processing Performance Tool (TPPT) can be found here: TPPT Tutorial. ----For later experiments.

Last updated on Sep 15, 2008 by Tingbo Hou