How to implement multi-threaded DBI::ProxyServer?
From: David Wesner (dwesner_at_dataswitch.com)
Date: 10/20/03
- Next message: jhannah_at_omnihotels.com: "DBD::Informix, AIX 5.1 -- no joy w/ AIX C or gcc"
- Previous message: Nicolas Mailhot: "Problem building DBD-Oracle-1.14"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: <dbi-users@perl.org> Date: Mon, 20 Oct 2003 10:56:16 -0500
I previously submitted the question at the end of this message, seeking how
to make the RPC:PLServer multi-threaded. I received a very helpful response
indicating the need to add a "--childs n" parameter to the call to
DBI::ProxyServer::main such as:
DBI::ProxyServer::main("--localport=118", "--childs=10");
The problem has been that whenever adding the "--childs" parameter, my
ProxyServer returns an error to the client attempting to send a SQL query to
the database. When I remove this new parameter (and only have the
"--localport" parameter, everything works fine again (except that the server
runs single-threaded). In seeking to pursue this suggestion, I've come up
empty on finding any documentation that speaks of the "--childs" parameter.
Has anyone else run into this difficulty, or have a different suggestion on
how to implement a multi-threaded ProxyServer? Are there possibly different
versions of DBI::ProxyServer, with only some having the "--childs"
parameter? In your answer, please keep in mind that I am quite new to Perl
and especially usage of the DBI module. :-)
Below was my original Question to the Forum:
I've installed the DBD::Proxy and RPC::PLServer modules on Windows 2000
accessing SQL Server 2000 (through an ODBC System DSN). I can interface to
the database from one or more Linux boxes just fine, with the exception that
the server is single threaded (i.e., when submitting a query from one script
on the same or different clients, connection to the server does not occur
until the connection from a different script is closed). How can I make the
DBI proxy server
multi-threaded such that many client connections may be open to my SQL
Server database simultaneously?
Thanks,
David
- Next message: jhannah_at_omnihotels.com: "DBD::Informix, AIX 5.1 -- no joy w/ AIX C or gcc"
- Previous message: Nicolas Mailhot: "Problem building DBD-Oracle-1.14"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
