Derby unBof at Java One

Hey folks, Sun Microsystems is hosting a Derby party at Java One. Here are the specifics. Hope to see you there! You are cordially invited to: An Apache Derby unBoF at JavaONE 2007! hosted by Sun Come learn what's cool and what's new in Apache Derby -- the database for Java applications

ij command

I have problem running the ij command that is located under C:\Derby\frameworks\NetworkServer\bin I got an error like this: C:\Derby\frameworks\NetworkServer\bin>ij JAVA_HOME not set or could not find java executable in JAVA_HOME. Please set JAVA_HOME to the location of a valid Java installation.

RE: Derby select query speed questions

Hi Olav, Thanks. That seems to have improved things. I was wondering whether or not there was a way to create one PreparedStatement from another. I have the first one that I've created and would like to clone or duplicate this, w/o needing to recompile it. So when I'm using a PreparedStatem

Re: Store very large Strings

Hi Ruben, The connection object has a setAutoCommit(boolean) api. If you can easily reference it and are not running within a transaction manager framework set it to false for the method call. If your connections are pooled you'll also want to remember to turn it back on after you're done.

Re: Store very large Strings

On Fri, 2007-04-13 at 10:19 -0700, Kathey Marsden wrote: > Ruben Fonseca wrote: > >> > > > > Thank you! I didn't know about the CLOB type! However, I'm still having > > problems when *reading* from the CLOB.. When I call the > > ResultSet.getString on the CLOB I get a IOException thrown, when

Re: Store very large Strings

Ruben Fonseca wrote: Thank you! I didn't know about the CLOB type! However, I'm still having problems when *reading* from the CLOB.. When I call the ResultSet.getString on the CLOB I get a IOException thrown, when the String is large... Is this a known problem? I am not sure if it wou

Re: Store very large Strings

Hi Guys, Just wanted to insert my experience into the mix. I came across the "ERROR 40XD0: Container has been closed.: java.io.IOException" error intermittently in the following scenario. I had a BLOB field from which I was storing retreiving files (~100MB). I encountered the error sometimes

Re: Store very large Strings

On Fri, 2007-04-13 at 08:38 -0700, Bryan Pendleton wrote: > > New trace :) > > Thanks Ruben! > > But we still don't seem to be getting down to the actual IOException. Thank you too! > > I'm expecting to see a line that says: > > java.io.IOException: ... > > with the actual information and th

Re: Store very large Strings

New trace :) Thanks Ruben! But we still don't seem to be getting down to the actual IOException. I'm expecting to see a line that says: java.io.IOException: ... with the actual information and the actual stack trace of the IOException itself, but so far all we've seen is the wrapping SQLExce

Re: Store very large Strings

On Fri, 2007-04-13 at 07:33 -0700, Bryan Pendleton wrote: > > Caused by: java.sql.SQLException: An IOException was thrown when reading a > > 'java.sql.String' from an InputStream. > > at > > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > > Source) > > at > > or

Re: Store very large Strings

Caused by: java.sql.SQLException: An IOException was thrown when reading a 'java.sql.String' from an InputStream. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(

Re: Store very large Strings

On Fri, 2007-04-13 at 07:22 -0700, Bryan Pendleton wrote: > > problems when *reading* from the CLOB.. When I call the > > ResultSet.getString on the CLOB I get a IOException thrown, when the > > String is large... Is this a known problem? > > Might be a resource exhaustion problem. Can you print o

Re: Store very large Strings

problems when *reading* from the CLOB.. When I call the ResultSet.getString on the CLOB I get a IOException thrown, when the String is large... Is this a known problem? Might be a resource exhaustion problem. Can you print out the entire exception stack trace, including all chained exceptions, a

Re: Store very large Strings

On Fri, 2007-04-13 at 15:56 +0200, Oystein Grovlen - Sun Norway wrote: > Ruben Fonseca wrote: > > Hi to all :) > > > > I'm doing a research project using Java and Apache Derby. It proved to > > be an excelent combination with a lot of power! > > > > However, I'm having a problem right now. I need

Re: Store very large Strings

Ruben Fonseca wrote: Hi to all :) I'm doing a research project using Java and Apache Derby. It proved to be an excelent combination with a lot of power! However, I'm having a problem right now. I need to store a very large string (150k - 200k lines) on a field of my database. AFAIK, there are n

Store very large Strings

Hi to all :) I'm doing a research project using Java and Apache Derby. It proved to be an excelent combination with a lot of power! However, I'm having a problem right now. I need to store a very large string (150k - 200k lines) on a field of my database. AFAIK, there are no database types for ho

Re: DERBY_HOME for UNIX

Hemant Gaur wrote: derby version db-derby-10.2.1.6-bin For UNIX the default scripts need DERBY_HOME to be set. [snip demonstration] This is automatically determined in Windows bats by relating path to the current dir, but for some unknown reason for the Solaris scripts, the DERBY_HOME is ad

DERBY_HOME for UNIX

derby version db-derby-10.2.1.6-bin For UNIX the default scripts need DERBY_HOME to be set. == bash-2.05# ./ij Error: DERBY_HOME is not set. Please set the DERBY_HOME environment variable to the location of your Derby installation. bash-2.05# export

can we log userid/password that connects to our database?

Hi Thank you for reading my post. Is it possible to log userid/passwords that create connection to a derby network server? Thanks -- View this message in context: http://www.nabble.com/can-we-log-userid-password-that-connects-to-our-database--tf3570383.html#a9974872 Sent from the Apache Derby