CSE 515: DB TPS Hints
[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
start your homework early to avoid possible trouble near the deadline.
- 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.
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
- 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.
· 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
- 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
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.
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
Started With JDBC
Bakery - A JDBC TM Order Entry Prototype - Part I
the website of the Transaction Lab
to get information about JDBC
usage in the lab. The following are the connection parameters that you
String mysJDBCDriver =
String mysURL = "jdbc:sybase:Tds:rdb.translab.cs.sunysb.edu:5000";
static String proxy=
String mysUserID = "your Id";
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
---- (new!) You will need for your experiment2! To run Transaction Processing Performance Tool (TPPT), you can
to execute, double click it.
---- (new!) A manual describing the
Transaction Processing Performance Tool (TPPT) can be found here: TPPT
Tutorial. ----For later experiments.
updated on Sep 15, 2008 by Tingbo Hou