vdbc

Overview

This is yet another JDBC database manager web-application. It should be deployable to any modern servlet container. Known to work in Apache Tomcat 7, Glassfish 3.1 and JBoss 7.

General Features

Connect to a database via JDBC
Connect to JNDI datasources
Run SQL queries
Browse database objects
View database metadata information

Requirements

Servlet container (Servlet API 3.0+)
JRE 1.7+

FAQ

Q: What is the current status of the project?
A: It is work-in-progress. Stable builds will be regularly published.

Q: Will you keep developing the project?
A: Hopefully, yes. Anyway, you know what happens to the most of such projects: there's always risk of being abandoned.

Q: How to run it?
A: Download featured tomcat-vdbc bundle, unzip it and run startup.sh or startup.bat depending on what operating system you use. Also make sure you have set your environment properly:
- variable JAVA_HOME must point to a JDK root directory if you have JDK installed
- variable JRE_HOME must point to a JRE root directory if you have JRE installed
Then open http://localhost:8080/vdbc/ in your browser.

Q: What database management systems are supported?
A: A DBMS is supported if it provides JDBC-compliant driver. H2 driver is already packaged. Add your driver jars to $TOMCAT_DIR/lib (in case of using featured tomcat package) or wherever your container expect these jars to be.

Q: Where are the connection profiles stored?
A: Connection profiles are stored in the vdbc-settings.xml file in your home directory ($HOME/.config/vdbc/vdbc-settings.xml). You are encouraged to use built-in settings manager to edit connection profiles.

Q: How to disable settings editor?
A: To disable settings editor you should provide a value for "vdbc.settings.editor-enabled" system property. E.g. for Tomcat you can create $TOMCAT_DIR/bin/setenv.sh file with the following content:
```
CATALINA_OPTS="-Dvdbc.settings.editor-enabled=false"
```

Q: Have anybody ever asked you these questions?
A: No. But it's nice to have a FAQ section.

Screenshots