> Date: Wed, 19 Dec 2012 15:53:31 +0100
> From: Thomas Binder
> 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
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 whe
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
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*, a
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
ma
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 d
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 r
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 increas
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 versio
perl -MDBD::WMI -e1
If "Can't locate DBD/WMI.pm in @INC" then install module via ppm.
--
Michael Ludwig
adata about what this means and how 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
ttle on what precisely those issues are?
And what exactly you expect the solution to solve?
--
Michael Ludwig
process and if so which one?)
> Our DBI and DBD versions in old server are 1.48 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
SK:
> export TWO_TASK=//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
:Oracle (a database driver what operates
within DBI) and adds an extra layer over 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
Finland, France, Germany etc.
http://search.cpan.org/mirror
--
Michael Ludwig
investigative work!
> So, Michael, 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
a recentish version).
Thanks. ActivePerl 5.12!
> By all means RT a request to default XML columns to unicode and that
> will mean you don't have to specify the TYPE in bind_param.
https://rt.cpan.org/Public/Bug/Display.html?id=61370
> Below is my example which may also indicate another subtle error with
> length() but I've not had time to look into it yet.
Yes, I noted 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
The problem is the INSERT statement, more specifically, in the XML part.
I can't seem to get it to accept my Unicode strings as Unicode for that
column. Instead, they're treated as octets, resulting in garbage.
Käse KäseKäse
МоÑква Москва МоÑкв
ement, prepare, and
execute. It is very common to discover, in the process of doing so, the
source of the error, typically in one's own code.
Best,
--
Michael Ludwig
e the culprit revealed (and removed) after such a long
investigation. Like a detective story where the criminal is finally
caught and brought to justice. Congrats!
--
Michael Ludwig
about your needs. How can
you even imagine it's someone else's business?
--
Michael Ludwig
to find
anything similar in DBD::Oracle, but then I didn't search thoroughly,
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;
> $ENV{ORACLE_SID}=$ORA
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 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 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
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 on
30 matches
Mail list logo