< 1 2 3 >   Sort: Rank

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, 8066👍, 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

Retrieving CLOB Values with getCharacterStream() Method
This section describes how to retrieve CLOB values with the ResultSet.getCharacterStream() method.
2017-03-18, 573👍, 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, 9753👍, 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, 3194👍, 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, 4436👍, 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, 7295👍, 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, 400👍, 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💬

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, 9355👍, 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 ...)

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

SQLCMD SQL Server Command Line Tool
This section describes how to SQL Server command line tool - SQLCMD.
2016-11-08, 777👍, 1💬

💬 2016-11-08 Vineesh: SELECT DB_NAME(); GO

insertRow() - Inserting New Rows through ResultSet Objects
This section describes how to insert rows into target tables through ResultSet objects.
2016-11-01, 211👍, 1💬

Installing Microsoft JDBC Driver for SQL Server
This section describes how to download and install Microsoft JDBC Driver 4.2 for SQL Server 2014.
2016-10-15, 10578👍, 4💬

💬 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

Loading Driver Class Automatically
This section provides a tutorial program to show how JDK 1.7 and 1.8 automatically loads JDBC driver classes from JAR files specified in the classpath.
2016-10-15, 660👍, 3💬

💬 2016-10-13 Herong: Matthew, can you try to run the above test program with "javac" and "java" commands in a command window first? Using Eclipse, yo...

💬 2016-10-12 Matthew: my apologies i thought you deleted my comments without responding to them. its hard to find where i put my question

💬 2016-10-12 Matthew: Sorry to be so burdensome, i am running the specified code however i am getting no drivers listed. i moved the sqljdbc42 to the ...

Overview of CallableStatement Objects
This section provides overview information on CallableStatement Objects for stored procedures.
2016-10-05, 218👍, 1💬

💬 2016-10-05 Mohammadali(VIRUS2): Thank you for describing

Closing the Database Connection - con.close()
This section describes how to close database connections.
2016-09-28, 122👍, 1💬

DriverManager.getConnection() and Connection URL
This section describes how to use DriverManager.getConnection() and connection URL for the Microsoft JDBC driver.
2016-09-27, 146👍, 1💬

JDBC (Java Database Connectivity) Introduction
This chapter provides a quick introduction about JDBC (Java Database Connectivity). Topics include overview of JDBC; versions of JDBC; JDBC driver types; database connection with DriverManager and DataSource; JDBC driver class and connection URL for DriverManager.
2016-08-31, 114👍, 1💬

"DROP TABLE" Statements
This section describes how to drop a table in the current database.
2016-07-27, 679👍, 2💬

💬 2016-07-27 XYZ1: HGTYGHTY

💬 2016-07-27 XYZ: HI HELLO

MySQL - JBDC CallableStatement
This chapter provides tutorial notes on JDBC CallableStatement objects for stored procedures. Topics include CallableStatement overview; creating stored procedures with parameters and multiple result sets; using place holders in CallableStatement objects; register output parameters; retrieving multi...
2016-07-21, 123👍, 1💬

"CREATE PROCEDURE" - Creating a Simple Procedure
This section describes how to create a simple procedure that runs a simple query.
2016-07-20, 146👍, 1💬

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

💬 2016-07-13 rahul krishna: good work

< 1 2 3 >   Sort: Rank