Hi Jason, ----- Original Message ----- From: "Jason McKerr" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 8:46 PM Subject: Connections, pooling, connections closed
> I have a question about connections: > > First, configuration: I'm using Orion Server 1.6.0, JDK 1.4.001, 1Gig > RAM Sun Solaris on Sparc. > > I set up a connection pool the odd way that Orion does this (you set up > a connection, then you set up a pool based on the connection, so you > have two complete connection setup entries in Data-sources.xml for one) > connection pool. > > The connection pool will destroy connections after a certain time (30 > Seconds default) and you can edit the max-connections, that sort of > thing. Now with OJB, after a while, I'm getting a "connection closed" > error from OJB after a bit of usage. I'm guessing that the PB pool is > sets up a pool of PB's based on connections. Then when a connection > get's closed by the app-server, it can't locate that connection anymore. First, I don't know anything about the Orion Server. I assume you use the 0.9.7 version of OJB and use datasources within OJB to obtain connections from the Orion pool. In the 0.9.7 version you have to change the ConnectionFactoryClass in OJB.properties (use ConnectionFactoryDefaultImpl or ConnectionFactoryPassThroughImpl), then OJB does not pool the connections too. I think you do so. > > Does the PB just get a connection and hold on to it? No, the PB does only temporary obtain a connection do some work and close the connection (or return it to pool - if a pool was used). > If that connection > closes does it freak out? Should I not use the Orion Connection pool, > or at least not ever time out the connections that are used by OJB? If you use OJB within EJB's you have to use datasources from the AppServer. regards, Armin > > Thanks, > > Jason > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
