RE: [JBoss-user] Where to keep the uploaded picture files.

2001-04-17 Thread Shahar Solomianik 

Hi.
The best is to keep it in a BLOB column in the db.
then the src="" of the image html elemt would be a servlet which its
reponse's content type is "image/gif"
and all it does is retreiving the byte[] of the image and writing it to the
response output stream.
Shahar.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Penn
Sent: Tuesday, April 17, 2001 3:31 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Where to keep the uploaded picture files.


Hi all,

May i know where to keep the uploaded picture files..
The uploaded file must be able to view/load by the browser via the
hyperlink.

problem

To provide the hyperlink the file must be sit inside the web context
directory  jBoss/tmp/deploy/Default/MyWar/

this directory will be deleted and recreate when the jBoss restart..

if i put the files outside the web context dir, i  can't havre the
hyperlink.


any suggestion.


tia

Penn


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

[JBoss-user] jboss2.1+tomcat periodically stuck

2001-04-16 Thread Shahar Solomianik 

Hi all.
My app is almost ready !!! the only major remaining problem ... (which I
MUST solve till the 22nd - then I'm off to a MAJOR client to install it as a
pilot)
JBoss just stuck (sometimes after some hours, sometimes after 1-2 days, the
volume of work, including heavy-load tests, is pretty much the same every
day) and I cant figure out the reason.
First , some system info :

jboss2.1+tomcat
Oracle8.1.7 oci driver + minerva
solaris 2.6
jdk1.3 hotspot

architecture:
* the servlets invoke methods on stateless session beans which in turn
invoke methods on cmp/bmp entities
* 2 mdb's
* jms also in use as a chat server (the public/subscribe topic mechanism
fits perfectly)

elimination:
it is not tomcat's fault. tomcat is still functioning when jboss stucks.
I wrote a little java program that tries to invoke a method on one of the
stateless session beans. I get the home interface, but it stucks when I
invoke "create()" method on the home interface.
I thought maybe I get to the limit of active session beans cause I forget to
remove(), but I count the create() and remove() invokation in the server.log
after it stucks and they are equal.
I check the db active connections amount and it is steady (doesnt get to db
limit , not even close).
even file descriptors parameter of the machine is high (2000 +)

any suggestions ?
what else can I check ?

Shahar.



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

RE: [JBoss-user] where is Minerva?

2001-04-13 Thread Shahar Solomianik 

search the mailing list archive and you will find the link
(i would send it to you , but i dont remeber it, and dont have it anywhere)

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]]On Behalf Of 
 Christian Sell
 Sent: Friday, April 13, 2001 4:32 PM
 To: jboss-user
 Subject: [JBoss-user] where is Minerva?
 
 
 Hello,
 
 I am using the minerva connection pool from the Jboss 
 distribution in an
 otherwise Tomcat-based webapp. I would like to cast an eye on 
 the source
 code, but cannot find it. It seems to have moved out of the 
 Jboss project-
 does anyone know its current whereabouts?
 
 thanks,
 Christian Sell
 
 
 ___
 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] Usign ejb from MBean

2001-04-12 Thread Shahar Solomianik 

I want to have a MBean invoking methods on an stateless ejb.
The problem is that when I put the home and remote interfaces of the bean
(let's call it bean A) in the Mbean jar which I put in lib/ext (so it can
find those classes on runtime), the deployment of the beans themselves
fails, on ClassNotFoundException. It tries to find Classes of other beans
which it (bean A) uses and cant find them in the classpath. for some reason
it doesnt look for them in the ejb.jar .

Shahar.


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

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-11 Thread Shahar Solomianik 

Keep in mind you can use Oracle Connection Manager tool which "pools"
connection in the dbms, outside the app server.
It keeps allocated resources for closed connection to bind it to new ones,
thus making the connection physical creation much faster.
Shahar

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor
Sent: Wednesday, April 11, 2001 2:21 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


Oracle's DataSources don't do pooling in the sense of maintaining pools
of physical connections (nneded for speed).  Oracle calls minerva's type
of pooling "connection caching" in their documentation for their JDBC
2.0 drivers.

Oracle provides an "example" implementation of a cache called
OracleConnectionCacheImpl (implements DataSource).  You instantiate the
cache with one of the pooling data sources (OracleXADataSource or
OracleConnectionPoolDataSource).  The cache then does what minerva does
in terms of pooling -- but not as conveniently or portably.

I also found what appears to be a limitation in the
OracleConnectionCacheImpl.  It did not appear to work correctly with
OracleXADataSources.  The cache allocates from the XA data source you
give it by calling getPooledConnection() -- not getXAConnection().  I
was able to call commit() on one of the connections from the supposedly
XAConnection cache, and that's not good.  There was no source code
nearby, so I gave up and just went with minerva.

Now if I could just get an example minerva's JDBCDataSourceLoader
working.   The trouble is that there are places that are outside the
container where you need data sources.  One example is, I think, in
using the database for authentication.  You need access to a connection,
but you are outside a container (in the SecurityInterceptor?).  Another
example is in custom MBean services where you might want to use the
database to store configuration information.

You can use physical connections from the minerva XA pool outside the
container and manually commit them if you want, but it seems wrong to do
that.

Tim



Toby Allsopp wrote:

 On Tue, Apr 10, 2001 at 05:55:27PM +0200, Shahar Solomianik wrote:

 Toby, I think you are right.
 I replaced the mbean configuration to use XADataSourceLoader and minerva
(I
 had to patch minerva to support scrollable result sets...), tested the
 server under load and it was MUCH faster.
 I didnt get into details and log/trace files, but the differences in
speed
 were visible to the human eye 


 I'd be very interested to hear of any deeper investigation of this. It
 might be as simple as the Oracle DataSource implementation not doing
 pooling.

 Toby.

 ___
 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] Gathering information on migrating from 2.0 to 2.2

2001-04-10 Thread Shahar Solomianik 

* point out that JDom users of 2.0 should remove the explicit xerces.jar
they have added to classpath in run.sh.
* 2.0 minerva users that use scrollable result sets cant upgrade to 2.2 ...
(or upgrade but use different config, without minerva)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tobias Frech
Sent: Tuesday, April 10, 2001 11:29 AM
To: JBoss Users
Cc: JBoss Documentation
Subject: [JBoss-user] Gathering information on migrating from 2.0 to 2.2


Hi everybody!
Most of you probably already noticed that there is a 2.2 release of
JBoss available at the website. I now would like to gather information
about what steps you needed to take to migrate from 2.0 to 2.2.
As a starting point there is already a section in the manual (actually
titled "Upgrading from JBoss 2.0 FINAL") that describes how the
configuration for JDBC datasources needs to be modified to work under
2.1/2.2.

My questions are:

a) Did the information contained in the above mentioned section help to
migrate to 2.2, is it correct ?

b) What would be the strategy you recommend for migration ? Either using
your old config files and patching them to contain the needed new values
OR using the new config files (coming with the distro) and patching them
with your modifications ?

c) What other steps did you need to take to successfully migrate to 2.2
?


You can reply to the discussion list or private to me. Either-way I will
collect the information and update a HTML page in the documentation
section with the new information every day.

Thanks, Tobias

___
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] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik 

Use RawXADataSource and it works (at least for me)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor
Sent: Saturday, April 07, 2001 11:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


I tend to agree that the JBoss-blocking behavior of incorrectly set up
XADataSources is a bug.  I ran into this too, and judging from the
number of "Oracle pool hanging" messages on this list, a lot of people
are running into it.

I think it happens at the end of the pool creation when
XADataSourceLoader of JBoss does a quick call to check the health of the
Minerva XADataSource.  The health check hangs waiting for a connection
from the source.  If the data source is set up incorrectly in any way,
the pool will never contain a connection to allocate, and the call hangs.

I think a call to an XADataSource.getConnection() should get an
SQLException when the underlying connection factory (in this case, in
the excellent Minerva) gets an SQLException.  My $0.02.

Tim Taylor

Tim Kemp wrote:

 I too have suffered from the Oracle Connection Pool hanging JBoss 2.1 on
 startup.

 By adding the following line to the Datasource mbean (in jboss.jcml), the
 exact error is displayed in the JBoss output.

 attribute name="LoggingEnabled"true/attribute

 In my case it was an incorrect database instance that caused the
connection
 pool to hand

 [OraclePool] Starting
 [OraclePool] XA Connection pool OraclePool bound to java:/OraclePool
 [OraclePool] java.sql.SQLException: Io exception: Connection
 refused(DESCRIPTION

=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)
 )))
 [OraclePool] Pool OraclePool factory
 org.opentools.minerva.jdbc.xa.XAConnectionF
 actory@6ac461 unable to create new object!
 [OraclePool] Pool OraclePool [0/0/10] waiting for a free object  
 Surely this is a problem in JBoss! 

 So the connection pool couldn't connect to Oracle - causing JBoss to hang
 while it was waiting for a free connection, which could never be returned
 cos the connection failed!

 Tim

 ___
 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] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik 

yes.
and use properties attribute instead the standard params, and Oracle XA
instead of minerva...
this is from my jboss.jcml :
  mbean code="org.jboss.jdbc.RawXADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OraclePool"
attribute name="PoolName"OraclePool/attribute
attribute
name="DataSourceClass"oracle.jdbc.xa.client.OracleXADataSource/attribute
attribute
name="Properties"URL=jdbc:oracle:oci8:scott/tiger@orcl/attribute
  /mbean

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Simphoukham,
Southin
Sent: Monday, April 09, 2001 2:15 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] Solving Oracle Connection Pool Hanging



Shahar,

How do you do that?

Do you replace org.jboss.jdbc.XADataSourceLoader?

 mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OracleDB"
attribute name="PoolName"OracleDB/attribute
attribute
name="DataSourceClass"org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l/attribute
    attribute name="Properties"/attribute

Southin

-Original Message-
From: Shahar Solomianik [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Solving Oracle Connection Pool Hanging


Use RawXADataSource and it works (at least for me)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor
Sent: Saturday, April 07, 2001 11:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


I tend to agree that the JBoss-blocking behavior of incorrectly set up
XADataSources is a bug.  I ran into this too, and judging from the
number of "Oracle pool hanging" messages on this list, a lot of people
are running into it.

I think it happens at the end of the pool creation when
XADataSourceLoader of JBoss does a quick call to check the health of the
Minerva XADataSource.  The health check hangs waiting for a connection
from the source.  If the data source is set up incorrectly in any way,
the pool will never contain a connection to allocate, and the call hangs.

I think a call to an XADataSource.getConnection() should get an
SQLException when the underlying connection factory (in this case, in
the excellent Minerva) gets an SQLException.  My $0.02.

Tim Taylor

Tim Kemp wrote:

 I too have suffered from the Oracle Connection Pool hanging JBoss 2.1 on
 startup.

 By adding the following line to the Datasource mbean (in jboss.jcml), the
 exact error is displayed in the JBoss output.

 attribute name="LoggingEnabled"true/attribute

 In my case it was an incorrect database instance that caused the
connection
 pool to hand

 [OraclePool] Starting
 [OraclePool] XA Connection pool OraclePool bound to java:/OraclePool
 [OraclePool] java.sql.SQLException: Io exception: Connection
 refused(DESCRIPTION

=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)
 )))
 [OraclePool] Pool OraclePool factory
 org.opentools.minerva.jdbc.xa.XAConnectionF
 actory@6ac461 unable to create new object!
 [OraclePool] Pool OraclePool [0/0/10] waiting for a free object  
 Surely this is a problem in JBoss! 

 So the connection pool couldn't connect to Oracle - causing JBoss to hang
 while it was waiting for a free connection, which could never be returned
 cos the connection failed!

 Tim

 ___
 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


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

[JBoss-user] Transaction propagation through super.ejbCreate()

2001-04-09 Thread Shahar Solomianik 

I know that in order to propogate transaction correctly when a bean invokes
its own methods, I use getEJBObject() so I can invoke the method on the
remote interface.
how about calling super.ejbCreate ???


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

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik 

Well, RawXADataSourceLoader works and XADataSourceLoader doesnt...
doesnt RawXADataSourceLoader pool connections ??? it should be implemented
in the driver.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
Sent: Monday, April 09, 2001 8:47 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


RawXADataSourceLoader is not a replacement for XADataSourceLoader.

The latter binds a DataSource implementation into JNDI which provides
connection pooling. The latter binds an XADataSource in JNDI, which provides
pretty much nothing that application components should be messing with.

How are you using the XADataSource in your code?

Toby.

On Mon, Apr 09, 2001 at 04:48:00PM +0200, Shahar Solomianik wrote:
 yes.
 and use properties attribute instead the standard params, and Oracle XA
 instead of minerva...
 this is from my jboss.jcml :
   mbean code="org.jboss.jdbc.RawXADataSourceLoader"
 name="DefaultDomain:service=XADataSource,name=OraclePool"
 attribute name="PoolName"OraclePool/attribute
 attribute

name="DataSourceClass"oracle.jdbc.xa.client.OracleXADataSource/attribute
 attribute
 name="Properties"URL=jdbc:oracle:oci8:scott/tiger@orcl/attribute
   /mbean

___
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] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik 

Im pretty sure I do get my transactions managed by jboss. are you 100% sure
about that ?

Shahar.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
Sent: Monday, April 09, 2001 9:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


On Mon, Apr 09, 2001 at 09:08:31PM +0200, Shahar Solomianik wrote:
 Well, RawXADataSourceLoader works and XADataSourceLoader doesnt...

I think you'll find that "works" is very limited in this case. You won't
get your transactions managed by the container for one thing.

 doesnt RawXADataSourceLoader pool connections ??? it should be implemented
 in the driver.

Why should it be? Connection pooling is a service provided by the app
server,
not the JDBC driver. It may well be the case that Oracle's XADataSource
implementation does do pooling, but this doesn't change the fact that your
application component code shouldn't be dealing directly with XADataSource
and XAConnection.

Toby.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
 Sent: Monday, April 09, 2001 8:47 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


 RawXADataSourceLoader is not a replacement for XADataSourceLoader.

 The latter binds a DataSource implementation into JNDI which provides
 connection pooling. The latter binds an XADataSource in JNDI, which
provides
 pretty much nothing that application components should be messing with.

 How are you using the XADataSource in your code?

 Toby.

 On Mon, Apr 09, 2001 at 04:48:00PM +0200, Shahar Solomianik wrote:
  yes.
  and use properties attribute instead the standard params, and Oracle XA
  instead of minerva...
  this is from my jboss.jcml :
mbean code="org.jboss.jdbc.RawXADataSourceLoader"
  name="DefaultDomain:service=XADataSource,name=OraclePool"
  attribute name="PoolName"OraclePool/attribute
  attribute
 

name="DataSourceClass"oracle.jdbc.xa.client.OracleXADataSource/attribute
  attribute
  name="Properties"URL=jdbc:oracle:oci8:scott/tiger@orcl/attribute
/mbean

___
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] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik 

Apart from things like that in my code (bmp entities and stateless sessions)
:

  Context ctx = new InitialContext();
  DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
  conn = ds.getConnection();

  ...
  jdbc bla bla bla
  ...
  conn.close();

I have all my cmp beans using (jboss.xml) :

  resource-ref
res-ref-namejdbc/OracleDB/res-ref-name
resource-nameOralceDB/resource-name
  /resource-ref

resource-manager
  res-nameOracleDB/res-name
  res-jndi-namejava:/OraclePool/res-jndi-name
/resource-manager

while (jboss.jcml):

  mbean code="org.jboss.jdbc.RawXADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OraclePool"
attribute name="PoolName"OraclePool/attribute
attribute
name="DataSourceClass"oracle.jdbc.xa.client.OracleXADataSource/attribute
attribute
name="Properties"URL=jdbc:oracle:oci8:scott/tiger@orcl/attribute
  /mbean

Shahar.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
Sent: Monday, April 09, 2001 10:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging


On Mon, Apr 09, 2001 at 10:05:43PM +0200, Shahar Solomianik wrote:
 Im pretty sure I do get my transactions managed by jboss. are you 100%
sure
 about that ?

I think we should make sure that we're talking about the same thing. Can
you post the code that uses the XADataSource, please?

Toby.

 Shahar.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp

 On Mon, Apr 09, 2001 at 09:08:31PM +0200, Shahar Solomianik wrote:
  Well, RawXADataSourceLoader works and XADataSourceLoader doesnt...

 I think you'll find that "works" is very limited in this case. You won't
 get your transactions managed by the container for one thing.

  doesnt RawXADataSourceLoader pool connections ??? it should be
implemented
  in the driver.

 Why should it be? Connection pooling is a service provided by the app
 server,
 not the JDBC driver. It may well be the case that Oracle's XADataSource
 implementation does do pooling, but this doesn't change the fact that your
 application component code shouldn't be dealing directly with XADataSource
 and XAConnection.

 Toby.

  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
 
  RawXADataSourceLoader is not a replacement for XADataSourceLoader.
 
  The latter binds a DataSource implementation into JNDI which provides
  connection pooling. The latter binds an XADataSource in JNDI, which
 provides
  pretty much nothing that application components should be messing with.
 
  How are you using the XADataSource in your code?
 
  Toby.
 
  On Mon, Apr 09, 2001 at 04:48:00PM +0200, Shahar Solomianik wrote:
   yes.
   and use properties attribute instead the standard params, and Oracle
XA
   instead of minerva...
   this is from my jboss.jcml :
 mbean code="org.jboss.jdbc.RawXADataSourceLoader"
   name="DefaultDomain:service=XADataSource,name=OraclePool"
   attribute name="PoolName"OraclePool/attribute
   attribute

name="DataSourceClass"oracle.jdbc.xa.client.OracleXADataSource/attribute
   attribute
   name="Properties"URL=jdbc:oracle:oci8:scott/tiger@orcl/attribute
 /mbean

___
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 to prevent jBoss overwrite update done directly to database

2001-04-05 Thread Shahar Solomianik 

You should use "commit option B" or "commit option C" insted of A which is
jboss default.
look in standardjboss.xml as for where you can change it
and look in ejb_spec-1.1 for details on what commit option is.

Shahar.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kar YEOW
Sent: Thursday, April 05, 2001 11:57 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] How to prevent jBoss overwrite update done directly to
database


I am having to do a lot of update to database, such as changes to price on
products.  When jBoss is running the cache object will overwrite all the
changes I may, hence I could not make the changes I want 'live' without
restarting jBoss.  Does anyone have the same problems, if so how can you
prevent it?  Any help is appreciated.

Kar YEOW


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

RE: [JBoss-user] load-on-startup Servlet can't find EJB

2001-04-04 Thread Shahar Solomianik 

do you create InitialContext in the servlet init method ?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Alexander
Jerusalem
Sent: Wednesday, April 04, 2001 4:11 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] load-on-startup Servlet can't find EJB


Hi,

Has anyone heard of problems with Servlets tagged as load-on-startup not
being able to lookup EJBs in their init method? Is it possible that EJBs
are bound to the JNDI context only after such Servlets are already loaded?
If this is the case what else can I do to initialize application state
before any client can call my EJBs?

(I'm using embedded tomcat with JBoss 2.1 on RedHat 7)

thanks,
Alexander Jerusalem


___
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] JDBC for JDK1.3 for Oracle 8i 8.1.7

2001-04-04 Thread Shahar Solomianik 

I compile 8.1.7 with jdk1.3 successfuly.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chong Joon lee
Sent: Wednesday, April 04, 2001 5:25 PM
To: [EMAIL PROTECTED]
Cc: Robert Butcher
Subject: [JBoss-user] JDBC for JDK1.3 for Oracle 8i 8.1.7


Hi,

I have recently got involved using the J2EE for constructing a suitable
back-end. I am using an Oracle 8i (8.1.7) and a JDK1.3 and I cannot seem to
find a suitable JDBC driver that complies with these specifications. Do you
know where I could possibly get hold of such a drive?
On your documentation of setting up the connection between the middle-tier
and a database, you request such a drive.

Currently, on the Oracle site, there is only the JDBC driver for
Oracle 8i 8.1.7 JDBC Drivers for use with JDK 1.2.x for NT

However, this does not compile with the JDK1.3 that is requested by JBoss.

Do you have any suggestions?
Any links?

CJ


___
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] JBossMQ connection pooling

2001-04-04 Thread Shahar Solomianik 

Hi.
I need to publish topic messages in some cases in my stateless sessions
methods.
As for now, I createTopicConnection each time I need to do so, create
session , publisher , and publish the message. then I close the connection.
I guess there's a more efficient way to do it.
Can anyone suggest  ?

Thanks,
Shahar.


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

RE: [JBoss-user] load-on-startup Servlet can't find EJB

2001-04-04 Thread Shahar Solomianik 

If you cant find the standard way for startup actions, and you still want to
use load-on-startup servlet, maybe try to forward the EmbeddedTomcat entry
in jboss.jcml , since :
!-- This is where you can add and configure your MBeans
  ATTENTION: The order of the listing here is the same order as
the MBeans are loaded. Therefore if a MBean depends on another
MBean to be loaded and started it has to be listed after all
the MBeans it depends on.
--


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

RE: [JBoss-user] Scrollable Result Sets

2001-04-04 Thread Shahar Solomianik 

If you use newest version of minerva - this is your problem.
minerva igonres 2nd and 3rd params of Connection.prepareStatement.
your options :
1. use a real XA driver
2. wait till Aaron fixes it
3. modify minerva code to your needs

Shahar.

btw, it doesnt ignore these parameters for prepareCall so you might want to
workaround by inoking a stored procedure/function instead plain jdbc

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Doug Ferguson
Sent: Wednesday, April 04, 2001 9:57 PM
To: jBoss Users
Subject: [JBoss-user] Scrollable Result Sets


Hi,

I am having trouble using scrollable resultSets when I obtain a
DataSource from jBoss via JNDI.
Whenever I use createStatment/prepareStatment it always returns a
ResultSet that is Type_Scroll_Forward_Only.

Can anybody tell me how I will obtain a ResultSet that is scrollable?

d.


___
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] Scrollable Result Sets

2001-04-04 Thread Shahar Solomianik 

org.opentools.minerva.jdbc.xa.wrapper.XAClientConnection
...

public PreparedStatement prepareStatement(String sql, int resultSetType,
int resultSetConcurrency) throws SQLException {
return prepareStatement(sql);
}

...

this is the offensive method. you can start investigate there ...


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Doug Ferguson
Sent: Thursday, April 05, 2001 12:00 AM
To: [EMAIL PROTECTED]; Shahar Solomianik
Subject: Re: [JBoss-user] Scrollable Result Sets


Do you know how to register Oracle XA driver?

d.

Shahar Solomianik wrote:

 If you use newest version of minerva - this is your problem.
 minerva igonres 2nd and 3rd params of Connection.prepareStatement.
 your options :
 1. use a real XA driver
 2. wait till Aaron fixes it
 3. modify minerva code to your needs

 Shahar.

 btw, it doesnt ignore these parameters for prepareCall so you might want
to
 workaround by inoking a stored procedure/function instead plain jdbc

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Doug Ferguson
 Sent: Wednesday, April 04, 2001 9:57 PM
 To: jBoss Users
 Subject: [JBoss-user] Scrollable Result Sets

 Hi,

 I am having trouble using scrollable resultSets when I obtain a
 DataSource from jBoss via JNDI.
 Whenever I use createStatment/prepareStatment it always returns a
 ResultSet that is Type_Scroll_Forward_Only.

 Can anybody tell me how I will obtain a ResultSet that is scrollable?

 d.

 ___
 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] Oracle database pool hangs on 2.1

2001-03-22 Thread Shahar Solomianik 

Off course , I ment prepareStatement and not getConnection in my previous
email...
[conn.prepareStatement(statementSyntax.toString(),ResultSet.TYPE_SCROLL_INSE
NSITIVE,ResultSet.CONCUR_READ_ONLY);]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Guy Rouillier
Sent: Thursday, March 22, 2001 5:10 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1


I don't understand what you are saying.  The code works fine under 2.1 with
Minerva.  It does not work with the Oracle XA implementation.

- Original Message -
From: "Shahar Solomianik" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 7:09 AM
Subject: RE: [JBoss-user] Oracle database pool hangs on 2.1


 Its not Oracle problem. the same code works fine under jboss2.0 with
 minerva.
 but thanks anyway.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Guy Rouillier
 Sent: Wednesday, March 21, 2001 7:30 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1


 Haven't tried the scrollable results sets.  When I tried the Oracle XA
 implementation, I got all sorts of errors (sorry, don't remember at the
 moment.)  I gave up at the moment and just went with minerva.  Did you
check
 the Oracle techweb site?  Perhaps there is an update to the Oracle
 implementation.

 - Original Message -----
 From: Shahar Solomianik [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, March 20, 2001 8:55 AM
 Subject: RE: [JBoss-user] Oracle database pool hangs on 2.1


  Hi.
  When I use this configuration (i.e. minerva and not oracle's XA
  implementation), I get exceptions when using scrollable result sets.
  Do you face the same problem ?
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]On Behalf Of Guy
Rouillier
  Sent: Tuesday, March 20, 2001 7:56 AM
  To: [EMAIL PROTECTED]
  Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1
 
 
  I followed other suggestions on this mailing list and got it to work.
 Here
  are my entries from jboss.jcml.  The first is an addition to an existing
  entry to add the Oracle driver, while the second is a new one for the
 pooled
  connection to Oracle (adjust entries to match your database - "userid"
and
  "password" should not be these literals, but the actual userid and
  password.)
 
!-- JDBC --
mbean code="org.jboss.jdbc.JdbcProvider"
  name="DefaultDomain:service=JdbcProvider"
   attribute
 

name="Drivers"oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.enhyd
  ra.instantdb.jdbc.idbDriver/attribute
/mbean
 
mbean code="org.jboss.jdbc.XADataSourceLoader"
  name="DefaultDomain:service=XADataSource,name=OracleDB"
  attribute name="PoolName"OracleDB/attribute
  attribute
 

name="DataSourceClass"org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
  l/attribute
  attribute
  name="URL"jdbc:oracle:thin:@localhost:1521:homedb/attribute
  attribute name="JDBCUser"userid/attribute
  attribute name="Password"password/attribute
/mbean
 
  Make sure classes12.zip is in your classpath.  When you start jboss you
  should see the following (amongst everything else).  The first group are
 the
  drivers loading, while the second group is the Oracle pooled connection
  being set up.
 
  [JDBC provider] Initializing
  [JDBC provider] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
  [JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver
  [JDBC provider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
  [JDBC provider] Initialized
  [Hypersonic] Initializing
  [Hypersonic] Initialized
  [InstantDB] Initializing
  [InstantDB] Initialized
  [DefaultDS] Initializing
  [DefaultDS] Initialized
  [OracleDB] Initializing
  [OracleDB] Initialized
 
  [OracleDB] Starting
  [OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
  [OracleDB] Started
 
  What are you seeing or not seeing?
  - Original Message -
  From: Bolt, Dave
  To: [EMAIL PROTECTED]
  Sent: Monday, March 19, 2001 7:30 PM
  Subject: RE: [JBoss-user] Oracle database pool hangs on 2.1
 
 
  I have the drivers in my jboss.jcml file and I get the message that the
  driver was loaded. But it still hangs. I can connect to the Oracle
server
  from the same machine that I'm running JBoss from (of course I'm using
OCI
  vs. a thin driver) as well.
  Any other ideas on getting a 2.1 connection pool unstuck?
  Dave
  -Original Message-
  From: Bill Burke [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 19, 2001 7:05 PM
  To: [EMAIL PROTECTED]
  Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1
 
 
  Make sure you have the oracle drivers in the JdbcProvider section in
  jboss.jcml.  Also make sure that you have the jdbc jar file in your
  ClassPa

RE: [JBoss-user] Problem with ORACLE CMP and BLOBS

2001-03-22 Thread Shahar Solomianik 

My friend !
CMPing a LOB has not yet been proven to be possible using jboss+oracle.
Even Oracle's JServer's EJB server doesnt CMP a LOB !!! (I heard it today
from Oracle support, it took them 2 months to clarify this issue for me...
they say : maybe Oracle9 will do it... ye right)
(If you do manage to do it somehow, cry it out loud !!!)
BMP it.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Noonan Michael
Sent: Thursday, March 22, 2001 7:59 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Problem with ORACLE CMP and BLOBS


Hi,

I'm trying to use CMP with an oracle data source.

one of my CMP fields is a byte[] that can get quite large
JAWS creates a table with this field mapped onto a BLOB type.

When I try to create the entity if the byte[] contains several k's
of data I get the following exception.


[docSession] javax.ejb.CreateException:
Could not create entity:java.sql.SQLException: ORA-01461: can bind a LONG
value only for insert into a LONG column

Is there a way to store large objects using CMP with Oracle?

In the mailing list archive there was a similar problem using BMP
which required rewritting the methods ejbCreate etc.

Will I have to change to BMP and work this way?

Is it possible to mix BMP and CMP in the same Entity Bean?

thanks
-Michael





[JAWS] java.sql.SQLException: ORA-01461: can bind a LONG value only for
insert into a LONG column
[JAWS]
[JAWS]  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
[JAWS]  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[JAWS]  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
[JAWS]  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
[JAWS]  at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
[JAWS]  at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313
)
[JAWS]  at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
[JAWS]  at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1
353)
[JAWS]  at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
[JAWS]  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1807)
[JAWS]  at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:332)
[JAWS]  at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedSta
tementInPool.java:82)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleR
esult(JDBCUpdateCommand.java:49)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159
)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEn
tityCommand.java:135)
[JAWS]  at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersisten
ceManager.java:122)
[JAWS]  at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManag
er.java:207)
[JAWS]  at
org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
[JAWS]  at java.lang.reflect.Method.invoke(Native Method)
[JAWS]  at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
[JAWS]  at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
[JAWS]  at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:87)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:445)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS]  at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
[JAWS]  at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS]  at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
[JAWS]  at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:425)
[JAWS]  at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
[JAWS]  at $Proxy8.create(Unknown Source)
[JAWS]  at
com.icl.itc.doclog.document.docSession.addDocument(docSession.java:185)
[JAWS]  at java.lang.reflect.Method.invoke(Native Method)
[JAWS]  at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulS
essionContainer.java:570)
[JAWS]  at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:17
7)
[JAWS]  at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSess
ionInstanceInterceptor.java:206)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS]  at