installing plugin for eclipse

2007-03-01 Thread Brett Moreton
Sorry if this question has been asked before... I'm having terrible problems trying to get the Derby plugins to install properly for Eclipse. The problem is that in Eclipse, the Window > Show View > Database Explorer isn't showing up. I guess i've done something wrong, but i've tried three

Derby : Lock time out in Read commited mode

2007-03-01 Thread Prashant
Hello all, I am trying to debug a lock time out issue. After turning on debug as advised in the FAQ[1], I am trying to make sense of the lock table dump that derby wrote to the log file when the lock timed out occurred. The test case involves two threads one inserting to Database, while othe

backup destination

2007-03-01 Thread Jim Newsham
Is there any particular reason that the built-in system procedure for backing up a database doesn't back it up to the directory I specify, but to a subdirectory of the directory I specify? For example, if my database is in a directory called c:\a\b and I request to back it up to c:\d, it puts i

Re: Working with Derby Java version verification question

2007-03-01 Thread Laura Stewart
Hi Stan - Thanks, please help me understand derbyrun.jar and how it might make some of the section obsolete. I had planned on keeping the verifying steps (1 &3 were kept) but was going to remove step 2 from "Introduction and prerequisites". Laura On 3/1/07, Stanley Bradbury <[EMAIL PROTECTED]>

Re: Naming the next Derby feature release

2007-03-01 Thread Craig L Russell
Speaking as a user of Derby, On Mar 1, 2007, at 12:04 PM, Rick Hillegas wrote: We wonder what the user community thinks. In particular: A) Would calling this release 11.0 make it less likely that you would be blindsided by these incompatibilities? Yes. A new major release number is a yello

Re: Does derby support bitwise operators in SQL?

2007-03-01 Thread Dan Karp
> I'd like to know if Derby supports bitwise operators in SQL > statements. Nope. Wish it did, but nope. > select * > from MyTable > where (status & 5) = 5 One workaround is: SELECT * FROM mytable WHERE MOD(status, 2) = 1 AND MOD(status / 4, 2) = 1;

Re: Working with Derby Java version verification question

2007-03-01 Thread Stanley Bradbury
Top posting: I think you are correct, Laura, this section can be removed when Working With Derby (WWD) and Getting Started are merged. In fact, I don't think WWD will suffer if it were removed prior to the merge (but that seems like it might be unnecessary work). The 'Introduction and Prere

Does derby support bitwise operators in SQL?

2007-03-01 Thread Imran Hussain
Hi, I'd like to know if Derby supports bitwise operators in SQL statements. I want to submit something like select * from MyTable where (status & 5) = 5 Thanks. Imran.

Re: Working with Derby Java version verification question

2007-03-01 Thread Laura Stewart
Kim - Appreciate the explanation. I was thinking that this might get covered in DERBY-2390. On 3/1/07, Kim Haase <[EMAIL PROTECTED]> wrote: Well, setting the JAVA_HOME variable and setting your PATH to include JAVA_HOME/bin are two separate steps. The instructions tell you to set JAVA_HOME but

Re: A question about the Working With Derby guide

2007-03-01 Thread Laura Stewart
Thanks Kim, big help :-) On 3/1/07, Kim Haase <[EMAIL PROTECTED]> wrote: The Working with Derby guide has 2 simple examples each of embedded and client-server mode, illustrating the differences between the two modes. That's one of the features that make it a useful guide. Kim -- Laura Stewart

Re: Naming the next Derby feature release

2007-03-01 Thread A. Rick Anderson
Rick Hillegas wrote: We wonder what the user community thinks. In particular: A) Would calling this release 11.0 make it less likely that you would be blindsided by these incompatibilities? Yes. I would be much more likely to review the release notes to determine what new features were availa

Re: Working with Derby Java version verification question

2007-03-01 Thread Kim Haase
Well, setting the JAVA_HOME variable and setting your PATH to include JAVA_HOME/bin are two separate steps. The instructions tell you to set JAVA_HOME but not to set your PATH, so the table shows how to run the command if you haven't set your PATH. I think you've identified a problem with the

Re: A question about the Working With Derby guide

2007-03-01 Thread Kim Haase
The Working with Derby guide has 2 simple examples each of embedded and client-server mode, illustrating the differences between the two modes. That's one of the features that make it a useful guide. Kim Laura Stewart wrote: The examples in Getting Started with Derby assume that you are using

Working with Derby Java version verification question

2007-03-01 Thread Laura Stewart
Hi - In the Working with Derby guide, there is a section (Introduction and Prerequisites) that has us check our version of java by running the java -version command. Then there is a table showing a path. I can run the java -version command from any path to get the info... so I find the path in t

Naming the next Derby feature release

2007-03-01 Thread Rick Hillegas
Dear Derby users, The next feature release of Derby will close some security holes: 1) When authentication is turned on, only the owner of a database will be allowed to shut it down, encrypt it, and hard-upgrade it. 2) When you boot the network server as the VM's entry point, the server will

A question about the Working With Derby guide

2007-03-01 Thread Laura Stewart
The examples in Getting Started with Derby assume that you are using the embedded mode of the Derby database engine. Is this the same assumption in Working with Derby? -- Laura Stewart

Re: Bay Area Derby Lunch & Discussions

2007-03-01 Thread Laura Stewart
On 2/21/07, Anders Morken <[EMAIL PROTECTED]> wrote: Shooting from the hip here, but one thing that has occured to me a few times as I've browsed the docs to figure something out is that I intuitively expect Derby system and database properties (especially the non-performance-related) to be docum

Re: How much derby need memory?

2007-03-01 Thread Pertti Ylijukuri
Thanks, this help a lot and answer was fast! On 2/28/07, Knut Anders Hatlen <[EMAIL PROTECTED]> wrote: Pertti Ylijukuri <[EMAIL PROTECTED]> writes: > Hi! > > I'am using derby nework server. I have started deby with following > properties: > derby.storage.pageCacheSize = 2 > derby.storage.p