Connection Pooling and Orion Hangs
Has anyone ran into a problem where Orion's connection pool does not return a connection until timeout? I am trying to call the datasource manager with 2 max connections and 30 clients. Each client does basic SQL calls and closes the connection. However, some of these clients get hung up in the connection call and wait until timeout. Does this sound familiar? I am using the standard ConnectionDataSource class and using Oracle 8i as the database. Thanks, Ozzie Gurkan Manheim Interactive 404-269-8776
RE: Connection Pooling in Orion
Adrian, Use orion's admin.jar to get connection pool info. On my machine, I can type this to get stats: java -jar admin.jar ormi://localhost admin password -application default -dataSourceInfo The output looks like this: DataSource info: jdbc/xa/HypersonicXADS - cached: 0 used: 0 total: 0 jdbc/HypersonicDS - cached: 0 used: 0 total: 0 jdbc/xa/EMD/MainXADS - cached: 2 used: 0 total: 2 jdbc/EDM/MainDS - cached: 2 used: 0 total: 2 -Original Message- From: Adrian Yau [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 7:43 PM To: Orion-Interest Subject: Connection Pooling in Orion I think I've correctly set up database connection pooling for my enterprise app. But how do I confirm that Orion is actually doing connection pooling for me? Thanks. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
Re: JDBC connection pooling and ORION
Does the DB Connection pool shrink? Vic - Original Message - From: Frank LaRosa [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 10:17 PM Subject: Re: JDBC connection pooling and ORION Like a lot of things in Orion, this is not particularly well documented. Here is how I have mine set up. The name identified as the pooled-location appears to behave as a pooled data source when I reference it from my application. data-source class=com.evermind.sql.DriverManagerDataSource connection-driver=sun.jdbc.odbc.JdbcOdbcDriver name=SQLServer location=jdbc/SQLServerCore xa-location=jdbc/xa/SQLServerXA ejb-location=jdbc/SQLServerEjb pooled-location=jdbc/SQLServer username= password= url=jdbc:odbc:LocalServer inactivity-timeout=30 min-connections=5 max-connections=1000 / - Original Message - From: Hao H Ngo [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 2:08 PM Subject: JDBC connection pooling and ORION Can someone tell me how to get JDBC connection pooling to work? Maybe some examples? I can't find anything on connection pooling. I have successfully made a JDBC connection to postgres, but I would like to grab connections from a pool and release to that pool. Help?
Re: Connection Pooling in Orion
At 18:43 04.05.2001 , you wrote: I think I've correctly set up database connection pooling for my enterprise app. But how do I confirm that Orion is actually doing connection pooling for me? - look at your dbms logs (if your dbms provides such facilities) - enable tracing in your jdbc driver (again, if your jdbc driver provides something like that) - just rely on it because it does work ;-) HTH robert Thanks. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ (-) Robert Krüger (-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH (-) Brüder-Knauß-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
Connection Pooling in Orion
I think I've correctly set up database connection pooling for my enterprise app. But how do I confirm that Orion is actually doing connection pooling for me? Thanks. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
JDBC connection pooling and ORION
Can someone tell me how to get JDBC connection pooling to work? Maybe some examples? I can't find anything on connection pooling. I have successfully made a JDBC connection to postgres, but I would like to grab connections from a pool and release to that pool. Help?
Database connection Pooling in Orion
Hi, Can somebody explain to me how does Database connection pooling stuff work in Orion. I don't see any parameters in datasources.xml file where I can specify things like min connections, max connections etc. Vimal __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
RE: Database connection Pooling in Orion
There is a max-connections attribute to the data-source in: http://www.orionserver.com/dtds/data-sources.dtd -Original Message- From: Vimal Kansal [SMTP:[EMAIL PROTECTED]] Sent: September 6, 2000 12:50 PM To: Orion-Interest Subject: Database connection Pooling in Orion Hi, Can somebody explain to me how does Database connection pooling stuff work in Orion. I don't see any parameters in datasources.xml file where I can specify things like min connections, max connections etc. Vimal __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
RE: Database connection Pooling in Orion
That answers only a part of question. Where do I specify the minimum number of connections in the pool. Typically the way a connection pool works is like this At the startup(i.e when the application server is started), a few number of connections are established(specified by some kind of parameter). This is called the low water mark. After this point onwards, as the requests are coming in, the pool keeps growing and shrinking in size but within min and max. Vimal --- Rick Bos [EMAIL PROTECTED] wrote: There is a max-connections attribute to the data-source in: http://www.orionserver.com/dtds/data-sources.dtd -Original Message- From: Vimal Kansal [SMTP:[EMAIL PROTECTED]] Sent: September 6, 2000 12:50 PM To: Orion-Interest Subject:Database connection Pooling in Orion Hi, Can somebody explain to me how does Database connection pooling stuff work in Orion. I don't see any parameters in datasources.xml file where I can specify things like min connections, max connections etc. Vimal __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/