ler. E.g.:
My $dbh = DBI->connect( ...
$SIG{ CHLD } = 'DEFAULT';
Regards,
-Aaron
-Original Message-
From: Sands Peter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 07, 2007 8:32 AM
To: 'dbi-users@perl.org'
Subject: Error always returned from system() aft
executing several other child processes.
Thanks for the help,
-Aaron
As a follow up, I rebuilt Perl using the Sun CC compiler and without the
"-D use64bitint" option. I rebuilt DBI and DBD::Oracle. All tests passed
and my connect no longer cores. I'm not sure how or if the 'use64bitint'
option was related to my previous problem but DBD is working now.
it to work please pass your
notes along.
""Aaron Saarela"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
tas.com...
Hi dbi-users,
I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've
x27;
# pstack core
fefe5bb0 XS_DBD__Oracle__dr_init_oci (137188, 302ef4, 1ca928, 2,
140dc4, 322ac8) + 1cc
00092d80 Perl_pp_entersub (137188, 1ca92c, 80, 0, 1ca924, 0) + 5c0
0008a4dc Perl_runops_standard (137188, 80, 0, 0, 12c, 14cd50) + 2c
0002a458 S_run_body (137188, 1, 137188, 0, 137188, 137cfc) + 13c
0002a0a0 perl_run (137188, 1, 3, ffbff8dc, 134c00, 2) + 8c
0002698c main (3, ffbff8dc, ffbff8ec, 137170, 0, 0) + b8
0002676c _start (0, 0, 0, 0, 0, 0) + 5c
Regards,
Aaron Saarela
Principle Software Engineer
Symantec Corporation
Email: [EMAIL PROTECTED]
ulder/www/syshandler
line 8
-> $DBI::errstr (&) FETCH from lasth=HASH
>> DBD::Pg::dr::errstr
<- $DBI::errstr= undef
DBI connect
('database=;host=*;port=5432','muuser',...) failed: (no error
string)
Any ideas? Thanks,
Aaron
On De
I debug
this to figure out why DBI is barfing?
The actual connect statement is:
my %dbh;
$dbh{'singlepid'} = DBI->connect(Mu::DBI->dsn, Mu::Config->DBUSER,
Mu::Config->DBPASS, { PrintError => 1, RaiseError => 1,
AutoCommit => 0,
FetchHashK
tc.) are available for MySQL right now, or are slated to be available
> in the next release. However, PgSQL is still slow, hard to use, and of
> questionable reliability.
MySql has really caught up stored procedures, views, and triggers are new
features in 5.0 while replication (since 3.xx), clustering (since 4.1),
transactional table types (innodb since 3.xx), have been around for a while.
Even with all these new features mysql is still blazing fast.
Aaron Dancygier
disconnect from DESTROY for the inherited DB
handle from the parent and thus should maintain the parent's connection.
Only calling disconnect() from the child on the handle should
disconnect the parent once InactiveDestroy is turned on.
At least that's what the DBI pod seems to say...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Nov 7, 2005, at 8:57 PM, Jonathan Leffler wrote:
On 11/6/05, Aaron Turner <[EMAIL PROTECTED]> wrote:
When I run my code, I see the
$dbh hash change inside of the child process and the parent hash stay
the same. Aren't I avoidin
d and then calling connect again?
Thanks,
Aaron
- --
Aaron Turner, Sr. Security Engineer
<[EMAIL PROTECTED]>
Ph: 408.329.6320 Fax: 408.329.6317
On Nov 5, 2005, at 9:56 PM, Jonathan Leffler wrote:
On 11/5/05, Aaron Turner <[EMAIL PROTECTED]> wrote:
dbh->{InactiveDestroy} = 1)) {
croak("Why can't i turn off destroy? " . DBI::errstr);
}
Mu::DBI->undef_dbh();
Mu::DBI->connect();
[ do some DB stuff here... ]
}
}
- --
Aa
suggestion as to how I can deal
with this other than using DBI->installed_versions ?
Thanks in advance for any help!
Aaron
__
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
ed within Perl code. But
TIMTOWTDI, of course.
-Aaron
e FROM person WHERE person_id = ?
And have some DBIx::Declare-aware template-processing engine handle
page requests automagically such that adding new templates and/or SQL
code doesn't involve writing or maintaining a single line of Perl code.
Thanks for your helpful comments,
-Aaron
ll. But stored procedures
still must be called by name, not by context.
Finally, where is this module obtained?
Currently, only in the dark nether regions of my cranium. Once I'm
satisfied that I've at least tried to satisfy comments such as yours,
I'll actually do the work of typing it out.
Thanks for your time and thoughts,
-Aaron
On Dec 24, 2003, at 2:21 PM, Jay Hannah wrote:
Your email client line-wrapped the POD. Is there a URL for easier
reading?
Thanks, I've put it up at
http://www.people.virginia.edu/~ajm6q/dbix-declare.html
field naming
conventions
should be followed. First, using the bare field name "id" for every
table's primary key will likely render DBIx::Declare useless;
instead,
use "table_id" for primary keys, and identically named foreign keys
to
reference the tabl
O entry_reference (reference_typeID, entryID, value)
VALUES ('9', '2118', http://synfin.net/)
obviously, that won't work...
Any suggestions?
DBI v1.35
DBD::mysql v2.1026
Thanks,
Aaron
--
Aaron Turner http://synfin.net/aturner
They that can give up essential
lf->{_value}) or $self->rollback($dbh->errstr);
and somehow, it's generating this (from the mysql log):
INSERT INTO entry_reference (reference_typeID, entryID, value)
VALUES ('9', '2118', http://synfin.net/)
obviously, that won't work...
Any suggestions?
Perl 5.6.1
DBI v1.35
DBD::mysql v2.1026
Thanks,
Aaron
which is some
sort
> of recepture for DBD::Oracle)
>
> Waldemar
>
Thanks for the tip. That patch was already installed, and after setting
LD_PRELOAD all tests passed.
Aaron Brice
ST Microelectronics
/arch/auto/DBD/Informix/Informix.sl' for module DBD::Informix: Exec
format error at /opt/perl5/lib/5.00503/PA-RISC1.1/DynaLoader.pm line 169.
Any suggestions?
Thanks,
Aaron Brice
ST Microelectronics
Koie
I put some code in your original email... This is an example
connecting to oracle, but should be pretty close. You will just need to
dress up the select statement.
Aaron.
At 12:08 PM 4/2/2002, you wrote:
>In my mysql database i have a field called custnum and password.
I am
not having much luck. I have tried reading various docs (most are Unix
related) and I can't quite seem to find the right combination to put DBD
together. Any ideas/suggestions are greatly appreciated.
Thanks,
Aaron.
---
Aaron MacL
Thanks,
Missed the "my" on the $dbh = Thanks.
Aaron
---
Aaron MacLennan ~OpenVMS 7.2-1
Western State College ~Oracle 8.1.6
Taylor Hall 105 ~Banner 2000 5.x
Gunnison CO,81231 ~Pipeline 3.0.1
ph
onnect to a database.
Thanks for any ideas/opinions.
Aaron
---
Aaron MacLennan ~OpenVMS 7.2-1
Western State College ~Oracle 8.1.6
Taylor Hall 105 ~Banner 2000 5.x
Gunnison CO,81231 ~Pipeline 3.0.1
ph (970) 943-3123 x 31
or, I don't think I want to try to handle CREATE FUNCTION syntax
parsing myself (does DBI have a hook into these? I didn't think so ...)
-Aaron
@ids );
}
And let Inline::SQL (or whatever it's called) do all the binding and
whatnot. I think this is much cleaner than the equivalent "inlined DBI
code".
-Aaron
>
> 3/ I have the impression that people want to use Inline as the Filter module
>
> 4/ I agree about most
get_users () { # or: @get_users()
SELECT name FROM users ORDER BY id;
}
etc.
Thanks in advance for any commentary or advice.
-Aaron
On Fri, 1 Mar 2002, Tim Bunce wrote:
> On Thu, Feb 28, 2002 at 10:14:08PM -0800, Dean Arnold wrote:
> > Just stumbled on this in c.l.p.modules, thought
binutils. After that Oracle installed fine.
Aaron
I have had similar trouble. When I try to install Oracle 9i over RH 7.1, I
get a large number of errors about missing files, I/O errors and makefile
this isn't ontopic for the dbi-list try perl friends or something like
that.
Aaron
On Fri, 2 Nov 2001, Nigel Gall wrote:
> Hi! I'm a new user of PERL and I'm trying to write a script to give me a
> condensed list of file permissions of an NTFS file system. For example,
if it's just the field names you are after,
you can also just ask oracle's data dictionary the same question:
use dbi;$dbh = DBI->connect(
"dbi:Oracle:Instance_name", 'user', 'pass', {RaiseError=>1});die "oracle
Connection error\n" unless (defined($dbh));
$stmt = $dbh->prepare("select
c
ing with this error:
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2] SQL0518N The
statement name
d in the EXECUTE statement is not in a prepared state or is a SELECT or
VALUES s
tatement. SQLSTATE=07003
Any suggestions or snippets of code that do the same thing would be very
helpful.
-Aaron
[EMAIL PROTECTED]
27;s online manual section for the convert
command and you should find what you need. The date_fmt will affect the
return of all dates, and you may not want to do that.
--
Aaron
Perl Hacker
perl -e "print pack 'h*',
'96473702075627c6c20247861647023786f657c6460216e6377756270297f6572
i:DriverName:database_name
dbi:DriverName:database_name@hostname
dbi:DriverName:database_name~hostname!port
dbi:DriverName:database=database_name;host=hostname;port=port
hth,
Aaron
35 matches
Mail list logo