This is all database specific and depends on the type of driver. For example a type 4 jdbc driver directly converts/maps the jdbc api to the wire protocol to talk with the database.
One of my next steps was to upgrade to the latest of everything (java, jboss, etc.) I'll also look for more recent jdbc drivers. Does "type 4" imply better performance or is there somewhere where I can get faster drivers? I've used the oracle odbc drivers (and ensured that they were the right ones for the database versions) I also tried the datadirect drivers, but there was no real performance boost.
By the way, I've been using the "Extensible Java Profiler" to look for bottlenecks. So I ran it again last night and it is able to show me the procedures called within the jdbc driver. It looks like the next level of API calls is database dependent so I guess I've answered my initial question. There is no lower level API available.
I think that your solution maybe the use of stored procedures...
> I think that your solution maybe the use of stored procedures...
Thank you - its being considered.
The only problem is that this is a commercial app and our clients can use any relational db they want. As most of them use oracle or sql server, we may just go wuith stored procedures anway.