Passing parameters via environment properties a bad design

2007-06-06 Thread chihiro
Hi, I'm programmatically starting my Network servers I just want to say: having to pass configuration info via System properties is not good design. I'm trying to redirect the output that's going to derby.log to different files having to define derby.stream.error.method before each call to the

Re: Connection refused

2007-06-06 Thread Bernt M. Johnsen
Hi, Steve Pannier wrote (2007-06-05 10:28:18): Hi all. I'm trying to access the network server using the network client driver. I connect to my database from a remote client and keep getting the connection refused error. Even when I connect from the local system, I get the error (in

RE: syntax for column names

2007-06-06 Thread Fantry, John
Sounds like you are using an ordinary SQL92 identifier. Convert it to a delimited identifier by placing quotes around it and I think you'll be ok. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 10:05 AM To:

Re: syntax for column names

2007-06-06 Thread Saad_Khawaja
Thank you very much. Saad. Bernt M. Johnsen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/06/2007 09:08 AM Please respond to Derby Discussion derby-user@db.apache.org To Derby Discussion derby-user@db.apache.org cc Subject Re: syntax for column names [EMAIL PROTECTED] wrote

Re: Difference between two timestamp fields

2007-06-06 Thread Kathey Marsden
Dmitri Pissarenko wrote: Hello! SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND, APP.MyTable.startTime, APP.MyTable.endTime)} FROM APP.MyTable WHERE APP.MyTable IS NOT NULL Should this be WHERE APP.MyTable.startTime IS NOT NULL ? Thanks for the hint! Now I'm getting

Re: recommended practices? dealing with the database-application divide

2007-06-06 Thread dmclean62
This is the kind of thing where ORM (object-relational mapping) can be very useful. I use Hibernate (www.hibernate.org) but there are a number of other solutions and you have to find one that best meets the needs of your project. Donald -- Original message --