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 for the query to be executed (take a
look at ORA-04031 message definition in your Oracle documentation for more
information)
Cheers,
Sacha
> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]De la part de Jon
> Haugsand
> Envoye : lundi, 19 aout 2002 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
> [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_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) OR
> (last_name=?) OR (last_name=?) OR (last_name=?) OR (last_name=?)
> OR (last_name=?) OR (last_name=?) OR (last_name=?) 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(OracleStat
> ement.java:1870)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePre
> paredStatement.java:363)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrep
> aredStatement.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
>
-------------------------------------------------------
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
