round in derby

2006-01-25 Thread firass

hi.

plz can you tell me where i can ask questions , and if i am in the 
correct place plz answer me
my question: is there a build in function in derby that do round for the 
values in the sql sentance?

and if not can i make a function and how to do it?

thanks a lot, plz reply.


Re: Changing location of Log file

2006-01-25 Thread Afkham Azeez
You can specify the log file in the derby.properties file.
e.g. derby.stream.error.file=/home/azeez/log/derby.log

This derby.properties file should be placed in the directory pointed
to by derby.system.home Java System property. e.g
System.setProperty("derby.system.home", "database");

Thanks Manjula Kutty for the tip

On 1/25/06, Afkham Azeez <[EMAIL PROTECTED]> wrote:
> Hi Folks,
>
> I'm using Derby with Hibernate as the ORM. I noticed that the
> derby.log file is getting created in the the directory from where I
> started the application. Is there a way of specifying the location of
> the log file?
>
> --
> Thanks
> Afkham Azeez
>


--
Thanks
Afkham Azeez


Re: Removing Derby tagline

2006-01-25 Thread Myrna van Lunteren
+1 lets get going...
Myrna 
On 1/25/06, Samer Kanjo <[EMAIL PROTECTED]> wrote:
+1 for remove tagline for now until things can be worked out with Sun orwith a vote. I do like having a tagline.
--Samer-Original Message-From: David W. Van Couvering [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 25, 2006 4:59 PMTo: Derby Discussion; Derby Development
Subject: Removing Derby taglineWe are trying to finalize the work on the Derby logo and getting thisposted to the web site and other places.  The one issue still open isthe tagline.  We all voted +1 for the images that had the tagline "Pure
Java Database."It's likely that Sun has no issues with using the tagline, but it'staking some time to get this clarified.  In the meantime publishing thelogo onto our site is being held back.
I wanted to see what you all felt about removing the tagline, at leastfor now.  We may in the future (potentially the near future if we getfinal clarification from Sun) have a vote to add a tagline (maybe accept
submissions just like for the logo itself), but I wanted to know ifthere were any objections to just removing it for now.Thanks,David


RE: Removing Derby tagline

2006-01-25 Thread Samer Kanjo
+1 for remove tagline for now until things can be worked out with Sun or
with a vote. I do like having a tagline.

--Samer

-Original Message-
From: David W. Van Couvering [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 25, 2006 4:59 PM
To: Derby Discussion; Derby Development
Subject: Removing Derby tagline

We are trying to finalize the work on the Derby logo and getting this 
posted to the web site and other places.  The one issue still open is 
the tagline.  We all voted +1 for the images that had the tagline "Pure 
Java Database."

It's likely that Sun has no issues with using the tagline, but it's 
taking some time to get this clarified.  In the meantime publishing the 
logo onto our site is being held back.

I wanted to see what you all felt about removing the tagline, at least 
for now.  We may in the future (potentially the near future if we get 
final clarification from Sun) have a vote to add a tagline (maybe accept 
submissions just like for the logo itself), but I wanted to know if 
there were any objections to just removing it for now.

Thanks,

David



Re: Removing Derby tagline

2006-01-25 Thread Craig L Russell
Seems non-controversial. Unlike the "Pure Java Database". :-(+1 to remove the tag line pending Sun's decision.CraigOn Jan 25, 2006, at 3:41 PM, Manjula Kutty wrote:yes..I also agree to remove the tagline   --Manjula  On 1/25/06, David W. Van Couvering <[EMAIL PROTECTED]> wrote: We are trying to finalize the work on the Derby logo and getting thisposted to the web site and other places.  The one issue still open is the tagline.  We all voted +1 for the images that had the tagline "PureJava Database."It's likely that Sun has no issues with using the tagline, but it'staking some time to get this clarified.  In the meantime publishing the logo onto our site is being held back.I wanted to see what you all felt about removing the tagline, at leastfor now.  We may in the future (potentially the near future if we getfinal clarification from Sun) have a vote to add a tagline (maybe accept submissions just like for the logo itself), but I wanted to know ifthere were any objections to just removing it for now.Thanks,David Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp!  

smime.p7s
Description: S/MIME cryptographic signature


Re: JSR169 and OSGi

2006-01-25 Thread Daniel John Debrunner
Byron Appelt wrote:

> I went ahead and created a Jira issue: DERBY-873
> 

Thanks very much!

Dan.




RE: JSR169 and OSGi

2006-01-25 Thread Byron Appelt
I went ahead and created a Jira issue: DERBY-873

Byron K. Appelt
Lead Developer - Devices and Gateways
SensorLogic│M2M made easy.
[EMAIL PROTECTED]
www.SensorLogic.com

-Original Message-
From: Daniel John Debrunner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 25, 2006 5:28 PM
To: Derby Discussion
Subject: Re: JSR169 and OSGi

Byron Appelt wrote:

> I am trying to run Derby as an OSGi bundle in a J2ME/CDC Foundation
> environment with JSR 169.  This doesn't seem to work properly since the
> EmbeddedActivator class has a reference to java.sql.DriverManager which
> is not included in the JSR169 subset. I am pretty new to OSGi and Derby,
> but this seems incorrect to me since the OSGi platform release 3
> specification defines the environment as J2ME/CDC or a subset which
> would seem to imply that JSR168 support would be appropriate. 
> 
> Has anyone run into this? Am I missing something? 

No it's something I forgot to do when I did the JSR169 work. It's on my
mental list to enter a Jira issue.

Dan.



Re: Removing Derby tagline

2006-01-25 Thread Manjula Kutty
yes..I also agree to remove the tagline
 
--Manjula 
On 1/25/06, David W. Van Couvering <[EMAIL PROTECTED]> wrote:
We are trying to finalize the work on the Derby logo and getting thisposted to the web site and other places.  The one issue still open is
the tagline.  We all voted +1 for the images that had the tagline "PureJava Database."It's likely that Sun has no issues with using the tagline, but it'staking some time to get this clarified.  In the meantime publishing the
logo onto our site is being held back.I wanted to see what you all felt about removing the tagline, at leastfor now.  We may in the future (potentially the near future if we getfinal clarification from Sun) have a vote to add a tagline (maybe accept
submissions just like for the logo itself), but I wanted to know ifthere were any objections to just removing it for now.Thanks,David


Re: Removing Derby tagline

2006-01-25 Thread Jean T. Anderson

David W. Van Couvering wrote:
We are trying to finalize the work on the Derby logo and getting this 
posted to the web site and other places.  The one issue still open is 
the tagline.  We all voted +1 for the images that had the tagline "Pure 
Java Database."


It's likely that Sun has no issues with using the tagline, but it's 
taking some time to get this clarified.  In the meantime publishing the 
logo onto our site is being held back.


I wanted to see what you all felt about removing the tagline, at least 
for now.  We may in the future (potentially the near future if we get 
final clarification from Sun) have a vote to add a tagline (maybe accept 
submissions just like for the logo itself), but I wanted to know if 
there were any objections to just removing it for now.




yes, let's remove the tagline. The logo should just include "Apache 
Derby" and the hat.


 -jean




Re: JSR169 and OSGi

2006-01-25 Thread Daniel John Debrunner
Byron Appelt wrote:

> I am trying to run Derby as an OSGi bundle in a J2ME/CDC Foundation
> environment with JSR 169.  This doesn't seem to work properly since the
> EmbeddedActivator class has a reference to java.sql.DriverManager which
> is not included in the JSR169 subset. I am pretty new to OSGi and Derby,
> but this seems incorrect to me since the OSGi platform release 3
> specification defines the environment as J2ME/CDC or a subset which
> would seem to imply that JSR168 support would be appropriate. 
> 
> Has anyone run into this? Am I missing something? 

No it's something I forgot to do when I did the JSR169 work. It's on my
mental list to enter a Jira issue.

Dan.



JSR169 and OSGi

2006-01-25 Thread Byron Appelt
I am trying to run Derby as an OSGi bundle in a J2ME/CDC Foundation
environment with JSR 169.  This doesn't seem to work properly since the
EmbeddedActivator class has a reference to java.sql.DriverManager which
is not included in the JSR169 subset. I am pretty new to OSGi and Derby,
but this seems incorrect to me since the OSGi platform release 3
specification defines the environment as J2ME/CDC or a subset which
would seem to imply that JSR168 support would be appropriate. 

Has anyone run into this? Am I missing something? 

Byron K. Appelt
Lead Developer - Devices and Gateways
http://www.SensorLogic.com



Removing Derby tagline

2006-01-25 Thread David W. Van Couvering
We are trying to finalize the work on the Derby logo and getting this 
posted to the web site and other places.  The one issue still open is 
the tagline.  We all voted +1 for the images that had the tagline "Pure 
Java Database."


It's likely that Sun has no issues with using the tagline, but it's 
taking some time to get this clarified.  In the meantime publishing the 
logo onto our site is being held back.


I wanted to see what you all felt about removing the tagline, at least 
for now.  We may in the future (potentially the near future if we get 
final clarification from Sun) have a vote to add a tagline (maybe accept 
submissions just like for the logo itself), but I wanted to know if 
there were any objections to just removing it for now.


Thanks,

David
begin:vcard
fn:David W Van Couvering
n:Van Couvering;David W
org:Sun Microsystems, Inc.;Database Technology Group
email;internet:[EMAIL PROTECTED]
title:Senior Staff Software Engineer
tel;work:510-550-6819
tel;cell:510-684-7281
x-mozilla-html:TRUE
version:2.1
end:vcard



date conversion

2006-01-25 Thread Binu Andrews



hi all,
 
i want to know wether there is any function for
converting date which is given in millisecond format to a date in proper
format.
 
 
eg:- select min(start_date) from message; 
-->  is
returning  "138015151844".
 
i want to convert the result into a format like
"2006-01-25 18:33:38.537".
 
i dont want to convert to this format using java
coding.
im checking for any built in functions provided by
derby.
 
 
 
 
 
Thanks in
advanceBinu Andrews. 
 

*
Disclaimer:
The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if any) are privileged and confidential material of MBT and should not be disclosed to, used by or copied in any manner by anyone other than the intended addressee(s).   In case you are not the desired addressee, you should delete this message and/or re-direct it to the sender.  The views expressed in this E-mail message (including the enclosure(s) or attachment(s) if any) are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of MBT.

This e-mail message including attachment/(s), if any, is believed to be free of any virus.  However, it is the responsibility of the recipient to ensure that it is virus free and MBT is not responsible for any loss or damage arising in any way from its use