A Brief Introduction to JDBC.
This article provides a brief introduction to JDBC. Explains
what is JDBC and how it can be used to access RDBMS. Provides a
brief overview of JDBC architecture.
Accessing Databases Using Java and JDBC
This article will show how a Java Application, Applet or Servlet can access data stored in relational databases using the JDBC API. Although this article will use mSQL as the example database, you could use any other databases that have JDBC interfaces. These include DB2, Oracle, Sybase, Solid and many others.
An easy JDBC wrapper
This article describes a simple wrapper library that makes basic database usage a snap. You'll find yourself wanting to use JDBC for every program you write.
Best performance practices for SDO and the JDBC DMS
This article shows you how to obtain the best performance from SDO and the JDBC DMS, by keep your metadata models as small as possible, ensuring that the most efficient SQL queries are being used, and by using static SDO models whenever possible.
Build an object database
In this first of two articles, we look at implementing an
object database frontend -- that is to say, a database frontend
that can automatically map between Java objects and records
within a relational database. Using this frontend you can, for
example, store Java User objects in a relational database,
where they will be automatically and transparently mapped
between the native Java object representation and, for example,
name, age, and gender fields within the database backend.
Build an object database, Part 2: Object storage backend
In the second of this two-article series, we implement relational database storage for the object-storing framework we developed last time. We then specialize it to support the open source MySQL database. Next, we plug the MySQL relational storage implementation into the object-storing framework and let it do its thing.
Connecting to a Database with JDBC
Create an application that demonstrates how to use JDBC to connect to a Microsoft Access database. This article is intended for someone just learning an object-oriented language and who wants to understand the basic concepts before jumping into the code, or someone who wants to understand the infrastructure behind an object-oriented language he or she is already using.
Connecting to a Database with JDBC
In this article, you will explore the ways to connect your Java applications to a database using Java Database Connectivity (JDBC). In this specific case, you will connect to a Microsoft Access database and utilize several aspects of JDBC functionality.
Connecting to a MySQL Database using Connector/J JDBC Driver.
A tutorial on how to connect to a MySQL Database using Connector/J JDBC Driver. Explains what are database URLs? Why and how to specify JDBC driver names? Then moves on to write a simple Java program to connect to a MySQL database server. Explains all the code in detail.
Derby database development with Apache Ant
The open source Derby database engine provides developers with
a powerful new tool for lightweight database development. Derby
databases are file system based and portable across different
types of systems. Because of this, a common strategy is to
create databases at development time and ship them with the
binary distribution as opposed to having it created on the fly.
Get Groovy with JDBC programming
Development is distinctively breezy with Groovy, and its lightweight syntax can alleviate some of the verbosity of JDBC in Java. This article shows you how to use GroovySql to build a simple data-reporting application. GroovySql combines closures and iterators to ease Java Database Connectivity (JDBC) programming by shifting the burden of resource management from you to the Groovy framework itself.
Getting Up To Date with JDBC API
Object Computing covers the JDBC 3.0 specification in its proposed final draft form, which promises to add more robust transactions by way of savepoints, a number of resource pooling enhancements, retrieval of auto-generated keys and a lot more.
Insider look at the Java type 4 JDBC Driver for Linux
Discover the latest step in the evolution of Java application development using DB2 Universal Database for Linux, UNIX, and Windows. Get an insider view of the JDBC Universal Driver, the clear advantages to using a pure Java type 4 driver, and examine common debugging techniques that will help you get to the heart of any problem.
Introduction to SQLJ
Want to write less code within your Java applications that deal with SQL calls to a database? Would you like your SQL statements to be checked during compilation and not runtime? Then SQLJ just may be what you need! SQLJ gives exactly what you need for quick development, with less code, ease of debugging, and automatic performance improvement.
Introduction to SQLJ
Want to write less code within your Java applications that deal with SQL calls to a database? Would you like your SQL statements to be checked during compilation and not runtime? Then SQLJ just may be what you need! SQLJ gives exactly what you need for quick development, with less code, ease of debugging, and automatic performance improvement. This article is part of the SQLJ series. This article assumes you have basic knowledge of JDBC and some of its methods, as well as some SQL. If you want to refresh your JDBC knowledge, have a look this article JDBC Basics.
Learn the Secrets to DB2 Java Performance Problems
This article brings insight into diagnosing and isolating performance problems from the application client perspective. You'll learn how to troubleshoot performance problems that occur with Java applications running against IBM DB2 for Linux, UNIX, and Windows databases.
Manage distributed JTables
When displaying tables with tens of thousands of rows (or more), it is imperative they quickly respond and display. One way to achieve this is by using a specialized TableModel that retrieves data from a server only when it is required, thereby minimizing data download. To further improve efficiency, row data can be retrieved in chunks of 50 rows and cached on the client side for future use. This article explains how to write such a distributed table and presents some of its advantages.
Modeling a database with Rational XDE Developer for Java
A data model provides application developers a much better understanding of the overall application architecture, even though generally speaking they are not required to know in-depth about database architecture details. A database designer can use a tool like Rational XDE to model and visualize the database, ensure database rules, add different database objects, and play around with relationships. This article shows you the basics of how to model a DB2 database using Rational XDE Developer for Java.
Object persistence and Java
Understanding the difference between persistence as a general issue and persistence as part of a larger collection of database services is quite important -- the former being much simpler to implement than the latter. In this article, we'll call attention to some of the prominent issues surrounding persistence in object-oriented languages, including the relationship between persistence and type, persistence and platform/language independence, and navigational versus query-based access to object data. We'll also take a close-up look at how Java itself handles object persistence and how one object database enhances Java persistence by offering transaction support
Open Source Java Reporting with JasperReports and iReport
JasperReports is a powerful and flexible open source reporting solution. The iReport visual designer enables you to take advantage of the full power of JasperReports without in-depth knowledge of the JasperReports native XML format.
Practical data binding: Get your feet wet in the real world
Data binding, although commonplace in today's world of Java technology and XML programming, is still largely misunderstood. This column throws out all the theoretical claptrap and focuses on the concepts you need to get started with data binding. You will understand the differences between general data binding and data binding in the XML world, as well as round-tripping, semantic equivalence, and what to look for in a data binding package.
Three ways to connect a database to a Geronimo application server
Follow along using the included example application and a downloadable Eclipse IDE project to learn how to hook things up and get your application talking through a JDBC connection pool deployed in Geronimo. You can use any of three JDBC methods to connect a database to a Geronimo application server.
Tired of hand coding JDBC?
There is an object relational mapper out there that is a hidden gem. Instead of creating a full domain model, its job is to map Java objects directly to SQL statements. This framework is called iBatis, and its goal is to implement 80% of the JDBC boilerplate code you would otherwise have to do yourself. In addition, it provides a simple mapping and API layer that lets developers quickly develop data access code. This article explains how iBatis can help you.
Tuning JDBC: Measuring JDBC performance
Java Database Connectivity (JDBC) is used extensively by many Java applications. In this article, the first of a series on performance-tuning JDBC, I look at how to measure the performance of JDBC and how to identify which parts of your JDBC subsystem need optimizing.
Undo Tablespace in Oracle 9i
Oracle Database keeps records of actions of transactiion, before they are committed and Oracle needs this information to rollback or Undo the Changes to the database. These records in Oracle are called Rollback or Undo Records. And here you'll find some information about these doings.
Use a RandomAccessFile to build a low-level database
This month, Step by Step's newest contributor, Derek Hamner,
shows you how to use Java's low-level file access to build a
simple database. He uses a RandomAccessFile to store and
retrieve arbitrary record data, allowing serializable objects
to be persisted to a file and then later retrieved via their
key. He wraps up with a demonstration of how his example can be
used in real-world applications.
Use Stored Procedures for Java Persistence
Find out why you should use stored procedures to build your Java persistence layer instead of embedded SQL, entity beans, or tools such as Hibernate. Then learn how to do it.
Using a Generic SQL Entity EJB Wrapper to Simplify EJB Development
This article shares a design pattern that generalizes the use of entity EJBs to simplify EJB development. The design pattern retains the intuitive SQL interface, yet delivers the reusability and built-in distributed transaction support of EJBs. Many common cases can be handled. Because it is generalized, it can be used for automatic code generation. Given a database table, the bottom-up approach can generate code from Container-Managed Persistence (CMP) entity beans, session beans, up to a Java Server Page (JSP) or even a Web service.
Using Object-Oriented Databases: A Step-By-Step Tutorial
This article walks you through the evolution of a simple application from a pure Java app to an OODB-enabled Java app. The author demonstrates how to create the database on the fly and give ou the source code for the whole solution.
Write Java Apps with purQuery Inline Method
IBM pureQuery is a high-performance Java data access platform focused on simplifying the tasks of developing and managing applications that access data. This article introduces the pureQuery inline method programming style, and discusses how users can use it to efficiently query and update databases. Also explore benefits and key features of using the inline method.
Computerworld The most comprehensive source of news and analysis on the technologies and management issues of information technology. ...
subscribe now
Files
