Embedded driver support for ResultSet.getRow

I am porting an application from PostgreSQL to Derby. I use ResultSet.getRow() to keep track of whether a particular row has been processed. However, I get an error like this: The 'getRow()' method is only allowed on scroll cursors It seems that even a forward iterator should be able to keep co

!!! Regression Search and Destroy Contest !!!

I posted the Wiki page this morning for the Derby 10.2 Regression Search and Destroy contest. The contest winners will be: "The top three developers or users who have made the greatest contribution toward a seamless upgrade to 10.2." Details are at: http://wiki.apache.org/db-derby/Regressi

Re: Derby and Active Directory

Quick question, what directory is your application attempting to create a database in//? [EMAIL PROTECTED] wrote: Greetings, I've written a desktop application that uses Derby as its database, and I've run into a problem. The app creates a database on first startup. One client site is runnin

Derby and Active Directory

Greetings, I've written a desktop application that uses Derby as its database, and I've run into a problem. The app creates a database on first startup. One client site is running Active Directory, and on their networked machines, it seems that the db creation process jams. I suspect that the

Embedding Apache Derby in Tomcat and creating an iBATIS JPetStore Demo

Excellent demonstration and now that I know how to do embed derby into Tomcat, I have many uses for it. Some notes from my environment. Tomcat 5.5.17 in my home directory Ubuntu Linux 6.06 Java 1.5 (Sun) I had to fully qualify the url to the database: username="" passwo

Prepared Statements

I have a prepared statement, that takes one parameter. DELETE FROM TRANSAUDIT WHERE TATRACKINGID = ? The code that executes this query is part of the database cleandown functionality of my application. For the data set that I am working with, the code runs properly, deleting many records, then a

Rename table error

Hi! I think this is being worked on... anyway, I'll ask: I'm returning to Derby because it advanced so much, and is almost a good choice for production systems (don't make this a flame war, I have my personal reasons for the "almost" there). As I starting a new project, I want to use Derby as

R: connection strange behavior

Hi, thanks everybody for the suggestions provided ;-)) Now I try to explane my goal : - I have an application shared in a local network environment (one jar file where every client in the network can double click and start it in a new jvm) - when the application starts, I'd like to start (auto

Re: Paginating result sets

Fantry, John wrote: I have tried a scrollable cursor and it is way too slow. The 'absolute()' method on the ResultSet object takes so long to return I have to show an hour glass icon and the user has to wait an eternity. In this case the result set had over 2 million rows. I have a requ

R: Paginating result sets

Hi, I tested, briefly, these stetements on DB2/400 and it works fine (I found it on a book, never used it in production) : select * from ( select * from ( select * from eurofile/anatit fetch first 35 rows only) as t1 order by atcodi desc fetch