The same jar/zip is used by both drivers. It is the JDBC URL that will signify the type. 1. Thin Driver - jdbc:oracle:thin:@hostname:portnumber:myDatabase 2. OCI Driver - jdbc:oracle:oci8:@tnsname
HTH regards MS -----Original Message----- From: David Rocks [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 6:56 AM To: [EMAIL PROTECTED] Subject: [JBoss-user] Re: Where has my memory gone? I have been using the driver in classes12.zip on both Solaris and win2k. I have seen a few comments about it's unreliability. We do use clobs in our tables. I have been suspicious of them for a while but i commented them out and the leak was still there. Are there alternatives to the driver i am using? I have not taken a look at the driver objects with JProbe but i think that is a good place to have a look. How can i find out the number of connections that i have on my Oracle database? We did have a fixable leak that was caused by not closing connections so i have been suspious of that for a while. cheers --__--__-- Message: 1 Date: Fri, 28 Mar 2003 13:35:33 +0100 From: Gaetan Zoritchak <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Where has my memory gone? Reply-To: [EMAIL PROTECTED] When you analysed the app with JProbe, did you take a look to the Oracle Driver objects? I had problems with it. There are Oracle "optimizations" that keep data in cache. Do the number of connection to the database increase? -- Gaetan Zoritchak Bright Side Factory http://www.bs-factory.com David Rocks wrote: > I am having a desperate problem with my JBoss app server. It seems to > be leaking memory all over the place but after a week of debugging > and JProbing I can just not find the problem. My architecture is > session beans that link onto Entity beans that can have dependant > objects. a la Composite entity design pattern, nothing radical. It > seems that when we make a call to the session layer to create an > entity with dependants from data in our oracle db then the server mem > jumps 5 meg and never goes down. Keep going and we crash. We > originally started with 2.4.4 but moving up to 3.0.6 did not seem to > make a change. We develop on win 2000 but the leak still seems to be > there on our Solaris servers. We use oracle 8i in our dev > environment and 9i on our servers. I have used JDK 1.3.1 and 1.4. It > just seems to point to our code but where I just can't find. I have > been through the code making sure that we close all of our > connections to the database 20 times. nulling references as well. > > I got JProbe to analyse the JVM that the app server runs on and it > claims that the level of objects remains the same and the memory they > take up is the same giving me the impression that is all OK. Looking > at task manger tells a different story with the memory zooming up > until the OutOfMemory Exception occurs. top on our Solaris servers > shows that the memory never seems to be recovering as well. > > If anybody can share a thought on why this is happening please feel > free to share this with me. Even the obvious clue would be great. I > have tried everything I know. > > David Rocks > > Software Development Manager [EMAIL PROTECTED] > > > > > > > ------------------------------------------------------- This SF.net > email is sponsored by: The Definitive IT and Networking Event. Be > There! NetWorld+Interop Las Vegas 2003 -- Register today! > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en > _______________________________________________ JBoss-user mailing > list [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This SF.net email is sponsored by: The Definitive IT and Networking Event. Be There! NetWorld+Interop Las Vegas 2003 -- Register today! http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.net email is sponsored by: The Definitive IT and Networking Event. Be There! NetWorld+Interop Las Vegas 2003 -- Register today! http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user