Skip to main content

DBClient

Yet another Jdbc client tool

DBClient is a new Open Source Tool for connecting to jdbc compliant relational databases.
DBClient is designed to be developer and adminsitrator friendly
DBClient is massively based on Plugin architecture.Specific extensions take care of each RDBMS implementation
Available plugins are here.
You can see some tutorials here.

Download DBClient now

News

DBClient Screenshots (GUI Front end)

Main Window SQL Autocomplete Record Editor Connection Dialog

DBClient Main 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 (a 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
  • ... And any other useful feature you'll suggest ;)
You can find detailed features Matrix in the following comparaison to other concurrent products

DBClient Keymap

CTRL+ENTER Execute Script
CTRL+J Execute Script
CTRL+SPACE Default autocomplete
CTRL+SLASH Comment line
CTRL+L Select line
CTRL+W Select word
CTRL+Y Delete line
CTRL+D Duplicate line/selection
CTRL+Z Undo
CTRL+SHIFT+Z Redo

Installing and Running DBClient

Java Runtime Environment(JRE) 1.6 is required for running this tool.

To run DBClient (and it's java installer) you must have a valid SUN JRE1.6. When using the installer, just follow the setup dialogs. For zip archive installation simply unzip the downloaded file into un empty folder and then run the script file bin/run.bat (on Windows) or bin/run.sh (on Linux/Unix). If jar files are already associated with java, you can simply double click on the run.jar file.
To connect to any RDBMS you should provide JDBC Driver by copying it into the jdbcdrivers folder. Note that you can point your jdbc drivers repository to a different location or specify for each Driver a specific Location in the DriverManager Tool.

DBClient Credits

  • Main Developer : Taha BEN SALAH ( taha.bensalah@gmail.com )

Tutorials

How to Use DBClient

  1. Using DBClient with Derby (javadb) Step By Step.
  2. Using DBClient with Oracle Step By Step.

How to Contribute in developping DBClient Plugins

  1. DBClient Plugins Architecture Overview.
  2. Hello World Plugin Step By Step.

DBClient Changes log

DBClient version 0.5.x
  • new features:
    • Enhanced SQLEditor
      • Line Numbering in SQL Editor
      • BreakPoint, Debugger step Icons in the Line Numbering Margin
      • Restored feature : debugger (step by step SQL Batch executing)
      • Added Support for Break points
      • Added in SQL Editor Status Bar : Error count / Success Count Labels
      • SQL auto complete will ne more raise a popup if a single option was found
      • SQL auto complete will raise when caret on keyword
      • SQL auto complete will raise when caret on keyword
      • Call (procedures) and values statements are supported
      • added "select statement" in the contextual menu (shortcut CTRL-T)
    • Enhanced Result Table
      • Added Refresh Action
      • Added AutoRefresh (Timer enabled) Action
      • Added Popup Menu Export Action
    • Derby Plugin
      • Added special Action to "Check conststency"
      • Added special Action to "Compress tables"
      • Added special Action to "Backup Database"
      • Added special Action for "Flush IO cachechanges"
      • support for "Values" statements
    • Added Execution Plan support
      • Added in API
      • Added default implementation in Derby
    • New plugins
      • Added Import/Export plugin. Export to csv, fixed length and xml is supported.
      • dbdriver-mysql : Default MySQL JDBC Drivers
      • dbdriver-postgresql : Default PostgreSQL JDBC Drivers
    • Library updates:
      • PostgreSQL jdbc 8.4
      • InfoNode 1.6.1
      • dbdriver-postgresql 1.8.5 : Default PostgreSQL JDBC Drivers
      • dbdriver-hsql,library-hsql-server : 1.9-rc5 Default PostgreSQL JDBC Drivers
      • dbdriver-derby,library-derby-server : 10.5.1.1.4 Default PostgreSQL JDBC Drivers
    • Default Icon has become a fallthgrough icon set : when iconset does not provide a convinient icon, the default one will be used unless the iconset says no (iconpath='')
  • bug fixing:
    • Error SQL Selection fixed
    • Bug when not using storesLowerCaseIdentifiers family metadata flags in finder fixed
    • Bug in AutoComplete (not always showing) fixed
    • Bug in parsing quoted identifiers fixed
    • Bug in saving session settings fixed
    • Bug in loading/saving onOpen and onClose Scripts fixed
    • Bug preventing connexions from closing properly fixed
    • fixed PluginInfo private constructor (needed for reflection). bug that makes it impossible to get updates
  • some refactoring:
    • Introduced messageSet and iconSet in DBCAnPlugin to enable simple localisation
    • Generalized (Result) Table Actions, for now on, to create a Table Action just create a class that inherits from DBCResultTableAction
    • Generalized (DBCSQLQueryTool) Actions, for now on, to create a SQLEditor Tool just create a class that inherits from DBCSQLQueryTool
    • Added DBCAutoCompleteComponent.init(DBCSession)
    • Removed DBCSessionView.getObjectPopupTitle(DBObject);
    • DBCDefaultConnection moved from api to system-plugin
    • system-plugin added as dependency to dbsupport-* plugins
    • added addWordTokenResolver/removeWordTokenResolver/getWordTokenResolvers to SQLParser
    • Some icons changed (default iconset)
Full Changes of DBClient log could be found here.

DBClient Call For contribution

DBClient is now sufficently mature to benifit from larger number of contributors. Please help me make this tiny tool better and better. Contribution are needed for

  • support for handled rdbms (test and implementation of other native functionnalities)
  • support for non yet supported rdbms (sybase...)
  • localization (i18n) in german, dutch : i have no partcular competance to update messages
  • localization (i18n) in other languages
  • localization (i18n) in french, arabic: i have no patience (!??!) to update messages
  • test, test and test
 
 
Close
loading
Please Confirm
Close