Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Java > Java APIs > JDBC


1-20 of 27     Previous     Next
Does Your RDBMS Support Savepoints?
by Leonard Anghel
Before using savepoints in your application, you need to be sure that your RDBMS supports this facility.
Using the Logger to Trace JDBC Driver Managers and Drivers
by Mahendar Aleti
Using java.util.Logger as your logging/tracing tool allows you to take advantage of the Logging framework.
Batch Processing in Hibernate
by Leonard Anghel
Suppose you need to insert 200,000 records into a database in Hibernate. You'll need to adjust these settings.
A List of JDBC Drivers
by Elayaraja David
If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them.
Closing JDBC Objects Explicitly Can Save You Headaches!
by Keith Naas
If you're closint database connections directly—without closing the ResultSet or Statement, you've been causing yourself unnecessary trouble.
Insert an Image into a Database Using JDBC
by Elayaraja David
How to Use SavePoint in JDBC
by Elayaraja David
Using Addbatch and Executebatch
by Tri Do
If you insert/update/delete multiple times to the database, you ...
Fast Execution of SQL Statements
by Nitin Kumar
Let's start with a code ...
JDBC Transactions
by DevX Pro
Does "Connection.setAutoCommit(false)" mean "begin a transaction?"
ResultSet Interface
by DevX Pro
If ResultSet is an interface, then why can we call methods like next(), isLast() etc. without defining the method body anywhere in the program? As I understand it, in an interface, methods are only declared but not defined.
Threads and JDBC Connections
by DevX Pro
Is the JDBC Connection class thread safe? In other words, can a connection be shared between multiple threads without using synchronization?
Close ResultSet Object Explicitly Before Closing Connection when Using Servlets
by C.V. Ram
Most Java programmers close a connection with database directly without closing the ResultSet. This is okay with standalone Java programs, where the Java compiler automatically closes the Resultset ...
Database Field Types
by DevX Pro
How do I get a string representation of a database field using JDBC regardless of its type? In other words, I have to use the getInt(), getDate(), getString(), etc., to get a field value depending on the field type in the database. I just want the string representations so I can print them in HTML output to a Web browser.
Loading the JDBC driver
by Manoj K.
< ...
Date Arithmetic in Java
by DevX Pro
I have a ResultSet created using JDBC and it contains some date fields. Now I want to subtract one date from the other. How do I do this?
Dumping Tables
by DevX Pro
Using JDBC, how can I turn a database table into a series of SQL INSERT statements that can recreate the table?
JDBCTest ClassNotFoundException
by DevX Pro
I'm trying to test the JDBC-ODBC bridge with JDBCTest tool and it gives me the following error: registerDriver() Failed: java.lang.ClassNotFoundException: sun/jdbc/odbc/JdbcOdbcDriver What's the problem?
ResultSet Positioning
by DevX Pro
How can I access the next and previous rows in a ResultSet when I connect to a database through a JDBC driver?
Initializing A ResultSet
by DevX Pro
I am building a prototype but am trying to make the code as reuseable as possible. To test the prototype, I need to simulate a ResultSet being returned from a database. When my backend program simulating a database tries to add columns into the ResultSet, I get error messages that the ResultSet has not been initialized, which is true. How would I go about initializing this ResultSet given that I have no database and am currently reading a file and trying to populate the ResultSet using methods within ResultSet.
1-20 of 27     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date