|
DBJMIN (STABLE SWING: version 0.1.9 / STABLE WEB: version 0.0.2)
LATEST NEWS: 2008-May-04: - SWING Version 0.1.9 Released: CHANGELOG Added support to save new db credentials using F3 key in password field (Thanks Mir0) Fixed bug that was not recognizing DROP command Fixed bug that was crashing any user's SQLs 2008-Apr-24: - SWING Version 0.1.8 Released: CHANGELOG This release was coded at FISL (International Forum of Free Software), where Mir0 and me had opportunity to show to community the features of DBJMIN
- SWING Version 0.1.7 Released: CHANGELOG 2008-Feb-25: - SWING Version 0.1.5 Released: CHANGELOG 2007-Oct-15: - SWING Version 0.1.3 Released: CHANGELOG 2007-Apr-19: - DBJMIN is a new name to the old project DB2-JMIN. - SWING Version 0.1.0 Released: CHANGELOG - WEB Version 0.0.2 Released: CHANGELOG What is this? This is a open source MULTI-DB client. First, this software was intented to be a client just to DB2. A Web-Based/Desktop client (general-purpouse), inspired on phpMyAdmin. But after the first release several users asked to add support to other databases, so since version 0.0.9 the software have full support to DB2 (since version 8.1), MYSQL (since version 5.0), POSTGRESQL (since version 7.3), FIREBIRD (since version 1.5), DERBY Embedded and Network (since version 10.1) AND ORACLE (since version 10g). The Desktop/SWING version runs on X,Windows,etc. The Web-Based version runs on Tomcat 5.5. All versions NEEDs JDK 1.5. Main Features: - Multi-plataform - Pre-configuration of servers - Schema Browsing - Multiple OS (where DB is installed) support - Tables Browsing - Tables Structure - SQL Query editor (Multiple queries parser) Downloads: - DB-JMIN-SWING_0.1.9 - DB-JMIN-WEB_0.0.2 Source Code: - CVS console: cvs -d:pserver:anonymous@db2-jmin.cvs.sourceforge.net:/cvsroot/db2-jmin login - CVS web: http://db2-jmin.cvs.sourceforge.net/db2-jmin Downloads Stats: Pre-requisites:
How to install? (Web-based version [.war]) 1) To the current version (Web-based) you will need a Servlet/JSP Container, in this case you should use Apache Tomcat 5.5 or greater. 2) Uncompress DB-JMIN-WEB_0.0.2.tar.gz or DB-JMIN-WEB_0.0.2.zip. 3) With Tomcat installed you need to copy DB-JMIN-WEB.war inside webapps folder. 4) After these steps restart Tomcat. 5) Finally, point your browser to http://< tomcat-server >:< tomcat-port >/DB-JMIN-WEB/ (usually http://127.0.0.1:8080/DB-JMIN-WEB/) How to install? (Desktop [swing] version) 1) Uncompress DB-JMIN-SWING_0.1.0.tar.gz or DB-JMIN-SWING_0.1.0.zip. 2) After uncompress you will have the follow directory structure: DB-JMIN-SWING/ DB-JMIN-SWING/db2jminicon.png DB-JMIN-SWING/lib DB-JMIN-SWING/lib/db2jcc_license_cu.jar DB-JMIN-SWING/lib/db2jcc.jar DB-JMIN-SWING/lib/mysql-connector-java-5.0.3-bin.jar DB-JMIN-SWING/lib/ojdbc14.jar DB-JMIN-SWING/lib/derby.jar DB-JMIN-SWING/lib/derbyclient.jar DB-JMIN-SWING/lib/postgresql-8.1-407.jdbc3.jar DB-JMIN-SWING/lib/jaybird-full-2.1.0.jar DB-JMIN-SWING/db2jminicon.ico DB-JMIN-SWING/app DB-JMIN-SWING/app/db2jmin.pojo.jar DB-JMIN-SWING/start_db2jmin.sh DB-JMIN-SWING/start_db2jmin.bat DB-JMIN-SWING/CHANGELOG DB-JMIN-SWING/LICENSE DB-JMIN-SWING/README DB-JMIN-SWING/VERSION 3) Now you MUST assure that lib/ directory has the JDBC Drivers in order to have the follow directory structure: DB-JMIN-SWING/lib/db2jcc_license_cu.jar DB-JMIN-SWING/lib/db2jcc.jar DB-JMIN-SWING/lib/mysql-connector-java-5.0.3-bin.jar DB-JMIN-SWING/lib/ojdbc14.jar DB-JMIN-SWING/lib/derby.jar DB-JMIN-SWING/lib/derbyclient.jar DB-JMIN-SWING/lib/postgresql-8.1-407.jdbc3.jar DB-JMIN-SWING/lib/jaybird-full-2.1.0.jar 4) Open start_db2jmin.sh (UNIX-LIKE OSs) or start_dbjmin.bat (Windows OSs) and edit JAVALOCAL (just on .sh) and DBJMINLOCAL variables 5) Finally to start the application run start_dbjmin.sh (UNIX-LIKE OSs) or start_dbjmin.bat (Windows OSs). In case of start_dbjmin.sh you will need to give execute permission before run (chmod +x start_dbjmin.sh). 6) To make use of pre-configuration of servers (since version 0.1.5), just add your database's credentials into preServer.xml file located at root of installation. Note that tag type must be one of the valid database types (db2, mysql, postgre, firebird, derby, derby-e, oracle). Each line added into preServers.xml will appear inside type dropdown of application. See the example bellow:
7) To save a new configuration of server without open preServers.xml file, just type database's credentials into fields of application, then press F3 to store (since version 0.1.9). See an example bellow: 
Project Statistics: Screenshots (Web-based version [.war]):  (Connection Preferences Screen)  (Tables)  (Table Structure)  (SQL Area/Result) Screenshots (Desktop [swing] version):  (Connection Preferences Screen)  (Connected: Schemas, Tables, Structure, Sample Data and SQL query area)  (SQL query area) Support: To receive support or to inform bugs send an email to Jose Damico (  ) |
|
|
|
