Summary
In this chapter, we learned how to materialize collections (nested tables and varrays) in a JDBC application as Java objects. We looked at various JDBC standard classes and Oracle extensions. We learned how to use collections in JDBC program using weakly typed classes and strongly typed custom classes generated by JPublisher utility. We also learned about various performance extensions that Oracle provides you with and measured their effectiveness on data retrieval speeds. Finally we learned what references are, and why you should avoid them in general. We also learned how to query and update them using weakly typed Ref and REF classes or using strongly typed custom classes created either manually or using JPublisher utility.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2005 R. M. Menon
About this chapter
Cite this chapter
(2005). Using Oracle Collections and References. In: Expert Oracle JDBC Programming. Apress. https://doi.org/10.1007/978-1-4302-0029-1_11
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0029-1_11
Publisher Name: Apress
Print ISBN: 978-1-59059-407-0
Online ISBN: 978-1-4302-0029-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books