test (disregard)
testing
I have a Problem please help me
Iam new to DBI ,
When I try to connect to a database using DBI the perl Interpreter gives following
error massage
install_driver(mysql) failed: DBD::mysql object version 2.0400 does not match
bootstrap parameter 2.0416 at C:/Perl/lib/DynaLoader.pm line 225.
Compilation failed in require at (eval 1) line 3.
what is the problem and how can i fix it
__---
#This is the program I tried
#!/usr/bin/perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI-connect(DBI:mysql:database=mysql;host=localhost,
lrmk, lrmklrmk,
{'RaiseError' = 1});
my $sth = $dbh-prepare(SELECT * FROM users);
$sth-execute();
while (my $ref = $sth-fetchrow_hashref()) {
print Found a row: name = $ref-{'name'}\n;
}
$sth-finish();
# Disconnect from the database.
$dbh-disconnect();
RE: Oracle and global temporary tables
Working on that. We have verified the following: 1) All rows are in temp. table 1 at after we create it. 2) All rows are in temp. table 1 at the point we start to create temp. table 2. They remain there until we execute the statement that prepares temp. table #2. We tried caching statement handles so they're not reused. No difference. We fully turned off AutomCommit, RaiseError, and PrintError with no effect. It almost seems like DBD::Oracle is reusing/resetting something at the Oracle level that's causing Oracle to act as if the first table was committed. When you commit an Oracle global temporary table, the rows are gone -- the idea is to only use the data uncommitted in the session. Steve Sapovits GSI Commerce [EMAIL PROTECTED] -Original Message- From: Dave K [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: Re: Oracle and global temporary tables Post some code... Steve Sapovits [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Has anyone used DBI to create and use Oracle's global temporary tables? This mostly works for us, but we're having problems creating multiple tables, where the ones after the first depend on the first via joins. Steve Sapovits GSI Commerce [EMAIL PROTECTED]
make fails for DBD-Oracle-1.12 on RedHat Linux 7.3
Cannot do make for DBD-Oracle-1.12 (have DBI-1.30 ) on Redhat Linux 7.3 and Oracle Client 9.2.0.1.0 Hi I have installed the Oracle client from the CD for the Oracle 9i database 9.2.0.1.0.I have installed DBI-1.30. I have downloaded DBD-Oracle-1.12. I enclose the files for the steps to install the latter. Note: my ORACLE_HOME for the Oracle client is /home/gail/OraHOme1 and my client is connecting to an Oracle 9i database on another machine. This Oracle 9i database has ORACLE_SID as ruby. My Oracle client can connect to this database (Net 8 is set up and using SQL PLUS I can connect). I am root when I am trying to install DBD-Oracle-1.12. So the enclosed files are: (1) last part of my .bash_profile ORACLE_HOME=/home/gail/OraHome1 export ORACLE_HOME ORACLE_SID=ruby export ORACLE_SID ORACLE_USERID=gail/laura@ruby export ORACLE_USERID LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export LD_LIBRARY_PATH (2) output of perl -v This is perl, v5.6.1 built for i386-linux Copyright 1987-2001, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using `man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. (3) a complete log of the build: (a) of the command perl Makefile.PL Using DBI 1.30 installed in /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /home/gail/OraHome1 Found header files in rdbms/demo. Found /home/gail/OraHome1/precomp/demo/proc/demo_proc.mk Using /home/gail/OraHome1/precomp/demo/proc/demo_proc.mk Reading /home/gail/OraHome1/precomp/demo/proc/demo_proc.mk. Reading /home/gail/OraHome1/precomp/lib/env_precomp.mk. Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Appending '-ldl' to TTLIBS Attempting to discover Oracle OCI build rules... gcc -c -I. -I/home/gail/OraHome1/precomp/public -I/home/gail/OraHome1/rdbms/ public -I/home/gail/OraHome1/rdbms/demo -I/home/gail/OraHome1/plsql/public -I/home/gail/OraHome1/network/public -I/home/gail/OraHome1/rdbms/demo -I/h ome/gail/OraHome1/rdbms/demo -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/aut o/DBI -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\1.12\ -DXS_VERSION=\1.12\ -fPIC -I/usr/lib/perl5/5.6.1/i38 6-linux/CORE DBD_ORA_OBJ.c Oracle oci build command: echo -o DBD_ORA_EXE DBD_ORA_OBJ.o -L/home/gail/OraHome1/lib/ -lclntsh `cat /home/gail/OraHome1/lib/ldflags` `cat /home/gail/OraHome1/lib/sysliblist` -ldl -lm -o DBD_ORA_EXE DBD_ORA_OBJ.o -L/home/gail/OraHome1/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9 - lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -ln tns9 -ldl -lm -lpthread -lnsl -ldl -lm Unable to interpret Oracle oci build commands. Using fallback approach. System: perl5.006001 linux daffy.perf.redhat.com 2.4.17-0.13smp #1 smp fri feb 1 10:30:48 est 2002 i686 unknown Compiler: gcc -O2 -march=i386 -mcpu=i686 -fno-strict-aliasing -I/usr/local/include Linker: /usr/bin/ld Sysliblist: -ldl -lm -lpthread -lnsl Oracle makefiles would have used these definitions but we override them: CC: cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -O3 (CDEBUG) -trigraphs -fPIC -DPRECOMP -I. -I/home/gail/OraHome1/precomp/publi c -I/home/gail/OraHome1/rdbms/public -I/home/gail/OraHome1/rdbms/demo -I/ho me/gail/OraHome1/plsql/public -I/home/gail/OraHome1/network/public -DLINUX -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE - DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS $(LPFLAGS) $(USRFLAGS)] build: $(CC) -o $(EXE) $(OBJS) $(LDPATHFLAG)$(LIBHOME) $(PROLDLIBS) Evaluating `cat $(LIBHOME)ldflags` expanded `cat /home/gail/OraHome1/lib/ldflags` returned lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -l ntcps9 -lnsslb9 -lntcp9 -lntns9 ' Evaluating `cat $(LIBHOME)sysliblist` expanded `cat /home/gail/OraHome1/lib/sysliblist` returned '-ldl -lm -lpthread -lnsl' [ cc -o $(EXE) $(OBJS) -L$(LIBHOME) -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 $(EXPDLIBS) $(EXOSLIBS) -ldl -lm -lpthread -lnsl -ldl -lm $(USRLIBS) ] LDFLAGS: -o $ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/ [-o $ -L/home/gail/OraHome1/precomp/lib/ -L$(LIBHOME)
RE: Oracle and global temporary tables
Here's the code. I've X'ed out our DB access parameters.
Any help appreciated.
#!/usr/local/bin/perl
use strict;
use DBI;
use DBD::Oracle;
my $dbh = DBI-connect('DBI:Oracle:XX', 'XX', 'XX',
{RaiseError = 0, AutoCommit = 0});
my $table_one_create_sql = END_SQL;
CREATE GLOBAL TEMPORARY TABLE temp_table_one
(
col_one VARCHAR2(10),
col_two VARCHAR2(10)
)
END_SQL
eval
{
$dbh-do($table_one_create_sql);
};
# Oracle temp. tables may already exist if we used them before.
# No problem ... just go on and fill the table (new session =
# new data).
die $@ if ( $@ ($@ !~ /ORA-00955/) );
$dbh-do(INSERT INTO temp_table_one VALUES ('foo1', 'foo2'));
$dbh-do(INSERT INTO temp_table_one VALUES ('bar1', 'bar2'));
$dbh-do(INSERT INTO temp_table_one VALUES ('fubar1', 'fubar2'));
show_table(temp_table_one, $dbh);
my $table_two_create_sql = END_SQL;
CREATE GLOBAL TEMPORARY TABLE temp_table_two AS
(SELECT col_one, col_two FROM temp_table_one
WHERE temp_table_one.col_one = 'foo1')
END_SQL
my $sth = $dbh-prepare($table_two_create_sql);
print temp_table_one after temp_table_two is prepared.\n;
show_table(temp_table_one, $dbh);
$sth-execute();
print temp_table_one after temp_table_two is executed.\n;
show_table(temp_table_one, $dbh);
show_table(temp_table_two, $dbh);
# Oracle temp. tables may already exist if we used them before.
# No problem ... just go on and fill the table (new session =
# new data).
$dbh-disconnect();
sub show_table
{
my $table = shift;
my $dbh = shift;
my $sth = $dbh-prepare(SELECT * FROM $table);
my $row;
$sth-execute();
print Rows from $table:\n;
while (defined($row = $sth-fetchrow_arrayref()))
{
print , join('|', @$row), \n;
}
$sth-finish();
}
Steve Sapovits
GSI Commerce
[EMAIL PROTECTED]
-Original Message-
From: Steve Sapovits
Sent: Friday, October 04, 2002 3:19 PM
To: 'Dave K'; [EMAIL PROTECTED]
Subject: RE: Oracle and global temporary tables
Working on that. We have verified the following:
1) All rows are in temp. table 1 at after we create it.
2) All rows are in temp. table 1 at the point we start to
create temp. table 2. They remain there until we execute
the statement that prepares temp. table #2.
We tried caching statement handles so they're not reused. No
difference.
We fully turned off AutomCommit, RaiseError, and PrintError with
no effect.
It almost seems like DBD::Oracle is reusing/resetting something
at the Oracle level that's causing Oracle to act as if the first
table was committed. When you commit an Oracle global temporary
table, the rows are gone -- the idea is to only use the data
uncommitted in the session.
Steve Sapovits
GSI Commerce
[EMAIL PROTECTED]
-Original Message-
From: Dave K [SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: Re: Oracle and global temporary tables
Post some code...
Steve Sapovits [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Has anyone used DBI to create and use Oracle's global temporary tables?
This mostly works for us, but we're having problems creating multiple
tables, where the ones after the first depend on the first via joins.
Steve Sapovits
GSI Commerce
[EMAIL PROTECTED]
Re: Oracle and global temporary tables
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Oct 04, 2002 at 03:23:41PM -0400, Steve Sapovits wrote: 1) All rows are in temp. table 1 at after we create it. 2) All rows are in temp. table 1 at the point we start to create temp. table 2. They remain there until we execute the statement that prepares temp. table #2. You're forgetting that Oracle triggers an implicit commit on any DDL statement. The creation of the second table is causing your phantom commit. Try creating both tables up front. - -- Stephen Clouse [EMAIL PROTECTED] Senior Programmer, IQ Coordinator Project Lead The IQ Group, Inc. http://www.theiqgroup.com/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9nsHzA4aoazQ9p2cRAju2AJ98u7BhbJAGaZfwps1odEyvDBuT+wCgrodb fSdMElFK1wg4cepsR4y8q74= =aX/M -END PGP SIGNATURE-
Re: I have a Problem please help me
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Oct 05, 2002 at 12:34:37AM +0600, LRMK wrote: When I try to connect to a database using DBI the perl Interpreter gives following error massage install_driver(mysql) failed: DBD::mysql object version 2.0400 does not match bootstrap parameter 2.0416 at C:/Perl/lib/DynaLoader.pm line 225. Compilation failed in require at (eval 1) line 3. Your installation is messed up. You have differing versions of the DBD::mysql ..pm file and the corresponding binary object file. Reinstall DBD::mysql. And BTW, you only have to post your message once. - -- Stephen Clouse [EMAIL PROTECTED] Senior Programmer, IQ Coordinator Project Lead The IQ Group, Inc. http://www.theiqgroup.com/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9nsKIA4aoazQ9p2cRAgogAJ9TOw6G4jbufwCsufKe0prO5Ph8QQCfSj6P rH0JUszmIskh+580fv/W+wY= =0HdS -END PGP SIGNATURE-
Re: make fails for DBD-Oracle-1.12 on RedHat Linux 7.3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Oct 04, 2002 at 03:44:51PM -0400, Gail L. Lange wrote: dbdimp.h:44:20: ocidfn.h: No such file or directory dbdimp.h:57:21: ociapr.h: No such file or directory You're missing the OCI header files. Make sure you've installed the Oracle Call Interface component (it should be part of the Oracle Developer section, assuming it hasn't changed from 9.0 to 9.2). If that doesn't work, try installing Pro*C as well. One of those has the header files you need to build DBD::Oracle. - -- Stephen Clouse [EMAIL PROTECTED] Senior Programmer, IQ Coordinator Project Lead The IQ Group, Inc. http://www.theiqgroup.com/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9nsPEA4aoazQ9p2cRAsKXAJ9ntlFRoD5mOPqBy3nbAmWSmE4jewCg+naS 3C3IrOt0tJhEiDOyx7Nqyt8= =3Xba -END PGP SIGNATURE-
Re: Oracle and global temporary tables
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, Oct 04, 2003 at 06:47:02AM -0400, Steve Sapovits wrote:
Not forgot -- just never knew. 8-)
It's actually easier to miss than I admit :)
I can't create both up front since the second depends on the first.
Sure you can, just move the dependency out of the way :) Nothing says you have
to use CREATE TABLE AS for this.
CREATE GLOBAL TEMPORARY TABLE temp_table_one (
col_one VARCHAR2(10),
col_two VARCHAR2(10)
);
CREATE GLOBAL TEMPORARY TABLE temp_table_two (
col_one VARCHAR2(10),
col_two VARCHAR2(10)
);
INSERT INTO temp_table_one VALUES ('foo1', 'foo2');
INSERT INTO temp_table_one VALUES ('bar1', 'bar2');
INSERT INTO temp_table_one VALUES ('fubar1', 'fubar2');
INSERT INTO temp_table_two (
SELECT col_one, col_two FROM temp_table_one
WHERE temp_table_one.col_one = 'foo1'
);
Any idea why we could do it in SQL*Plus?
Er, friendly SQL*Plus gnomes? :) Can't explain that one.
- --
Stephen Clouse [EMAIL PROTECTED]
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. http://www.theiqgroup.com/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9nsXRA4aoazQ9p2cRAgfQAKCooiFq1m0K9sVoG7mswtYouK5dSgCgu4D+
7sPo20fujE8H2UQeUNeFzow=
=IbVl
-END PGP SIGNATURE-
Re: Oracle and global temporary tables
Stephen Clouse wrote: You're forgetting that Oracle triggers an implicit commit on any DDL statement. The creation of the second table is causing your phantom commit. Try creating both tables up front. Not forgot -- just never knew. 8-) I can't create both up front since the second depends on the first. Unless there's a way to roll them into one statement. Any idea why we could do it in SQL*Plus? Thanks. -- Steve SapovitsGSI Commerce, Inc.http://www.gsicommerce.com [EMAIL PROTECTED]
Re: Oracle and global temporary tables
Stephen Clouse wrote: Sure you can, just move the dependency out of the way :) Nothing says you have to use CREATE TABLE AS for this. There are disadvantages to being up so early. 8-) I'll give that a shot. Thanks. -- Steve SapovitsGSI Commerce, Inc.http://www.gsicommerce.com [EMAIL PROTECTED]
Just a test
testing
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: DBI FAQ File: 1 URL: http://xmlproj.com/fom-serve/cache/1.html What: moved a sub-item to Trash As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: DBI FAQ File: 1 URL: http://xmlproj.com/fom-serve/cache/1.html What: added a sub-item #115 As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: New Item File: 115 URL: http://xmlproj.com/fom-serve/cache/115.html What: inserted a part New text: As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: New Item File: 115 URL: http://xmlproj.com/fom-serve/cache/115.html What: edited the item configuration. As always, thanks for your help maintaining the FAQ.
FAQ emails now work
The list will now receive email about any FAQ changes. Ilya
DBI object version problem
Hi, Does anyone have a solution to this problem? : DBI object version 1.28 does not match $DBI::VERSION 0.93 at E:/Perl/lib/DynaLoader.pm line 225 Vivek __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: Miscellaneous File: 53 URL: http://xmlproj.com/fom-serve/cache/53.html What: added a sub-item #116 As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: When I try to connect to a database using DBI the perl Interpreter gives following error massage quot; install_driver(mysql) failed: DBD::mysql object version 2.0400 does not match bootstrap parameter 2.0416quot; File: 116 URL: http://xmlproj.com/fom-serve/cache/116.html What: edited the item configuration. Changed the item title, was New Item As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: When I try to connect to a database using DBI the perl Interpreter gives following error massage quot; install_driver(mysql) failed: DBD::mysql object version 2.0400 does not match bootstrap parameter 2.0416quot; File: 116 URL: http://xmlproj.com/fom-serve/cache/116.html What: inserted a part New text: Your installation is messed up. You have differing versions of the DBD::mysql ..pm file and the corresponding binary object file. Reinstall DBD::mysql --Stephen Clouse [[EMAIL PROTECTED]] As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: When I try to connect to a database using DBI the perl Interpreter gives following error massage quot; install_driver([your driver]) failed: DBD::mysql object version [x] does not match bootstrap parameter [y]quot; File: 116 URL: http://xmlproj.com/fom-serve/cache/116.html What: edited the item configuration. Changed the item title, was When I try to connect to a database using DBI the perl Interpreter gives following error massage install_driver(mysql) failed: DBD::mysql object version 2.0400 does not match bootstrap parameter 2.0416 As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: DBI FAQ File: 1 URL: http://xmlproj.com/fom-serve/cache/1.html What: added a sub-item #117 As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: When I try to connect to a database using DBI the perl Interpreter gives following error massage quot; install_driver([your driver]) failed: DBD::mysql object version [x] does not match bootstrap parameter [y]quot; File: 116 URL: http://xmlproj.com/fom-serve/cache/116.html What: edited a part As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: How can I share a connection between processes? File: 117 URL: http://xmlproj.com/fom-serve/cache/117.html What: edited the item configuration. Changed the item title, was New Item As always, thanks for your help maintaining the FAQ.
Re: FAQ emails now work
- Original Message - From: Sterin, Ilya [EMAIL PROTECTED] The list will now receive email about any FAQ changes. I think once a week or month would be plenty... -Douglas Wilson
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: How can I share a connection between processes? File: 117 URL: http://xmlproj.com/fom-serve/cache/117.html What: inserted a part New text: Very carefully. :-) First of all, the processes we are talking about here are parent and child process. The typical scenario is that one parent opens up a connection and then forks off a child who wants to use the same connection. There are actually two kinds of shareing. Once is true shareing, where the programmer expects both thee parent and the child to use the connection. The other type is passing, where the parent opens the connection, but the child is the only one who actually uses it. In the former case, the answer to the question of shareing a connection is You can't. The reason is simple; database client libraries are not designed to have two different processes talking to the same connection/socket/whatever that is established when the client connects to the database. This is the logical equivilent of calling a friend on the telephone and having your roomate pick up another line and talk at the same time. It simply cannot be done. In the latter case or passing a connection, you can have the parent open the connection and let the child use it under the following conditions: 1)Once the child is forked, the parent CANNOT USE THE CONNECTION. The only thing that the parent is allowed to do (indeed, the parent MUST do) is to set the InactiveDestroy attribute on the handle. That way, when the parent's copy of the handle goes out of scope, the connection is not closed by the parent and the child can still use it. 2) The child now has full control over the handle and is responsible for cleaning up and disconnecting. The InactiveDestroy attribute must NOT be set in the child's copy of the handle. 3) The parent cannot pass the connection onto another child. Two children trying to use the same handle brings us back to the first case of two processes sharing a connection, which is not possible, as explained above. As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: How can I share a connection between processes? File: 117 URL: http://xmlproj.com/fom-serve/cache/117.html What: edited a part As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: Miscellaneous File: 53 URL: http://xmlproj.com/fom-serve/cache/53.html What: added a sub-item #118 As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: How can I share a connection between processes? File: 118 URL: http://xmlproj.com/fom-serve/cache/118.html What: edited the item configuration. Changed the item title, was New Item As always, thanks for your help maintaining the FAQ.
[DBI FAQ] Faq-O-Matic Moderator Mail
[This is a message about the Faq-O-Matic items you moderate.] Who: [EMAIL PROTECTED] Item: How can I share a connection between processes? File: 118 URL: http://xmlproj.com/fom-serve/cache/118.html What: inserted a part New text: Very carefully. :-) First of all, the processes we are talking about here are parent and child processes. The typical scenario is that one parent opens up a connection and then forks off a child who wants to use the same connection. There are actually two kinds of sharing. Once is true sharing, where the programmer expects both thee parent and the child to use the connection. The other type is passing, where the parent opens the connection, but the child is the only one who actually uses it. In the former case, the answer to the question of sharing a connection is You can't. The reason is simple; database client libraries are not designed to have two different processes talking to the same connection/socket/whatever that is established when the client connects to the database. This is the logical equivilent of calling a friend on the telephone and having your roomate pick up another line and talk at the same time. The result is gibberish. In the latter case of passing a connection, you can have the parent open the connection and let the child use it under the following conditions: 1)Once the child is forked, the parent CANNOT USE THE CONNECTION. The only thing that the parent is allowed to do (indeed, the parent MUST do) is to set the InactiveDestroy attribute on the handle. That way, when the parent's copy of the handle goes out of scope, the connection is not closed by the parent and the child can still use it. 2) The child now has full control over the handle and is responsible for cleaning up and disconnecting. The InactiveDestroy attribute must NOT be set in the child's copy of the handle (unless the child is itself going to fork and expect the grandchild to use the connection. Once the child is a parent, the parent's rules apply.) 3) The parent cannot pass the connection onto another child. Two children trying to use the same handle brings us back to the first case of two processes sharing a connection, which is not possible, as explained above. As always, thanks for your help maintaining the FAQ.
Re: FAQ emails now work
And is proving to be... There has been on the order of 50 of em today alone. If that keeps up half the list subscribers will jump ship. - Original Message - From: Crown David T. (DNREC) [EMAIL PROTECTED] To: Sterin, Ilya [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, October 05, 2002 1:18 PM Subject: RE: FAQ emails now work IMHO, I think an email to the list for every edit to the faq might be a bit much. David Crown, MCSE, MCP+I, CCNA Information Resources Management State of Delaware, Department of Natural Resources and Environmental Control [EMAIL PROTECTED] Voice: (302)739-4409 Fax: (302)739-6242 Pager (302)247-1401 www.dnrec.state.de.us/ -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Sat 10/5/2002 14:39 To: '[EMAIL PROTECTED]' Cc: Subject: FAQ emails now work The list will now receive email about any FAQ changes. Ilya
Cheng XI/CA/ALCATEL is out of the office.
I will be out of the office starting 09/11/2002 and will not return until 01/13/2003. For urgent issues, please fcontact Mara Zarins 4249. See you in New Year
Re: FAQ emails now work
on 10/05/2002 3:18 PM, Crown David T. (DNREC) at [EMAIL PROTECTED] wrote: IMHO, I think an email to the list for every edit to the faq might be a bit much. I second that sentiment.
RE: FAQ emails now work
This is a bit much -Original Message- From: Christopher Pryce [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 2:52 PM To: DBI Users Subject: Re: FAQ emails now work on 10/05/2002 3:18 PM, Crown David T. (DNREC) at [EMAIL PROTECTED] wrote: IMHO, I think an email to the list for every edit to the faq might be a bit much. I second that sentiment.
***FAQ Emails now disabled***
Sorry for the inconvenience, all. We thought it would be a good idea for the FAQ changes to go to the list, but guess it was too much... Tim, what do you think, should we just proceed and keep them off, or do you want me to write a patch to FAQ-o-matic to only send new additions? Let me know, also anyone willing to contribute such a patch we'll be appreciated. Ilya
