SmallSQL is the ultimate Java Desktop SQL Database Engine with JDBC 3.0 API.
There are 2 solutions to start with SmallSQL DBMS
1.) From an existing Database
You can convert an existing Database with JDbConverter. This is an open source tool to convert a database from one DBMS to another DBMS via JDBC. You can download it and convert your existing JDBC database.
2.) Create a database with a GUI tool
We does not have such tool but we recommended one of the follow:
JDBC Navigator. This is a free graphical Java tool. After you have download it
Select the menu "Open JDBC Data Source"
Name: Small SQL Database
Driver Class: smallsql.database.SSDriver
URL: jdbc:smallsql
Save and Connect
Open the menu "Connection | SQL Window"
Enter "CREATE DATABASE db1" and execute it with ENTER
Close the Connection
Select the menu "Open JDBC Data Source" and change the URL to
jdbc:smallsql:db1
Save and Connect
SQuirreL SQL Client. This is an open source graphical Java tool. After you have download and install it
Create a new JDBC Driver
Name: Small SQL Database
Example URL: jdbc:smallsql:
Create a new Alias
Name: Small SQL db1
JDBC Driver: Small SQL
URL: jdbc:smallsql
Auto Logon: Yes
Connect to the alias "Small SQL db1"
Change to the tab "SQL"
Enter "CREATE DATABASE db1" and execute it
Close the window
Change the alias
JDBC URL: jdbc:smallsql:db1
Connect to the alias "Small SQL db1"
Configuration:
JDBC Driver class name: smallsql.database.SSDriver
JDBC URL: jdbc:smallsql:< database >
< database > is a absolute or relative directory name
In the Java code for a directory "db1" this look like:
Class.forName( "smallsql.database.SSDriver" );
java.sql.Connection con = java.sql.DriverManager.getConnection( "jdbc:smallsql:db1" );
What is new in this release:
- Some minor bugs were fixed and the JDBC URL property "readonly" was added.
- Now you can share one database in read-only mode between multiple Java processes.
What is new in version 0.20:
- This release adds some features to make the SmallSQL Database syntax more compatible with MySQL.
- This makes a change simpler. Some critical thread problems were fixed.
Comments not found