Projects tagged ‘java’ and ‘sql’

hsqldb is a relational database engine written in Java with a JDBC driver that supports a subset of ANSI SQL:1999. It offers a small, fast database engine. Embedded and server modes are available. It includes tools such as a minimal Web server ... [More] , in-memory query and management tools (which can be run as applets or servlets, too), a test framework, PHP compatibility, Eclipse and NetBeans IDE compatibility, and a number of demonstration examples. [Less]

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

H2 is an SQL database engine written in Java. It is very fast and small (about 1 MB), and supports embedded, server, and clustering modes. A browser based console application is included. Disk based and in-memory tables and databases are supported. ... [More] Some of its features are transactions isolation, multi-version concurrency (MVCC), table level locking, encrypted databases, fulltext search, and strong security. The main API is JDBC, however ODBC and others are also supported via PostgreSQL network protocol compatibility. [Less]

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible.

Apache Cayenne is an open source persistence framework licensed under the Apache License, providing object-relational mapping (ORM) and remoting services. With a wealth of unique and powerful features, Cayenne can address a wide range of persistence ... [More] needs. Cayenne seamlessly binds one or more database schemas directly to Java objects, managing atomic commit and rollbacks, SQL generation, joins, sequences, and more. With Cayenne's Remote Object Persistence, those Java objects can even be persisted out to clients via Web Services. Or, with native XML serialization, objects can be even further persisted to non-Java clients - such as an Ajax-capable browser. [Less]

Simple yet Powerful Jdbc Tool for browsing Relational databases. DBClient provides both a convenient SQL Editor (highlighting, auto-complete, ...) and automated Browsing and Refactoring Actions (Select, Drop, etc...). Since release 0.3, it is massively based on Plugins architecture which makes it very extensible.

Open Source framework designed to build easily Web 2.0 applications, based on a "Client/Server" principle, using J2EE (Servlet, JSP, JDBC), lightweight clients and AJAX technology (XML requests via HTTP)

Hibernate Spatial is a generic extension to Hibernate for handling geographic data. It is generic in the sense that it works in the same way across different databases. Hibernate Spatial allows you to deal with geographic data in a standardized ... [More] way, whatever database that you use (as long as a Spatial Dialect Provider exists for it). In other words, it abstracts away from the specific way your database supports geographic data, and provides a standardized, cross-database interface to geographic data storage and query functions. Hibernate Spatial supports most of the functions of the OGC Simple Feature Specification. [Less]

HiveDB is an open source framework for horizontally partitioning MySQL systems. HiveDB uses a partition-by-key scheme to manage sharded data stored in separate MySQL databases. Out of the box HiveDB supports simple JDBC or HIbernate via HIbernate Shards.

The PoolMan library and JDBC2.0 Driver and DataSource provide a JMX-based, XML-configurable means of pooling and caching Java objects, as well as extensions for caching SQL queries and results across multiple databases.

SDO JSR-235 Implementation

My Money is a high quality personal financial software written from ground up to work with online bank statements. Simply download your transactions from bank web site and they are automatically entered into electronic register. My Money: - ... [More] Instantly organizes financial records.Eliminates errors. - Categorizes expenses automatically for business, taxes, budgeting. - Eliminates Manual bookwork, simply download and import your statements from a bank website - Reconciles your bank statement for you. Actually finds and fixes mistakes - Transfers your reports into PDF, OpenDocument or Microsoft Excel formats - Works with all US and Canadian Bank statements out of the box - Works with Microsoft Money files - Works with Quicken files [Less]

CDO Model Repository ===================== CDO is both a technology for distributed shared EMF models and a fast server-based O/R mapping solution. With CDO you can easily enhance your existing models in such a way that saving a resource ... [More] transparently commits the applied changes to a relational database. Optionally other connected clients are actively notified about these changes so that their model copies get partially invalidated and all user interfaces reflect the current state at once. Stored resources are demand-loaded from the database only as needed. CDO uses the Net4j technology as a flexible and scalable signalling backbone. [Less]

Java Desktop SQL Database Engine with JDBC 3.0 API. SmallSQL is small, fast, embeddable, SQL 99 conformance, platform independent and 100% pure Java

XMLToaster is a two way database to XML mapping tool. It maps XML messages directly into database tables and extracts data into XML documents. It uses a simple SQL "select" like statement to extract data into XML documents of arbitrary ... [More] complexity. It scales to handle very complex mappings such as might be found when extracting from a legacy database into an ESB service catalog. Persistence is currently through an XML mapping file, shortly to be replaced by more user-friendly SQL style update statements. The persistence engine is also capable of handling enterprise level requirements. Key features: - Simple XML message generation from a database. - Quick and easy persistance of XML messages to the database without the traditional coding overhead. It specialises in handling very complex mappings of XML to tables. [Less]

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or configuration files. Data can be imported from and ... [More] exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]

The purpose of DO.rb is to rewrite existing Ruby database drivers to conform to a single interface. At present, PostgreSQL, MySQL, and SQLite adapters are available.

Closed L2J Faction Server Project based of L2J Free

jDBI is designed to provide convenient tabular data access in Java(tm). It uses the Java collections framework for query results, provides a convenient means of externalizing sql statements, and provides named parameter support for any database being used.

Model-based data export tool. Exports consistent, referentially intact row-sets from relational databases. Removes obsolete data without violating integrity. DBMS agnostic (JDBC). Generates hierarchically structured XML and topologically sorted SQL-DML.

Beginning of a JPDA-based integrated debugger (as an Eclipse plugin) for mixed-language applications. The proof-of-concept allows seamless stepping through from Java code into PL/SQL stored procedure and back.

A Java Servlet based generic game tournament pool bracket tracking application suitable especially for the NCAA basketball championship tournament. Features include bracket enterring, multiple scoring systems, multiple users, groups, pools, etc.

A database for a publishing house as a project for the University of Applied Sciences in Saarbrücken realized using Swing, JDBC and SQL Server 2005.

This is a new intiative to develop a unique Dashboarding application. The development will be in PHP. The studio will allow to connect to any database and Excel files. It will allow you to create reports and Dashboards. Dashboard Studio will be able ... [More] to import dashboard definitions directly from InfoCaptor Designer. It will also have in-built role and security mechanism. This will be a totally new application from InfoCaptor which is a java based Dashboard application. [Less]

Squiggle is a little Java library for dynamically generating SQL SELECT statements. It's sweet spot is for applications that need to build up complicated queries with criteria that changes at runtime. Ordinarily it can be quite painful to figure out ... [More] how to build this string. Squiggle takes much of this pain away. The code for Squiggle is intentionally clean and simple. Rather than provide support for every thing you could ever do with SQL, it provides support for the most common situations and allows you to easily modify the source to suit your needs. FeaturesConcise and intuitive API. Simple code, so easy to customize. No dependencies on classes outside of JDK 1.5 Small, lightweight, fast. Generates clean SQL designed that is very human readable. Supports joins and sub-selects. Combine criteria with AND, OR and NOT operators. Supports functions in selects and WHERE criteria ExampleHere's a very simple example: SelectQuery select = new SelectQuery(); Table people = new Table("people"); select.addColumn(people, "firstname"); select.addColumn(people, "lastname"); select.addOrder(people, "age", Order.DESCENDING); System.out.println(select);Which produces: SELECT people.firstname , people.lastname FROM people ORDER BY people.age DESCNow continue with the Tutorial... [Less]

this is sample code of Martin Fowler's 'Domain Logic and SQL' for Java Martin Fowlerさんの「ドメインロジックとSQL」という記事で示されたRubyサンプルコードをJavaで書き直しました。 データベースはPostgreSQLを前提としてます。

FAnAD - Ferramentas Analíticas para Administração de Dados Sabemos que as equipes de administração de dados além de administrarem acesso e regras sobre os bancos. VPU - Verificação de Permissões entre Usuários.

It's a code generation tool. In particular, it generates a persistence layer implementation from an already-deployed relational model. In ACM we weren't satisfied with the effort JDBC-based manual implementations require, as well as their average ... [More] reliability and performance: the time they consume adding almost no value, and the severity of the problems they can produce (connection or cursor leaks, to name a few). [Less]

sql2code is a code that generator C++/Java/python/ruby and even sql file from a sql description xml file Until now, sql2code is still under developing. For preview the developing plan, you could check RoadMap. And the ToDo list present our plan ... [More] in a more detail view Advanced Extremely reduce amount of codes you write. Spread and unify good coding standard and experience all around Easily modify data model, without discordancy in codes Usage Go to Usage for more details [Less]