Java 8 Friday: JavaScript goes SQL with Nashorn and jOOQ

At Data Geekery, we love Java. And as we're really into jOOQ's fluent API and query DSL, we're absolutely thrilled about what Java 8 will bring to our ecosystem. Java 8 Friday Every Friday, we're showing you a couple of nice new tutorial-style Java 8 features, which take advantage of lambda expressions, extension methods, and … Continue reading Java 8 Friday: JavaScript goes SQL with Nashorn and jOOQ

SQL Developer’s “Securely” Encrypted Passwords

Note: This article is outdated. It only worked for a specific version of SQL Developer. We're keeping the article around for historic reasons. Recently, while at one of our customers' site, the customer and I needed to get access to a database. On my machine, I had stored the password, but the customer obviously didn't … Continue reading SQL Developer’s “Securely” Encrypted Passwords

Don’t Forget to Set the SEQUENCE CACHE Size

In most cases, simply creating an Oracle SEQUENCE with all defaults is good enough: CREATE SEQUENCE my_sequence; This sequence can then be used immediately in triggers when inserting new records in a table: CREATE OR REPLACE TRIGGER my_trigger BEFORE INSERT ON my_table FOR EACH ROW -- Optionally restrict this trigger to -- fire only when … Continue reading Don’t Forget to Set the SEQUENCE CACHE Size