Tuesday, June 30, 2015

New Tools releases , now with Java

What's New

  For the 90%+ of people using sqldev/modeler on windows, the JDK bundled versions are back.  So no more debating what to install or worrying about conflicting Java versions.

  Lots of bug fixes.

   My favorite bug is now fixed so you can use emojis in your sql> prompt.

RESTful CSV Loading

  We wrapped he same CSV import code in SQL Developer into the REST Auto-Enablement feature. Here's a very short example of javascript batch inserting 4 records into the EMP table.  I'm not sure it can get much easier.

// CSV (POST http://localhost:8888/ords/klrice/emp/batchload)

    url: "http://localhost:8888/ords/klrice/emp/batchload?" + jQuery.param({
        "responseFormat": "RAW",
    type: "POST",
    headers: {
        "Content-Type": "text/csv",
    processData: false,
    data: "empno,ename,job,mgr,hiredate,sal,comm,deptno
5001,M,SPY MAST,,2005-05-01 11:00:01,4000,,11
5002,J.BOND,SPY,0,2005-05-01 11:00:01,2000,,11
5003,R.Cooper,SOFTWARE,0,2005-05-01 11:00:01,10000,,11
5004,Max,DENTIST,0,2005-05-01 11:00:01,5000,,11
.done(function(data, textStatus, jqXHR) {
    console.log("HTTP Request Succeeded: " + jqXHR.status);
.fail(function(jqXHR, textStatus, errorThrown) {
    console.log("HTTP Request Failed");
.always(function() {
    /* ... */

Here's the same example in Paw which is a great client if are on OSX

While this is a very simple case, there are a lot of switches to customize this importing.  Those options are all in the doc found here:  http://docs.oracle.com/cd/E56351_01/doc.30/e56293/develop.htm#BABCACEC

Go Forth and Download

SQL Developer 4.1.1

Data Modeler 4.1.1

REST Data Services 3.0.1

SQLCL - Main Line Build
( Last Link on the bottom of the sqldev download page )

Disqus for Kris' Blog