Hello,
(B
(BIs there way to set timeout in DBD::ODBC?
(BI'm trying to make a script updating SQL server.
(B
(BI hear our SQL server is set 10 minutes as timeout (default).
(BAnd also I hear ADO has 30 secomd default time & can be
(Bchanged with some property.
(BNot knowing much about timeou
Another good point Ron. This strategy allows update and delete activity on
the table concurrently with the insert.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 15 September 2004 6:53 AM
To: Steve Baldwin; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject
I'm using DBI 1.43 as part of a plugin module for the "Radiator" RADIUS
protocol server.
The server forks child processes to handle incoming requests. I
believe that the children are dumping core at the time that they exit.
Here is the stack backtrace from the core:
current thread: [EMAIL PROTE
Or ...
SELECT MIN(id)
FROM t
FOR UPDATE;
Would only cause a row lock.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Steve Baldwin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 2:50 PM
To: Reidy, Ron; 'NIPP, SCOTT V (SBCSI)'; [EMAIL
Good point Ron. However, if the requirement were to 'recycle' deleted ID's,
you could obtain an exclusive lock on the table before issuing the SELECT.
However, if you expect a large number of concurrent executions of this code,
you would want to ensure the INSERT and subsequent COMMIT happens
imme
With Oracle, this will not work with many users executing the code at the same time.
Better to use q sequence.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Steve Baldwin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 2:41 PM
To: 'NIPP
You didn't mention what DB you are using, but if it were Oracle, I would do
something like this ...
SELECT MIN (user_id) + 1
FROM user_table a
WHERE userid >= 3000
ANDNOT EXISTS (
SELECT 0
FROM user_table b
WHERE b.user_id = a.user_id + 1)
You would obviously want t
Thank you all for the correct pointer.
It works great.
Urmil
-Original Message-
From: Sterin, Ilya (I.) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:27 AM
To: Shah, Urmil; [EMAIL PROTECTED]
Subject: RE: How to read LONG data type
Set LongTruncOK and LongReadLen, also
Is there a reason you want to use 3000 as a base? If there are no IDs >=
3000, then just start with 3000 and increment. If there are ID values
that exceed 3000, do you want to start AFTER those values, or if you
have 3000, 3001, 3002, 3010 in the table, do you want the next value to be
30
NIPP, SCOTT V (SBCSI) wrote:
I have a table that has a list of users with numeric user IDs.
The user IDs are not sequential. There are large gaps in the list of
numeric IDs. I want to pick the next unused number beginning at 3000.
I'd use an autoincrement column for ID so you don't have
On Tue, Sep 14, 2004 at 02:30:43PM -0500, NIPP, SCOTT V (SBCSI) wrote:
> I have a table that has a list of users with numeric user IDs.
> The user IDs are not sequential. There are large gaps in the list of
> numeric IDs. I want to pick the next unused number beginning at 3000.
> How do I d
I have a table that has a list of users with numeric user IDs.
The user IDs are not sequential. There are large gaps in the list of
numeric IDs. I want to pick the next unused number beginning at 3000.
How do I do this?
Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mai
Read the docs; look for LongReadLen.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Shah, Urmil [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 10:23 AM
To: [EMAIL PROTECTED]
Subject: How to read LONG data type
I have a column in a table
Sometimes you just can't see the wood for the trees
:-)
More sleep needed!
Thanks all,
Marty
--- "Sterin, Ilya (I.)" <[EMAIL PROTECTED]> wrote:
> Or better yet
>
> $sth->bind_param($_, $execute_args[$_]) for
> (0..$#execute_args);
>
> Arrays start from zero.
>
> Ilya
>
> -Original Mess
Set LongTruncOK and LongReadLen, also make sure you are always binding
anything that has to do with Longs.
See docs for above parameters.
Ilya
-Original Message-
From: Shah, Urmil [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 12:23 PM
To: [EMAIL PROTECTED]
Subject: How to
I have a column in a table that has a data type=LONG. The content of
this column is a text file(it is not a pointer to a text file but the
raw text file itself). When I try to simple select statement in perl it
gives following error.
Do I need to notify perl that it is a LONG data type and read
No, not quite right.
While arrays start from zero, bind_param numbers start at 1.
See my other contribution I posted just prior to this.
-Original Message-
From: Sterin, Ilya (I.) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 8:58 AM
To: Tim Bunce; Martin Moss
Cc: Jenda Kry
Personally, I would recommend this variation of the idiom...
$sth->bind_param($_+1, $execute_args[$_]) for 0..$#execute_args;
Or maybe this???
my $i=1;
$sth->bind_param($i++, $_) foreach @execute_args;
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, Septembe
Or better yet
$sth->bind_param($_, $execute_args[$_]) for (0..$#execute_args);
Arrays start from zero.
Ilya
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:56 AM
To: Martin Moss
Cc: Tim Bunce; Jenda Krynicky; [EMAIL PROTECTED]
Subject:
On Tue, Sep 14, 2004 at 10:47:27AM -, Jbari Mohamed Said wrote:
>Hello,
> i have select statement in the format:
>
> select record1 from table where record2 in ('122','134')
>
> The problem is i don't know in fact the number passed to 'in' in the select
> below so whe
On Tue, Sep 14, 2004 at 02:33:41PM +0100, Martin Moss wrote:
> I've got one further issue thats driving me nuts.
>
> Here is the code I'm running,
>
> $sth->bind_param($_, $execute_args[$_]) for ([EMAIL PROTECTED]);
Actually that needs to be $execute_args[$_-1]
That may fix your other problem.
Jbari Mohamed Said wrote:
select record1 from table where record2 in ('122','134')
The problem is i don't know in fact the number passed to 'in' in the
select below so when i call 'execute' from PERL/DBI module like this:
<> $sth = $dbh->prepare(q{select record1 from table where record2 in
Are you using MTS (if so, have you performed the diagnostics in note 1005259.6)? Have
you done any SQL*Net tracing?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Tristan Greaves [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 9:06 AM
To
> ---Original Message-
> From: Reidy, Ron [mailto:[EMAIL PROTECTED]
> Sent: 14 September 2004 16:04
> To: Tristan Greaves; [EMAIL PROTECTED]
> Subject: RE: :Oracle and ORA-600 [16365] errors
>
> You should listen to Oracle support. From metalink:
>
> Doc ID: Note:106607.1
> Subject:
Use temp tables.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Jbari Mohamed Said [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 4:47 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Jbari Mohamed Said
Subject: PER
You should listen to Oracle support. From metalink:
Doc ID: Note:106607.1
Subject:ORA-600 [16365] "Half duplex violation"
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 26-APR-2000
Last Revision Date: 25-MAR-2004
Note: For addi
I've got one further issue thats driving me nuts.
Here is the code I'm running,
$sth->bind_param($_, $execute_args[$_]) for
([EMAIL PROTECTED]);
$sth->bind_param_inout(scalar
@execute_args+1,\$new_id,38);
if($sth->execute())
{
..
N.b. using scalar @execute_args produces rebind
errors,
>
>
>
> "Jeff Urlwin" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Robert,
> >
> > I do have the 1.16 rc (beta) up there and it is 51K, not
> 193K. It's
> > bad
> and I have to
> > look at it.
> >
> > Jeff
> >
> Is the "esoftmatic" site the generally the "right" place to
Hello,
i have select
statement in the format:
select record1
from table where record2 in ('122','134')
The problem is
i don't know in fact the number passed to 'in' in the select below so when i
call 'execute' from PERL/DBI module like this:
$sth =
$dbh->prepare(q{select record1
Thanks for you help,
Marty
--- Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 14, 2004 at 12:34:09AM +0200, Jenda
> Krynicky wrote:
> > From: Tim Bunce <[EMAIL PROTECTED]>
> > >
> > > Use bind_param() or bind_param_inout() for all
> the params
> > > and then call execute() with no argumen
On Mon, Sep 13, 2004 at 07:03:41PM -0500, James D. White wrote:
> If either
> use64bitall or threads will cause a problem in building and
> installing my add-on modules, then I probably need to avoid
> enabling these options.
The only way to be sure is to try it.
You'll need to reinstall all you
[Copy of original email I sent to Tim, but I would value the input from
anyone on this list who has any ideas]
Hi there Tim,
We are using DBD::Oracle as part of our web site here, and are
experiencing some Oracle crash issues. We are trying to pin down the
cause and I was wondering if you have h
On Tue, Sep 14, 2004 at 12:34:09AM +0200, Jenda Krynicky wrote:
> From: Tim Bunce <[EMAIL PROTECTED]>
> >
> > Use bind_param() or bind_param_inout() for all the params
> > and then call execute() with no arguments.
> >
> > Tim.
>
> I wonder ... how about adding a method bind_params() like this:
33 matches
Mail list logo
