Hi Shimit,
sorry for the long period of time until my answer, if been ill.
> The PL/SQL package is some how getting invalid, that is causing the
> problem.
But why? I\'m not changeing anything on that package. And sometimes the
error occours...
> When the problem again occur you can check the status of the package
> and if u see it is in the invalid state, u can make it valid using
ALTER
> package <name>
This was one of my first thougts. But they were all on vailid state.
> By the by are u doing any correction in the package and you compile
frequently?
No. Not realy. Somethimes changes are made. But not very often. Could
it
be a configurationproblem of the JBoss-Connection-Pool?
This is the Config-File one of the definied datasources on JBoss:
-------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>test_dataSource</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:ora</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>scott</user-name>
<password>tiger</password>
<check-valid-connection-sql>select * from
cat</check-valid-connection-sql>
<min-pool-size>5</min-pool-size>
<max-pool-size>30</max-pool-size>
<idle-timeout-minutes>10</idle-timeout-minutes>
<set-tx-query-timeout>7</set-tx-query-timeout>
</local-tx-datasource>
</datasources>
-------------------------------------------------------
The following exception is thrown from time to time.
-------------------------------------------------------
2005-03-02 09:27:21,579 INFO [STDOUT] java.sql.SQLException: ORA-06550:
line 1, column 13:
PLS-00201: identifier \'P_PROMAN.INSERTTMP_DATA\' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
2005-03-02 09:27:21,581 INFO [STDOUT] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
2005-03-02 09:27:21,581 INFO [STDOUT] at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
2005-03-02 09:27:21,582 INFO [STDOUT] at
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
2005-03-02 09:27:21,582 INFO [STDOUT] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
2005-03-02 09:27:21,582 INFO [STDOUT] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
2005-03-02 09:27:21,582 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:
1313)
2005-03-02 09:27:21,583 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1
232)
2005-03-02 09:27:21,583 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.ja
va:1353)
2005-03-02 09:27:21,583 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
2005-03-02 09:27:21,584 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1805)
2005-03-02 09:27:21,584 INFO [STDOUT] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:320)
2005-03-02 09:27:21,584 INFO [STDOUT] at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStateme
nt.java:364)
2005-03-02 09:27:21,585 INFO [STDOUT] at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(Wrapped
PreparedStatement.java:276)
2005-03-02 09:27:21,585 INFO [STDOUT] at
edu.db.query.CallableStatementQueryModul.doQuery(CallableStatementQueryM
odul.java:95)
2005-03-02 09:27:21,585 INFO [STDOUT] at
edu.ejb.jboss.session.stateless.StatelessDbBean.doQuery(StatelessDbBean.
java:113)
2005-03-02 09:27:21,585 INFO [STDOUT] at
sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
2005-03-02 09:27:21,586 INFO [STDOUT] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
2005-03-02 09:27:21,586 INFO [STDOUT] at
java.lang.reflect.Method.invoke(Method.java:324)
2005-03-02 09:27:21,586 INFO [STDOUT] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stat
elessSessionContainer.java:683)
2005-03-02 09:27:21,587 INFO [STDOUT] at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(
CachedConnectionInterceptor.java:185)
2005-03-02 09:27:21,587 INFO [STDOUT] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Statele
ssSessionInstanceInterceptor.java:72)
2005-03-02 09:27:21,587 INFO [STDOUT] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterce
ptor.java:84)
2005-03-02 09:27:21,588 INFO [STDOUT] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
CMT.java:315)
2005-03-02 09:27:21,588 INFO [STDOUT] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
2005-03-02 09:27:21,588 INFO [STDOUT] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav
a:120)
2005-03-02 09:27:21,588 INFO [STDOUT] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
2005-03-02 09:27:21,589 INFO [STDOUT] at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryF
inderInterceptor.java:122)
2005-03-02 09:27:21,589 INFO [STDOUT] at
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionC
ontainer.java:331)
2005-03-02 09:27:21,589 INFO [STDOUT] at
org.jboss.ejb.Container.invoke(Container.java:723)
2005-03-02 09:27:21,590 INFO [STDOUT] at
sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
2005-03-02 09:27:21,590 INFO [STDOUT] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
2005-03-02 09:27:21,590 INFO [STDOUT] at
java.lang.reflect.Method.invoke(Method.java:324)
2005-03-02 09:27:21,591 INFO [STDOUT] at
org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.jav
a:60)
2005-03-02 09:27:21,591 INFO [STDOUT] at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
2005-03-02 09:27:21,591 INFO [STDOUT] at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
2005-03-02 09:27:21,592 INFO [STDOUT] at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
2005-03-02 09:27:21,592 INFO [STDOUT] at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav
a:185)
2005-03-02 09:27:21,592 INFO [STDOUT] at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
2005-03-02 09:27:21,593 INFO [STDOUT] at
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360
)
2005-03-02 09:27:21,593 INFO [STDOUT] at
sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
2005-03-02 09:27:21,593 INFO [STDOUT] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
2005-03-02 09:27:21,593 INFO [STDOUT] at
java.lang.reflect.Method.invoke(Method.java:324)
2005-03-02 09:27:21,594 INFO [STDOUT] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
2005-03-02 09:27:21,594 INFO [STDOUT] at
sun.rmi.transport.Transport$1.run(Transport.java:148)
2005-03-02 09:27:21,594 INFO [STDOUT] at
java.security.AccessController.doPrivileged(Native Method)
2005-03-02 09:27:21,595 INFO [STDOUT] at
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
2005-03-02 09:27:21,595 INFO [STDOUT] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
2005-03-02 09:27:21,595 INFO [STDOUT] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja
va:701)
2005-03-02 09:27:21,595 INFO [STDOUT] at
java.lang.Thread.run(Thread.java:536)
Kind Regards
Rolf Rothamel
-----------------------------------------
Rolf Rothamel
Tel: 0049.178.3637334
Web: www.rothamel.com
-----------------------------------------
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
