Date: Wed, 19 Dec 2012 15:53:31 +0100
From: Thomas Binder tcb...@gmail.com
use SQL::Statement;
my $sql= SELECT a FROM b JOIN c WHERE c=? AND e=7 ORDER BY f DESC
LIMIT 5,2;
my $parser = SQL::Parser-new();
$parser-{RaiseError}=1;
$parser-{PrintError}=0;
…
printf Offset
Jenda Krynicky schrieb am 11.07.2012 um 12:23 (+0200):
http://search.cpan.org/~timb/DBI-1.622/DBI.pm#Callbacks
in theory, we could load the DBI module in the loader script so the
DBI code would be there, and then we could register callbacks on the
*class*, not on the *instance*, and they
godperl7 schrieb am 21.07.2012 um 13:30 (+0800):
Dancer:Plugin:Database takes care of ensuring that the database handle
is still connected and valid.
If the handle was last asked for more than connection_check_threshold
seconds ago, it will check that the connection is still alive.
If the
godperl7 schrieb am 21.07.2012 um 23:30 (+0800):
according to what you said.
if the database handler was interrupted by accident before the
implement of the script, To Dancer:Plugin:Database the only need to do
is to obtain a new connection. And reperformance the script from the
place where
There's a huge perl process running, and we don't have access to the
source code. We only have access to a loader script, which starts the
entire process.
This process is doing lots of SQL via DBI. We'd like to change that SQL
a little bit. This can be done via DBI callbacks as described in the
James Marshall schrieb am 13.05.2012 um 11:29 (-0700):
I'm writing a forking HTTP server that needs to access a database
with each hit. Speed is pretty important, so I was hoping to reuse
database handles and prepared statement handles in the forked child
processes. Is this possible, or do I
Steve Baldwin schrieb am 23.04.2012 um 20:53 (+1000):
loop
select count(*) from some_table
sleep 2 seconds
end loop
My problem is that the count shows the number of rows the first time
it executes and from that point never changes.
While the program is running, I insert rows into
Daniel L Murphy schrieb am 25.02.2012 um 10:03 (-0600):
ActivePerl-5.14.2.1402-MSWin32-x64-295342
The DBI PPM works fine for me. Did you try installing it using ppm?
Guess your problem is building the DB2 driver, DBD::DB2, not the DBI.
Never used DB2, so can't help you there.
You could
Daniel L Murphy schrieb am 24.02.2012 um 12:46 (-0600):
Upgrading from 32 bit XP to Windows 7 64 bit use Perl and DB2 DBI
interface.
Several weeks ago I downloaded binaries from ActiveState Perl for 64
bit OS (Windows 7). I have 64 Bit DB2 9.7 installed.
You're not saying what version of
then install module via ppm.
--
Michael Ludwig
to avoid it?
http://www.teradataforum.com/
There's one mention of DYNAMIC RESULT SETS here.
http://www.teradataforum.com/teradata/20110701_132448.htm
--
Michael Ludwig
on what precisely those issues are?
And what exactly you expect the solution to solve?
--
Michael Ludwig
and 1.06 where in new
server it is 1.616 and 1.24 respectively.
One of the disadvantages with using such antique versions is that you're
not likely to find much other people still using that stuff.
--
Michael Ludwig
=//betoracle.easysoft/local/devel
export TWO_TASK=//betoracle.easysoft.local/devel
^
I can run sqlplus with:
sqlplus -S fred/passw...@$betoracle.easysoft.local:1521/devel
--
Michael Ludwig
DBI method calls. The
Oraperl module should only be used to allow existing Perl 4
oraperl scripts to run with minimal changes; any new development
should use DBI directly.
http://search.cpan.org/~timb/DBD-Oracle-1.16/Oraperl.pm
Hope this helps!
Best,
--
Michael Ludwig
We are using following versions -
MySql - 5.1.52
Perl- 5.12.2
DBI - DBI-1.615
DBD - DBD-mysql-4.018
Is this combination correct?
All up-to-date stable releases, so I'd consider it very good.
--
Michael Ludwig
Roode, Eric schrieb am 18.10.2010 um 13:11 (-0400):
What is this TDS and where can I learn more about it?
http://en.wikipedia.org/wiki/Tabular_Data_Stream
--
Michael Ludwig
there was an inaccuracy - but it's not the main trouble
right now. :-)
To resume:
* INSERT still not working because of SQL-HY104 error
* SELECT will need patch
Thanks a lot for your prompt and encouraging help with this issue!
--
Michael Ludwig
, you really need to make a few changes to your script and
then you need a new DBD::ODBC which I can send you. Let me know.
As stated:
* INSERT will need guidance or upgrade (see my other reply)
* SELECT will need a patch from you
--
Michael Ludwig
://search.cpan.org/mirror
--
Michael Ludwig
.
--
Michael Ludwig
to discover, in the process of doing so, the
source of the error, typically in one's own code.
Best,
--
Michael Ludwig
(and removed) after such a long
investigation. Like a detective story where the criminal is finally
caught and brought to justice. Congrats!
--
Michael Ludwig
can
you even imagine it's someone else's business?
--
Michael Ludwig
,
just scanning for connect and time and idle.
You could probably also ask the DBA to raise the max idle time.
--
Michael Ludwig
Am 28.05.2010 um 09:45 schrieb newbie01 perl:
Can someone advise how to set LD_LIBRARY_PATH from within the Perl scripts?
But if I do the following instead in the Perl script, it does not work? How
to set the LD_LIBRARY_PATH then?
$ENV{ORACLE_HOME}=$ORACLE_HOME;
Am 29.04.2010 um 04:08 schrieb Pam Wampler:
What are the steps to install perl-DBD:Oracle on a centos 5 server?
rpm -i perl-DBD-Oracle-1.19-1.el5.i386.rpm
warning: perl-DBD-Oracle-1.19-1.el5.i386.rpm: Header V3 DSA signature:
NOKEY, key ID e42d547b
error: Failed dependencies:
Am 28.04.2010 um 18:01 schrieb ranjith makineni:
I need to install DBI for connection to Oracle Database for Perl version
5.8.0 from windows X86.
Perl 5.8.0 is ages old. You should upgrade to get the bugfixes.
I have downloaded DBI-1.48. We are able to run perl Makefile.PL, but unable
to
Am 27.04.2010 um 20:17 schrieb Royce Miller:
install_driver(Informix) failed: Can't load
'/home/users/polling/perl/lib/site_perl/5.8.8/sun4-solaris-64/auto/DBD/Informix/Informix.so'
for module DBD::Informix: ld.so.1: SdtQuery.pl: fatal: libifsql.so: open
failed: No such file or directory at
Am 06.04.2010 um 17:14 schrieb Bobby:
Hello,
I am very new to the DBI module. I am trying to connect to a
mysql installation on a server over the internet, however I cannot get
the DBD::mysql driver installed properly.
You need a libmysqlclient on your local machine. One way to get one
30 matches
Mail list logo