RE: [JBoss-user] 3.2.0 Crashed Out Of Memory After 1 Hour...

2003-04-12 Thread Filip Hanik
1.4.1 has a memory leak in java.lang.StringBuffer, if you reuse it alot

filip

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Hunter
 Hillegas
 Sent: Saturday, April 12, 2003 5:24 PM
 To: JBoss User
 Subject: Re: [JBoss-user] 3.2.0 Crashed Out Of Memory After 1 Hour...


 Running the default config with a couple of my EARs installed.

 I downgraded to 1.4.0_04 and so far, memory use seems more stable.

 I'm on Linux.

  From: Nicholas [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date: Sat, 12 Apr 2003 16:30:21 -0700 (PDT)
  To: [EMAIL PROTECTED]
  Subject: Re: [JBoss-user] 3.2.0 Crashed Out Of Memory After 1 Hour...
 
  Are you seeing this with no additional modules
  deployed  ? Just the bare installation ?
 
  I have been running 2 3.2 clustered instances on NT
  with 1.4.1_02 and they have been flat memorywise.
 
  //Nicholas
 
 
  --- Hunter Hillegas [EMAIL PROTECTED] wrote:
  Interesting.
 
  Anyone else have trouble with this combo? Perhaps I
  need to downgrade to
  1.4.0?
 
  Hunter
 
  From: Bradley McLean [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date: Sat, 12 Apr 2003 18:04:44 -0400
  To: [EMAIL PROTECTED]
  Subject: Re: [JBoss-user] 3.2.0 Crashed Out Of
  Memory After 1 Hour...
 
  * Hunter Hillegas ([EMAIL PROTECTED])
  [030412 17:48]:
  Just upgraded to 3.2.0 and it ended up crashing
  after about 1 hour of use...
 
  We have allocated 900MB to the JVM and never had
  OOM with 3.0.6.
 
  Anyone else seeing huge memory usage?
 
  We are: SMP Linux, JDK 1.4.1_02 (Sun).
 
  We've had trouble with that combination, with
  JBoss 3.0.4 and other
  java code.  We use 1.4.0 on SMP Linux because of
  that.
 
 
 
 
 
  ---
  This SF.net email is sponsored by: Etnus, makers
  of TotalView, The debugger
  for complex code. Debugging C/C++ programs can
  leave you feeling lost and
  disoriented. TotalView can help you find your way.
  Available on major UNIX
  and Linux platforms. Try it free. www.etnus.com
  ___
  JBoss-user mailing list
  [EMAIL PROTECTED]
 
 
  https://lists.sourceforge.net/lists/listinfo/jboss-user
 
 
 
 
  ---
  This SF.net email is sponsored by: Etnus, makers of
  TotalView, The debugger
  for complex code. Debugging C/C++ programs can leave
  you feeling lost and
  disoriented. TotalView can help you find your way.
  Available on major UNIX
  and Linux platforms. Try it free. www.etnus.com
  ___
  JBoss-user mailing list
  [EMAIL PROTECTED]
 
  https://lists.sourceforge.net/lists/listinfo/jboss-user
 
 
  =
  Nicholas Whitehead
  Home: (973) 377 9335
  Cell: (201) 615 2716
  [EMAIL PROTECTED]
  Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/
 
 
  ---
  This SF.net email is sponsored by: Etnus, makers of TotalView,
 The debugger
  for complex code. Debugging C/C++ programs can leave you
 feeling lost and
  disoriented. TotalView can help you find your way. Available on
 major UNIX
  and Linux platforms. Try it free. www.etnus.com
  ___
  JBoss-user mailing list
  [EMAIL PROTECTED]
  https://lists.sourceforge.net/lists/listinfo/jboss-user



 ---
 This SF.net email is sponsored by: Etnus, makers of TotalView,
 The debugger
 for complex code. Debugging C/C++ programs can leave you feeling lost and
 disoriented. TotalView can help you find your way. Available on
 major UNIX
 and Linux platforms. Try it free. www.etnus.com
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
for complex code. Debugging C/C++ programs can leave you feeling lost and 
disoriented. TotalView can help you find your way. Available on major UNIX 
and Linux platforms. Try it free. www.etnus.com
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] Override the Manager element for embedded Tomcat

2003-03-14 Thread Filip Hanik
I'm trying to use the Tomcat persistence manager for sessions with embedded
JBoss 3.0.6

DefaultContext cookies = true crossContext = true override = true
Manager className=org.apache.catalina.session.PersistentManager
 all other attributes here/
/DefaultContext)

I'm changing this in the file /default/deploy/tomcat41-service.xml

but the wars still get deployed with the StandardManager,

any thoughts?
Filip



---
This SF.net email is sponsored by:Crypto Challenge is now open! 
Get cracking and register here for some mind boggling fun and 
the chance of winning an Apple iPod:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] JDBC / ResultSet Question

2001-06-19 Thread Filip Hanik

Currently in our project we have well over 15,000,000 data
items in the database and a user will do a search for certain criteria.
Some
of the queries are returning 10,000+ rows.

are you using all these rows (10,000+).
if not. why even pull them out of the database. if these results are
intended for a user. only retrieve as many as the user wants to see.

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Matt Veitas
Sent: Tuesday, June 19, 2001 4:40 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] JDBC / ResultSet Question


CachedRowSet is a great way to implement sending a resultset over the
wire, but what about in the case where you may have thousands of records to
list.

I am not using JBoss as of now, just using plain servlets/jsp on
my project,
but I am always looking for a better way to code the idea of paging through
a ResultSet. Currently in our project we have well over 15,000,000 data
items in the database and a user will do a search for certain
criteria. Some
of the queries are returning 10,000+ rows. Right now we have a
piece of code
that maintains the connection to the DB, along with the ResultSet
so that we
can page through the data set. The jsp page will access it and get the data
straight from the ResultSet.

We will be starting to convert our web app over to EJB in the next few
months, but was how others are handling cases such as this with EJB...I was
thinking about a stateful session bean to take care of this, but the only
question is how to maintain the connection, statement, and ResultSet when
ejbPassivate() needs to be called? Any other suggestions on how to do this
or experiences with such a thing would be great.

Matt

--
[EMAIL PROTECTED]
703-304-6988

Emerging Paradigms Corporation
innovative ideas for smarter solutions
http://www.emerging-paradigms.com/


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of David Ward
Sent: Tuesday, June 19, 2001 7:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] JDBC / ResultSet Question


Look at CachedRowSet implementation from Sun - it is Serializable and
can be disconnected:
http://developer.java.sun.com/developer/Books/JDBCTutorial/chapter5.html

David

--

Mike korcynski wrote:

 Hello:
I am currently working on a project using JBoss
 2.2.  I have stumbled upon a strange problem I was
 hoping someone could help me with.  I have a method in
 a session bean that will perform an ad hoc query on a
 database and return the results to the client in a
 ResultSet.  However, it appears that the
 implementation of ResultSet is not serializable:
   Caused by: java.io.NotSerializableException:
 org.opentools.minerva.jdbc.ResultSetInPool

Am I doing something wrong or is this some sort of
 bug?  It would seem useful to be able to return a
 ResultSet to a client.  Can someone advise?  Thank you
 for your time.

 Mike Korcynski






 __
 Do You Yahoo!?
 Spot the hottest trends in music, movies, and more.
 http://buzz.yahoo.com/

 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user





___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] TomCat and Apache

2001-06-12 Thread Filip Hanik

will version 3.2.2 of tomcat work with apache 1.3.12
have you tried
why don't you try and let us know.
Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net 


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] Everlasting sessionbean

2001-06-05 Thread Filip Hanik

A bean is not allowed to access a socket unless it is being passed as a
reference into a method call.
a bean holding a reference to a socket will prevent it from being properly
serialized, and replicated.

2. is there a problem if the session bean's function never returns?? It is
reading from the socket forever.

yes, you are violating the spec.

why would you want to do this with a bean? use a regular Java object.

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Javier
Muguruza
Sent: Tuesday, June 05, 2001 11:11 AM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Everlasting sessionbean


Hi,

I want to use a sesssion bean (dont know yet wether it will be statefull,
stateless or it does not matter) to read data from a socket (comming from a
non ejb application).

This bean would proceed calling other session beans to do the
actual work. I
have tried with a stateless bean with jboss and it works, but i have a
couple of questions:

1. now I am using a client app just to invoke the session bean's only
function, is there a way in jboss to make a session bean instantiate and
invoke a method without a client (just for easier administration).



3. Should it be statefull, statelesss... any other proposition?

thank you,


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] how does this work (classpath)?

2001-05-31 Thread Filip Hanik

really the problem with putting your application classes into lib/ext is
twofold: it mixes application classes with infrastructure, which will
make upgrades, server re-configuration, scaling onto multiple servers,
and various other administrative tasks more difficult. It also makes
that application's classes available to all applications deployed on any
JBoss instance that runs from that directory, which is messy at best.

to add more info for this. you may experience strange behavior related to
the classloaders.
Remember that if some of your classes are loaded using the system class
loader (for example) they may not have access to classes loaded by class
loaders higher up in the loader stack. You will experience ClassNotFound,
ClassCast, and other exceptions. It may also affect the functionality of the
app server itself.

in other words, yes you can put your classes in /lib/ext but you may cause
yourself a good series of troubleshooting too.

have fun
Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] petstore 1.1.2 deployed successfully

2001-05-18 Thread Filip Hanik

go ahead

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net 

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Cuong Tran
 Sent: Friday, May 18, 2001 2:13 PM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] petstore 1.1.2 deployed successfully
 
 
 
 Hi everyone,
 
   I have managed to successfully deploy petstore 1.1.2 
 on jboss 2.2.1-tomcat 3.2.1, using Hypersonic as the database.
 If anyone is interested, I'm willing to share what I've done.
 
 
 =
 Cuong Q. Tran [EMAIL PROTECTED]
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - buy the things you want at great prices
 http://auctions.yahoo.com/
 
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user
 

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] Firewall and JBoss

2001-05-11 Thread Filip Hanik

you also have the JMX HTTPConnector port - I believe this one is 8082

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net 

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Cober
 Sent: Friday, May 11, 2001 4:45 PM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] Firewall and JBoss
 
 
 Help!
 I am interested in locking the ports JBoss uses.
 1099 if the default JNDI lookup that is fine.
  is the default RMI Object Port that can be controlled in jboss.xml.
 There is a third port that seems to be randomly assigned everytime the 
 server is started.  I have seen 1591, 2291, etc.
 I believe this port may be part of the default RMI Socket Factory or 
 something.  How can I control it?
 
 Thanks for any help you can provide
 
 
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com
 
 
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user
 

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] ZIP Manual

2001-05-02 Thread Filip Hanik

you can check out the manual cvs module from jboss cvs 

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net 

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Edilmar
 Alves
 Sent: Wednesday, May 02, 2001 12:20 PM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] ZIP Manual
 
 
 Hi,
 
 I'm new into JBoss and I'd like to download the complete
 manual, that is in HTML pages. Is there some FTP to
 download a zip file with all pages???
 
 
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user
 

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] org.xml.sax.SAXParseException: Document root element is missing

2001-05-01 Thread Filip Hanik



looks 
like you have crimson.jar in your classpath and this may conflict with some 
other JAXP implementation (Xerces, jaxp.jar, parser.jar)

Filip

~Namaste - I bow to the divine in you~Filip 
HanikSoftware Architect[EMAIL PROTECTED]www.filip.net 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jason 
  DurstSent: Tuesday, May 01, 2001 3:14 PMTo: 
  [EMAIL PROTECTED]Subject: [JBoss-user] 
  org.xml.sax.SAXParseException: Document root element is 
  missing
  I am new to JBOSS and EJB's in general. I have 
  created several beans and "jarr'ed" them along with the corresponding home 
  interfaces, remote interfaces and the deployment descriptor. When I drop my 
  jar file in the deploy folder, this is the error I get. I would appreciate it 
  if anyone could give me a clue as to what the error is referring to with: 
  org.xml.sax.SAXParseException: Document root element is missing. If additional 
  information is necessary I would be glad to provide it. Thank you in advance 
  for your help.
  
  I suspect that the problem is with my ejb-jar.xml 
  file but I cannot find a reference to this error.
  
  jason
  
  the error message continues but I thought that 
  this was the relevant part.
  
  [J2EE Deployer Default] Starting[J2EE 
  Deployer Default] Cleaning up deployment directory[J2EE Deployer Default] 
  Started[Auto deploy] Starting[Auto deploy] Watching 
  E:\jboss-tomcat-2.2\jboss-2.2\deploy[Auto deploy] Auto deploy of 
  file:/E:/jboss-tomcat-2.2/jboss-2.2/deploy/musicdb.jar[J2EE Deployer 
  Default] Deploy J2EE application: 
  file:/E:/jboss-tomcat-2.2/jboss-2.2/deploy/musicdb.jar[J2EE Deployer 
  Default] Create application musicdb.jar[J2EE Deployer Default] install 
  module musicdb.jar[Container factory] 
  Deploying:file:/E:/jboss-tomcat-2.2/jboss-2.2/tmp/deploy/Default/musicdb.jar[Container 
  factory] Document root element is missing.:-1:1[Container factory] 
  org.xml.sax.SAXParseException: Document root element is missing.[Container 
  factory] at 
  org.apache.crimson.parser.Parser2.fatal(Parser2.java:3035)[Container 
  factory] at 
  org.apache.crimson.parser.Parser2.fatal(Parser2.java:3023)[Container 
  factory] at 
  org.apache.crimson.parser.Parser2.parseInternal(Parser2.java, Compiled 
  Code)[Container factory] at 
  org.apache.crimson.parser.Parser2.parse(Parser2.java:304)[Container 
  factory] at 
  org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:433)[Container 
  factory] at 
  org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:179)[Container 
  factory] at 
  javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:86)[Container 
  factory] at 
  org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:148)[Container 
  factory] at 
  org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:132)[Container 
  factory] at 
  org.jboss.metadata.XmlFileLoader.load(XmlFileLoader.java:89)[Container 
  factory] at 
  org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java, Compiled 
  Code)[Container factory] at 
  org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java, Compiled 
  Code)[Container factory] at 
  org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java, Compiled 
  Code)[Container factory] at 
  java.lang.reflect.Method.invoke(Native Method)[Container 
  factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[Container 
  factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[Container 
  factory] at 
  org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java, Compiled 
  Code)[Container factory] at 
  org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:178)[Container 
  factory] at java.lang.reflect.Method.invoke(Native 
  Method)[Container factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[Container 
  factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[Container 
  factory] at 
  org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:358)[Container 
  factory] at 
  org.jboss.ejb.AutoDeployer.run(AutoDeployer.java, Compiled Code)[Container 
  factory] at 
  org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java, Compiled 
  Code)[Container factory] at 
  org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)[Container 
  factory] at java.lang.reflect.Method.invoke(Native 
  Method)[Container factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[Container 
  factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[Container 
  factory] at 
  org.jboss.util.ServiceControl.start(ServiceControl.java, Compiled 
  Code)[Container factory] at 
  java.lang.reflect.Method.invoke(Native Method)[Container 
  factory] at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[Container 
  factory] at 
  

RE: [JBoss-user] I really need the help

2001-04-27 Thread Filip Hanik

http://www.jboss.org/documentation/HTML/ch06s05.html

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Zhang
 Sent: Friday, April 27, 2001 1:24 PM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] I really need the help


 HI all:
 I am using a session bean to call a entity bean. like following:

 public  class SignInLoggerManagerEJB implements javax.ejb.SessionBean
 {
  privateSignInLoggerHome   mySignInloggerHome;

 public SignInLoggerManagerEJB(){}
public void ejbRemove(){}
 public void ejbActivate(){}

 public void ejbPassivate(){}
 public void setSessionContext(javax.ejb.SessionContext sc){}
  public void ejbCreate()

  public void generateSignInloggerHome(){
   String signInloggerHomeName =
 SignInLogger;//JndiBeanName.SIGN_IN_LOGGER;
try{
  InitialContext jndiContext = new InitialContext();
  Object ref = jndiContext.lookup(SignInLogger);
  mySignInloggerHome = (SignInLoggerHome)
 PortableRemoteObject.narrow(ref, SignInLoggerHome.class);
   }
   catch ( Exception ex){
 throw new GeneralEjbException(ex);
   }
  }
 }

 in my generateSignInloggerHome() function I can not lookup the name of the
 entity bean SignInLogger. Actially in the entity bean's ejb-jar file and
 jboss.xml the jndi name is SignInLogger, why I can not look up?
 what should
 I do?

 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] downloading the docs for local browsing

2001-04-26 Thread Filip Hanik

check out the manual cvs module from sourceforge

then just build it and voila, you have the docs

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net 

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Maxime
 Levesque
 Sent: Thursday, April 26, 2001 8:18 AM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] downloading the docs for local browsing
 
 
 
  The online browsable docs are great,
 but i'd like to download them, they
 don't seem to be packaged for downloading...
 
 (I live in an area where a dial up connection
 is the only choice)...
 
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - buy the things you want at great prices
 http://auctions.yahoo.com/
 
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user
 

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] ResultSet or minerva.ResultSetInPool

2001-04-19 Thread Filip Hanik

getUnderLyingResultSet returns a java.sql.ResultSet, and if you are using
racle then it returns oracle.jdbc.ResultSet or something like that, you have
to look up the exact class.
you get a classcast exception because you think it is a Minerva resultset.

getUnderLyingResultSet returns the actual driver's result set, not minervas

filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Ramon
 Diaz
 Sent: Thursday, April 19, 2001 10:42 AM
 To: JBOSS Mail List
 Subject: [JBoss-user] ResultSet or minerva.ResultSetInPool


 Hi,

 We are trying to obtain a ResultSet from an Oracle database. We find
 a trouble with Minerva types,
 We are using JBoss 2.2, with JDBC 2.0 and Oracle 8.1.7.

 We are using MinervaPool driver for the JDBC. In our configuration
 files,
   -  jboss.jcml: We use  'org.jboss.minerva.xa.XADataSourceImpl' in
 the Pool configuration
   -  jboss.properties:
 #jboss.xa.xidclass=oracle.jdbc.xa.OracleXid

   First, is OraclePool (oracle.jdbc.xa.client.OracleXADataSource) better
 than MinervaPool (org.jboss.minerva.xa.XADataSourceImpl) ?
   Second, When we try to execute a ResultSet from the EJB it throws:

 [noticiasAccesoBD] Exception in
 noticiasAccesoBD::obtenerNoticiasBoletin()
 [noticiasAccesoBD] java.lang.ClassCastException:
 org.opentools.minerva.jdbc.ResultSetInPool
 [noticiasAccesoBD]  at
 es.westlaw.noticiasAccesoBDBean.obtenerNoticiasBoletin(Compiled Code)

   The code we use:
  l_query= "SELECT noticia FROM noticias";
  l_pstmt = l_con.prepareStatement(l_query);
  l_rst   = l_pstmt.executeQuery();
 // which of the next two lines should be here??
 //  l_rst2 =
 ((org.jboss.minerva.jdbc.ResultSetInPool)l_rst).getUnderlyingResultSet()
 ; // JBOSS
 l_rst2 =
 ((org.opentools.minerva.jdbc.ResultSetInPool)l_rst).getUnderlyingR
 esultSet()
 ; // JBOSS
 while (l_rst2.next())
{
 l_noticiasCLOB  = ((OracleResultSet)l_rst2).getCLOB(1);
}

Any help would be appreciated...

 Thanks in advance...

   Jose R.  Juan












 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] ResultSet or minerva.ResultSetInPool

2001-04-19 Thread Filip Hanik

The code we use:
   l_query= "SELECT noticia FROM noticias";
   l_pstmt = l_con.prepareStatement(l_query);
   l_rst   = l_pstmt.executeQuery();

   // which of the next two lines should be here??
a)   l_rst2 =
((org.jboss.minerva.jdbc.ResultSetInPool)l_rst).getUnderlyingResultSet(); //
JBOSS
b)   l_rst2 =
((org.opentools.minerva.jdbc.ResultSetInPool)l_rst).getUnderlyingResultSet()
; // JBOSS

   while (l_rst2.next())

the easiest way to find out is to add this line

System.out.println( l_rst2.getClass().getName() );
^^

before line a) and b)

I couldn't tell you on top of my head which one it is, but this will tell
you

Filip
~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of danch
 Sent: Thursday, April 19, 2001 11:17 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-user] ResultSet or minerva.ResultSetInPool


 He's casting what was returned from executeQuery so that he can call
 getUnderLyingResultSet.

 Filip Hanik wrote:
 
  getUnderLyingResultSet returns a java.sql.ResultSet, and if you
 are using



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] Not so much JBoss, but XSL/XSLT

2001-04-18 Thread Filip Hanik

not that this will solve your problem, it may help you fix it.

http://www-106.ibm.com/developerworks/xml/library/x-xslt2/index.html?openl=
bigx-2,t=gr,p=x.saxon

I know that we used to cache the parsed XSL sheet, this way we increased our
performance dramatically, otherwise, the XSLT parser has to parse the XSL
everytime you use it.

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
Sent: Wednesday, April 18, 2001 7:55 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Not so much JBoss, but XSL/XSLT



We have run it under Optimize It and the objects appear to be cleaning up
properly - in fact, the profiling tool showed us that there was a HUGE
number
of objects being used just to do a single transformation (as per the XSLT
implementation)!!

We've thought about the idea of clustering more, smaller sized VM's, but
figured that would take a bit more programming to pull off.  We had tried
running a test case in multiple VM's, but that didn't help too much because
the added overhead of the additional VM's killed us (which may be due to
how we had tuned the vm settings.)

Anyways, back to the drawing board...

Robert


Robert Schulz [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/17/2001 07:22 PM
Please respond to jboss-user

To:"'[EMAIL PROTECTED]'"
[EMAIL PROTECTED]
cc:
Subject:RE: [JBoss-user] Not so much JBoss, but XSL/XSLT



Don't know about XSL but this sounds like a VM garbage collection problem.
What seems to happen with large heap sizes is that it keeps allocating
without
collecting and then gets tangled up when trying to collect ... try
clustering over
a number of smaller heap size virtual machines. Also, use some profileing
tool
(optimize it) to see what's happening and whether you are hanging on to no
longer
needed objects.

R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 April 2001 8:29
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Not so much JBoss, but XSL/XSLT


Sorry to post this here, but I know more eyes will see it.

We've looked at a number of different XSL/XSLT Processors
and found one that is documented fairly well, runs fast, but
apparently doesn't scale very well.

For example, at up to loads of about 300 users it performs
very well.  But, go beyond that, say to 500 users and it just
crawls like a dog - running on a 4-CPU (700MHz each) box
with 4G ram!!  The cpus are running at about 80% capacity
and our memory usage is over 1G (for whatever reason, we
can't set the heap size any larger than that).

So - anyone have any experiences with XSL transformations
and scalability??

I'd love to know.

Robert


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] How to deploy an external jar in JBoss?

2001-04-02 Thread Filip Hanik



WEB-INF/lib

Filip

~Namaste - I bow to the divine in you~Filip 
HanikSoftware Architect[EMAIL PROTECTED]www.filip.net 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of suyan 
  zhuSent: Monday, April 02, 2001 5:14 PMTo: 
  [EMAIL PROTECTED]Subject: [JBoss-user] How to deploy 
  an external jar in JBoss?
  I'd like to deploy an external jar file(e.g jdom.jar)used by 
  thewar of an application in JBoss. How should it be specified in 
  deployment descriptor, or Manifest.mf?
  Thanks,
  Suyan,
  
  
  Do You Yahoo!?Yahoo! Mail Personal 
  Address - Get email at your own domain with Yahoo! 
Mail.


RE: [JBoss-user] What is the beta in jboss-tomcat-2.1-beta.zip?

2001-03-30 Thread Filip Hanik



beta 
means beta.

almost 
all features complete
not 
fully tested/verified to be considered production quality.

that 
is what beta means to most software organizations :)

Filip

~Namaste - I bow to the divine in you~Filip 
HanikSoftware Architect[EMAIL PROTECTED]www.filip.net 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Chunnuan 
  ChenSent: Friday, March 30, 2001 10:40 AMTo: 
  [EMAIL PROTECTED]Subject: [JBoss-user] What is the 
  "beta" in jboss-tomcat-2.1-beta.zip?Hi, When 
  Idownload the binary for  
  . JBoss_tomcat.zip (8.75M) [MAR-26-2001] 
  the file name is jboss-tomcat-2.1-beta.zip. What does the "beta" within 
  the filename mean (seeing this word just makes me feel not so comfortable)? 
  Does it mean the Jboss 2.1 itself is in beta release? If so, why doesn't the 
  download page state that? 
  Thanks, Chunnuan   


RE: [JBoss-user] I need ammo. -WL SUX

2001-03-30 Thread Filip Hanik

 |So one, BEA screwed up using multicast for messaging large
 amounts of data
 |in a cluster. Other products like Gemstone have a much more
 mature cluster
 |technology and do not need to message to stay in synch.

 that is actually pretty smart (mcast sync of ball) we were
 planning on using
 that... if they ran into problems likeliness is we will too

 marc

Unless, you have a framework that implements reliable multicasting, like
www.javagroups.com, I'm still researching and digging into this technology
to see if it would
be a fit. As of now, it looks really good, but it is a little bit built to
be its own application instead of a component inside of a server
application. The statement here, is about thread handling can not be
controlled from outside, and when developing an EJB server you have to be
able to control most of the threads.

Will send you all more feedback once I get really down and dirty with this
one.

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] JBoss questions...

2001-03-29 Thread Filip Hanik

 1) when using BMP how do you return a database connection to the pool when
 your finished with it?

Connection.close();


 2) can JBoss perform distributed transactions with SQL Server? If so, is
 there any information showing how to do this with BMP?


nope, true 2 phase commit is not implemented,. the only server that has it
is Weblogic 6.0

 3) our current RMI based app executes batch jobs in a thread on
 the server,
 and these threads pound SQL Server. Given that EJB doesnt allow
 new threads
 to be spawned, how can this be achieved using the EJB model?

use JMS to do asynchronous requests

 4) does/will JBoss support load balancing between multiple JBoss
 app servers
 running concurrently on different win2000 boxes?

yes, if it is stateful loadbalancing, it your request gets pinned to a
machine when the connection is established.
true loadbalancing is underway.

 5) is there any published schedule of the planned upcoming
 releases and what
 th

dunno


Filip
~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of
 Crothers.Dean
 Sent: Thursday, March 29, 2001 1:57 PM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] JBoss questions...


 Hi,

 I've looked on the website and thru the archives, but couldnt find answers
 to the following questions.

 But first some background, we plan to use JBoss 2.1 on Win2000
 with multiple
 SQL Server databases (potentially on different boxes).

 1) when using BMP how do you return a database connection to the pool when
 your finished with it?

 2) can JBoss perform distributed transactions with SQL Server? If so, is
 there any information showing how to do this with BMP?

 3) our current RMI based app executes batch jobs in a thread on
 the server,
 and these threads pound SQL Server. Given that EJB doesnt allow
 new threads
 to be spawned, how can this be achieved using the EJB model?

 4) does/will JBoss support load balancing between multiple JBoss
 app servers
 running concurrently on different win2000 boxes?

 5) is there any published schedule of the planned upcoming
 releases and what
 they will contain?


 thanks,

 Dean

 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] JBoss questions...

2001-03-29 Thread Filip Hanik

 You mentioned that 'true 2 phase commit' is not implemented in JBoss? The
 logging of the JBoss console at startup outputs:

 [SQLServerPool] Starting
 [SQLServerPool] XA Connection pool SQLServerPool bound to
 java:/SQLServerPool
 [SQLServerPool] Started

Well. that is the jdbc driver that implements the XA protocol.
This means that if the server was able to handle distributed transactions,
the underlying driver will support that.

so for a distributed transaction to work across multiple database servers to
work it requires a) the driver to handle two phase commits and b) the server
to implement the logic for the distributed transactions.

now, if I remember correctly, jboss doesn't seem to have support for
distributed transactions, but hey, I could be full of shit, so if I am
please correct me :)

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] JBoss user archive search doesn't work

2001-03-22 Thread Filip Hanik

are you running Win95 or Win98?
you have to set the environment space for your dos prompt /e:4096 or
something like that?

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Pifen
 Ellwood
 Sent: Thursday, March 22, 2001 8:37 AM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] JBoss user archive search doesn't work


 Hi,
 Can anyone provide a link to search the jboss-user archive? I got an error
 msg everytime I tried to search via
 http://www.geocrawler.com/lists/3/SourceForge

 I got Out of Environment Space error when I run Jboss. I know some one ask
 the same question before. However, I can't search the archive so I'm sorry
 to ask again here.

 Thanks
 Pifen Ellwood


 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 http://lists.sourceforge.net/lists/listinfo/jboss-user



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [JBoss-user] A little BMP philosophy/understanding

2001-03-22 Thread Filip Hanik

you should close the statements and connections.
the code for using a connection pool should be the same as if you were not
using a connection pool.
ie transparent.
when using a connection pool the con.close() call is an indicator for the
pool that you are done with the connection and it is now available to other
threads.

 If not, should I open a connection in ejbCreate/ejbPostCreate/ejbActivate
 and close it in ejbRemove/ejbPassivate? Will it speed up the things?

this way you are going to run out of connections really fast and your system
will not scale.
because eventually the pool will be empty.

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Alexander
 Kogan
 Sent: Thursday, March 22, 2001 1:23 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-user] A little BMP philosophy/understanding


 Hello,

 I've been trying to follow this interesting discussion, but
 now I'm lost. Let me explain my confusion:

 Usually in my BMP business methods I obtain a connection,
 create prepared statements and close statements and the connection
 at the very end of the method (assuming that jboss is caching
 the connection and statements).

 Is that the right pattern?



 Thanks in advance for any advice.

 Alex.




  Mike Jau wrote:
 
  So, the caching of the PreparedStatement is stored in the database
  connection context and is not shared between the database connection. I
  am thinking a work around way and it may solve the caching issue.  If
  we have the "named connection" from the pool with the lifecyclye
  control to release the PreparedStatement from the applicaiton which
  invoke the container specific API, it probably can solve the problem.
 
  - Mike Jau
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, March 22, 2001 1:25 PM
   To: [EMAIL PROTECTED]
   Subject: RE: [JBoss-user] A little BMP
   philosophy/understanding
 
   In the original JBoss 2.0 version the PreparedStatement cache
   was not discarded after the connection was returned to the
   pool because more than likely you might want to issue that
   one of these PreparedStatements again. To make matters worse
   there wasn't an upper limit on the number of
   PreparedStatement objects in the cache so things would
   continue to grow as you prepared new SQL statements. If you
   happened to prepare the same exact SQL statement then you
   received the previously cached PreparedStatement object but
   otherwise you got a new PreparedStatement that was also added
   to the cache. This would continue until either a) the
   database complained or b) you ran out of memory which ever
   came first. On Oracle, for example, each PreparedStatement
   takes memory on the database and once you hit 100 or so the
   database throws an exception when you try to get another one.
 
   I patched the code by releasing the PreparedStatement cache
   when the Connection was released and submitted that fix but
   I'm not sure it was accepted. What really needs to happen is
   that the PreparedStatement cache needs to be enhanced so that
   an upper bound can be established via a configuration
   variable so that after x PreparedStatements have been cached
   new PreparedStatements will push one of the old ones out of
   the cache.
 
   - Jon Harvie
 
Mike Jau [EMAIL PROTECTED]
Sent by:To:
[EMAIL PROTECTED]
 "'[EMAIL PROTECTED]'"
 
 [EMAIL PROTECTED]
03/22/2001 12:42 PM cc:
Please respond to jboss-userSubject:
   RE:
[JBoss-user] A little BMP
philosophy/understanding
 
   Could you give me some background information about the
   Preparedstaement
   caching on the EJB container side?
 
   Since the connection get from pool need to return to pool
   once the
   transaction done. I assumed that the resouce associate to
   this connection
   should be released and the released resoure include the
   preparedstatement.
   Later on, the create preparedstatement will be invoked again
   from different
   connection. How the preparedstatement cached is my question?
 
   - Mike
 
   -Original Message-
   From: Bill Burke [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, March 22, 2001 12:10 PM
   To: [EMAIL PROTECTED]
   Subject: Re: [JBoss-user] A little BMP
   philosophy/understanding
 
   Dan Christopherson wrote:
 
On Fri, 23 Mar 2001, Peter Routtier-Wone wrote:
   
Someone from this discu

RE: [JBoss-user] A little BMP philosophy/understanding

2001-03-22 Thread Filip Hanik

 Doesn't this defeat the purpose of caching and prepared statements? If you
 close the prepared statement then the db connection goes away
 right? So why
 used a prepared statmenet at all, beacuse it is never really prepared? It
 seems to me the cache would need to keep at least one of each prepared
 statement used to be of any value.

no, you should not cache statements. If you are using prepared statements,
it is on the level of the driver to make sure that they are cached.

a prepared statement should give you the same performance even if you close
them in your code, since it is handled by the driver, not by the programmer,
or by jboss.

caching statements goes back to 1997 when the drivers did not do this for
you. now a days, almost all of them do.

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Hansen,
 Richard
 Sent: Thursday, March 22, 2001 1:53 PM
 To: '[EMAIL PROTECTED]'
 Subject: RE: [JBoss-user] A little BMP philosophy/understanding




 Rick Hansen

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 22, 2001 1:25 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [JBoss-user] A little BMP philosophy/understanding



 In the original JBoss 2.0 version the PreparedStatement cache was not
 discarded after the connection was returned to the pool because more than
 likely you might want to issue that one of these PreparedStatements again.
 To make matters worse there wasn't an upper limit on the number of
 PreparedStatement objects in the cache so things would continue to grow as
 you prepared new SQL statements. If you happened to prepare the same exact
 SQL statement then you received the previously cached PreparedStatement
 object but otherwise you got a new PreparedStatement that was
 also added to
 the cache. This would continue until either a) the database
 complained or b)
 you ran out of memory which ever came first. On Oracle, for example, each
 PreparedStatement takes memory on the database and once you hit 100 or so
 the database throws an exception when you try to get another one.

 I patched the code by releasing the PreparedStatement cache when the
 Connection was released and submitted that fix but I'm not sure it was
 accepted. What really needs to happen is that the PreparedStatement cache
 needs to be enhanced so that an upper bound can be established via a
 configuration variable so that after x PreparedStatements have been cached
 new PreparedStatements will push one of the old ones out of the cache.

 - Jon Harvie



 Mike Jau [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 03/22/2001 12:42 PM
 Please respond to jboss-user

 To:"'[EMAIL PROTECTED]'"
 [EMAIL PROTECTED]
 cc:
 Subject:RE: [JBoss-user] A little BMP
 philosophy/understanding



 Could you give me some background information about the Preparedstaement
 caching on the EJB container side?

 Since the connection get from pool need to return to pool once the
 transaction done. I assumed that the resouce associate to this connection
 should be released and the released resoure include the preparedstatement.
 Later on, the create preparedstatement will be invoked again from
 different
 connection. How the preparedstatement cached is my question?


 - Mike

 -Original Message-
 From: Bill Burke [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 22, 2001 12:10 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-user] A little BMP philosophy/understanding




 Dan Christopherson wrote:

  On Fri, 23 Mar 2001, Peter Routtier-Wone wrote:
 
  Someone from this discussion group indicate that container might cache
 the
  PreparedStatement.
 
  I can't speak with authority on this, but that rings true. I'm guessing
 that
  interception doesn't happen for the setEntityContext() method and
 therefore
  you actually create a PreparedStatement rather than receiving one from
 the
  pool.
 
  Just for kicks, I gave it a try but transactions weren't completed and
  they'd just hang out there forever, blocking every other
 persistence and
  finder method until they timed out.
 
  That would bollox lifecycle management, and the described behaviour
 wouldn't
  be at all surprising.
 
  This is also a common bean bug: 'close()' should be called on every
  resultset, statement, and connection in a finally clause so
 that you know
  it happens every time.
 
  On the other hand, I'd have thought that PreparedStatements
 would be far
  less costly to manufacture than Connections, and therefore not
 worth the
  overhead of managing a pool. I think I'll poke my nose into the source
 and
  see what's there.
 
  There's often communication with the database to create the
  PreparedStatement. That way it can pre-compile a query plan. There is a
  prepared statement cache in JBoss: in JBoss 2.0, it cause

RE: [JBoss-dev] Re: [JBoss-user] A little BMP philosophy/understanding

2001-03-22 Thread Filip Hanik

oops, we are cross posting, no good, sorry about that.

 I'm re-writing the PreparedStatement cache
 -  so that it is configurable from jboss.jcml.  I can no way right now
 other than changing the source directly of configuring the PS cache size.
 - so that connections watch all open cursors that are created(Statements
 and PreparedStatements).  Basically if you have 50 PreparedStatements
 cached, your max open cursors  is 50, and you want to createStatement,
 I'm making the connection release one of the cached PreparedStatement so
 that the new createStatement won't fail.

remember that during a transaction, the connection (JDBC 1) used gets
associated with the transaction context.
hence, other transactions/threads will not be accessing the connection
during that time since they are not involved in this DB transaction.

why would you want to keep the cursors open. once you retrieved your
resultset, your are done with the cursor and should close it. the prepared
statement is nothing but precompiled (during runtime) SQL, and if the
connection should keep this precompiled statement alive on the database, not
through the PreparedStatement reference that the programmer holds in his
code.

can somebody please tell *ME* to shut up, if I am completely off balance
here :)

Filip

~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Bill
 Burke
 Sent: Thursday, March 22, 2001 2:57 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: [JBoss-dev] Re: [JBoss-user] A little BMP
 philosophy/understanding


 In JBoss 2.1 (minerva beta3?) the PreparedStatement cache does have a
 limit. Also, when the cache reaches it's limit, it removes the least
 recently used PS and closes it.


 - Is it useful to block if the max open cursors have been reached when
 creating a new Statement or PreparedStatement?  This would only be
 useful if more the one thread had access to the connection, but does
 that ever happen, and is it allowed to happen?

 Bill

 Mike Jau wrote:

  So, the caching of the PreparedStatement is stored in the database
  connection context and is not shared between the database connection.
  I am thinking a work around way and it may solve the caching
  issue.  If we have the "named connection" from the pool with the
  lifecyclye control to release the PreparedStatement from the
  applicaiton which invoke the container specific API, it probably can
  solve the problem.
 
 
 
  - Mike Jau
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, March 22, 2001 1:25 PM
  To: [EMAIL PROTECTED]
  Subject: RE: [JBoss-user] A little BMP philosophy/understanding
 
 
  In the original JBoss 2.0 version the PreparedStatement cache was
  not discarded after the connection was returned to the pool
  because more than likely you might want to issue that one of these
  PreparedStatements again. To make matters worse there wasn't an
  upper limit on the number of PreparedStatement objects in the
  cache so things would continue to grow as you prepared new SQL
  statements. If you happened to prepare the same exact SQL
  statement then you received the previously cached
  PreparedStatement object but otherwise you got a new
  PreparedStatement that was also added to the cache. This would
  continue until either a) the database complained or b) you ran out
  of memory which ever came first. On Oracle, for example, each
  PreparedStatement takes memory on the database and once you hit
  100 or so the database throws an exception when you try to get
  another one.
 
  I patched the code by releasing the PreparedStatement cache when
  the Connection was released and submitted that fix but I'm not
  sure it was accepted. What really needs to happen is that the
  PreparedStatement cache needs to be enhanced so that an upper
  bound can be established via a configuration variable so that
  after x PreparedStatements have been cached new PreparedStatements
  will push one of the old ones out of the cache.
 
  - Jon Harvie
 
 
 
 
  Mike Jau [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
 
  03/22/2001 12:42 PM
  Please respond to jboss-user
 
 
  To:"'[EMAIL PROTECTED]'"
  [EMAIL PROTECTED]
  cc:
  Subject:RE: [JBoss-user] A little BMP
  philosophy/understanding
 
 
 
 
  Could you give me some background information about the
  Preparedstaement
  caching on the EJB container side?
 
  Since the connection get from pool need to return to pool once the
  transaction done. I assumed that the resouce associate to this
  connection
  should be released and the released resoure include the
  preparedst