Java201.com

• Working with Large Object Datatypes by John O'Donahue   - [Clicks: 22]
  JDBC supports large objects like ARRAYs, BLOBs, CLOBs, and Structured types in addition to the usual datatypes. See how to use locators to streamline data access in applications.
  http://www.fawcette.com/javapro/2004_01/magazine/features/jodonahue/ - Dec, 2003
• SQuirreL SQL Client: A Single, Open Source Front End to Interact with Your Heterogeneous Database Environment by Kulvir Singh Bhogal   - [Clicks: 32]
  This article describes an open source application called SQuirreL SQL Client that provides an easy-to-use interface to DB2 UDB as well as a number of other vendor databases like Oracle and SQL Server. If your job requires you to interface with many different databases in the course of a day, this may be the tool for you.
  http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0312bhogal/index.html - Dec, 2003
• JDBC-ODBC Bridge Driver Enables Spreadsheet-as-database Interaction by Kulvir Singh Bhogal   - [Clicks: 61]
  Java APIs such as Apache Jakarta POI allow applications to programmatically modify Microsoft Excel spreadsheets but only on a cell-by-cell basis. Using JDBC in conjunction with ODBC, Java programmers can interact with Excel spreadsheets as if they were databases.
  [Includes source code]
  http://www.devx.com/Java/Article/17848 - Nov, 2003
• Give your DB a Break by Dion Almaer   - [Clicks: 24]
  Learn how caching data in front of the database can allow for faster running, and more available applications. In this article, Dion Almaer looks at clustering and caching strategies, using a distributed cache, read-through/write-behind caching, and technologies that integrate nicely into a distributed caching architecture such as JDO, JMS, and JNDI.
  http://www.theserverside.com/resources/article.jsp?l=DB_Break - Oct, 2003
• SQLExecutor - A Simple, Open Source JDBC Framework by Jeff Smith   - [Clicks: 21]
  Since developers can learn to use this simple framework in about five to ten minutes, it is worth their investment in time to reap the rewards of concise and readable code. Moreover, with the database independent exception code, it is easy to port applications to additional databases and to determine the root cause of database exceptions without resorting to ugly if else or switch statements in a catch block.
  http://www.theserverside.com/resources/article.jsp?l=SQLExecutor - Sep, 2003
• Stored Procedures for Java Programmers by Nic Ferrier   - [Clicks: 28]
  This article explains how to use DBMS stored procedures. I explain the basics and some advanced features such as returning ResultSets. The article presumes you are fairly familiar with DBMSs and with JDBC. It also assumes you're fairly comfortable reading code in a foreign language (that is, not Java), but does not expect any previous stored procedure experience.
  http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html - Aug, 2003
• Bridge your database to XML with Java and XML-DBMS by Peter V. Mikhalenko   - [Clicks: 16]
  XML-DBMS is a middleware product that allows database-to-XML conversion, even for non-XML databases. See how you can implement XML-DBMS using Java.
  http://builder.com.com/5100-6370-5054852.html?tag=sc - Jul, 2003
• Format Java-extracted data using DOM and XSL   - [Clicks: 15]
  Java can pull data from a database rather easily, but formatting it into something useful is another matter. See how to take Java-captured data, load it into a DOM document, and use XSL style sheets to format the data into any fashion you require.
  http://builder.com.com/5100-6370-5055034.html?tag=sc - Jul, 2003
• Extract XML/DOM-friendly data from a JDBC-compliant database   - [Clicks: 17]
  Java can programmatically extract data from any JDBC-compliant database, but performing this task so that both XML documents and DOM objects can use the data is a bit tricky. See how to create a Java interface to produce XML- and DOM-friendly ResultSets.
  http://builder.com.com/5100-6370-5054643.html?tag=sc - Jul, 2003
• JDBC Today by Art Taylor   - [Clicks: 10]
  See why the Java Database Connectivity (JDBC) API represents the tool of choice for Java applications to access data from relational databases by exploring JDBC design, object databases, and modern programming.
  http://www.informit.com/isapi/product_id~{590B0966-06D5-4C45-8A7D-11879744F962}/session_id~{}/content/index.asp - Apr, 2003
• SQLExecutor: A Simple JDBC Framework by Jeff Smith   - [Clicks: 18]
  A good JDBC framework can eliminate many of the problems associated with executing SQL statements in J2EE.
  http://www.developer.com/db/article.php/2189471 - Apr, 2003
• Five Paths to Persistence by Daniel F. Savarese   - [Clicks: 19]
  Java provides several mechanisms for retrieving and storing data, but it's your application's requirements that should dictate your choice. Take a look at five possibilities and how to use them.
  http://www.fawcette.com/javapro/2003_02/magazine/features/dsavarese/ - Feb, 2003

[Top]

• TSS Surveys: A Report on JDBC and XML Usage   - [Clicks: 4]
  What JDBC 3.0 features matter? Are many developers storing XML data directly in the database? On behalf of the data connectivy company, DataDirect, we recently emailed a small group of TSS subscribers to take part in a survey on their JDBC and XML usage habits. The results were interesting enough that we decided to publish them here for everyone's benefit. This is the first of many more surveys to come, which will hopefully be useful to the community.
  http://www.theserverside.com/resources/surveys/reports/jdbcsurvey/index.jsp - Oct, 2003

[Top]

• Java Tip 143: Utilize the Database Schema Browser by Saurabh Singh   - [Clicks: 9]
  The Database Schema Browser utility eases the task of database lookup by providing users with a consolidated list of tables and their definitions with one simple hit to the servlet. What's more, you can use the browser's print options to print out a handy database reference. This tip highlights how you can use Java Database Connectivity (JDBC) APIs to create a simple database utility. It's a first step towards building more complex utilities like code generators and SQL browsers.
  http://www.javaworld.com/javaworld/javatips/jw-javatip143.html? - Oct, 2003

[Top]