Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Dummy operation to check integrity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Dummy operation to check integrity" Watch "Dummy operation to check integrity" New topic

Dummy operation to check integrity

shri Sonparote
Ranch Hand

Joined: May 07, 2007
Posts: 30
I want to know the any dummy operation which will check integrity.
I don't want execute query .I am using isReadOnly() and isclosed() but they can't check integrity of connection.
So any body please tellme any lightweight operation to check integrity.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32811

Why don't you want to run a query? It could be a "dummy" query. For example, in Oracle you could do a query on the dual table which doesn't result in a table scan.

I don't know of a way of checking a connection is good without actually connecting. You could do a query on table structure/metadata, but that is likely to take longer than running a tiny query.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Dummy operation to check integrity
It's not a secret anymore!