Re: Getting Oracle ORA-00018 (max sessions) without opening connections?!

I guess you configured your connection pool with a lot of sessions. The first time you use one the pool is filled. This may exceed your limit.

Please don't crosspost.

Regards,

Martin

"news.telus.net" wrote:
>
> Hi there,
>
> I'm experiencing a problem that seems like it couldn't be happening. Even
> though I am not creating a connection, I'm getting an Oracle 'maximum number
> of sessions exceeded' error. All I'm doing is creating a preparedCall,
> executing it, and getting the resultset from it.
>
> Here are more details:
>
> When running our application under load, we're getting the following
> exception in our log..
>
> Exception in ActivityDAOHelper.buildUnreadPoints(...):
> java.sql.SQLException: ORA-00018: maximum number of sessions exceeded
>
> Based on the signature of the log entry, this exception must have been
> raised within the try clause of this method:
>
> private static List buildUnreadPoints(Connection conn, UserVO user, Locale
> locale) throws SQLException {
> PreparedStatement stmt = null;
> ResultSet rs = null;
> List result = null;
>
> try {
> String query = buildUnreadPointsQuery(locale);
> stmt = conn.prepareCall(query);
> stmt.setInt(1, user.getRowId());
> stmt.execute();
> rs = stmt.getResultSet();
> result = buildUnreadPointsList(rs);
> } catch (SQLException exc) {
> System.out.println("Exception querying endorsements in
> ActivityDAOHelper.buildUnreadPoints(...): "+exc);
> throw exc;
> } finally {
> releaseResources(rs, stmt);
> }
>
> return result;
> }
>
> The BuildUnreadPointsQuery performs simple String manipulation and also uses
> the Locale after which it returns a straightfoward SELECT..FROM..WHERE
> query, and the buildUnreadPointsList method goes through the resultset and
> simply builds an object based on the resultset.
>
> I don't understand how the actions performed in that code can create an
> ORA-00018 exception?
>
> We're using WebSphere 4.0.2, connection pooling, and Oracle 8.1.7.0.0 with a
> JDBC thin client.
>
> Martijn.
Received on Thu Mar 21 2002 - 03:09:30 CST