Hello,
I have some jsp's that are using orion's connection pooling.
When a jsp page opens the db connection (oracle) through the connection
pool, is it dedicated to that particular jsp page? Another jsp couldn't
issue a commit or rollback and somehome impact another jsp's transactions,
correct
That's correct AFAIK, and applies to all connection pooling
schemas(JDBC, ODBC, you name it) but on most recent versions, the driver
will pool the connections itself, not Orion.
Anyhow, you got most of it right, except that another jsp page instance
may vote in a different connection. No sweat
: HyungKee Hwang
[mailto:[EMAIL PROTECTED]]Sent: Thursday, July 26, 2001 5:45
PMTo: Orion-InterestSubject: RE: Anyone experience any
problems with JDBC Oracle drivers and JDK 1.3.1 with connection
pooling?
Im
using Oracle 8.1.7s
JDBC driver (classes12) with JDK 1.3.0. And it seems
At 05:44 PM 7/26/2001, you wrote:
I m using Oracle 8.1.7 s JDBC driver (classes12) with JDK 1.3.0. And it
seems to have some problems to handle CLOB. But there has not been any
problem except CLOB problem up to now.
Interesting. No problems handling CLOBs here except when using a Type 1 or
problems with JDBC Oracle drivers and JDK 1.3.1 with connection pooling?
Im using Oracle 8.1.7s JDBC driver (classes12)
with JDK 1.3.0. And it seems to have some problems to handle CLOB. But there
has not been any problem except CLOB problem up to now.
I heard from Oracle technical
support
I have been trying to
figure out why I can't connect to our Oracle database. We are running JDK 1.3.1
with Orion 1.5.2. We are using the jdbc.zip (I assume classes12.zip). I am
reading on Oracle that Oracle 8.1.7 (and 8.1.5) only have JDBC drivers that
support JDK 1.2.x. Does this mean
experience any problems with JDBC
Oracle drivers and JDK 1.3.1 with connection pooling?
I have been trying to
figure out why I can't connect to our Oracle database. We are running JDK
1.3.1 with Orion 1.5.2. We are using the jdbc.zip (I assume classes12.zip). I
am reading on Oracle
with connection
pooling?
I have been trying to
figure out why I can't connect to our Oracle database. We are running JDK
1.3.1 with Orion 1.5.2. We are using the jdbc.zip (I assume classes12.zip). I
am reading on Oracle that Oracle 8.1.7 (and 8.1.5) only have JDBC drivers that
support JDK
Oracle drivers and JDK 1 .3.1 with connection
pooling?
I have been trying to
figure out why I can't connect to our Oracle database. We are running JDK
1.3.1 with Orion 1.5.2. We are using the jdbc.zip (I assume classes12.zip). I
am reading on Oracle that Oracle 8.1.7 (and 8.1.5) only
.
-HK
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
Behalf Of Duffey, Kevin
Sent: Friday, July 27, 2001 6:30
AM
To: Orion-Interest
Subject: Anyone experience any
problems with JDBC Oracle drivers and JDK 1.3.1 with connection pooling?
I have
.
Of course Oracle recommends to go to JDK
1.2.2.
ap
- Original Message -
From:
Duffey,
Kevin
To: Orion-Interest
Sent: Thursday, July 26, 2001 6:32
PM
Subject: RE: Anyone experience any
problems with JDBC Oracle drivers and J DK 1.3.1 with connection
pooling?
Funny
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
/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
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
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
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
Hi,
There is no facility in orion to setup connection pooling for JMS. JMS in
orion uses flat file for persistence. If you need persistence for a queue,
you have to declare it in jms.xml.
I still find some problem using persistence and transaction in JMS with
Orion server.
Good luck to you
Title: RE: Orion performance meassures ?
Has
any one tried to setup connection pooling for JMS? Is there any such
facility in orion 1.4.7?
Kesav Kumar Software Engineer Voquette, Inc. 650 356 3740 mailto:[EMAIL PROTECTED]
http://www.voquette.com Voquette...Delivering Sound
Information
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?
How to specify min number of connections and max number of connections in my
data base connection pooling. I am using the following settings currently.
data-source class="com.evermind.sql.DriverManagerDataSource"
name="Oracle8" location="jdbc/Chal
Subject: Connection Pooling
How to specify min number of connections and max number of connections in my
data base connection pooling. I am using the following settings currently.
data-source class="com.evermind.sql.DriverManagerDataSource"
name="Oracle8" locat
in my
data base connection pooling. I am using the following settings
currently.
data-source class="com.evermind.sql.DriverManagerDataSource"
name="Oracle8" location="jdbc/Challenger"
connection-driver="oracle.jdbc.driver.OracleDriver" username=&qu
You need to include pooled-location="jdbc/OraclePooledDS" and look up
"jdbc/OraclePooledDS" in the EJB or servlet.
From: Ugur Karakaya [EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: connection pooling
Date: Wed,
i explained datasource (data-source.xml) for oracle to use
connection pooling with orion;
data-source
name="Oracle"
location="jdbc/OracleCoreDS"
xa-location
Hi,
I am new to EJBs so I apologize if my question sounds silly. I am trying to
configure Orion to use Oracle 8 and pooled connections.
This is how my data-source looks like:
data-source
class="com.evermind.sql.ConnectionDataSource"
ejb-location="jdbc/MyApollo"
cc:
owner-orion-interest@orionSubject: Oracle database and
connection pooling
Title: RE: Oracle database and connection pooling
Try using com.evermind.sql.DriverManagerDataSource as your datasource class and set your max-connections. Look it up using your ejb-location and setting it to the standard DataSource interface. Orion will pool the connection automatically
Hello,
I followed the orionsupport.com instructions on how to configure Orion for
connection pool seems to work, but how do you verify Orion is pooling? I
checked the logs.
Keith
dear all,
do requests for EJB UserTransaction objectsor
db connections accessible through a Context get handled in a *queued* manner
under orion?, or does it just notifyAll() the worker threads and let them fend
for themselves?
we're currently doing our own database connection
pooling
Hello,
I have a couple questions about Orion and EJB in general.
1. Shouldn't the server pool database connections ? It is not.
2. If so, is there something we are missing in the configuration to allow
this ? We have tried our own code and sample code found on
www.orionsupport.com.
This is the
st
Subject: Database connection pooling
Hello,
I have a couple questions about Orion and EJB in general.
1. Shouldn't the server pool database connections ? It is not.
2. If so, is there something we are missing in the configuration to allow
this ? We have tried our own code and sample
On Fri, 8 Dec 2000, Todd Mayfield wrote:
Hello,
I have a couple questions about Orion and EJB in general.
1. Shouldn't the server pool database connections ? It is not.
Ah so! But it does. :)
2. If so, is there something we are missing in the configuration to allow
this ? We have
Title: RE: Deleting cookies with Orion
Hi,
I need
to use connection pooling in one of my EJB objects and I don't want to use any
Orion specific code so I can move the EJB from Orion to other application
servers it works again.
I was
reading the Orion mailing list and I couldn't find
that's what the datasource absraction hides from you. what else do you
need? any EJB 1.1 example will do. there are lots of books ou there (a free
one at www.theserverside.com)
robert
At 14:19 16.10.00 , you wrote:
Hi,
I need to use connection pooling in one of my EJB objects and I don't
Title: RE: Deleting cookies with Orion
As far
as I know, you will want to use DataSources, JDBC 2.0 and what not..they are
standard to J2EE, so they should allow it to work. I know Connection Pooling is
not Orion specific (in that it implements the J2EE standard for connection
pooling). Its
Hello All,
Could some one please explain the data-sources.xml file/usage other then
the rudimentary documentation on the web site.
For instance, how does one setup a connection pool? Is it enough to use
the example and point your data source object to the JNDI location
specified in the
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
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
://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
When I submit the connection to an oracle method I get a class cast
exception.
The object returned from DataSource.getConnection() is an
com.evermind.sql.ai object. Unfortunately oracle requires an
oracle.jdbc.driver.OracleConnection. com.evermind.sql.ai has to be storing
an instance of the
This is VERY slow, and in some tests its 100's of times slower than
implementing a connection pool. For the original sender (and Conrad if you
are not aware of this), there are two methods I would choose over the others
above. The first is connection pooling. Servlets in the same web app
Option 2 is better when you are dealing with application servers,
especialy
with Orion. Orion has a very easy built-in connection pooling capability.
When you suggest this method, I assume you are talking about an Orion
specific mechanism correct? This is convenient if Orion is the only
pooling
Hi everybody,
thank you for your responses!
i forgot to say that i am already using orion's connection pooling
capability (i never thought i would give up my old connection pooling
package, but orion made it possible ;=)
the reason why i wrote the original message to this list
Connections obtained through a datasource ar closed to indicate that they are
available for re-use. The actual underlying connection to the database is not
closed.
Joe Peer wrote:
Hi everybody,
thank you for your responses!
i forgot to say that i am already using orion's connection pooling
hi everybody,
i have a design question: how should i manage (pooled) database connections
in my web app?
i found different hints from different sources...
* some people say, it's best practice to put 1 connection into 1 user's http
session and use it for all requests of that user
* other
they need/want to
who is right? or, how do you handle it?
This is also resource hungry.
The suggested approach is to setup Orion for connection pooling, and
get connections using the datasource as usual.
Subbu
=
__
Do You Yahoo!?
Kick off your
is expensive unless
there is a connection pooling mechanism in place.
Conrad
ways.
* again other people argue that they don't care at all about reusing
connection, they just open and close them when they need/want to
I would not like this idea since opening a database connection is
expensive unless there is a connection pooling mechanism in place.
This is VERY slow
,
Karl Avedal
KirkYarina wrote:
I'm running a series of performance tests as both a learning tool and to
assist our chief designer, and am converting our test suite from CMP to
BMP.
I'm confused about how Orion manages jdbc connection pooling. The mail
archive discussion I found
I'm running a series of performance tests as both a learning tool and to
assist our chief designer, and am converting our test suite from CMP to BMP.
I'm confused about how Orion manages jdbc connection pooling. The mail
archive discussion I found , from last November, is adding to the fog
CMP to BMP.
I'm confused about how Orion manages jdbc connection pooling. The mail
archive discussion I found , from last November, is adding to the fog
The following snippet from data-sources.xml would suggest that it's
possible to obtain either a pooled or non-pooled connection by using
51 matches
Mail list logo
