Oracle TimesTen continues to evolve its developer capabilities with expanded support for JSON, now accompanied by new examples across a broad set of APIs and programming environments.

With native JSON storage and query functionality, TimesTen enables developers to work with semi-structured data alongside relational data using familiar SQL and programming interfaces. These new examples demonstrate how JSON features can be used across the languages, drivers, and environments commonly used to build modern applications.

The JSON examples are now available for:

  • JDBC
  • ODBC
  • OCI
  • ODP.NET
  • TTClasses
  • SQL
  • Node.js
  • Python

This expanded coverage makes it easier to explore and adopt TimesTen’s JSON capabilities across a wide range of development models—from native interfaces and SQL scripting to Java, .NET, and open source environments.

Each example is built around a practical purchase-order scenario and highlights key JSON operations in TimesTen, including:

  • Creating a table with a JSON column
  • Loading JSON documents from sample files
  • Creating a functional index with JSON_VALUE
  • Updating existing JSON documents
  • Querying documents by identifier and JSON attributes
  • Projecting JSON arrays into relational form using JSON_TABLE

By using a consistent workflow across APIs, these examples provide a straightforward way to understand how JSON data can be stored, queried, and transformed in TimesTen. Whether you are working in C, C++, Java, .NET, SQL, Node.js, or Python, you can see how the same JSON operations are expressed in your preferred environment.

These examples are especially useful for teams looking to incorporate semi-structured data into existing applications without changing their development stack. Instead of starting from scratch, developers can begin with working code that demonstrates common JSON use cases across supported APIs.

To get started, visit the Oracle TimesTen samples repository:

https://github.com/oracle-samples/oracle-timesten-samples

Each sample directory includes a README with setup instructions, prerequisites, and execution steps. Choose your preferred API and run your first JSON workflow in minutes.

With these additions, Oracle TimesTen provides a more complete set of examples for working with JSON in modern application environments.