Re: Re: Derby 10.1.3.1 Embedded+Network

Not that is should matter but I set the Derby home property before I start Tomcat so Derby can find the properties file. I've never tried to connect from anything other than localhost export JAVA_OPTS=-Xmx500m -server -Dderby.system.home=/usr/local/derby/database s

can we use a PK in where clause ?

Hi thank you for reading my post can we use a PK (which is composed of more than one column) in a where clause ? or better i ask how we can retrieve the PK values when they are composite thanks

Re: can we use a PK in where clause ?

Yes. If your PK is colA,colB,colZ then in your where clause use WHERE colA=? AND colB=? AND colZ=? Followed by the rest of your where clause. The optimizer should then choose the pk index. Sent via BlackBerry. -Mike Segel Principal MSCC 312 952 8175 -Original Message- From: Legolas

DST rule change support for derby?

Hi, All, Does anybody knows if derby has exposure of the new DST rule change in 2007? Thanks, Jessie

Re: DST rule change support for derby?

Lee, Jessie wrote: Hi, All, Does anybody knows if derby has exposure of the new DST rule change in 2007? Thanks, Jessie I believe Derby derives all of it's support for understanding DST from the JVM, so whatever exposure the JVM's have Derby will also have.