Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: DB connection sharing w/o DBI?

by runrig (Abbot)
on Nov 04, 2001 at 01:56 UTC ( #123091=note: print w/replies, xml ) Need Help??


in reply to DB connection sharing w/o DBI?

Sorry to hear it. Sounds like maybe someone wants this solution to fail and is sabotaging it so it can be implemented some other way. You could pipe sql to SQL*Plus and read the results back out, it's kind of kludgy and slow but I did the same thing with Informix (piping to Informix's dbaccess) awhile back when it was taking a long time to get someone to install the Informix SDK (a prerequisite for DBD::Informix). I tried to batch the commands as much as possible so I wouldn't have to essentially connect to the database too many times. In fact, to be efficient, it might be worthwhile to just code alot of it in PL/SQL if you can't whack any sense into someone with a heavy clue x 4.

Replies are listed 'Best First'.
(jptxs) Re: DB connection sharing w/o DBI?
by jptxs (Curate) on Nov 04, 2001 at 23:26 UTC
    you're close =] It's actually a large political war I'm trying to side-step. Short version is I'm taking functionality we have in one place and putting it in another because it makes sense. The official channels for getting that done are too busy arguing over who's got the bigger, errr.. I mean, who's going to get the credit. I figure if I just do it then the arguing becomes moot. But I have to do it without any official help, which means no altering the servers in any way I cannot as my own ID...fun, eh?

    We speak the way we breathe. --Fugazi

      no altering the servers in any way I cannot as my own ID..

      Well, you can always install into your own directories by running 'perl Makefile.PL PREFIX=/home/myhomedirectory/perl/lib', and then making sure that the directories and files are readable by everyone, and using 'use lib qw(/home/myhomedirectory);' in all the scripts you write (that's assuming you're doing the make/make test/make install thing instead of using the CPAN module or downloading an ActiveState PPM or ...?) :-)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://123091]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2022-05-17 14:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (66 votes). Check out past polls.

    Notices?