03
Oct
Calling stored procedure from Java program
In RDBMS, a stored procedure is set of sql statements which is complied and stored in a database to perform a special task. A stored procedure can have any...
-
Read More
-
03OctRead More
Batch Statement in SQL
Batch Statement in SQL The following examples show you how to perform a batch operation to insert bulk records into a relational database using the JDBC API. The “PreparedStatement#addBatch()”...
-
03OctRead More
Save image file into database
Saving Image file into Databases In this post, we will show you how to save a long binary string or image file into a BLOB (Binary Large Object) column...
-
03OctRead More
Working with ResultSet metada
Working with ResultSet metada A “ResultSetMetaData” object is used to get metadata (i.e. data about data) of the columns from query’s result. The “ResultSetMetaData” object provides the following information...
-
03OctRead More
working with result sets of a “Stored Procedure” in JDBC
Callablestatement + resultset example in JDBC This examples shows how to call a stored procedure from a java program using the JDBC API. Following example will demonstrate how to...
-
03OctRead More
Perform Transaction mgmt. in JDBC calls
Client Session plays an important factor which determines if changes made via Selenium scripts needs to be committed to database or not. For Selenium scripts to support session based...
-
03OctRead More
Navigating Resultsets to validate selenium actions in database.
Navigating resultsets with JDBC By default access to data results via JDBC ResultSet object is non scrollable / updatable and is forward only. This limits the end test case’s...