Re: [castor-dev] How to describe SQL function as OQL

[Hong Rae Cho]

Dear Low Heng Sin.

 

Thank you for your kind reply.

 

I did my best to find example related SQL function with Castor JDO.

I didn't evently find it.

 

Would you give me a example about SQL function?

 

Speaking in detail, I'd like to make OQL matching SQL like below, if possible.

select count(*) from Table_Name;

 

Thank you for your kindness.

 

Best Regards.

Hong Rae

 

-----Original Message-----
From: Low Heng Sin [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 01, 2001 11:58 AM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] How to describe SQL function as OQL

Hi,

 

The current OQL implementation *DOES* support SQL function ( We have been using that for quite some time ) . What problem are u facing ?

 

Regards,

Low

-----Original Message-----
From: Hong Rae Cho [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 10:45
To: [EMAIL PROTECTED]
Subject: [castor-dev] How to describe SQL function as OQL

Dear castor-dev.

I'm Hong Rae Cho.

I have developed a project with Castor JDO 0.9.3.
Database is Oracle for linux.
I'd like to use SQL function like TO_CHAR(), RTRIM() or User-defined functions.
In Castor web site, OQL syntax is described simply How to use SQL function.
I made a program as OQL described in Castor web site, and exected it. But there was a error about parsing it.

I think current Castor JDO version does not support SQL function.

I'd like to know if Castor JDO supports SQL function in Oracle.
If it supports, How can I use Castor JDO for using SQL function?
If possible, I'd like to recevie a sample code related SQL fucntion with Castor JDO.
[Hong Rae Cho] II 
Thank you for any assistance.
Regards.