-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> The following reproduces what I believe is a know bug in DBD::Pg 1.40. Is
> there a new version due out anytime soon?
This has been fixed in CVS, and will be in 1.41. We hope to release it in
the next few weeks. Until then, you can specifically bi
b == [EMAIL PROTECTED] writes:
b> Here is a small script that reproduces the problem:
b> $ cat ii
b> #!/usr/bin/perl
b> use strict;
b> use warnings;
b> use lib '/ems_src/lib/modules';
b> use DBI;
b> my $h = 'foo';
b> my $v1 = 382;
b> my $v2 = 1;
b> my $dbh = DB
Here is a small script that reproduces the problem:
$ cat ii
#!/usr/bin/perl
use strict;
use warnings;
use lib '/ems_src/lib/modules';
use DBI;
my $h = 'foo';
my $v1 = 382;
my $v2 = 1;
my $dbh = DBI->connect("dbi:Pg:dbname='mydb';host='dbhost'");
my $sth = $dbh->prepare
k == [EMAIL PROTECTED] writes:
k> On Wed, 23 Mar 2005 15:11:13 -0600 (CST), Brandon Metcalf
k> <[EMAIL PROTECTED]> wrote:
k> > I have several cases where if I try to prepare() a statement and then
k> > execute() it, I get the following:
k> >
k> > DBD::Pg::st execute failed: ERROR: column
On Wed, 23 Mar 2005 15:11:13 -0600 (CST), Brandon Metcalf
<[EMAIL PROTECTED]> wrote:
> I have several cases where if I try to prepare() a statement and then
> execute() it, I get the following:
>
> DBD::Pg::st execute failed: ERROR: column "report_time" is of type integer
> but expression is o
I have several cases where if I try to prepare() a statement and then
execute() it, I get the following:
DBD::Pg::st execute failed: ERROR: column "report_time" is of type integer
but expression is of type character varying
HINT: You will need to rewrite or cast the expression.
However, if
Hmmm...
Deadlocks are an application level issue. I would be very surprised if this
were a problem with DBI or DBD::Oracle. Did this generate a trc file in the
user_dump_dest?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: [EMAIL PROTECTED] [mail
On Wed, 23 Mar 2005 19:56:48 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> This statement
...
> causes a deadlock. But accidently, we found that this one
...
> works!
Maybe it's not a DBI or DBD::Oracle problem. How about this issue if
the statement is executed via other tools
Does 'tnsping Mycad4prod' work from host(A)? I created a service
called test.xyz.com. 'tnsping test' fails (TNS-03505: Failed to resolve
name), but 'tnsping test.xyz.com' works. This doesn't sound like a DBI
issue at this point.
On Mar 23, Kairam, Raj scribed:
> To those who could help me with
This is not a DBI issue.
However, from oerr:
$ oerr ora 12514
12514, 0, "TNS:listener could not resolve SERVICE_NAME given in connect
descriptor"
// *Cause: The SERVICE_NAME in the CONNECT_DATA was not found in
// the listener's tables.
// *Action: Check to make sure that the SERVICE_NAME s
Yup.
On Wed, 2005-03-23 at 11:10 -0800, Jeff Zucker wrote:
> For the past couple of days, I have been getting blank messages from Kim
> Nielsen [EMAIL PROTECTED] every time I post to dbi-users. Anyone else?
>
--
Scott T. Hildreth <[EMAIL PROTECTED]>
Jeff Zucker wrote:
For the past couple of days, I have been getting blank messages from Kim
Nielsen [EMAIL PROTECTED] every time I post to dbi-users. Anyone else?
Nothing yet - lets see what this posting triggers...
Jacqui
It hangs up in the connect - using DBI::pg 1.40, DBD 1.48
Code is:
my $db = "dbi:Pg:dbname=issp";
my $dbh = DBI->connect($db); #, "", "");
I also tried it with ($db, $username, $password) as well.
The problem is the call to DBI->connect() never returns.
Any assistance on this greatly appreciat
To those who could help me with a problem connecting to an Oracle database on
HP-UX from within a perl script that uses DBI
I have a perl program on a unix (HP-UX) host(A) running Oracle 8.1.6
In the program I am trying to connect to another unix (HP-UX) host(B) running
Oracle 8.1.7 holding a t
On Wed, 23 Mar 2005 12:12:51 -0700, Reidy, Ron
<[EMAIL PROTECTED]> wrote:
> yes
>
Me too.
From some others also.
I suspect it's because of the mail reader / posting software some were using.
K.C
Reidy, Ron wrote:
yes
For the past couple of days, I have been getting blank messages from Kim
Nielsen [EMAIL PROTECTED] every time I post to dbi-users. Anyone else?
Ok, I've written to the postmaster. So far only response is another
blank message :-).
--
Jeff
yes
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 12:11 PM
To: dbi-users; [EMAIL PROTECTED]
Subject: Anyone getting blank messages from the list?
For the past couple of days, I h
For the past couple of days, I have been getting blank messages from Kim
Nielsen [EMAIL PROTECTED] every time I post to dbi-users. Anyone else?
--
Jeff
Brandon Metcalf wrote:
j == [EMAIL PROTECTED] writes:
j> Brandon Metcalf wrote:
j> >Hm. The documentation says it's experimental, but the version I have
j> >seems to be broken altogether. There is no new() method in the
j> >DBI::Format package in the code and I get in the following error:
j> >
j>
j == [EMAIL PROTECTED] writes:
j> Brandon Metcalf wrote:
j> >Hm. The documentation says it's experimental, but the version I have
j> >seems to be broken altogether. There is no new() method in the
j> >DBI::Format package in the code and I get in the following error:
j> >
j> You don't decl
Brandon Metcalf wrote:
Hm. The documentation says it's experimental, but the version I have
seems to be broken altogether. There is no new() method in the
DBI::Format package in the code and I get in the following error:
You don't declare a new DBI::Format object, you create a new
DBI::Format::F
Hi!
This statement
$SqlStr_pstes_i = "insert into [EMAIL PROTECTED] (PSTES_OC, PSTES_ECO_SCHAPO,
PSTES_DATUM) ".
"select PSTES_OC, PSTES_ECO_SCHAPO, PSTES_DATUM ".
"from zplus_pstes ".
"where PSTES_OC = :1 and PSTES_DATUM = to_date(:2,
'
j == [EMAIL PROTECTED] writes:
j> Brandon Metcalf wrote:
j> >Does DBI have a print method similar to the print in the old Pg.pm
j> >interface? With the old print method I could print out query results
j> >as they would appear if I ran the query directly with the column names
j> >and column
Brandon Metcalf wrote:
Does DBI have a print method similar to the print in the old Pg.pm
interface? With the old print method I could print out query results
as they would appear if I ran the query directly with the column names
and column widths according to value widths, etc.
Do I have to roll
Does DBI have a print method similar to the print in the old Pg.pm
interface? With the old print method I could print out query results
as they would appear if I ran the query directly with the column names
and column widths according to value widths, etc.
Do I have to roll my own under DBI using
Can we see your connection code?
Version 0.07 of DBIx::DBH has entered CPAN with support for Sybase
connections provided by Rachel Richard.
NAME
DBIx::DBH - Perl extension for simplifying database connections
ABSTRACT
DBIx::DBH is designed to facilitate and validate the process of creating
DBI database connections.
If this is due to a timeout issue then you want to increase the timeout
settings on your system. That would be something you will need to configure
on the client side in the OS settings.
> -Original Message-
> From: Chris Masters [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, Marc
On 2005-03-23 02:09:40 -0800, Chris Masters wrote:
> --- Chris Masters <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > A firewall is terminating my connection with a mysql
> > database after a period of inactivity. I've used the
> > following code (with ref to cpan docs and connect)
> > and
> > it
Thanks for the reply Tony - much appreciated.
I've had this happen before with the C mysql lib. The
library handled the alarm signal internally somehow.
The only way to timeout the query was to use fork(2)
and select(2) - way too complex for the perl process
I'm using.
I wonder if the mysql serve
Hi Chris,
I've seen this problem before but connecting to an Oracle DB. I wasn't
directly involved so at the time, but I believe that we found some
documention that says that alarm is not guartenteed to respond "on time" on
a busy system. In our case a 5 seconds wait came back over an hour lat
On Tue, Mar 22, 2005 at 01:52:10PM -0800, Greg Fossheim wrote:
> Has anyone built DBD::Oracle with the instantclient libraries? (v. 10.0.
> specifically)
>
> Would greatly appreciate any feedback available,
Some have and reported here. Try google.
I hope to get aroundtuit sometime soonish to ad
It turned out that I had not download and installed the proper version of
DB2. I revisited IBM's web site and downloaded the developer's edition.
After installing this version of DB2 I was able to successfully compile and
install the DBD::DB2 module for perl. Thanks to all who responded to my
Hi list,
please CC to me, I'm not on the list.
I have a problem using DBI on FreeBSD.
The mysql server is on a remote host and I can login with my username
manually.
However, the DBI module always appends a @'localhost' to the username,
even when I specify the username to be '[EMAIL PROTECTED]'
Has anyone built DBD::Oracle with the instantclient libraries? (v. 10.0.
specifically)
Would greatly appreciate any feedback available,
Greg Fossheim
[EMAIL PROTECTED]
That would be the very definition of "known issue", I'd say. Thanks,
and sorry for the silly question!
--Ben
--
Benjamin Warfield
Research Associate, Computational Chemistry
Neurogen Corporation
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March
Is the lack of response because this is a stupid
question related to an extensively documented problem
or does no one else have experience of this issue?
Anyone?
Thanks, Chris
--- Chris Masters <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> A firewall is terminating my connection with a mysql
> data
Hello all,
I am still having problems to 'connect internal' when there are different
$ORACLE_HOMEs owned by different $ORACLE_OWNERs.
For example (SunOS sap09 5.7 Generic_106541-32 sun4us sparc FJSV,GPUSK):
user1: /oracle/elearn/app/oracle/product/9.2.0_32
user2: /oracle/S13/817_64
(On an
38 matches
Mail list logo
