Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

connection pooling and oracle  RSS feed

 
Mahesh Kulkarni
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello friends,
We'r facing the following problem
We've deployed an application on iplanet app server using oracle 8i as the rdbms.
we've aet max_open_cursors =2000.The following is the details of our deployment.
We would like to know about reserved,unreserved and total pools available.
1.We created one external database driver(jdbc driver) viz ora-type4 with the proper classes and classpath.
2.We then created one datasource viz connectdb/ConnectDbDB for the above specified driver.
Details of the same are as follows.
a)Jndi name = connectdb/ConnectDbdB.
b)Driver type =ora-type4.
c)Database url= jdbc racle:thin:@server:1521:WEB
d)Username = scott
e) password= tiger
f) DebugLevel =1
g) MaxPoolSize =15
h) MaxWait= 5
i) Monitorinterval = 10
j) SteadyPoolSize=5
k) UnUsedMaxLife = 120
3.We created a stateless session bean viz ConnectBean which has all the methods, for eg getConnection(),insert(String sql),update(String sql)etc.This bean is used to get the connection with the oracle as well as querying the database etc.
4.We have used the above session bean in our other EJB or servlets for making/executing the database queries.
5.We are getting the exception as follows.

Error while retriving..Closed Connection
ResultSet..null
After Retriving.....
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:381)
at com.netscape.server.servlet.platformhttp.PlatformHttpServletRequest.s
etAttribute(Unknown Source)
at com.wl.scms.tpl.tplconsign.CustomerWiseViewConsignServlet.service(Cus
tomerWiseViewConsignServlet.java:109)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at com.netscape.server.servlet.servletrunner.ServletInfo.service(Unknown
Source)
at com.netscape.server.servlet.servletrunner.ServletRunner.execute(Unkno
wn Source)
at com.kivasoft.applogic.AppLogic.execute(Unknown Source)
at com.kivasoft.applogic.AppLogic.execute(Unknown Source)
at com.kivasoft.thread.ThreadBasic.run(Native Method)
at java.lang.Thread.run(Thread.java:479)
Finally Connection Closing...
closing Statement
closing Connection
[18/Jan/2002 18:27:36:2] info: RLOPMGR-023: connectdb/ConnectDbDB: Reserved=13
Also some times we r getting the exception as follows
closing Statement
#
# An EXCEPTION_ACCESS_VIOLATION exception has been detected in native code outsi
de the VM.
# Program counter=0x4f31f73
#
# Problematic Thread: prio=5 tid=0xfdc2a30 nid=0x223 runnable
#
#
# An EXCEPTION_ACCESS_VIOLATION exception has been detected in native code outsi
de the VM.
# Program counter=0x4f31f73
#
# Problematic Thread: prio=5 tid=0xfdc2a30 nid=0x223 runnable
#
#
# An EXCEPTION_ACCESS_VIOLATION exception has been detected in native code outsi
de the VM.
# Program counter=0x4f31f73
#
# Problematic Thread: prio=5 tid=0xfdc2a30 nid=0x223 runnable
#
LoginID :TPL
All connection are closed properly after each query.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!