> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Aaron Mulder
> Sent: Thursday, September 14, 2000 9:03 AM
> To: jBoss
> Subject: Re: [jBoss-User] JDBC Connection reset by peer
>
>
> That's not going to work either. For one thing, it might take
> some effort to locate a table the user has select privileges on (we can't
> really tell an access denied SQLException from a collection to DB lost
> SQLException). But more importantly, I've seen Oracle instances that were
> so bloody complex that it took minutes to load the database metadata.
> Now you might argue that that represents poor database design, but it's
> not up to you.
I've seen poor metadata implementation in drivers ... (postgreSQL)
> We could maybe let the user specify a table and then execute a
> "select 'x' from foo where 0=1" or something. But I kind of liked the
> other idea about just timing out the connections if they've been idle too
> long.
yes, it seems to be a "tried" solution
marc
>
> Aaron
>
> On Thu, 14 Sep 2000, Rick Horowitz wrote:
> > I'm not 100% sure of the problem you're trying to solve here, but would
> > it be possible to use one of the JDBC connections to read the database
> > metadata, and from that create a JDBC query that could be executed to,
> > for example, just read some data from one of the tables?
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
