Hi,
you should consider defining a db view returning the computed value
to_days(s.end_of_subscription_date) - to_days(SYSDATE()) as
expiration_days.
You could then simplify your query to look like this:
SELECT user_id
FROM details d, view_subscribers v
WHERE v.app_id = d.app_id
AND v.expiration
Tine Sperlich wrote:
> excuse my late answer, I've been away for awhile.
no problem with me
> But now, back in full swing, I'd like to
> thank you a lot for your suggestion,
> it works perfectly for me
Great! Glad I could help with your request.
[...]
> Is the nowait option ANSI compliant
Hi Tino,
good question . . .
One would like to be able to override the createQueryString method of the
XxxPeer class, but - alas! - it is a static method :-(
The only solution I see is implement some additional methods in your
XxxPeer class that do everything that's already in the BaseXxxPeer c
Hi Tino once more,
another more "official" way to achieve your goal is accessing the
to-be-updated database rows with the
SELECT ... FOR UPDATE NOWAIT
statement.
I believe there has already been some discussion around that theme complex
in this list.
Gruss
Arne
"Sperlich, Tino" wrote
ublic void setWaitOption(int waitOption);
The valid values for waitOption are:
0 = The program waits until the requested resource is available (default
setting)
4 = The driver returns an error code if the requested resource is not
available (this one should work for you)
Arne Siegel
Hi all,
my
an error code if the requested resource is not
available (this one should work for you)
Arne Siegel
Hi all,
my problem is this:
My app using torque accesses an oracle db that
is shared with other apps. These apps tend to
use long blocking calls to select/update data,
causing my app to wait
>>>
Did you look at 3.1.1? I have here
--- cut ---
--- cut ---
<<<
You're right, that's also what's stated inside torque-gen-3.1-src.zip. The
place I got the (seemingly outdated) information from was
http://db.apache.org/torque/generator/data
Henning P. Schmiedehausen wrote:
>>>
Just use
No need for patches. Use the regular Torque distribution.
<<<
Actually the dtd does not allow this:
Nevertheless defaultIdMethod="autoincrement" might be accepted by the
regular distr; Henning surely knows more ab
"Ferruh Zamangoer"
<[EMAIL PROTECTED] An: "Apache Torque Users List"
<[EMAIL PROTECTED]>
-online.de>
Hi Sandeep,
my suggestion is you try the patch for the MSSQL adapter class that I
described by my message on May 6.
Its intention is simply to account for the extra precision that the DATE
class of the MSSQL DB provides.
I'm not sure if it fixes your problem because I'm not very deep in Torque'
OvidiuAn: "'Apache Torque Users
List'" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] Kopie: (Blindkopie: Arne
Siegel/PTA_GL/De)
so no problem).
The generated Peer doDelete methods which get an object instance or an
ObjectKey as its parameter would then have to be extended to evaluate the
number of returned rows and throw the proposed exception.
Regards,
Arne Siegel
***
12 matches
Mail list logo
