Herong's Tutorial Examples: JDBC

XML Tutorials - Herong's Tutorial Examples
This XML tutorial book is a collection of notes and sample codes written by the author while he was learning XML himself. Topics include introduction to XML, DTD (Document Type Definition), XSD (XML Schema Definition), XPath (XML Path Language), XSL (Extensible Stylesheet Language), XSLT (XSL Transf... 2023-03-09, 11976🔥, 3💬

1 2 3 4 5 6 … > >> Sort: Date

Create Tables with CLOB Columns
This section describes how to create tables with CLOB columns in Oracle server. 2023-03-09, 34075🔥, 6💬

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

JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver
This section describes how to load the JDBC-ODBC Bridge driver class with the Class.forName() method. 2023-05-17, 31240🔥, 19💬

💬 2023-05-17 Coicoubeh: You helped me more with 3 lines that a bunch of tech nerds

💬 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

(More comments ...)

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. 2023-03-23, 29068🔥, 29💬

💬 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 ...)

Installing Microsoft JDBC Driver for SQL Server
This section describes how to download and install Microsoft JDBC Driver 4.2 for SQL Server 2014. 2021-03-23, 26962🔥, 5💬

💬 2016-10-13 Herong: Matthew, see the Loading Driver Class Automatically tutorial my response to your other question.

💬 2016-10-12 Matthew: well that was rude.. you could have just said you didnt have the time to help me... what goes around come around

💬 2016-10-04 Eric: very happy

💬 2016-04-23 bhanu: thanks

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, 20232🔥, 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 ...)

Oracle Database 11g Express Edition (XE) Installation
This section describes how to download, install, and start Oracle Database 11g Express Edition (XE). 2022-03-12, 17232🔥, 6💬

💬 2022-03-12 Mrunali: thanks

💬 2022-02-20 SAJID ALAM: I WANT TO LEARN

💬 2015-09-11 Herong: Peter, what type of assignment requires you to install Oracle database server?

💬 2015-09-11 Peter M Chauke: Please allow me to write assignment no 2 for second Semester at Unisa becauese the disk I am having does not want to install

💬 2015-09-11 Peter M Chauke: Want to do assigment for Inntroduction to Databases in Oracle XE.Univ.exe

Create Tables with CLOB Columns
This section describes how to create tables with CLOB (LONGTEXT) columns in MySQL server. 2022-07-19, 17020🔥, 4💬

💬 2018-01-06 Herong: AAA, what is the this statement for?

💬 2018-01-02 AAA: update MyriadReport mr set Construction_Quality_Sql = CONCAT( "select ConstructionQuality from building bg where bg.CMMContainer...

SQL Server CLOB (Character Large Object) - TEXT
This chapter provides tutorial notes on CLOB (Character Large Object) data types, TEXT, with SQL Server JDBC Driver. Topics include creating tables to store CLOB values in SQL Server server; inserting CLOB values with direct SQL INSERT statements, or PreparedStatement with setString(), setCharacterS... 2016-04-07, 15007🔥, 1💬

💬 2016-04-07 kuchbhi: OK. Thank you................................. .................................... .................................... .............

JDBC-ODBC - Connecting to a DSN
This section describes how to connect to a DSN (Data Source Name) with JDBC-ODBC Bridge. 2023-05-06, 14342🔥, 4💬

💬 2023-05-06 Luca: Connecting is somewhat the easy part. What happens when you try and read a few thousand rows of data from the source into a text...

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

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

💬 2015-10-08 manoj soni: satisfied

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, 13600🔥, 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

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, 13524🔥, 5💬

💬 2016-03-06 Morn: My Testing

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

MySQL Connector/J - Download and Installation
This section describes how to download and install MySQL Connector/J (JDBC driver). 2016-12-09, 13073🔥, 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 ...)

deleteRow() - Deleting Rows through ResultSet Objects
This section describes how to delete rows from target tables through ResultSet objects. 2016-07-13, 12881🔥, 2💬

💬 2016-07-13 rahul krishna: good work

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, 12466🔥, 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 ...)

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, 9850🔥, 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 ...)

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, 9822🔥, 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

Inserting BLOB Values with setBinaryStream() Method
This section describes how to insert BLOB values with the PreparedStatement.setBinaryStr eam()method. 2016-04-08, 8835🔥, 2💬

💬 2016-04-08 Herong: Saqib, you are welcome!

💬 2016-04-06 Saqib Ayub: Just want to thank you so much. You made my day.

Inserting BLOB Values with SQL INSERT Statements
This section describes how to insert BLOB values as normal strings using INSERT statements. 2019-04-29, 8579🔥, 2💬

Loading JDBC Driver Class - ojdbc16.jar
This section describes how to load the Oracle JDBC driver class - ojdbc14.jar. 2017-03-07, 8578🔥, 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...

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, 7941🔥, 2💬

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

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

💬 2019-09-27 shubham: very nice

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

Create Tables with CLOB Columns
This section describes how to create tables with CLOB (VARCHAR(MAX)) columns in SQL Server server. 2016-03-17, 6591🔥, 2💬

💬 2016-03-17 Herong: Hi Maddy, you can read the Retrieving CLOB Values with getString() Method tutorial.

💬 2016-03-15 maddy: how to retrieve data from clob datatype(varchar(MAX)) in sql server 2008.

Retrieving CLOB Values with getClob() Method
This section describes how to retrieve CLOB values with the ResultSet.getClob() method. 2022-07-25, 6444🔥, 5💬

Commonly Used JDBC Class Methods
This section lists some commonly used JDBC classes and motheds. 2016-02-19, 6400🔥, 2💬

💬 2016-02-19 Herong: Deepak, you can see all methods in the JDBC API document.

💬 2016-02-14 Deepak32536@gmail.com: can u you please show me all method List of JDBC

1 2 3 4 5 6 … > >> Sort: Date