How to insert XMLType column value in oracle10g using JDBC driver?

Recently while working on the client project, i can came across a situation where i have to insert the XML file as XMLType datatype in Oracle 10g table. I was trying to insert the XML file as CLOB object, but it was giving me some Exception. I tried below options for this Inserting the XML …

Read More

Hibernate or iBatis or both ? Which is better?

What’s really difference between two and really more importantly when should I use one over the other. Its pretty interesting question because there are major differences between iBatis and Hibernate. Within in the java persistence there is no one size, fits all solution. So, in this case Hibernate which is a de facto standard is …

Read More

Why do JDBC drivers always create problems?

Why do JDBC drivers always create problems?

I’m not sure if the readers of this blog have seen this problem or not but I’ve always seen driver issues (especially JDBC drivers) when deploying applications. Why does every vendor have tens of jdbc driver versions and why does every database vendor create a bunch of drivers for every release out there. This kind …

Read More

Using JDBC with MySQL, Getting Started

Using JDBC with MySQL, Getting Started

Purpose The purpose of this Articleis to get you beyond the initial hurdles involved in:   Downloading and installing a MySQL database server. Preparing that database for use with JDBC. Writing and testing your first JDBC programs to administer the database and to manipulate the data stored in the MySQL database.     What is …

Read More