Prentice Hall and Sun Microsystems. Personal use only; do not redistribute.
484
Chapter 18 JDBC and Database Connection Pooling
Listing 18.9 EmployeeTest result (connecting to Oracle on
Solaris)
Prompt> java coreservlets.EmployeeTest dbhost1.apl.jhu.edu PTE
hall xxxx oracle
Database: Oracle
Version: Oracle7 Server Release 7.2.3.0.0 Production Release
PL/SQL Release 2.2.3.0.0 Production
employees:
==========
+ + + + + +
| ID | FIRSTNAME | LASTNAME | LANGUAGE | SALARY |
+ + + + + +
| 1 | Wye | Tukay | COBOL | 42500 |
| 2 | Britt | Tell | C++ | 62000 |
| 3 | Max | Manager | none | 15500 |
| 4 | Polly | Morphic | Smalltalk | 51500 |
| 5 | Frank | Function | Common Lisp | 51500 |
| 6 | Justin |Timecompiler | Java | 98000 |
| 7 | Sir | Vlet | Java | 114750 |
| 8 | Jay | Espy | Java | 128500 |
+ + + + + +
Listing 18.10 EmployeeTest result (connecting to Sybase on NT)
Prompt> java coreservlets.EmployeeTest dbhost2.apl.jhu.edu 605741
hall xxxx sybase
Database: Adaptive Server Anywhere
Version: 6.0.2.2188
employees:
==========
+ + + + + +
| id | firstname | lastname | language | salary |
+ + + + + +
| 1 | Wye | Tukay | COBOL | 42500.0 |
| 2 | Britt | Tell | C++ | 62000.0 |
| 3 | Max | Manager | none | 15500.0 |
| 4 | Polly | Morphic | Smalltalk | 51500.0 |
| 5 | Frank | Function | Common Lisp | 51500.0 |
| 6 | Justin |Timecompiler | Java | 98000.0 |
| 7 | Sir | Vlet | Java | 114750.0 |
| 8 | Jay | Espy | Java | 128500.0 |
+ + + + + +
Second edition of this book: www.coreservlets.com; Sequel: www.moreservlets.com.
Servlet and JSP training courses by book's author: courses.coreservlets.com.
footer
Our partners:
PHP: Hypertext Preprocessor Best Web Hosting
Java Web Hosting
Jsp Web Hosting
Cheapest Web Hosting
Visionwebhosting.net Business web hosting division of Web
Design Plus. All rights reserved