-
1. Re: Could not create connection; - nested throwable: (java.s
frito Mar 11, 2003 2:19 AM (in response to iury)It's an exception stacktrace...
to be more precise: it is an SQLException showing an oracle error (ORA-00020)...
even more precise: oracle tells you, that the number of processes exeeded...
change the apropriate value in your init.ora
Frito -
2. Dont close connection
iury Mar 11, 2003 8:55 AM (in response to iury)I´m using "jboss 3 with oracle". I am opening connections normaly.
The problem is that the data base connection does not properly closed or it is not being reused using jboss.
What I make so that the connections are closed automatic. -
3. Re: Dont close connection
iury Mar 11, 2003 9:09 AM (in response to iury)I´m using "jboss 3 with oracle" whe I am just using CMPs in my application.
The problem is that the data base connection is not closed or returned to the pool, or reused by jboss.
Is there any configuration in the datasource to jboss reuse the statements or close the connections? -
4. Re: Dont close connection
frito Mar 11, 2003 9:24 AM (in response to iury)Please explain what you are doing exactly and which version of JBoss you are using (3.?.?). Perhaps you can post some helpful code / configuration snippets...
Frito -
5. Re: Dont close connection
iury Mar 11, 2003 12:04 PM (in response to iury)I am making some operations of insert in the data base using Entity Bean CMP.
As the amount of register to be inserted is greater that the number of connections configured for the Oracle (150), the Jboss
does not close nor reuses the connections after the commit, leaving them inactive, causing the burst of excess of allowed connections.
This same application functions without problems in other application servers (Ex: BAS, BES, OAS). -
6. Re: Dont close connection
iury Mar 11, 2003 12:05 PM (in response to iury)the jboss versoin is 3.0.5