Free jdbc software for linux

Jagzilla is simply the Java version of bugzilla. The idea of this project is:
- To provide a complete java-based interface to bugzilla
- To facilitate interoperation between bugzilla and java based apps
- To provide additional functionality to bugzilla while mantaining compatibility
Main features:
- Bugzilla and java based apps integration
- Bugzilla and eclipse integration (with the eclipse plugin)
- Bugzilla and cvs integration (with the eclipse plugin)
- Bugzilla extended functionality mantaining backwards compatibility (with jagzilla extension tables)
Components:
Hibernate Mapping
- This components includes java classes that represent rows in bugzilla tables, as well as mapping files. This provides direct hibernate access to bugzilla database.
Jagzilla Core API
- The core api is a higher abstraction level than hibernate mapping, which understands buisiness logic and provides an easy access to this funcionality.
Jagzilla Web Services API
- The web services API is actually the core api implementation which uses xml and http as transport. see rest-webapp
WS Client lib
- This is a simple jar to enable easy access to jagzilla WS from any java app.
Jagzilla mail processor
- A program to read email accounts and add bugs to database with information found on these mails.
Hibernate Client lib
- This is a simple jar to enable easy access to jagzilla Core API from any java app.
Eclipse plugin
- This plugin enables using most functionallity of jagzilla. The access can be with hibernate and JDBC (directly to the database) or via web services.
Webapp
- This is the web frontend for jagzilla. This web application shows how to use the jagzilla backend to provide a java web based front-end.
REST Webapp
- This web application is the server for the web services (in a simple sense of xml over http) interface.

JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create indexes.

This small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files.

Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.

This tool can be very useful when you have a big volume of queries that you need to analyze not one by one (meaning that the specific time isnt that much of interest), but rather when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.

The Swing GUI was based on Apaches Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.

Panther is a lightweight, modular Java application server, suitable for embedding in a web server.
The intention of the project is not to duplicate all the functionality found in a J2EE app server, rather just some of the most commonly used features (Note: panther was formerly known as Wicker).
1. Panther is not trying to be a full application server, rather it provides a limited subset of services that most app servers provide.
2. Most app servers seem to be huge monolithic behemoths where its all or nothing. If you want one service, then you pretty much need them all. Even where you can modify the configuration to only include the services you require, based upon our experience, many projects dont.
3. Many projects only use a microscopic subset of the features an app server provides. This is particularly true if you want to be cross-appserver/cross-platform, so a modular app server, where you include the bits you want, makes a lot of sense (at least to us). This is, of course, rather similar to the argument certain luminaries have used in the past against the feature bloat in Office software like Word.
4. There isnt another open source app server out there that does what we want (or that we could get working just the way we wanted).
Main features:
- A Stateless Session Bean container.
- Note 1: SSBs were not pooled prior to version 0.9.1, so there -was- a single instance of each EJB in the container. There didnt seem to be any overhead/negative impact doing things this way, except that the beans are truly/completely stateless -- if youre writing code with this is mind, then you shouldnt have any problems, but we recommend using the latest release anyway.
- Note 2: At time of writing only the ejbCreate method has been implemented in panther (the other ejb* methods are not currently called).
- deployment and configuration by Jython
- transaction manager -- linked to the data source service. This only works with JDBC data sources, and has only been tested with Postgres so far. (Note, transactions do not cross VM boundaries.)
- a basic messaging service (multicast, broadcast and lightweight reliable multicast options available)
- jdbc distributed caching service, codenamed c3d -- basically a jdbc driver that caches selects to reduce load on the database and to improve performance (slightly)
- a python-scripted (well, jython) telnet management console
- example mail and datasource (using Jakarta DBCP) python scripts are also included
Version restrictions:
- You cannot currently pass parameters to ejbCreate, or indeed include parameters in your home create methods.
- transaction support is currently extremely limited. The transaction manager is a basic service written to get us going -- "Required", "Supports" and "NotSupported" should (hopefully) work as advertised, anything else (i.e. "RequiresNew") may get unpredictable results. Were working on the transaction service at the moment.
Enhancements:
NOTES
- Fix a bunch of bugs I discovered this morning with the build process, demo, etc
CHANGES
- Reorganised the doc directory. Moved example files to doc/examples
- added jetty.sh, start.sh and stop.sh, to be used for running jetty5. Create a bin dir in $JETTY_HOME, put both files there (along with panther in the root of jetty home) and run start.sh to use.
- tidied up readme.txt
BUG FIXES
- added a Makefile for the simple demo. Fixed a bug with the ant build. Moved the jsp to a plain servlet
- distribution tars werent created with the correct directory (shouldve had a root panther dir).

ShellRaptor is a simple command-line SQL utility and editor. ShellRaptor project supports any database for which you can provide a TYPE-4 JDBC driver.
Such databases include Oracle, Informix, DB2, MySQL, SQLServer, HSQLDB, and ODBC.
Enhancements:
- The ability to load both .jar and .zip libraries is now included.
- A new feature allows for the loading, creation, execution, and saving of PreparedStatements.
- "load-ps [file]" loads an XML prepared statement file.
- "init-ps [name] [prepared statement]" creates the prepared statement.
- "list-ps" lists the alias names of all available prepared statements that are available.
- "exec-ps [alias] [args1], [args...n]" executes the prepared statement and uses the given values.
- "save-ps [output file]" saves the prepared statements in memory in an XML format.

db2dot reverse engineers an existing database and produces an ER diagram in dot format.

The dot file can be fed through graphvizs dot to produce a pretty ER diagram. The diagram includes tables and relationships derived from db meta-data and foreign key constraints.

What format is the output?

It generates a dot file which can be turned into a diagram with the graphviz utility.

What database servers will it work with?

It has only been tested with MySQLs JDBC driver, but it uses only
generic java.sql.* classes so it should work with any JDBC driver which is
sufficiently advanced.

What license is the code released under?

db2dot is released under the GPL v2.0 license.

How do I build the source?

Run: ant build jar

What are the command line arguments?

The command line arguments may be in any order, the following are required:

driver=< JDBCDriver class >
url=< db connection url >
user=< db user name >
pass=< db password >

The following are optional:

+showRelations
+showColumns

Dinamica project is a powerful and very easy to use framework for J2EE Web development. Its newbie friendly and was built from scratch to be a high productivity framework for building business-oriented Web applications, whether they are large-scale or smaller ones.
It stands apart from other Java MVC frameworks because it incorporates innovative programming techniques that boost productivity without sacrificing good object oriented design practices. Most common programming tasks can be completed without writing a single line of code.It uses Servlet API 2.3 and does not require JSP or TagLibs.
Main features:
- Centralized request control via powerful MVC mechanism
- Data-driven application behavior - declarative programming style
- Integrated performance log - no coding required (request, MVC and JDBC level)
- Centralized error handling with configurable email notifications
- Complete and real separation of presentation from business logic
- Powerful page composition with reusable HTML parts
- Automatic and flexible form validation - extensible via simple plugins
- Effortless international support
- Declarative Server-side charts (with JFreeChart)
- Server-side PDF reports (with IText)
- Easy Blob management (save, retrieve and display)
- Fully encapsulated JDBC facilities - automatic persistence
- Disconnected Recordsets - efficient abstraction that eliminates O-R mapping
- Transparent and declarative JDBC transactions control
- Includes a complete security system with administrative web based console
- Built-in support for Hessian Web Services
- Built-in support for SOAP-based Web Services
- Built-in support for HTTP tunneling
- Built-in support for consuming RSS feeds
- Built-in support for publishing simple REST services
- Integrated AuditLog API
- Fully documented (26+ PDFs), with a complete collection of How-to and Step-by-Step guides
- Extensible in many ways via Plug-Ins
- Abundant template code and pre-built solutions
- Free support available
- Includes a Code Generator, that auto-generates SQL, HTML and Java code, reads metadata from your database to generate code, it also creates documentation from your application configuration files.
Enhancements:
- This release adds better support for code-free Oracle BLOBs management (tested with Oracle 9i R2), a new generic class and complete reusable solution template, and enhanced generic recordset capabilities.

Schema Crawler project is a platform (database and OS) independent command-line tool to output your database schema and data in a readable form.
The output is designed to be diff-ed with previous versions of your database schema. Schema Crawler is also an API that improves on standard JDBC metadata.
Build
Ant Build
The ant build is a quick build that builds the Schema Crawler jar without compiling and running unit tests. Download ant, and run it from the Schema Crawler directory. The jar file will be created in the _distrib directory. The main targets are all.build and all.clean.
Maven Build
The maven build is a more comprehensive build that runs unit tests, and also creates the project web-site. Download maven, and run it from the Schema Crawler directory. The jar file will be created in the _distrib directory. The main goals are all.build and all.clean.
Eclipse
Schema Crawler consists of two Eclipse projects, dbconnector and schemacrawler. Since schemacrawler depends on dbconnector, you will need to import both projects into Eclipse.
Enhancements:
- Database properties are now retrieved, along with column data types, both system data types, and UDTs.
- A new command, maximum_schema, gives all possible details of the schema, including database system properties.
- Bugs with the merge rows option and with appending output for multiple runs of SchemaCrawler are fixed.
- An SQL exception with the Oracle Database 10g Express Edition driver on outputting views is fixed.

IrssiBot is an IRC bot written in pure Java. IrssiBot is a powerful IRC automation - a "bot" - that was written for my personal needs & fun in summer/fall 2000. It is written in 100% Java, giving it advantages to traditional platform dependent counterparts in flexibility and ease of development.
IrssiBot is released under GNU Public Licence (GPL). A newest version of both source and binaries is downloadable, and possibly some older versions also. Required Java Runtime Environment 1.3.1 or newer may be downloaded from Sun Microsystems.
The latest MySQL JDBC driver may be downloaded from here.
Main features:
- Multinetwork support
- Configuration data as standard XML
- Dynamically (un)loadable java .class modules
- Built-in ability to "connect" channels, even across networks
- Effectiveness through simplicity; easy to configure and use
- Platform independent: runs anywhere required Java Environment is installed.
Enhancements:
- removed IrcMessage object reuse causing problems with message muxing