Herong's Tutorial Examples: JDBC

Free Chinese Calendar 2021 - Year of the Ox
Want to know when is the 2021 Chinese New Year day? Look for free Chinese calendars for 2021? Chinese New Year Date for Year 2021 The Ox2021February 12FridayChinese New Year ⇒ Free Chinese Calendar 2022 - Year of the Tiger ⇐ Free Chinese Calendar 2020 - Year of the Rat ⇑ Chinese New Year Dates in... 2021-01-23, 50211👍, 1💬

💬 2021-01-23 Jorge Leach: Well you can find the 2021 lunar date simply by using the Gregorian Lunar Calendar Converter https://www.bbgender.com/gregorian-. ..

1 2 3 4 > >> Sort: Rank

insertRow() - Inserting New Rows through ResultSet Objects
This section describes how to insert rows into target tables through ResultSet objects. 2021-02-09, 258👍, 2💬

💬 2021-02-09 Deepanshu: Thankyou this helped alot

JDBC Driver Connection URL
This section describes the connection URL format and how to create connection objects with the DriverManager class. 2021-01-28, 117👍, 2💬

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, ... 2020-12-11, 7537👍, 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 ...)

Inserting CLOB Values with SQL INSERT Statements
This section describes how to insert CLOB values as string literals using SQL INSERT statements. 2020-11-30, 114👍, 1💬

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

💬 2020-11-11 Herong: Erik, Links are fixed now. Thanks.

💬 2020-10-29 Erik: Your Amazon link is wrong...

💬 2019-05-10 Raed: nice to gut Ducument about JDBC thanks alot.

💬 2018-04-21 Herong: Tony, you are welcome!

💬 2018-04-20 Tony Ekpo: I appreciate your work because it has help me so much connecting to the database, more grace n ur work.

(More comments ...)

Installing and Running Java DB - Derby
This chapter provides tutorial notes on downloading, installing and setting up Java DB (Derby) server. Topics include downloading and installing Java DB 10.5.3; verifying Java DB execution environment; running Java DB in Network Server mode; using 'ij' to create database and tables. 2020-10-08, 2560👍, 4💬

💬 2020-10-08 Raji: Nice

💬 2015-08-09 a: g

Inserting CLOB Values with SQL INSERT Statements
This section describes how to insert CLOB values as string literals using SQL INSERT statements. 2020-09-15, 445👍, 2💬

💬 2020-09-12 Herong: David, see Inserting BLOB Values with setBinaryStream() Method. It provides a good example of saving a binary file to the databa...

💬 2020-08-28 David Colbourn: needs a couple of real word examples say save and retrieve myfile.doc or myfile.xls or myfile.ppt

Performance of Inserting Rows with a ResultSet
This section describes how to measure the performance of inserting rows using a ResultSet object. 2020-06-28, 142👍, 1💬

💬 2020-06-28 manohar: same problem came to me

Retrieving CLOB Values with getString() Method
This section describes how to retrieve CLOB values with the ResultSet.getString() method. 2020-06-11, 385👍, 2💬

💬 2020-06-11 Herong: Connor, thanks for sharing your comment and the link. I will review and update accordingly.

💬 2020-06-10 Connor: This won't always work. If the Clob value is too large then the jdbc driver will truncate the value when using getString(). You ...

Create Tables with CLOB Columns
This section describes how to create tables with CLOB columns in Oracle server. 2020-06-04, 18721👍, 4💬

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

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... 2020-03-06, 15649👍, 28💬

💬 2020-03-06 wy: thanks

💬 2020-03-04 Smile: thanks

💬 2020-02-25 Sean: thx

💬 2020-02-21 Eduardo: thanks

💬 2019-09-13 rohit: thanks

(More comments ...)

JDBC Driver Types
This section provides some quick information about different types of JDBC drivers. 2020-01-14, 1234👍, 2💬

💬 2015-09-16 saddaqat: saddaqatali99@yahoo.com

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. 2019-10-22, 23074👍, 26💬

💬 2019-10-15 felipe: um teste de mensagem

💬 2017-09-12 tilahun bekele: good site

💬 2017-08-27 Herong: Can you try to the 32-bit 1.7JDK?

💬 2017-08-24 jaime: Hi I have created a DSN and the test is Ok. I have this program: import java.sql.*; public class OdbcDsnConnection { public stat...

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

(More comments ...)

Outdated: Accessing Oracle Server through Web Interface
This section describes how to access an Oracle Server through its Web interface. 2019-10-03, 118👍, 1💬

Creating Procedures with Multiple Queries
This section describes how to create a procedure with multiple queries. 2019-09-27, 4625👍, 2💬

💬 2019-09-27 shubham: very nice

💬 2016-01-12 svr: Really a great article

Oracle JDBC Drivers Overview
This section provides overview information on Oracle JDBC drivers. 2019-05-28, 102👍, 1💬

Inserting BLOB Values with SQL INSERT Statements
This section describes how to insert BLOB values as normal strings using INSERT statements. 2019-04-29, 7409👍, 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. 2019-04-28, 8306👍, 5💬

💬 2019-04-28 M1001101: Meaningful comments. Thanks!

💬 2018-09-20 raj: hatt budbak aisa kuch nahin hota bakwas hai ye program

💬 2017-09-16 vivek sharma: good

💬 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

Creating Connections with DataSource Class
This section describes how to create connection objects with the DataSource class. 2019-04-24, 193👍, 3💬

💬 2019-04-24 Hamdan: iam using jdbc 6

💬 2019-04-20 Herong: Hamdan, Which JDBC jar file are you using?

💬 2019-04-16 Hamdan: I have followed it according to the steps above, but I found a problem here Exception: class "com.microsoft.sqlserver.jdbc.ISQLS. ..

Listing All Schemas - getSchemas()
This section describes how to get a list of all schemas in the current database on the SQL Server through the DatabaseMetaData object. 2019-04-03, 1310👍, 2💬

💬 2019-03-31 Herong: challa, I have no idea why the catalog name is null.

💬 2019-03-26 challa: why is the catalog name null for sys tables..can we retreive that as well?

Creating Tables with AUTO_INCREMENT Columns
This section describes how to create a table with an AUTO_INCREMENT column. 2019-01-03, 2236👍, 4💬

💬 2016-01-22 gokul: useful

Retrieving CLOB Values with getClob() Method
This section describes how to retrieve CLOB values with the ResultSet.getClob() method. 2018-09-20, 5032👍, 2💬

💬 2018-09-20 sdsfsdfs: hello its me

💬 2015-12-04 asdadsads: hello its me

Listing All Tables - getTables()
This section describes how to get a list of all tables in the current database on the SQL Server through the DatabaseMetaData object. 2018-09-01, 2694👍, 2💬

💬 2018-09-01 Herong: Arthur, thanks for your comment.

💬 2018-08-31 Arthur: When executing this with Oracle it will work. Unless you have several schemas on that database. It will then give you all the ta...

Retrieving CLOB Values with getString() Method
This section describes how to retrieve CLOB values with the ResultSet.getString() method. 2018-09-01, 886👍, 2💬

💬 2018-09-01 Herong: Srikanth, there should no size limitation. CLOB is designed to store very large character strings.

💬 2018-08-21 Srikanth: Is there any size limitation on getString() when used for clob column?

1 2 3 4 > >> Sort: Rank