Re: [JBoss-user] Strange select statement

2002-08-20 Thread Jon Haugsand
* Sacha Labourey > Well, this one is really easy and is not related to Oracle, which is pretty > rare ;) : > > "java.lang.ClassNotFoundException: > org.jboss.ejb.plugins.local.EntityProxy" > > What is strange is that class doesn't seem to be in any of the client JAR. > Maybe it is a bug. In th

RE: [JBoss-user] Strange select statement

2002-08-20 Thread Sacha Labourey
Hello Jon, > What I did was to increase the LARGE_POOL_SIZE from 614400 to 2614400. > Oracle worked clock like then. To create and delete 1000 bean > instances JBoss used 60 seconds. I do not know if this is > representative? many factors can have an effect (are they distant hosts, etc.) > Ea

Re: [JBoss-user] Strange select statement

2002-08-20 Thread Jon Haugsand
* Sacha Labourey > > Does not this show that the share_pool_size is more than three times > > as big as LARGE? > > Maybe you need to flush your pool: some posts suggests this. What I did was to increase the LARGE_POOL_SIZE from 614400 to 2614400. Oracle worked clock like then. To create and del

RE: [JBoss-user] Strange select statement

2002-08-20 Thread Sacha Labourey
>Collection col=listAll(); >for (Iterator i=col.iterator(); i.hasNext(); ) { > Object o=i.next(); > System.out.println("Object is " + o); > telefonLocal tf = (telefonLocal) o; > > System.out.println("Before"); > telefo

RE: [JBoss-user] Strange select statement

2002-08-20 Thread Sacha Labourey
> Thanks. However, the following is an excert from my initsid.ora: > > shared_pool_size = 31457280 # INITIAL > # shared_pool_size = 350 > # SMALL > # shared_pool_size = 500 > # MEDIUM > # shared_pool_size = 900 > # LARGE > > Does not this show that the share_pool_size is

Re: [JBoss-user] Strange select statement

2002-08-20 Thread Jon Haugsand
* Pavel Kolesnikov > I guess Jon's problem is just the fact that such weird SQL statement > was even generated - and it doesn't seem to be an oracle-problem :-) > > It would be helpful to see the original code (before running XDoclet) > and XDoclet generated code to find out if it's error of JBos

Re: [JBoss-user] Strange select statement

2002-08-20 Thread Jon Haugsand
* Sacha Labourey > Hello Jon, > > The problem is not really with JBoss but with your Oracle configuration. > > The SQL query that is generated is normal (take a look at the CMP doco for > more information on available optimisations). You should modify your > SHARED_POOL_SIZE in Oracle to allow f

Re: [JBoss-user] Strange select statement

2002-08-19 Thread Dan Christopherson
Pavel Kolesnikov wrote: > On Mon, 19 Aug 2002, Sacha Labourey wrote: > > >>Hello Pavel, >> >>No, it is not an error and this code hasn't been generated by xdoclet but by >>the CMP 2.0 engine. > > > Yes, I understand the SQL statement itself has to be generated > by CMP engine. > > >>Everythi

RE: [JBoss-user] Strange select statement

2002-08-19 Thread Sacha Labourey
> BTW I understand why generated SQL statements may contain some > redundant stuff, but Jon's example seemed to me to be really > too strange :-) No, it is an optimisation used to pre-fetch some instances in a CMP internal cache. An explicit where clauses to choose concerned XID is necessary in t

RE: [JBoss-user] Strange select statement

2002-08-19 Thread Pavel Kolesnikov
On Mon, 19 Aug 2002, Sacha Labourey wrote: > Hello Pavel, > > No, it is not an error and this code hasn't been generated by xdoclet but by > the CMP 2.0 engine. Yes, I understand the SQL statement itself has to be generated by CMP engine. > Everything is fine as long as the SQL query is > conc

RE: [JBoss-user] Strange select statement

2002-08-19 Thread Sacha Labourey
-Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]De la part de Pavel > Kolesnikov > Envoye : lundi, 19 aout 2002 19:53 > A : [EMAIL PROTECTED] > Objet : Re: [JBoss-user] Strange select statement > > > I guess Jon's problem is just the

Re: [JBoss-user] Strange select statement

2002-08-19 Thread Pavel Kolesnikov
I guess Jon's problem is just the fact that such weird SQL statement was even generated - and it doesn't seem to be an oracle-problem :-) It would be helpful to see the original code (before running XDoclet) and XDoclet generated code to find out if it's error of JBoss, XDoclet or Jon :-) Pavel

Re: [JBoss-user] Strange select statement

2002-08-19 Thread Marius Kotsbak
This is a oracle-problem. Check the errorcode ORA-04031. Maybe it doesn't support so many entites at a time. And maybe last_name isn't a good primary key (it looks like it is the primary key). Or maybe the server just is out of memory. On Mon, 2002-08-19 at 19:01, Jon Haugsand wrote: > JBoss 3.0

RE: [JBoss-user] Strange select statement

2002-08-19 Thread Sacha Labourey
2 19:02 > A : [EMAIL PROTECTED] > Objet : [JBoss-user] Strange select statement > > > JBoss 3.0.1, datasource is Oracle 8.1.7, OS=Linux 2.2.18 > > When trying to access an XDoclet generated getData the following happens: > > 2002-08-19 18:44:27,940 DEBUG > [o

[JBoss-user] Strange select statement

2002-08-19 Thread Jon Haugsand
JBoss 3.0.1, datasource is Oracle 8.1.7, OS=Linux 2.2.18 When trying to access an XDoclet generated getData the following happens: 2002-08-19 18:44:27,940 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder 2002-08-19 18:44:27,944 DEBUG [org