Re: Eclipse Plug-in Lab code is failing to find driver in derby.jar

2007-02-16 Thread Bryan Pendleton
A. Rick Anderson wrote: I'm getting a "driver not found" exception when running a relatively trivial derby program from within eclipse. It's frustrating because I can crack the derby.jar file and the targeted driver class is in the derby.jar file that is in the build path for the project. ...

Eclipse Plug-in Lab code is failing to find driver in derby.jar

2007-02-16 Thread A. Rick Anderson
I'm getting a "driver not found" exception when running a relatively trivial derby program from within eclipse. It's frustrating because I can crack the derby.jar file and the targeted driver class is in the derby.jar file that is in the build path for the project. The targeted driver is "Bor

Re: logged/unlogged operations

2007-02-16 Thread Suresh Thalamati
Jim Newsham wrote: Hello, I’d like to back up an online derby database, and would also like to understand how this interacts with other concurrent transactions (regarding visibility, blocking, etc.). I found some documentation in derbyadmin.pdf. It mentions logged and unlogged operati

Re: getColumn( table.field) / getInt( table.field )

2007-02-16 Thread Stanley Bradbury
Diego Zanga wrote: 2007/2/15, Stanley Bradbury <[EMAIL PROTECTED]>: Diego Zanga wrote: > hi! > > I've seen there is some problem to use a syntax like > resultset.getString( "TABLENAME.FIELDNAME" ) > 'cause it works only with > resultset.getString( "FIELDNAME" ) > ( with every get method, eve

Re: "ERROR 40XD1: Container was opened in read-only mode" when performing SELECT DISTINCT on database in jar

2007-02-16 Thread Stanley Bradbury
Rajesh Kartha wrote: Stanley Bradbury wrote: Thomas Kelder wrote: Hello, I'm using Derby in embedded mode, with my databases stored in jar files. I've set the 'derby.storage.tempDirectory' and 'derby.stream.error.file' properties to writable locations, as advised in the help file. When I now

Re: "ERROR 40XD1: Container was opened in read-only mode" when performing SELECT DISTINCT on database in jar

2007-02-16 Thread Stanley Bradbury
Stanley Bradbury wrote: Thomas Kelder wrote: Hello, When I now perform a query like "SELECT DISTINCT FROM ..." on this database, it produces the following exception: ERROR 40XD1: Container was opened in read-only mode. - SNIP - Thomas Hi Thomas - I looked into this further after I disc

Re: "ERROR 40XD1: Container was opened in read-only mode" when performing SELECT DISTINCT on database in jar

2007-02-16 Thread Rajesh Kartha
Stanley Bradbury wrote: Thomas Kelder wrote: Hello, I'm using Derby in embedded mode, with my databases stored in jar files. I've set the 'derby.storage.tempDirectory' and 'derby.stream.error.file' properties to writable locations, as advised in the help file. When I now perform a query like "

Re: "ERROR 40XD1: Container was opened in read-only mode" when performing SELECT DISTINCT on database in jar

2007-02-16 Thread Stanley Bradbury
Thomas Kelder wrote: Hello, I'm using Derby in embedded mode, with my databases stored in jar files. I've set the 'derby.storage.tempDirectory' and 'derby.stream.error.file' properties to writable locations, as advised in the help file. When I now perform a query like "SELECT DISTINCT FROM ..."

Re: "ERROR 40XD1: Container was opened in read-only mode" when performing SELECT DISTINCT on database in jar

2007-02-16 Thread Stanley Bradbury
Thomas Kelder wrote: Hello, I'm using Derby in embedded mode, with my databases stored in jar files. I've set the 'derby.storage.tempDirectory' and 'derby.stream.error.file' properties to writable locations, as advised in the help file. When I now perform a query like "SELECT DISTINCT FROM ..."

Re: getColumn( table.field) / getInt( table.field )

2007-02-16 Thread Lance J. Andersen
In ResultSet.getXXX(String columnName), the columnName parameter represents the column Label which defaults to the column name if a label is not specified in the query. You can get your query to work by using an alias select f.col1 as col1, f.col2 as col2 from ftab f ResultSet.getXXX("col1"

"ERROR 40XD1: Container was opened in read-only mode" when performing SELECT DISTINCT on database in jar

2007-02-16 Thread Thomas Kelder
Hello, I'm using Derby in embedded mode, with my databases stored in jar files. I've set the 'derby.storage.tempDirectory' and 'derby.stream.error.file' properties to writable locations, as advised in the help file. When I now perform a query like "SELECT DISTINCT FROM ..." on this database, it

Re: getColumn( table.field) / getInt( table.field )

2007-02-16 Thread Diego Zanga
2007/2/15, Stanley Bradbury <[EMAIL PROTECTED]>: Diego Zanga wrote: > hi! > > I've seen there is some problem to use a syntax like > resultset.getString( "TABLENAME.FIELDNAME" ) > 'cause it works only with > resultset.getString( "FIELDNAME" ) > ( with every get method, even getColumn) > is th