Skip site navigation (1) Skip section navigation (2)

RE: Re: Shutdown hook imp

From: Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com>
To: Joseph Shraibman <jks(at)selectacast(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: RE: Re: Shutdown hook imp
Date: 2001-07-10 20:21:47
Message-ID: XFMail.20010710132147.ned.wolpert@knowledgenet.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On 10-Jul-2001 Joseph Shraibman wrote:
> Barry Lind wrote:

>> a) its only purpose is to supress warning messages in the server log
>> when the client isn't coded properly (i.e. the client application should
>> be closing connections gracefully/explicitly before calling exit()).
> 
> For some people (like me) it isn't that simple to close the connection
> objects because of the asyncronous nature of their applications.

Well... also, if someone is using PoolMan to pool connections, there isn't a
'close' connections anyways... it just puts existing connections into the pool.
However, this is the responsibility of the parent application that is using the
JDBC connections.  See below...


>>    3) Increased complexity for users needing to run under JRUN (and
>> possibly other JSEE servers) because it requires editing the security
>> manager settings to allow the JDBC driver to do this privileged operation.
> 
> I posted the code for the policy file before.  If people use that there
> won't be any problems.
> Even better if the distributed jar files were signed we could have
> policy file entries that would just grant the permission for code that
> was signed by postgres.

No.  Signed jar files isn't valid if people produce their own jar files from
the src code. (Via cvs or a tar'd release)  They would have to sign it
themselves, versus having 'PostgreSQL' sign it.  Otherwise, we'd have to ship a
full jar file, rather than have people create their own.

I feel that the shutdown hook is not something that should be in the
JDBC driver itself, but in the parent application.  In other words, the parent
application that is using the JDBC driver should be aware of its own context,
and stop the JDBC driver as needed, rather than assume that the JDBC driver is
given the ability to shutdown itself.

For example, if this was a JMX controlled app, one can stop() the server, which
may require the JDBC connections to be closed.  This would occur before the
actual shutdown command.  A given JMX controlled server may be stop() and
start() many times while the JVM is running.  The JMX hook for the application
should contol the 'fate' of the JDBC connections.

In short, to me, the JDBC connections should be minimal, efficent and not to
add intelligence in the JDBC Driver to assume their operating environments.


Virtually, 
Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com>

D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7S2PbiysnOdCML0URAvNfAJ9cMpPTd8xSt4quL67bkTV3OShC1wCfTbbm
RgztLP5Kn/raf0Qn52xsfMQ=
=J7qE
-----END PGP SIGNATURE-----

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2001-07-10 21:42:37
Subject: Re: Time to read pg_hba.conf (Re: [PATCHES] [PATCH] Patch to make...)
Previous:From: Jason TishlerDate: 2001-07-10 20:00:54
Subject: Re: Python (PyGreSQL) make install patch

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-07-10 21:21:01
Subject: Re: JDBC Support - prepared Statements?
Previous:From: Joseph ShraibmanDate: 2001-07-10 19:45:43
Subject: Re: Shutdown hook imp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group