Sun Java DB pure Java RDMS

\[Sun Tech Day 2\]

Sun Java DB is

  • Apache Derby
  • Bundled in JDK 6
  • 10.2.2
  • JDBC
  • SQL 92/99/2003
  • Used in 100 IBM projects
  • Used by GlassFish

Sun Java DB

  • Supported in NetBeans
  • Any hardware, any OS, any vendor
  • Common binary for all OS
  • Can run in same JVM as your application
  • Just one 2M JAR (600k download)
  • (Auto)Start and Stop from inside your app
  • Requires physical 16M and heap of 4M
  • DRDA v3 opengroup.org compliant

Sun Java DB has

  • Transactions
  • Triggers can send email
  • Procedures SQL standard part 13
  • Caching
  • Backup
  • Encryption
  • LDAP
  • Grant/Revoke

DataStore

  • FileSystem
  • JAR (Readonly)
  • Memory (alpha)

Tools

  • IJ - works with any JDBC db
  • DBLOOK
  • SQUIRREL

Read and post comments | Send to a friend