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
On 19 Aug 2002, Marius Kotsbak wrote:
> 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.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.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.telefon] Executing SQL: SELECT
>last_name,first_name, address, telephone, status FROM PERSONS WHERE (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last!
> _name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_na!
> me=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=
> > ?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?!
> ) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
>(last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) O!
> R (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (
> > last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
>OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
>OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
>OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
>OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> > 2002-08-19 18:44:28,014 ERROR [org.jboss.ejb.plugins.LogInterceptor]
>TransactionRolledbackLocalException, causedBy:
> > java.sql.SQLException: ORA-04031: unable to allocate 2008 bytes of shared memory
>("large pool","unknown object","session heap","frame segment")
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
