Below Java code shows how to store BLOB object into database – Database BLOBs (Binary Large Objects) can be used to stored any data, it could be image, audio or video file for instance. This example shows you how we use JDBC library to store image in our database. To send the binary information to…
Continue Reading »

Below java code shows how to read BLOBs column database from database-

Below java code shows how to get or retrieve column values from Resultset-

Below Java code shows how to get Table Column name using DatabaseMetadata-

Below code shows how to get JDBC Connection to MS Access database –

Below Java code shows how to get database connection using JDBC-ODBC :

Below Java code shows how to get Max concurrent connections to database –

Below Java code shows, how to insert OBJECT TYPE value in Oracle Table –

Below Java code shows, how to create oracle type for storing Java Types –

Below Java code shows, how to create Oracle Table using JDBC Driver –

Below code shows, how to get the Major and Minor version of JDBC driver in Java –

Below Code shows, how to get all loaded JDBC Driver list in java code –

Below Java code shows, how to get JDBC Driver Version –

Below code show how to get Driver name in java –

Below java code shows, how to enable JDBC logging in the code –

Below code snippet shows you to get the JDBC connection in java for ORACLE DB. To get the JDBC connection you will need JDBC Driver Jar for ORACLE Database.

Below code snippet shows you to get the JDBC connection in java for MYSQL DB. To get the JDBC connection you will need JDBC Driver Jar for MYSQL Database.

Below code snippet shows you to get the JDBC connection in java. To get the JDBC connection you will need JDBC Driver Jar for HSQLDB.

Below java code shows you JDBC driver property information – /**************************************************************************************** * Created on 04-2011 Copyright(c) http://kodehelp.com All Rights Reserved. ****************************************************************************************/ package com.kodehelp.javasql; import java.sql.Driver; import java.sql.DriverManager; import java.sql.DriverPropertyInfo; import java.util.Properties; /** * Created by http://kodehelp.com * Date: 4/29/11 */ public class GetDriverPropertyInfo { public static void main(String args[]) throws Exception{ Class.forName(“oracle.jdbc.driver.OracleDriver”); Properties info =…
Continue Reading »