Dbclient

DBClient Yet Another Jdbc Tool

Developer(s)	Taha BEN SALAH
Stable release	0.4 alpha 3 / June 1, 2008; 3 years ago (2008-06-01)
Written in	Java
Operating system	Cross-platform
Type	RDBMS
Website	https://dbclient.dev.java.net

DBClient is a new Open Source Tool for connecting to JDBC-compliant relational databases. It is almost written in Java which makes it platform independent and it stores it configuration info using an embedded version of Apache Derby. DBClient is massively based on Plugin architecture and supports Apache Derby, Oracle, MS SQL Server, MySQL, PostgreSQL. HSQL.

Features

Features
Developer oriented product
Plugin Architecture
Database Objects Tree Explorer
Multiple SQL Command windows
Multiple Result Tables
SQL Syntax coloring
Autocomplete SQL words
Script handling
Debugging tools (for scripts)
Embedded Java Code Support (à la JSP)
SQL generation
SQL formatting
Code Generation Tools (Java, J2EE, C#.Net using Neormf Framework)
User Friendly Front end
I18N including English, Arabic, French, Dutch and German

Plugins

DBClient supports three types of plugins:

   (1) messagesets:
     Messagesets are language pack archive files for localizing DBClient messages.
   (2) iconsets:
     Iconsets are icon pack archive files for customizing all icons.
   (3) artsets:
     ArtSets are image pack archive files for customizing all banners, splashscreen, ...
   (4) dbsupport:
    DBSupport plugins are sql-centric plugins than add specific rdbms functionality to DBClient. Thus, we could find a dbsupport plugin for oracle, another for mysql and so on.
   (5) dbdriver:
     DBDriver plugins are simple archive holders for some known rdbms. This is provided to simplify their integration in DBClient.
   (6) library:
     Library plugins are simple archive holders for some known other jar files/libraries needed by more than one plugin. 
   (7) presentation:
     Presentation plugins are presentation-centric plugins which makes it possible to customize dbclient look and layout
   (8) tools:
     Are general purpose plugins.

To install a new Plugin, simply download it to the $DBCLIENT$/plugins folder.

Plugin	Description
derby-support	Auto Identity support, View DDL
postgresql-support	Actually this is only a holder project for future PostgreSQL support
mysql-support	Actually this is only a holder project for future MYSQL support
oracle-support	View DDL supported Actually this is only a holder project for future Oracle support
mssqlserver-support	Auto Identity support, View DDL
infonode	Docking Support, More Plafs
swinglabs	Table sorting support, Session folding in Session Chooser, Better Error Handler
recordeditor	Plugin for simplifying Record Edition with generating dynamically a formula for inserting and updating table records. Provides also mechanisms to configure Fields Editors (checkboxes, comboboxes, etc...)
searchengine	This plugin enables searching into all of database data and schema information.
neormf	neormf (New Enterprise Object Relational Mapping Framework) is a Bottom-Up Code Generation Framework for a number of languages/platforms (Java/J2EE,C#/DotNet,...) and architectures, following main design patterns and frameworks. This plugin enables code generation from within DBClient.

External links

• Official Web Site