dittoand I'd add that if your delete is taking forever to run that
you may want to consider getting some indexes on the columns you are
using to filter for your delete. If a select * from myTable where
insert your predicate here takes a long time, then so will a delete
with the same
The rollback issue will not disappear. IIRC, Autocommit simply issues
a commit at the end of the transaction (delete) without you having to do
it explicitly.
Steve Sapovits wrote:
Feeling all confident, I fired up a DELETE/WHERE from SQL*Plus directly,
only to get a weekend call at my
the flags your DBM implementation expects and
pass them as specified in the DBD::DBM docs.
--
Jeff
fix the distro soon.
--
Jeff
there.
--
Jeff
{ SELECT * FROM info WHERE ip = 192.168.1.44 };
Also it looks like you are connecting twice - the first connection in your
script will be ignored.
--
Jeff
SELCT
-Original Message-
From: Christian Krauße [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 7, 2007 10:42 PM
To: dbi-users
* FROM info WHERE ip = '192.168.1.44' };
To use delimited identifiers would be something like this:
my $sql = qq{ SELECT * FROM c:/foo/bar.csv WHERE ip='192.168.1.44' };
--
Jeff
Also it looks like you are connecting twice - the first connection in your
script will be ignored.
--
Jeff
(also by me) for their SQL
engine.
Does somebody know any DBD for flat files that will meet above requirements?
No, sorry, but patches and collaborators welcome.
--
Jeff
Thanks
- Santosh
On 4/27/07, Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
wrote:
Santosh Pathak wrote:
Hi
chopping in Perl and the CSV parsing in Text::CSV_XS.
--
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 27, 2007 04:50 PM
To: 'Santosh Pathak', 'Garrett, Philip (MAN-Corporate)', dbi-users@perl.org
Subject: Re: :CSV and multi character
in the connect
statement and omit or die in the rest of the code.
--
Jeff
of perl
errors in your code.
--
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 14, 2007 04:01 PM
To: [EMAIL PROTECTED], dbi-users@perl.org
Subject: Re: ShowErrorStatement
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent
. I'd
also like to thank the many people over the years who sent bug reports
and patches and jumped in to help when I needed it, especially Tim Bunce
and Dean Arnold.
--
Jeff Zucker (j...@perlmonks, jzuc...@cpan)
::Oracle8;
my $db3=DBI-connect(dbi:Oracle8:SERV2,'','');
Any ideas as to why? Thanks.
Jeff
Yes, They are built against the different
Oracle libs.
If anyone has solved this before I'm happy
to abandon this strategy
:-)
On Wed, 2009-10-28 at 19:41 +, Martin J. Evans wrote:
jeff wrote:
Hi all,
Hope someone can help.
I need to talk to both an oracle 8 and oracle 10
to Oracle 7 and 9i.
May be a bit less hassle.
Steve
On Thu, Oct 29, 2009 at 6:41 AM, Martin J. Evans
martin.ev...@easysoft.com wrote:
jeff wrote:
Hi all,
Hope someone can help.
I need to talk to both an oracle 8 and oracle 10 server in the same
script using their respective
, Oct 29, 2009 at 6:41 AM, Martin J. Evans
martin.ev...@easysoft.com wrote:
jeff wrote:
Hi all,
Hope someone can help.
I need to talk to both an oracle 8 and oracle 10 server in the same
script using their respective external connections capabilities (i.e.,
no user name or password
versions PLEASE let me know how.
Thanks. Any other solutions would be GREATLY appreciated.
;-)
On Wed, 2009-10-28 at 21:18 +0100, Alexander Foken wrote:
On 28.10.2009 20:38, jeff wrote:
Hi all,
Hope someone can help.
I need to talk to both an oracle 8 and oracle 10 server in the same
Asked a question yesterday but I don't think I worded it very well so
heres another try.
I want to do an 'external connection' (i.e., No user or password
supplied in DBI-connect ) from a single script to multiple versions of
Oracle ( Oracle 8 10 ).
What I have found so far is that Oracle.pm
On Thu, Oct 29, 2009 at 6:41 AM, Martin J. Evans
martin.ev...@easysoft.com wrote:
jeff wrote:
Hi all,
Hope someone can help.
I need to talk to both an oracle 8 and oracle 10 server in the same
script using their respective external connections capabilities (i.e
,PASSWORD from dba_users;
OW_ADMIN_UTILS 26749C6AA7E5A212
MYUSER EXTERNAL
OWPROJECT F068F107BFFB41DD
On Thu, 2009-10-29 at 05:15 -0400, jeff wrote:
Asked a question yesterday but I don't think I worded it very well so
heres another try
away with this with an 9 client and if memory serves me
correctly it can connect both wallet and the old 8 way
DBD::Oracle would then be able to handle both.
cheers
John Scoles
jeff wrote:
Please read the next post I put up to rephrase my question.
In all cases the connections
:
On 29/10/09 09:15, jeff wrote:
Asked a question yesterday but I don't think I worded it very well so
heres another try.
I want to do an 'external connection' (i.e., No user or password
supplied in DBI-connect ) from a single script to multiple versions of
Oracle ( Oracle 8 10
way
DBD::Oracle would then be able to handle both.
cheers
John Scoles
jeff wrote:
Please read the next post I put up to rephrase my question.
In all cases the connections have to 'external' - No name or password
given. The mechanism changed to the Oracle wallet in 10
and
the apps themselves running client 10 - 2 different perl installations.
Looks like it will work so far.
On Fri, 2009-10-30 at 08:27 -0700, Jared Still wrote:
On Wed, Oct 28, 2009 at 12:38 PM, jeff j...@roqc.no wrote:
I need to talk to both an oracle 8 and oracle 10 server
PS: Forgot to mention, these apps need to connect to an 8 and a 10
within the same script simultaneously. :-)
On Fri, 2009-10-30 at 08:27 -0700, Jared Still wrote:
On Wed, Oct 28, 2009 at 12:38 PM, jeff j...@roqc.no wrote:
I need to talk to both an oracle 8 and oracle 10
W: (03) 98110010
From: jeff j...@roqc.no
Date: Fri, 30 Oct 2009 11:59:24 -0400
To: Jared Still jkst...@gmail.com
Cc: dbi-users@perl.org
Subject: Re: Multiple Oracle clients in same code - no usernames needed
PS: Forgot to mention, these apps need to connect to an 8 and a 10
:-)
Can't, privileges do vary from SID to SID so need user's real access.
DBI::Proxyserver for one or the other is a winner I think.
On Mon, 2009-11-02 at 09:10 -0700, Bruce Johnson wrote:
On Oct 29, 2009, at 2:15 AM, jeff wrote:
Oracle.pm built against 8 works great with Oracle 8 when doing
and the usual setup for Oracle 10
connections with some limited success.
What would be ideal would be to have 2 different Oracle DBD connections
from within the same perl build. Any suggestions or ideas for potential
solutions out there ?
Thanks.
Jeff
To clarify - connecting 'internally' (ie, forcing users to provide
username passwords on the GUI ) is not an option - all connections
must be 'external'.
Forwarded Message
From: jeff j...@roqc.no
To: dbi-users@perl.org dbi-users@perl.org
Subject: Looking for clever solution
, preferably
the newer 10 client. It shuld work in 99.9% of all cases. If that
doesn't work, try 8. If that still does not work, try 9.
Alexander
On 14.12.2009 13:18, jeff wrote:
I need to connect simultaneously to both Oracle 8 and oracle 10 from the
same script using 'external' connection
NO user name/password
on interface.
The oracle client libraries seem to be mutually exclusive on the above
two modes of connection.
Forwarded Message
From: jeff j...@roqc.no
To: dbi dbi-users@perl.org
Subject: Clarify: Different versions of Oracle .so files within single
Perl build
DBI ProxyServer does not seem to return {NAMES} and {ora_types} on a
prepare statement as part of the statement handle hash for an oracle
connection. Is there a work around to get this info back on a prepare
statement ?
that thread startet two months ago. Well, I did, and it seems
you are resistant to consulting, both from Oracle experts and from
experienced DBI users.
So, why do you waste our time?
Alexander
On 14.12.2009 13:18, jeff wrote:
I need to connect simultaneously to both Oracle 8 and oracle 10 from
handles from the other.
This is effectively the proxy solution, but you're just forking and
proxying to a private sub-process you created.
(Full disclosure: I wrote the RMI modules. If they break for you please
email me.)
Scott
jeff wrote:
You make an incorrect assumption
Scott,
Would something like this be close:
##
$c = RMI::Client::ForkedPipes-new();
$c-call_use_lib($ENV{MY_PERL_INSTALL}.'/some/path/to/other/Oracle_module');
# A build of Oracle DBD using oracle 8 client not normally in @INC
$c-call_use('DBI');
Thank you, Scott !
In case anyone else needs this sort of setup: I wanted to share this
quick dirty successful test using Scott's RMI to connect to both
oracle 10 with a wallet and oracle 8 with external authentication - no
user names or passwords provided in script.
ora8_lib contains the
Who's ever the dbi-users group monitor, please shut this annoying person
off:
Kenneth Webber mp34...@hotmail.com
When building DBI with threads enabled there is a warning against using
threads. Is this really true - does anyone have any experience using
DBI with threads ?
Anyone know how ? The automated method doesn't work and owner doesn't
respond. LOL- You can not use the unsub word anywhere in your email
or it get bounced. Is this is some diabolical plot to never let anyone
leave. ;-)
Forwarded Message
From: jeff j...@roqc.no
To: Lesley Binks lesl...@pgcroft.net
Subject: Re: Get off the list
Date: Wed, 16 Jun 2010 07:39:01 -0400
Well, will try again. Hasn't worked yet. Get a reply asking for
confirmation. Send email to confirmation. The dbi-user emails keep
:-(
Oh well.
Forwarded Message
From: jeff j...@roqc.no
To: dbi dbi-users@perl.org
Subject: [Fwd: Re: Get off the list]
Date: Wed, 16 Jun 2010 07:40:04 -0400
Forwarded Message
From: jeff j...@roqc.no
To: Lesley Binks lesl...@pgcroft.net
Subject: Re: Get off
LOL
On Wed, 2010-06-16 at 13:12 +0100, Neil Beddoe wrote:
Welcome to the Hotel California.
-Original Message-
From: jeff [mailto:j...@roqc.no]
Sent: 16 June 2010 12:43
To: dbi
Subject: [Fwd: [Fwd: Re: Get off the list]]
:-(
Oh well.
Forwarded Message
Who is the administrator anyway ?
:-)
On Wed, 2010-06-16 at 08:06 -0400, jeff wrote:
LOL
On Wed, 2010-06-16 at 13:12 +0100, Neil Beddoe wrote:
Welcome to the Hotel California.
-Original Message-
From: jeff [mailto:j...@roqc.no]
Sent: 16 June 2010 12:43
To: dbi
No. It just doesn't seem to work. Has anyone tested it?
On Wed, 2010-06-16 at 18:27 -0500, David Nicol wrote:
does your receiving MTA give you a return-path header? Maybe you
forgot you are subscribed under an alias.
On Wed, Jun 16, 2010 at 5:47 AM, jeff j...@roqc.no wrote:
Anyone know how
./brokennvarchar -b
you should see it successfully get ID 100 5 times.
(If you run with -w you'll see it work the first time and fail the rest.
That was my original problem with the nvarchar's but now it affects the
regular varchar's. sigh)
Any pointers you could give me would be terrific!
--
Jeff
holders you didn't bind with -bind_param.
--
Jeff Trout [EMAIL PROTECTED]
http://www.jefftrout.com/
http://www.stuarthamm.net/
and they don't (and in reality you
folks convert unnamed to named internally).
good luck. let me know if I can help further.
--
Jeff Trout [EMAIL PROTECTED]
http://www.jefftrout.com/
http://www.stuarthamm.net/
this.
--
Jeff
Hi there,
I have a problem with quoting of backslashes when using DBI:CSV.
To be precise:
I insert a string containing a backslash into my database, and when I read
it out again, the backslash is doubled.
Please have a look at this sample code:
~
#!/usr/bin/perl -w
use strict;
use DBI;
my
Steffen G. wrote:
Jeff wrote:
...
Is this a bug in the DBI:CSV driver (DBD::File, DBD::CSV, Text::CSV_XS ?)
- or what am I doing wrong?
LOL, you're right there is a bug, and those are good guesses about where
it occurs, but all wrong :-). The bug is acutally in SQL::Parser!
How
-prepare($code)
or die Cannot prepare: . $dbh-errstr();
$sth-execute(1,'adams','morticia');
or die Cannot execute: . $sth-errstr();
When I made those changes to your code, it worked fine for me.
--
Jeff
e. Column
names can not contain anything other than letters, numbers, and
underscores.
--
Jeff
= DBI-connect("dbi:Pg:dbname='jeff'", 'jeff', '',
{AutoCommit = 0 });
open(FILE, 'test.msg');
undef $/;
my $msg = FILE;
close(FILE);
my $sth = $dbh-prepare("INSERT INTO message_sources VALUES(91, ?)");
$sth-bind_param(1, $msg);
$sth-execute();
$dbh-commit();
$dbh-disconnect;
I can look next? I imagine there will be quite a number
of people who will want to use this new functionality, as it finally
breaks the 32k row limit for PostgreSQL.
Jeff
--
Jeff Duffy
[EMAIL PROTECTED]
imp.h" in there).
3. Type 'patch dbdimp.h dbdimp.patch'.
4. Continue as usual with 'Perl Makefile.PL; make; make install'.
Big thanks go out to Tom.
Jeff Duffy
--
Jeff Duffy
Great Bridge LLC
[EMAIL PROTECTED]
, and life will be good.
So here's a call for patches: if anyone else knows of patches to
DBD::Pg 0.95 send them to me (along with some sort of explanation :)
and I'll get a pl1 release out.
Jeff
--
Jeff Duffy
[EMAIL PROTECTED]
he current Pg source to make doubly sure
of this, but I think it should be in there. Anyone else?
patch snipped
Thanks for the help, Giles.
Jeff
--
Jeff Duffy
Great Bridge, LLC (http://www.greatbridge.com)
PostgreSQL support and consulting services.
[EMAIL PROTECTED]
bh) = DBI::_new_dbh($drh, {
'Name' = $Name,
Ask your sysadmin how to apply it.
So many people offering different methods of doing this is stressful and
hectic
TMTOWTDI :)
Jeff
to perform the second insert directly after, the query executes ok, but
on the return from the function the script hangs as if something is going
out of scope. I can trace into OLE.pm, and in the FETCH method it hangs.
Can help with this, I'm kinda at a loss.
Regards,
Jeff Butler
-Original
in the
current session.
Your error sounds like nextval has not been called yet in the current
session.
HTH,
-Jeff
- Original Message -
From: K Old [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 11:30 AM
Subject: PostgreSQL currval()
Hello all,
I'm trying to do
I have found that the problem ocuurs in many
cases. For example, I use
sqlload userid=scott/tiger control=load log=load.log
to upload my data to the oracle. Once the data file
is very long. The same problem also occurs: it is stuck.
Jeff
From: Sterin, Ilya [EMAIL PROTECTED]
To: jeff knot
hard...
Jeff
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 8:14 AM
To: '[EMAIL PROTECTED]'
Subject: Re: Extract data from MS Excel Spreadsheets. Can it be done?
Yes, DBD::ADO or DBD::ODBC. Both will talk to Excel and Access.
Tom
$class_title : $prof_name\n;
}
--
Jeff
to these or is there
something wrong I'm doing. The ProxyServer is running in single-connection
mode but there is only one connection on it. Ans as far as I know the port
I'm using should not be used elsewhere. Any hints, tips, suggestions are
welcome.
Thanks,
Jeff Butler
-Original Message-
From: Neil Lunn [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 8:54 AM
To: 'Butler, Jeff'
Subject: RE: :Proxy with ADO/Access on WinNT
-Original Message-
From: Butler, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 5:25 PM
) at c:\perl\site\lib/DBI/ProxyServer.pm line
318, IN chunk 1.
Thanks,
Jeff Butler.
-Original Message-
From: Neil Lunn [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 8:54 AM
To: 'Butler, Jeff'
Subject:RE: :Proxy with ADO/Access on WinNT
-Original
Lunn [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 8:53 AM
To: 'Butler, Jeff'; '[EMAIL PROTECTED]'
Subject: RE: :Proxy with ADO/Access on WinNT
Hello Jeff,
Probably Still can't get mail to dbi-users but let's try any way.
I really checked out your problem on just about any
this to
$stmt = $dbh-prepare(SELECT * FROM foo WHERE date_added $mydate);
it's fine. What am I missing here?
--
Jeff Boes vox 616.226.9550
Database Engineer fax 616.349.9076
Nexcerpt, Inc
://www.vpservices.com/jeff/programs/AnyData/
--
Jeff
$0.02 to the effort, maybe even a nickel if time
permits, so please get in touch.
--
Jeff
page??? Do you just have to use
perlscript?
Frankly I hate ASP, but would consider writing more of it if I didn't
have to deal with that terrible database interface MS uses.
Jeff
Hi, all.
I 'v got an array of data(result of some ASP-page).
I want transfer this data to another ASP-page(call
*[+-]?\s*\.?\s*\d/
#$d =~ /^\s*[+-]?\s*\.?\s*\d/ ) {
} elsif ($c =~ /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/
$d =~ /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/) {
###
--
Jeff
) allows one to enter datatypes but
then ignores them. The fix is the patch to SQL::Statement I sent in my
previous note.
--
Jeff
Cannot execute: $DBI::errstr\n;
What could be wrong?
Jeff
AnyData.pm, for the DBI/SQL version you need both AnyData.pm and
DBD::AnyData.pm and you should install AnyData.pm first.
--
Jeff Zucker
README FILE FOR PERL MODULE -- AnyData
WHY USE IT?
The AnyData modules provide simple and uniform access to data from
many sources -- perl arrays, local files
,
for the DBI/SQL version you need both AnyData.pm and DBD::AnyData.pm and
you should install AnyData.pm first.
--
Jeff Zucker
README FILE FOR PERL MODULE -- DBD::AnyData
WHAT THE HECK IS IT?
The DBD::AnyData module provides a DBI (Perl Database Interface)
and SQL (Structured Query Language
. I replied to the email lists, rather than just Jeff, in case
another user or developer hit a problem like this, or could
benefit from my experience. But I would be willing to move
this discussion elsewhere if we can agree on where.
If folks don't want this level of specificity on the dbi lists
? Would raise error have been better?
The code to do this is trivial, would it be of any benefit to fix my
code and post it? Or is there a much better tool to do this?
Jeff
.
--
Jeff Boes vox 616.226.9550
Database Engineer fax 616.349.9076
Nexcerpt, Inc. [EMAIL PROTECTED]
::Oracle 1.07.
perl -MDBD::Oracle -e 'print DBD::Oracle-VERSION'
perl -MDBD::Oracle -e 'print DBD::Oracle-VERSION'
cheers,
jeff
-selectrow_array(SELECT pass FROM htp WHERE user = 'jeff');
#
# ... any other DBI commands using AnyData's subset of SQL
In addition to providing SQL access, this method has other advantages
over the Text_CSV approach including things like flock (if supported on
your platform) and verbose error
characters that you can set in
Text::CSV_XS as well as providing some built-in common variants like
CSV, Tab or Pipe delimited, etc. Unlike DBD::CSV, DBD::AnyData does
this via its own regexes (variants of Friedl) rather than through
Text::CSV_XS but the results should be pretty similar.
--
Jeff
above
accomplishes for DBD::AnyData.
--
Jeff
necessary.
This is all covered in the readme and installation notes for the
modules.
If you've installed AnyData.pm and still get errors, let me know.
--
Jeff
.
--
Jeff
::Oracle that reveals components of the TNS
alias description? If not, is there some API that would allow someone to
retrieve the TNS alias description from 'the master' (i.e., an Oracle*Names
server)? If there is such an API and no one has written a perl wrapper for
it, I'd be willing it.
Thanks,
Jeff
If you are loading a large file to Informix and want to avoid the
overhead of doing many inserts, you can call dbaccess from a system call
and pipe commands to it (see below). Otherwise, you need to loop and
insert each row individually.
While I love DBI, doing inserts just isn't as fast as
above to:
col1 | col2 | col3
a | foo | baz
a | d | baz
Clear as mud?
--
Jeff
);
my $sql = SELECT * FROM $table_name WHERE id 3;
$ad_dbh-func('temp','DBI',$pg_dbh,{sql=$sql},'ad_import');
print $ad_dbh-func('temp','HTMLtable','ad_export');
__END__
If it's meant to go to a browser, don't forget to print the
content-header first.
--
Jeff
that I accidently munged my
warning handler to die instead of warn, so the above statement was
crashing my code.
--
Jeff Boes vox 616.226.9550
Database Engineer fax 616.349.9076
Nexcerpt, Inc
.
--
Jeff
, released 30 July, 2001
It's all new!
--
Jeff
that doesn't exist in the table)
since file I/O is only attempted once the syntax check is passed and an
execute called.
Remember, also, this is a DBI *emulation*. The full DBI interface will
come later when I've more fully debugged the modules.
--
Jeff
Tongue planted frimly in cheekok, so do this:
$qh = $dbh-prepare(blabla);
print SQL is busy processing your query, please wait ...\n;
$qh-execute;
@results = $qh-fetchrow_array;
print ... Processing complete.\n;
The whole point of this is that TIMTOWTDI, but if you actually want to be
on doing often!). That seemed to me
to be strange behaviour. Is that expected DBI behaviour or a quirk in
MySQL?
Jeff
I failed on my first attempt in similar circumstances, though I did get an
error.
The solution in my case was as simple as lowercasing the DBI in the
connection string, i.e. like:
$dbh = DBI-connect(dbi:Pg:dbname=$TEST_REGISTRY);
Note also the single colon between dbi and Pg.
I am too
How about reading the POD documentation in ODBC.pm?
Jeff
Hello all,
I've recently begun moving my perl skills from a Win32 platform to now a
Linux platform. I plan to make a lot of database use of my previously
built
SQL Server databases. I'm familiar with DBI, however I'm
having
segments exist for
a single ID, collapse those record segments by joining them together ###
use Marc.pm;
### Now parse through the MARC record with my newly created Supersegments ###
etc.
etc.
Thanks in advance for your help on this hard-to-describe problem...
Jeff
Jeff
This response received from Stephen Clouse. This fixed the problem.
Ah, you had the same problem I did on Slackware 8. Seems they do something like
hardcode some SuSE pathnames into the thing and it won't link properly anywhere
else. But I have figured out how to get everything to link
Neil,
To confirm: you don't need the readme.cygwin anymore?
Thanks,
Jeff
-Original Message-
From: Neil Lunn [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:41 PM
To: 'Timothy C. Phan'; [EMAIL PROTECTED]
Subject: [Patch] RE: DBD-ODBC 0.28 for Cygwin
-Original
It is now.
Jeff
Can't the (intended) error be silenced by the test script?
Tim.
On Wed, Aug 08, 2001 at 12:24:58PM +1000, Neil Lunn wrote:
I have this problem during 'make test'. Is it good/bad? Thanks
t/02simple..ok 7/14DBD::ODBC::st fetchrow failed:
[Microsoft][ODBC
1 - 100 of 1208 matches
Mail list logo