Skip to Main Content

JSON in Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

June 09, 2020

17:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


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.

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

Your Experts

    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    Blaine Carter

    Blaine Carter   

    As a product manager for Visual Builder, Blaine focuses on helping developers adopt the new Oracle application development platform. For most of his career, Blaine has used Oracle tools to build applications, including Oracle Forms and Oracle Reports, Java, and a whole lot of SQL and PL/SQL. Blaine is borderline obsessed with automating as much as he can. This has drawn him to CI/CD tools and, of course, the cloud. Blaine has a deep love of learning and sharing what he learns with other people.