Skip to Main Content

The Java API for JSON type in Oracle JDBC 20c

Oracle 20c (currently available as a preview release only) introduces a new built-in SQL type ('JSON') to support the efficient and type-rich storage of JSON data. Values are both stored and transmitted across the network using Oracle's binary JSON format to provide fast ingest, retrieval, query, and update of JSON data. This session will give an overview of the new JSON facilities in JDBC (package oracle.sql.json). Software engineer Josh Spiegel will cover functionality, architecture, and performance best practices for accessing JSON from a Java program. A mixture of slides and live demonstration will be used throughout the talk. Timestamps: 0:0 - 0:53 Introduction 0:54 - 2:20 Recap JSON Type 2:21 - 6:40 JSON type, JDBC, JSON data model, Performance 6:41 - 8:05 Example for JSON encoding on Database and Java/JDBC 8:06 - 10:00 why store JSON in Oracle database 10:01 - 12:20 The Java API for JSON in JDBC 12:21 - 17:00 JSON Tree Model 17:01 - 19:34 JSON Event Model 19:35 - 25:35 SQL Integration 23:36 - 42:00 Java Code Demos 42:01 - 47:17 JSON-P (JSR 374) 47:18 - 50:00 JSON-B (JSR-367) 50:01 - 55:24 Performance Tips 55:25 - End Conclusion, Links

Workshop Info

Session Has Completed - 09 June 2020
1 Hour
JSON in Oracle Database Office Hours
English
JSON

Other Upcoming Sessions