1 2 3 > >>   Sort: Rank

JDBC-ODBC Bridge Driver Features
This section describes Sun's JDBC-ODBC Bridge driver and its features.
2017-07-14, 1851👍, 5💬

💬 2017-07-14 nks: need jdbc odbc drver

💬 2017-03-02 Herong: rajendra, you may want to download and use JDK 1.7, which will allow you to create MS-Access connection. Or read the comments fr...

💬 2017-02-23 rajendra: hello,, need jdbc odbc bridge driver

💬 2015-11-12 yutt: Hello

What Is ResultSet?
This section describes what is a ResultSet object.
2017-07-03, 162👍, 1💬

JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
This chapter provides tutorial notes on the JDBC-ODBC Bridge driver produced by Sun and DataDirect. Topics include loading JDBC-ODBC Bridge driver; creating a DSN (Data Source Name) with a ODBC driver; Connecting to SQL Server with JDBC-ODBC Bridge.
2017-06-27, 10004👍, 28💬

💬 2017-06-27 Herong: Shubhankar, you can download JDK 1.7. It has JDBC-ODBC bridge included.

💬 2017-06-25 Shubhankar: I want Sun.jdbc.odbc.jdbcodbcdriver

💬 2017-05-02 amol: thanks

💬 2017-02-08 frank: appreciation

💬 2017-01-24 selamawit: thank you for driver

(More comments ...)

JDBC Tutorials - Herong's Tutorial Examples
This JDBC tutorial book is a collection of notes and sample codes written by the author while he was learning JDBC technology himself. It can be used as a tutorial guide for beginners. Topics include Java, Database, JDBC, Driver, ODBC, Connection, DataSource, SQL, ResultSet, Metadata, Derby, MySQL, ...
2017-06-26, 4250👍, 10💬

💬 2017-06-26 NIRMAL PUDASAINI: how cani get it?

💬 2015-12-15 hassan: nice, can i get it please?

💬 2015-09-20 Alan: Nice

💬 2011-01-21 Herong: Agree. The driver class must be loaded as shown in this tutorial: Loading Driver Class with Class.forName().

💬 2011-01-18 John: For the JDBC tutorials, you must add: Class.forName with newInstance before making connection.

(More comments ...)

Create Tables with CLOB Columns
This section describes how to create tables with CLOB columns in Oracle server.
2017-06-20, 3575👍, 2💬

💬 2016-12-14 morgane: dhzeujf zihf zeiuhfzehf ezhf zoiehfqiejfcksbfhjre fnr jcrh vrf

JDBC-ODBC - Creating a MS Access Database File
This section describes how to create a MS Access database file to be used for ODBC MS Access driver testing.
2017-06-20, 2134👍, 3💬

💬 2017-06-20 Musa: Hi

💬 2015-10-25 kaushal: nice job for solving jdbc connection problem

Java DB (Derby) - DML Statements
This chapter provides tutorial notes on executing DML statements with Java DB (Derby) JDBC Driver. Topics include inserting, updating and deleting data rows in existing tables; creating IDENTITY columns; handling date and timestamp values.
2017-06-18, 119👍, 1💬

MySQL CLOB (Character Large Object) - TEXT
This chapter provides tutorial notes on CLOB (Character Large Object) data types, TEXT, with MySQL JDBC Driver. Topics include creating tables to store CLOB values in MySQL server; inserting CLOB values with direct SQL INSERT statements, or PreparedStatement with setString(), setCharacterStream() or...
2017-06-12, 2169👍, 2💬

💬 2016-02-29 sasjkh: aposmu9pze9e9e9dudududududuoxnpduqwp oiudnxiopxpqwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww...

JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver
This section describes how to load the JDBC-ODBC Bridge driver class with the Class.forName() method.
2017-06-06, 19726👍, 17💬

💬 2017-06-06 Panther: Need to run mdb server

💬 2017-04-24 Mukidi: hi

💬 2017-04-07 Herong: Yaiphaba, Are you referring to the Apache OpenOffice software?

💬 2017-04-02 yaiphaba: ddbc database driver class already installed andopen office

💬 2017-03-28 Hameed Ullah: i want to download this library

(More comments ...)

JDBC-ODBC - Connecting to MS Access Database Files
This section describes how to connect to a SQL Server 2005 through DSN with JDBC-ODBC Bridge.
2017-05-24, 7168👍, 5💬

💬 2017-05-24 sgat: thanks

💬 2016-11-04 ahmed: thanks

💬 2016-11-04 ahmed: sank you

💬 2015-11-06 Herong: Vous êtes bienvenue! ☺

💬 2015-11-06 azedine: merci pour votre aide

Microsoft JDBC Driver for SQL Server - sqljdbc42.jar
This chapter provides tutorial notes on sqljdbc42.jar, JDBC Driver 4.2 produced by Microsoft for SQL Server 2014. Topics include downloading and installing Microsoft JDBC Driver 4.2; loading sqljdbc42.jar; creating a connection to SQL Server with port number, instance name and database name; closing...
2017-05-02, 5697👍, 15💬

💬 2017-05-02 asdasdas: thx

💬 2017-03-24 sid: hi

💬 2017-02-16 daniel: thanks

💬 2017-02-01 paul: thanks

💬 2017-01-24 Narasimha Ulli: I want this driver class fro testing

(More comments ...)

Retrieving CLOB Values with getCharacterStream() Method
This section describes how to retrieve CLOB values with the ResultSet.getCharacterStream() method.
2017-03-18, 299👍, 2💬

💬 2017-03-18 Herong: Saurin, I am glad this is helpful to you!

💬 2017-03-14 saurin: Thanks man! you save my day...

JDBC-ODBC - Inserting Data Rows to MS Access Database
This section describes how to insert new data rows into MS Access database through the JDBC-ODBC driver.
2017-03-17, 7785👍, 5💬

💬 2016-03-06 Morn: My Testing

💬 2015-08-10 ramya: this website is very useful

Installing AdventureWorksLT Sample Database
This section describes how to install AdventureWorksLT as a sample database on SQL Server.
2017-03-13, 1981👍, 5💬

💬 2017-03-13 Justme: Thank you so very, very much

💬 2017-01-31 Chriselle: Thank you! :)

💬 2016-08-30 Herong: browser, Sorry the title is outdated and needs to be updated to say AdventureWorks2014. Do you need help to install AdventureWor...

💬 2016-08-30 browser: Search brings up "Installing AdventureWorksLT Sample Database - Herong Yang" but when go to page it is for installing AdventureW...

Loading JDBC Driver Class - ojdbc16.jar
This section describes how to load the Oracle JDBC driver class - ojdbc14.jar.
2017-03-07, 2350👍, 3💬

💬 2017-03-07 yuguohui: study and work

💬 2016-08-02 Herong: mukesh, Which test code are you running? The test code in this tutorial is just to test how to load the JDBC driver JAR file. Yo...

💬 2016-08-01 mukesh: Do not connect to DB - Error:java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:lis...

JDBC-ODBC - Connecting to a DSN
This section describes how to connect to a DSN (Data Source Name) with JDBC-ODBC Bridge.
2017-02-28, 5288👍, 3💬

💬 2017-02-28 Munna Shaw: My name is Munna Shaw

💬 2016-04-27 Anish Goel: Thanks a lot!

💬 2015-10-08 manoj soni: satisfied

mysqladmin - MySQL Admin Tool
This section describes how to use MySQL admin tool to check server status and other admin tasks.
2017-02-16, 211👍, 2💬

💬 2017-02-16 Herong: Jack, thanks for sharing the information about dbForge Studio.

💬 2017-02-14 Jack: There is also a good mysql admin tool -dbForge Studio for MySQL (https://www.devart.com/dbforge/mysq l/studio/features.html).I l...

Calling createStatement() and executeQuery
This section describes how to run a SELECT query statement with createStatement() and executeQuery().
2017-02-08, 280👍, 2💬

Loading JDBC Driver for MySQL Server
This section describes how to load the MySQL JDBC driver class - mysql-connector-java-5.1.36-bi n.jar.
2017-01-14, 1724👍, 2💬

💬 2017-01-14 Herong: Thanks for the nice comment! ☺

💬 2017-01-13 jasonts2000: Thank you, this is the best example of how to test a JDBC connection to mysql that I have seen posted

JDBC-ODBC Bridge Driver - MS Access
This chapter provides tutorial notes on using the JDBC-ODBC Bridge driver with MS Access database. Topics include creating MS Access database file; creating DSN for MS Access database files; inserting rows to and retrieving rows from Access database.
2016-12-22, 7081👍, 11💬

💬 2016-12-22 nhat: need jdbc

💬 2016-12-04 Herong: Sumon, Stay with JDK 7. It has a built-in JDBC=ODBC bridge driver to connect to Access database.

💬 2016-12-03 sumon: To run my access database

💬 2016-05-20 djamo: thenk you

💬 2016-01-11 Mars Chen: thanks for your providing this jar lib

(More comments ...)

PDF Printing Version: JDBC Tutorials
Information on how to obtain the PDF version of this book for printing.
2016-12-16, 1756👍, 16💬

💬 2016-12-16 Herong: Dzung, check your email. You should have it now.

💬 2016-12-16 Dzung Nguyen: I donated $10 through paypal, but I still can't download this book.

💬 2016-08-03 Arvind kumar: thank you

💬 2016-02-17 A: Very precise and clear examples

💬 2016-02-15 A: good!

(More comments ...)

MySQL Connector/J - Download and Installation
This section describes how to download and install MySQL Connector/J (JDBC driver).
2016-12-09, 5713👍, 8💬

💬 2016-12-09 esma: HELLO

💬 2016-09-06 Bittan: I am a student.

💬 2016-01-06 Amir: Let Me go

💬 2015-09-23 Herong: Hi Kpl, if you don't have the \local\lib folder, you can create it first. Then copy mysql-connector-java-5.1.36-bin.jar to that ...

💬 2015-09-22 KpL: -------- MySQL JDBC Connection Testing ------------ Where is your MySQL JDBC Driver? java.lang.ClassNotFoundException: com.mysql...

(More comments ...)

Instance Name Better than Port Number
This section describes how SQL Server support JDBC client applications to use instance name instead of port number to connect to a specific instance.
2016-11-26, 336👍, 1💬

💬 2016-11-26 Bill: Great explanation on. Better than Microsoft website!

"INSERT INTO" Statements
This section describes how to insert data rows with INSERT INTO statements.
2016-11-08, 138👍, 1💬

1 2 3 > >>   Sort: Rank