DBJMIN (STABLE SWING: version 0.2 / STABLE WEB: version 0.0.2)

real size dbjmin screenshot

LATEST NEWS:

2008-May-20: Version 0.2 Released!
This version is one of the most important since the beginning of project. It is a mature release for day-to-day users of DBJMIN.
Several bug fixes were done, also, new interface improvements were implemented as well as builds of RPM and DEB packages. The manual installation on Linux was improved too.
Many return messages were redesigned and a better integration with Linux environment was added.
For more info, check the CHANGELOG.
Special thanks to Juliano Martins for all suggestions and feedback for this release.


deb pkg rpm pkg
tar gz pkg zip pkg


All packages were tested into Debian 4 (i386/AMD64), Fedora 8, OpenSuse 10.3, Slackware 12 and Windows XP.


User's screenshot:

Razec's screenshot
Sent by Razec

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
DBJMIN Team at FISL 2008 DBJMIN Team at FISL 2008
Thanks, David Kwast for the images.
2008-Apr-16:
- 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:


deb pkg rpm pkg
tar gz pkg zip pkg


All packages were tested into Debian 4 (i386/AMD64), Fedora 8, OpenSuse 10.3, Slackware 12 and Windows XP.


- 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:

downloads stats

Pre-requisites:

Software:Description:Web-based:Desktop:
Java:Java Runtime Environment Version 5.0
(http://java.com/en/download/manual.jsp)
YESYES
Servlet Container:Apache Tomcat >= 5.5
(http://tomcat.apache.org)
YESNO
DB2 JDBC Driver:IBM DB2 Driver for JDBC (type 4)
(http://www-306.ibm.com/software/data/db2/java/)
YESYES
MYSQL JDBC Driver:MySQL Connector/J 5.0
(http://dev.mysql.com/downloads/connector/j/5.0.html)
NOYES
POSTGRESQL JDBC Driver:POSTGRESQL JDBC 3
(http://jdbc.postgresql.org/download/
postgresql-8.1-407.jdbc3.jar
)
NOYES
DERBY JDBC Driver:DERBY COMPLETE PACKAGE
(http://db.apache.org/derby/derby_downloads.html)
NOYES
FIREBIRD JDBC Driver:JAYBIRD
(http://prdownloads.sourceforge.net/firebird/
JayBird-2.0.1JDK_1.5.zip?download
)
NOYES
ORACLE JDBC Driver:ORACLE 10g JDBC
(http://www.oracle.com/technology/software/
htdocs/distlic.html?url=http://www.oracle.com/
technology/software/
tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
)
NOYES

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)

0) On Linux the best way to install is use one of packages (.deb or .rpm) or even use the install-sh script. If you are using Windows, try first the dbjmin.exe. But for any cases BE SURE to have JRE >= 1.5 installed and configured at your PATH.

1) If you want to continue with manual installation, go ahead with the follow steps:
Uncompress dbjmin-<version>.tar.gz or dbjmin-<version>.zip.

2) After uncompress you will have the follow directory structure:

dbjmin-<version>/
dbjmin-<version>/install-sh
dbjmin-<version>/dbjminicon.png
dbjmin-<version>/lib
dbjmin-<version>/lib/db2jcc_license_cu.jar
dbjmin-<version>/lib/db2jcc.jar
dbjmin-<version>/lib/mysql-connector-java-5.0.3-bin.jar
dbjmin-<version>/lib/ojdbc14.jar
dbjmin-<version>/lib/derbyclient.jar
dbjmin-<version>/lib/postgresql-8.1-407.jdbc3.jar
dbjmin-<version>/lib/jaybird-full-2.1.0.jar
dbjmin-<version>/dbjminicon.ico
dbjmin-<version>/app
dbjmin-<version>/app/db2jmin.pojo.jar
dbjmin-<version>/start_db2jmin.sh
dbjmin-<version>/start_db2jmin.bat
dbjmin-<version>/LICENSE
dbjmin-<version>/README
dbjmin-<version>/VERSION

4) Finally to start the application run start_db2jmin.sh (UNIX-LIKE OSs) or start_db2jmin.bat (Windows OSs). In case of start_db2jmin.sh you will need to give execute permission before run (chmod +x start_db2jmin.sh).

5) If you want to run directly from java, java -jar app/db2jmin.pojo.jar should work once you have all jars from lib/ folder into you classpath.

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:

<PRESERVERS>
        <SERVER type="db2" host="127.0.0.1" port="50000" dbname="TEST" user="user1"/>
        <SERVER type="mysql" host="127.0.0.1" port="3306" dbname="myDB" user="user2"/>
</PRESERVERS>


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:

save a new db credential



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 ()


SourceForge.net Logo
Back to jd.comment
hacker emblem