JDBC 2 Test suite

Connecting... connected.

DeleteAll()...done

Select all...done

Insert() X 6...done

Select all...done

Last Name	First Name	Email
LastName0	FirstName0	Email0
LastName1	FirstName1	Email1
LastName2	FirstName2	Email2
LastName3	FirstName3	Email3
LastName4	FirstName4	Email4
LastName5	FirstName5	Email5

Update() record 2...done

Delete() record 3...done

Select all...done

Last Name	First Name	Email
LastName0	FirstName0	Email0
LastName3	FirstName3	Email3
LastName4	FirstName4	Email4
LastName5	FirstName5	Email5
Updated Last Name	Updated First Name	Email1

spParm() Email0...Email0 MEFIRSTNAME MELASTNAME done

Closing statements...closed

JDBC2 Specific Tests

Select all...done

Last Name	First Name	Email
LastName0	FirstName0	Email0
LastName3	FirstName3	Email3
LastName4	FirstName4	Email4
LastName5	FirstName5	Email5
Updated Last Name	Updated First Name	Email1

Display ResultSet Info

getType()... java.sql.ResultSet.TYPE_SCROLL_SENSITIVE done

getConcurrency()... java.sql.ResultSet.CONCUR_UPDATABLE done

getFetchDirection()... java.sql.ResultSet.FETCH_FORWARD done

getFetchSize()...Size: 10 done

getRow()...0 done

Absolute(3)...

Last Name	First Name	Email
LastName4	FirstName4	Email4

done

afterLast()...done

isAfterLast()...true done

last()...done, last row is:

Last Name	First Name	Email
Updated Last Name	Updated First Name	Email1

isLast()...true done

beforeFirst()...done

isBeforeFirst()...true done

first()...done, first row is:

Last Name	First Name	Email
LastName0	FirstName0	Email0

isFirst()...true done

Select all...done

Last Name	First Name	Email
LastName0	FirstName0	Email0
LastName3	FirstName3	Email3
LastName4	FirstName4	Email4
LastName5	FirstName5	Email5
Updated Last Name	Updated First Name	Email1

Cursor Tests

absolute(1)

Last Name	First Name	Email
LastName0	FirstName0	Email0

done

relative(2)

Last Name	First Name	Email
LastName4	FirstName4	Email4

done

previous()

Last Name	First Name	Email
LastName3	FirstName3	Email3

done

Select all...done

Last Name	First Name	Email
LastName0	FirstName0	Email0
LastName3	FirstName3	Email3
LastName4	FirstName4	Email4
LastName5	FirstName5	Email5
Updated Last Name	Updated First Name	Email1

Closing down...

Closing statements...closed

done