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")
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
> at
>oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
> at
>oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
> at
>oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
> at
>oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
>
> --
> Jon Haugsand, <[EMAIL PROTECTED]>
> Norges Bank, <http://www.norges-bank.no>
>
>
>
> -------------------------------------------------------
> 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
--
Marius Kotsbak
Boost Communications A/S
Trondheim, Norway
-------------------------------------------------------
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
