Appendix A. Java and Oracle Type Mappings
This appendix documents the mappings between Java types used to create host variables and objects later used in SQLJ host expressions, and their compatible Oracle database types. When a column is retrieved from the database into a compatible Java host variable or object, the Oracle database type is converted to the corresponding Java type. For example, using the mappings defined in Table A-1, you can see that a host variable defined using a Java short, int, or long type may be used to store a value retrieved from a database NUMBER column. The reverse happens when you use a Java host variable or object to supply a value to a database column via a host expression; for example, you can use a Java short, int, or long host variable to supply a value to a database NUMBER column.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access