Help: Out of Memory Error...

2001-11-28 Thread Arjen Schoneveld

Hi All,
 
We are about to deploy a new application for our client that is built on
Orion. The application consists of some Servlets, statefull and
stateless
session beans and CM entity beans.
We have been testing the application for a month now and did not
experience
any problems.
However today we set up a client application that sequentially submits
XML
documents to the Servlet which controls a Statefull Session bean.
(This is also
how our web-application (and that of others) talk to this servlet (via
XML).
Normally a human is entering data in a web application and the data is
marshalled
in an XML document and send to the Servlet).
The client-application is supposed to submit 2 XML documents
sequentially
to the servlet, which parses it, calls some methods of a statefull
session bean 
(which controls other stateless session beans and entity beans) and
sends an XML
reply back. Every XML request takes about 1.5s to process. So far so
good. However after an hour (or so) of running, Orion gets an
java.lang.OutOfMemory Exception (see below).
Does anybody known a solution. It is very important because we are about
to deploy our application in production environment.
 
Maybe we should delimit the number of (entity) bean instances? For every
XML
request about 20 records (hence entity beans) are created.
 
BTW We are using SQL-server as a database.
 
Thanks very much in advance,
Arjen Schoneveld
 
11/28/01 6:28 PM nbwo: Servlet error
java.lang.OutOfMemoryError
 no stack trace available
11/28/01 6:28 PM Error in bean NBWOSession
java.lang.OutOfMemoryError
 no stack trace available
11/28/01 6:28 PM Error in bean Requests: Error loading state
java.rmi.RemoteException: java.lang.IllegalStateException: Transaction
expired: java.lang.OutOfMemoryError
 at
com.dvs.nbwo.toolbox.ejb.entity.RequestsBean.ejbLoad(RequestsBean.java:8
6)
 at
Requests_EntityBeanWrapper3.loadState(Requests_EntityBeanWrapper3.java:7
17)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ejb.EntityEJBObject.endTransaction(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransactionSynchronization._vib(Unknown
Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransaction._vib(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransactionSynchronization.afterCompleti
on(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransaction._end(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransaction.end(Unknown Source)
 at
NBWOSession_StatefulSessionBeanWrapper27.storeData(NBWOSession_StatefulS
essionBeanWrapper27.java:3919)
 at
com.dvs.nbwo.toolbox.servlets.NBWOServlet.maakResultaatWaardebepalingsBe
richt(NBWOServlet.java:1375)
 at
com.dvs.nbwo.toolbox.servlets.NBWOServlet.doNbwoToetsing(NBWOServlet.jav
a:977)
 at
com.dvs.nbwo.toolbox.servlets.NBWOServlet.doAction(NBWOServlet.java:168)
 at
org.dexels.toolbox.server.ToolboxServerServlet.doPost(ToolboxServerServl
et.java:395)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:211)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
 at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown Source)
 at com.evermind[Orion/1.5.2 (build 10460)]._cxb.include(Unknown Source)
 at org.dexels.toolbox.server.Postman.dispatch(Postman.java:197)
 at org.dexels.toolbox.server.Postman.doPost(Postman.java:513)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:211)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
 at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown Source)
 at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown Source)
 at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown Source)
 at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown Source)
 at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown Source)
11/28/01 6:28 PM Error in bean Requests: Error while delisting bean from
TX
com.evermind[Orion/1.5.2 (build
10460)].transaction.MarshallingXAException
 at com.evermind[Orion/1.5.2 (build
10460)].server.ejb.EntityEJBObject.endTransaction(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransactionSynchronization._vib(Unknown
Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransaction._vib(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransactionSynchronization.afterCompleti
on(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransaction._end(Unknown Source)
 at com.evermind[Orion/1.5.2 (build
10460)].server.ApplicationServerTransaction.end(Unknown Source)
 at
NBWOSession_StatefulSessionBeanWrapper27.storeData(NBWOSession_StatefulS
essionBeanWrapper27.java:3919

RE: Microsoft JDBC Driver - Issues w/ Data Source

2001-11-17 Thread Arjen Schoneveld

All,
 
We have been using Orion  MS-SQL server successfully in a project.
The JDBC driver we are using is called Opta2000 (see
http://www.inetsoftware.de).
Here's an excerpt from our data-sources.xml:
 
 data-source
  class=com.evermind.sql.DriverManagerDataSource
  name=NBWO_BACKEND
  location=core/NBWO_BACKEND
  xa-location=xa/NBWO_BACKEND
  ejb-location=NBWO_BACKEND
  connection-driver=com.inet.tds.TdsDriver
  username=sa
  password=sa
  url=jdbc:inetdae7:nbtodev:1433?database=nbwo_backend
  inactivity-timeout=120
 /

We've had no troubles so far.
 
Regards,
Arjen Schoneveld
--
Dexels BV
The Netherlands
 

-Oorspronkelijk bericht- Van: Mitesh Pancholy 
Verzonden: za 17-11-2001 0:29 
Aan: Orion-Interest 
CC: 
Onderwerp: Re: Microsoft JDBC Driver - Issues w/ Data Source



Geoff,

Orion  SQLServer = = bad combo, you will learn through
suffering as we have
:) What you need to do is to unzip the contents of the jar file
under the
lib folder, and you did reference all 3 files in the class path
right. Also
use the orion data source, don't use the msft source.
So your data-source.xml should look like this.
 data-source
  class=com.evermind.sql.DriverManagerDataSource
  schema=database-schemas/ms-sql.xml
  xa-location=XADS
  location=DS
  ejb-location=poolname
  name=poolname

connection-driver=com.microsoft.jdbc.sqlserver.SQLServerDriver

url=jdbc:microsoft:sqlserver://servername:1433;DatabaseName=dbname
  username=username
  password=password
 /

RANT: The people who are using Orion  Ms SQL Server need to
start putting
more knowledge on the list. I'll take the lead with some stuff,
but people
also need to contribute :)

- Original Message -
From: [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Sent: Friday, November 16, 2001 8:25 AM
Subject: Microsoft JDBC Driver - Issues w/ Data Source


 I'm having some issues with using the Microsoft SQL Server
JDBC Driver
with
 Orion.

 Let me give you some context:

 Although I have some past experience with Orion (servlets,
beans, jsp),
I've
 never used its Data Sources, so I know next to nothing about
them.  And,
 although the community and documentation have improved of
late, Orion's
 documentation is still pretty sparse.  When it came time to
spend some
time
 with EJB, I moved over to JBoss, which has stronger
documentation, for a
 while, and while on JBoss, I started making use of the
Microsoft SQL
Server
 driver beta, which has proved to be quite reasonable (which is
not too
 surprising, since it's the Merant driver).

 Due to some performance issues, I wanted to see how the
application we're
 working on would run under Orion, so I downloaded the latest,
and started
to
 try and configure it.  The basic steps were still pretty easy,
but now I'm
 stuck on the data source - no matter what I do, I can't seem
to get Orion
to
 recognize the SQL Server driver.

 Has anyone tried it yet?  Am I missing something obvious?

 I put the driver JARs (three of them: msbase, msutil,
mssqlserver) in
 orion/lib.  I modified the data-sources.xml to use the driver,
as follows:
 data-source

 name=MicrosoftSqlServer

 location=jdbc/SqlServerDS



connection-driver=com.microsoft.jdbc.sqlserver.SQLServerDriver



url=jdbc:microsoft:sqlserver://panthro:1433;DatabaseName=dbVoicenetDevG
eoff
 ;SelectMethod=cursor
 username=user
 password=password

 inactivity-timeout=30
 class=com.evermind.sql.DriverManagerDataSource

 /

 When orion starts, it says the following:
 Error initializing data-source 'jdbc/SqlServerDS':
DriverManagerDataSource
 driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not
found

 What does this mean?  It can't find the driver?  The JARs are
in orion
lib,
 I've checked that several times, including that the driver
name is right,
 and the class is in the JAR.  I can't swear that Orion is
loading the
JARs,
 because it doesn't put that out to the console or log files,
so I don't
 really know that it's doing that, but I'm assuming it is.

 It does say 'DriverManagerdataSource driver', so perhaps