CSE 515: DB TPS Hints

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

·  Experiment 4:

• Once you finished GradMultiUser debugging, you should run on single server database from TPPT using Bench login only. Please don't use your multi user login for single user.
• Please start your homework early to avoid possible trouble near the deadline. 

·  Experiment 3:

• TPPT SingleUser server may not be in Single User mode yet. Once you finished GradMultiUser debugging, you only need a few minutes more to run it again on SingleUser to get the final results. So finish your job up to GradMultiUser now. If the SingleUser is not ready by the time of submission you can submit with GradMultiUser

·  Experiment 2:

• You can use any mode of transaction as you see fit.But all 3 cases should be in the same mode of transaction.
• In part 1, where you need to fetch the rows into a updatable resultset, you can fetch them "all at once" or "one row at a time". But you should update each row individually. You shouldn't update them all at once.
• In part 2, you will have to iterate a single update statement that updates all the rows. There is no need to fetch rows here.
• tppt1.4.zip is the TPPT tool for download.The tool is already installed in GradLab.Extract it and run the tppt batch file. When you connect to RDB you should use from the drop-down in the tool GradMultiUser option. This where you will debug your code. Choosing single-User mode will by default connect you to the benchmark server which is where you will ONLY generate reports.
• All install problems with the TPPT software (in GRADLAB ONLY) should be reported via wreq requests.
• Each student will use their login/password already given for connecting to GradMultiUser option in TPPT. If you haven't got a login, send me an email and I will give you one.
• Please use blackboard for submitting your assignment.

3.                                

·  Experiment 1:

• All the CSE-515 students should access the database server rdb.translab.cs.sunysb.edu from the GRADLABS and not the TRANSLAB which is the undergraduate lab in the department.
• The GRADLABS have jisql and isql installed on the machines to access their databases. All install problems with the software should be reported via wreq requests.
• To use jisql from GRADLAB or to install it at home follow these instructions.
• Each student will use their login/password and type it in the jisql window or isql console (isql -U c515_XXX -S rdb.translab.cs.sunysb.edu). If you haven't got a login, send me an email and I will give you one.
• Read the JDBC docs given below for information on JDBC.
• Use of TPPT is NOT required for this experiment.

　

　

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