<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="4. Sample ODBC & JDBC Applications" />
<meta name="dc.subject" content="4. Sample ODBC & JDBC Applications" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="sampleapps.html" title="Chapter Contents" />
<link rel="prev" href="quicktours.html" title="Quick Start & Tours" />
<link rel="next" href="binsrcloc.html" title="Binary & Source File Locations" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>4. Sample ODBC & JDBC Applications</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="sampleapps" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>4. Sample ODBC & JDBC Applications</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="sampleapps.html">Chapter Contents</a> | <a class="link" href="troutips.html" title="Troubleshooting Tips">Prev</a> | <a class="link" href="binsrcloc.html" title="Binary & Source File Locations">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a href="overview.html">Overview</a>
</div>
<div>
<a href="installation.html">Installation Guide</a>
</div>
<div>
<a href="quicktours.html">Quick Start & Tours</a>
</div>
<div class="selected">
<a href="sampleapps.html">Sample ODBC & JDBC Applications</a>
<div>
<a href="binsrcloc.html" title="Binary & Source File Locations">Binary & Source File Locations</a>
</div>
<div>
<a href="sampleodbcapps.html" title="Sample ODBC Applications">Sample ODBC Applications</a>
</div>
<div>
<a href="jdbcdemos.html" title="Sample JDBC Applications & Applets">Sample JDBC Applications & Applets</a>
</div>
</div>
<div>
<a href="concepts.html">Conceptual Overview</a>
</div>
<div>
<a href="server.html">Administration</a>
</div>
<div>
<a href="accessinterfaces.html">Data Access Interfaces</a>
</div>
<div>
<a href="sqlreference.html">SQL Reference</a>
</div>
<div>
<a href="sqlprocedures.html">SQL Procedure Language Guide</a>
</div>
<div>
<a href="hooks.html">Database Event Hooks</a>
</div>
<div>
<a href="repl.html">Data Replication, Synchronization and Transformation Services</a>
</div>
<div>
<a href="webappdevelopment.html">Web Application Development</a>
</div>
<div>
<a href="webandxml.html">XML Support</a>
</div>
<div>
<a href="rdfandsparql.html">RDF Data Access and Data Management</a>
</div>
<div>
<a href="webservices.html">Web Services</a>
</div>
<div>
<a href="runtimehosting.html">Runtime Hosting</a>
</div>
<div>
<a href="internetservices.html">Internet Services</a>
</div>
<div>
<a href="freetext.html">Free Text Search</a>
</div>
<div>
<a href="tpcc.html">TPC C Benchmark Kit</a>
</div>
<div>
<a href="xa.html">Using Virtuoso with Tuxedo</a>
</div>
<div>
<a href="appendixa.html">Appendix</a>
</div>
<div>
<a href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
</div>
<div id="text">
<div class="abstract">
<h2>Abstract</h2>
<p>This chapter applies exclusively to the various commercial releases of Virtuoso. If you are working with the open source version, please refer to the instructions on the web site where you obtained it.
</p>
<p>The OpenLink Virtuoso Installation provides sample applications to help you get quick and easy results from you installation. This chapter explains how to use these applications.
</p>
</div>
<h2>Table of Contents</h2>
<div class="minitoc">
<div>
<a class="sect1" href="binsrcloc.html">4.1. Binary & Source File Locations</a>
</div>
<div>
<a class="sect2" href="binsrcloc.html#odbcdemos">4.1.1. ODBC Demonstration Applications</a>
</div>
<div>
<a class="sect2" href="binsrcloc.html#sampjdbcdemos">4.1.2. JDBC Demonstration Applications</a>
</div>
<div>
<a class="sect1" href="sampleodbcapps.html">4.2. Sample ODBC Applications</a>
</div>
<div>
<a class="sect2" href="sampleodbcapps.html#macosxsamples">4.2.1. Mac OS X</a>
</div>
<div>
<a class="sect2" href="sampleodbcapps.html#winodbcsamples">4.2.2. Windows 95/98/NT/2000</a>
</div>
<div>
<a class="sect2" href="sampleodbcapps.html#unixodbcsamp">4.2.3. Linux & UNIX</a>
</div>
<div>
<a class="sect2" href="sampleodbcapps.html#MSDTCsample">4.2.4. MS DTC ODBC Sample Application </a>
</div>
<div>
<a class="sect2" href="sampleodbcapps.html#MSDTCsample2">4.2.5. MS DTC OLE DB Sample Application </a>
</div>
<div>
<a class="sect1" href="jdbcdemos.html">4.3. Sample JDBC Applications & Applets</a>
</div>
<div>
<a class="sect2" href="jdbcdemos.html#JDBCDemo">4.3.1. JDBCDemo Java Application</a>
</div>
<div>
<a class="sect2" href="jdbcdemos.html#ScrollDemo2">4.3.2. ScrollDemo2 Java Application</a>
</div>
<div>
<a class="sect2" href="jdbcdemos.html#ScrollDemo2Applet">4.3.3. ScrollDemo2 Java Applet</a>
</div>
<div>
<a class="sect2" href="jdbcdemos.html#JBenchApplication">4.3.4. JBench Application</a>
</div>
<div>
<a class="sect2" href="jdbcdemos.html#JTADemo">4.3.5. JTA Demo Application</a>
</div>
</div>
<br />
<p>A number of sample applications are bundled
with your Virtuoso installation for the following purposes:</p>
<ul>
<li>
To simplifying the process of getting
Virtuoso up and running
</li>
<li>
To accelerate the support case creation and
resolution process
</li>
<li>
To demonstrate Virtuoso's unique product
features highlighting the benefits it brings to your organization
</li>
<li>
To demonstrate application programming
techniques that can used to aid and assist your ODBC and JDBC programmers
</li>
</ul>
<p>Virtuoso's services are consumed primarily via
ODBC and JDBC applications (OLE-DB applications connect to Virtuoso via ODBC Data
Providers for OLE-DB), thus separate ODBC & JDBC sample applications (including source
code) have been packaged and integrated into the Virtuoso installer. The current list of
sample applications include:</p>
<ul>
<li>
<div class="formalpara">
<strong>C++ Demo</strong>
<p>an ODBC
based Interactive SQL processor written in C++. </p>
</div>
</li>
<li>
<div class="formalpara">
<strong>ODBC Bench Test</strong>
<p>a 32 Bit C++ program based on the industry standard TPC-A benchmark (we will be extending
this program to include the TPC-C and TPC-D benchmarks also). This program helps you
compare the performance of Virtuoso against other backend database engines as well as
compare the performance of various ODBC Drivers connecting to any ODBC compliant backend
database.</p>
</div>
</li>
<li>
<div class="formalpara">
<strong>ODBCTEST</strong>
<p>ODBC based Interactive SQL processor written in 'C' for Linux & UNIX</p>
</div>
</li>
</ul>
<ul>
<li>
<div class="formalpara">
<strong>JDBCDemo</strong>
<p>a JDBC sample application that demonstrates Virtuoso's SQL query.</p>
</div>
</li>
<li>
<div class="formalpara">
<strong>ScrollDemo2</strong>
<p>a JDBC 2.0 sample application that demonstrates Virtuoso's support of
Scrollable Cursors and its ability to perform scrollable cursor operations across heterogeneous
databases.</p>
</div>
</li>
<li>
<div class="formalpara">
<strong>JBench</strong>
<p>a Java and JDBC based adaptations of the industry standard TPC-A and TPC-C benchmarks.
This program helps you compare the performance of Virtuoso against other backend database
engines, it also helps you to compare the performance of various JDBC Drivers connecting
to any JDBC compliant backend database.</p>
</div>
</li>
<li>
<div class="formalpara">
<strong>JTADemo</strong>
<p>a sample based on the TPC-A benchmark as
well but implemented as a J2EE application which shows the use of XA distributed
transactions as defined in JDBC 3.0 and JTA 1.0 specifications.</p>
</div>
</li>
</ul>
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="troutips.html" title="Troubleshooting Tips">Previous</a>
<br />Troubleshooting Tips</td>
<td align="center" width="34%">
<a href="sampleapps.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="binsrcloc.html" title="Binary & Source File Locations">Next</a>
<br />Binary & Source File Locations</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
869
