Java: Passing Array to Oracle Stored Procedure

This tutorial guides us on how to pass Array objects from Java to stored procedures in Oracle and also, how to retrieve an array object in Java. All PLSQL arrays can not be called from java. An array needs to be created as TYPE, at SCHEMA level in the database and then it can be used with ArrayDesc

[ read more ]

Batch Insert In Java – JDBC

[caption id="" align="alignright" width="128"] JDBC[/caption] Let’s see how we can perform batch insert in Java using JDBC APIs. Although you might already knew this, I will try to explain the basic to a bit complex scenarios. In this note, we will see how we can use JDBC APIs like Statement and

[ read more ]

Android SQLite Database and ContentProvider

Android SQLite Database and ContentProvider

1. SQLite and Android 1.1. What is SQLite? SQLite is an Open Source Database which is embedded into Android. SQLite supports standard relational database features like SQL syntax, transactions and prepared statements. In addition it requires only little memory at runtime (approx. 2

[ read more ]

Calling Stored Procedures from ASP.NET and VB.NET

Let us see how can we create and call Stored procedures, in a .NET Environment, i.e Visual Studio.We use .NET 2.0 and Visual Studio 2005 for all the examples.fs Creating Stored Procedures Writing stored procedures has never been easy as Microsoft has almost integrated SQL Server with Visual Studio 2

[ read more ]

Spring Batch Example

JDBC Template Batch update example, In the tutorial we have discussed about  batchUpdate()  method of class JdbcTemplate in Spring framework. The Batch update methods are used to executes multiple SQL updates query on a single JDBC Statement. The example given below consists of the code to del

[ read more ]