• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

connection pooling and oracle

 
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic