Want to export a ton of tables, but only get SOME of the records?
Want to apply a GLOBAL filter across the tables to only get the records you want?
Tools > Database Export.
I’m going to export data, NOT DDL.
I’m going to write it to a single JSON file.
I’m going to grab data from a couple of... [Read More
For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…
Here the presentation slide deck (100+) used during the oGH Dutch Usergroup session and (partially…
The native JSON functionality in Oracle Database version 12.2 has evolved quite a bit since the JSON functions first appeared in Oracle Database version 220.127.116.11. Just one example is JSON_TABLE can be used as a bridge between the open standard GeoJSON format and the database internal SDO_GEOMETRY format, making it very simple to use externally available geocoding datasources within spatial applications in the database.
You have been able to do this (more...)
In Part I and Part II, we looked at how to index specific attributes within a JSON document store within an Oracle 12c database. But what if we’re not sure which specific attributes might benefit from an index or indeed, as JSON is by it’s nature a schema-less way to store data, what if we’re not entirely sure […]
At a customer we are working in an Oracle Fusion Middleware environment. In this environment we created queues. These queues are configured with an error queue when messages could not be delivered.
Because there are a number of error queues, monitoring is a lot of work. You have to check each queue independently. Recently I ran into this blog of Frank Munz (link). In this blogpost he talks about the framework Jolokia. This (more...)
Do you need to accept payments for goods and services via your (APEX) application and would you prefer to handle the payments in the database via PL/SQL? Then this blog post is for you... :-)
Almost a decade ago (in 2007), Oracle released a whitepaper on Integrating Application Express with PayPal Payments Pro
which used PayPal's Name Value Pair (NVP) API.
In the years since then, PayPal has made available a new API which is (more...)
In Part I, we looked at how you can now store JSON documents within the Oracle 12c Database. For efficient accesses to JSON documents stored in the Oracle database, we can either create a function-based index based on the JSON_VALUE function or on JSON .dot notation. These indexes are useful for indexing specific JSON attributes, […]
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
Error: parsererror - SyntaxError: JSON.parse:
unexpected non-whitespace character after JSON data at line 2 column 1 of the JSON data
You may get this self-explanatory error at run-time if you specified a non-existing page item in the list of items to be returned after invoking a PL/
Via Steven Feuerstein
I was asked to try and give advice concerning fastest way to parse CSV data in PL/SQL. The case was that they had a different database that could be setup to deliver data as a webservice serving either CSV, XML or JSON, and they wished to let their APEX application use PL/SQL to retrieve data from that other database via such webservices. They were not yet on 18.104.22.168.0 (more...)
This post is a quick and simple introduction to Geospatial feature of MongoDB 2.6 using simple dataset and queries.
Storing Geospatial Informations
As you know you can store any type of data, but if you want to query them you need to use some coordinates, and create index on them. MongoDB supports three types of indexes for GeoSpatial queries:
2d Index : uses simple coordinate (longitude,
Following from my last posting
, I thought I'd also show how Eclipse (OEPE) makes the new Java EE 7 APIs available from Oracle WebLogic Server 12.1.3.
The first step was downloading and installing the Oracle Enterprise Pack for Eclipse (OEPE) distribution from OTN.http://www.oracle.com/technetwork/developer-tools/eclipse/downloads/index.html
Firing up Eclipse, the next step is to add a new Server type for Oracle WebLogic Server 12.1.3, pointing at a local installation.
Oracle WebLogic Server 12.1.3 provides full support for Java EE 6 and also adds support for a select set of APIs from Java EE 7.
The additional APIs are:
- JSR 356 - Java API for WebSocket 1.0
- JSR 353 - Java API for JSON Processing
- JSR 339 - Java API for RESTful Web Services 2.0
- JSR 338 - Java Persistence API 2.1
See the "What's New in 12.1.3 (more...)
Another feature of WebLogic Server 12.1.3 that I'm sure developers will find useful is the inclusion of an implementation of JSR-353 Java API for JSON Processing.JSR 353: JavaTM API for JSON Processing
This new API, working from the foundations provided by earlier implementations such as Jackson, Jettison and Google JSon, now provides a standard API for working with JSON from Java. This goals and objectives of the API described in the initial (more...)
The PATCH method
is one the the less well loved HTTP methods simple because until recently there really wasn't a standard PATCH format. This has been standardized for JSON for a while
now so there are quite a few libraries that will do the heavy lifting for you. For the purposes of this blog I am going to use json-patch
although it would be easy to adapt this particular implementation to the patch library of (more...)
I have been playing with JSON-P a little bit
recently and one of the thing I wanted to try as making it work with Jersey 1.x. (Jersey 2.x has this functionality built in
I had hoped to use the org.glassfish:jsonp-jaxp component that comes from the json-p project
; but it depends on the JAX-RS 2.0 API. With a bit of friendly badgering of the ever helpful Pavel Bucek
, a (more...)