H2 Database

H2 Database is good one

• the latest version is 1.2.139
  
  
  

  #!/bin/bash
  pre="-Dh2.bindAddress=0.0.0.0 -DwebAllowOthers=true" 
  postW="-web -webAllowOthers -webPort 8052" 
  postT="-tcp -tcpAllowOthers -tcpPort 8050" 
  
  echo jdbc:h2:tcp://localhost:8050/~/work/db/test
  echo  -Doracle.display.default.schema.only=false 
  
  echo 
  java -cp ~/bin/lib/h2-1.2.139.jar $pre org.h2.tools.Server $postW $postT
  

• able to connect with Eclipse Sql Explorer
• To enable Sql Completion in Sql Explorer do as
• Files > Preferences > SQL Explorer. Tick the Tables and columns auto-completing assistance. Click OK and if it doesn’t work still, just restart SQL Explorer and will work.