kpeterson wrote:
>> You might need to increase your Sequence Number Cache size
>> http://download-west.oracle.com/docs/cd/A87860_01/doc/index.htm
Cheers Kore... Will give it a try out. Sorry for the late reply, didn't
get any list emails at all yesterday!
--
-dc [ cf5, ora8.1.7, iis5 ]
[Today
You might need to increase your Sequence Number Cache size
You can read about it on OTN.
http://download-west.oracle.com/docs/cd/A87860_01/doc/index.htm
---cut---
When designing applications for Oracle Parallel Server, use sequence
numbers whenever possible. To maximize the use of sequences, eac
I've never had a problem with them. But, our sites aren't extremely high
traffic.
-d
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 15, 2003 6:43 AM
Subject: Oracle Sequences
> Anybody ever had problems with the request for a seque
Hm...I wonder how we could test it got any thoughts?
-Deanna
- Original Message -
From: "Dave Carabetta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 12:28 PM
Subject: Re: Oracle Sequences
> >That
>That's how it's been explained to me. It might be different with CFMX
>(we're
>still on CF 5.0).
Well, unless it was a CF 5-specific thing (we went straight from 4.5 to MX),
we did this all the time without issue using CF 4.5/Oracle in our code. And
this was as recent as 3 months ago when we u
That's how it's been explained to me. It might be different with CFMX (we're
still on CF 5.0).
-Deanna
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 11:14 AM
Subject: RE: Oracle Seq
plicit
commit within cftransaction tags. cftransaction withh perform the commit
unless otherwise told not to do so.
>
> Doug
>
> -Original Message-
> From: Deanna Schneider [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 12:02 PM
> To: CF-Talk
> Sub
withh perform the commit unless otherwise told not to do so.
Doug
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 12:02 PM
To: CF-Talk
Subject: Re: Oracle Sequences
It's a driver issue. The oracle drivers don't allow multip
; _
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 10:47 AM
> To: CF-Talk
> Subject: RE: Oracle Sequences
>
>
> in Oracle you select stuff like this from the table dual, Oracles all
> powerful ally.
>
>
> Example
> se
media.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: Tyler Clendenin
To: CF-Talk
Sent: Wednesday, November 05, 2003 8:28 AM
Subject: RE: Ora
AIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 10:28 AM
Subject: RE: Oracle Sequences
> right but that is not a very intuitive approach, shouldn't there be
> something. is it just because the oracle driver does not allow multiple
&g
Dave Carabetta wrote:
>
> JDBC has a limitation where you can't have multiple queries within the same
> cfquery, as least for Oracle (not sure about the other vendors).
The JDBC spec has the limitation, but not every JDBC driver obeys
the spec.
Jochem
--
You have the right
to remain silent
b
>right but that is not a very intuitive approach, shouldn't there be
>something. is it just because the oracle driver does not allow multiple
>queries in the same cfquery and the mssql driver does? is there any way i
>can get around this. i really don't want to have to break that statement
>out
Thanks Dave. What a pain. but i'm glad i recieved a more difinitive
answer.
Tyler Clendenin
GSL Solutions
_
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 11:19 AM
To: CF-Talk
Subject: Re: Oracle Sequences
>I am using CF6.1 on a redh
cfsqltype="CF_SQL_VARCHAR">
)
-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: 05 November 2003 16:24
To: CF-Talk
Subject: RE: Oracle Sequences
right i tried that too (sorry forgot to post it), still the same
error of
"[Macrome
n
GSL Solutions
_
From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:44 AM
To: CF-Talk
Subject: RE: Oracle Sequences
Try doing two separate queries:
INSERT INTO ...
SELECT PKSeq.CurrVal
Stick them inside a transaction and you shoul
>I am using CF6.1 on a redhat linux server connecting to Oracle 8i. I am
>trying to select the CurrVal of the sequence that i just used to insert a
>recod. in mssql server i can do this by selecting @@identity and i know in
>oracle i can do it using SeqName.CurrVal. The problem is i get this err
2003 10:47 AM
To: CF-Talk
Subject: RE: Oracle Sequences
in Oracle you select stuff like this from the table dual, Oracles all
powerful ally.
Example
select elem_seq.currval from dual
Doug
-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 200
in Oracle you select stuff like this from the table dual, Oracles all powerful ally.
Example
select elem_seq.currval from dual
Doug
-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:48 AM
To: CF-Talk
Subject: Oracle Sequences
I
Try doing two separate queries:
INSERT INTO ...
SELECT PKSeq.CurrVal
Stick them inside a transaction and you should be good to go.
-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:48 AM
To: CF-Talk
Subject: Oracle Sequenc
20 matches
Mail list logo
