tquadrat.org

View on GitHub

Database Lore

I bareley know how to spell database correctly, so I am quite often surprised about details about RBDMS and other databases that other will not even notice as something remarkable. Some of these things are collected here, and some of it made its way into a Foundation Library with some tools related to JDBC.

The articles here are covering a topic always in the same manner: first JDBC in general, then from a per RDBMS product perspective.

  1. Does Table exists?
    A problem that I have quire often is that I need to check whethe a particular table (already) exists.

  2. Date/Time Value Columns
    How are date/time values are stored in the database and how will they be mapped to the Java types?