Check the sqls being generated
Also, why do you have a findAllSubNetworks finder... isn't it just meant to
do what findAll does?
Vinay
----- Original Message -----
From: "Madhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 10:01 AM
Subject: [JBoss-user] Invalid Column Name
> Hi All,
> I am facing java.sql.SQLException: ORA-00904: invalid column
name.
> This is the content of the server.log file. Please find the same below
>
>
> JAWS] java.sql.SQLException: ORA-00904: invalid column name
> [JAWS]
> [JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:184)
> [JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
> [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1206)
> [JAWS] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:506)
> [JAWS] at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:982)
> [JAWS] at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1143)
> [JAWS] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1178)
> [JAWS] at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:57)
> [JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat
ementInPool.java:71)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleRe
sult(JDBCQueryCommand.java:58)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159
)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.
java:60)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEnti
tiesCommand.java:145)
> [JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten
ceManager.java:138)
> [JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManag
er.java:280)
> [JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:392)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
> [JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
> [JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:87)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
> [JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:425)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
> [JAWS] at $Proxy140.findAllSubNetworksInDomain(Unknown Source)
> [JAWS] at
com.softalia.neoems.mo.basemo.SubNetIntfBean.findAllSubNetworksInDomain(SubN
etIntfBean.java:394)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
sSessionContainer.java:472)
> [JAWS] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInstanceInterceptor.java:87)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
> [JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:17
7)
> [JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
> [JAWS] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:271)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:471)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(Stateless
SessionProxy.java:152)
> [JAWS] at $Proxy39.findAllSubNetworksInDomain(Unknown Source)
> [JAWS] at
com.softalia.neoems.srvrinterfaces.ServerCache.updateCache(ServerCache.java:
240)
> [JAWS] at
com.softalia.neoems.srvrinterfaces.ServerCache.initialize(ServerCache.java:1
88)
> [JAWS] at
com.softalia.neoems.srvrinterfaces.ServerCache.<init>(ServerCache.java:109)
> [JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.startServerCache(NeoEmsStarterB
ean.java:160)
> [JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.ejbCreate(NeoEmsStarterBean.jav
a:107)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager.createSession(St
atefulSessionFilePersistenceManager.java:172)
> [JAWS] at
org.jboss.ejb.StatefulSessionContainer.createHome(StatefulSessionContainer.j
ava:375)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invokeHome(State
fulSessionContainer.java:514)
> [JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
> [JAWS] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(Stateful
SessionInstanceInterceptor.java:99)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS] at
org.jboss.ejb.StatefulSessionContainer.invokeHome(StatefulSessionContainer.j
ava:311)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:358)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:152)
> [JAWS] at java.security.AccessController.doPrivileged(Native Method)
> [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
> [JAWS] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
> [JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
> [JAWS] at java.lang.Thread.run(Thread.java:484)
> [JAWS] java.sql.SQLException: ORA-00904: invalid column name
> [JAWS]
> [JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:184)
> [JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
> [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1206)
> [JAWS] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:506)
> [JAWS] at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:982)
> [JAWS] at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1143)
> [JAWS] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1178)
> [JAWS] at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:57)
> [JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat
ementInPool.java:71)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleRe
sult(JDBCQueryCommand.java:58)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159
)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.
java:60)
> [JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEnti
tiesCommand.java:145)
> [JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten
ceManager.java:138)
> [JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManag
er.java:280)
> [JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:392)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
> [JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
> [JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:87)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
> [JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:425)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
> [JAWS] at $Proxy140.findAllSubNetworksInDomain(Unknown Source)
> [JAWS] at
com.softalia.neoems.mo.basemo.SubNetIntfBean.findAllSubNetworksInDomain(SubN
etIntfBean.java:394)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
sSessionContainer.java:472)
> [JAWS] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInstanceInterceptor.java:87)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
> [JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:17
7)
> [JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
> [JAWS] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:271)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:471)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(Stateless
SessionProxy.java:152)
> [JAWS] at $Proxy39.findAllSubNetworksInDomain(Unknown Source)
> [JAWS] at
com.softalia.neoems.srvrinterfaces.ServerCache.updateCache(ServerCache.java:
240)
> [JAWS] at
com.softalia.neoems.srvrinterfaces.ServerCache.initialize(ServerCache.java:1
88)
> [JAWS] at
com.softalia.neoems.srvrinterfaces.ServerCache.<init>(ServerCache.java:109)
> [JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.startServerCache(NeoEmsStarterB
ean.java:160)
> [JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.ejbCreate(NeoEmsStarterBean.jav
a:107)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager.createSession(St
atefulSessionFilePersistenceManager.java:172)
> [JAWS] at
org.jboss.ejb.StatefulSessionContainer.createHome(StatefulSessionContainer.j
ava:375)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invokeHome(State
fulSessionContainer.java:514)
> [JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
> [JAWS] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(Stateful
SessionInstanceInterceptor.java:99)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS] at
org.jboss.ejb.StatefulSessionContainer.invokeHome(StatefulSessionContainer.j
ava:311)
> [JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:358)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:152)
> [JAWS] at java.security.AccessController.doPrivileged(Native Method)
> [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
> [JAWS] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
> [JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
> [JAWS] at java.lang.Thread.run(Thread.java:484)
> [SubNetIntfBean] TRANSACTION ROLLBACK EXCEPTION:null; nested exception is:
> javax.ejb.EJBException
> [SubNetIntfBean] java.lang.reflect.UndeclaredThrowableException:
javax.ejb.FinderException: Find failed
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.
java:64)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEnti
tiesCommand.java:145)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten
ceManager.java:138)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManag
er.java:280)
> [SubNetIntfBean] at
org.jboss.ejb.EntityContainer.find(EntityContainer.java:392)
> [SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
> [SubNetIntfBean] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:87)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [SubNetIntfBean] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:425)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
> [SubNetIntfBean] at $Proxy140.findAllSubNetworksInDomain(Unknown Source)
> [SubNetIntfBean] at
com.softalia.neoems.mo.basemo.SubNetIntfBean.findAllSubNetworksInDomain(SubN
etIntfBean.java:394)
> [SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
> [SubNetIntfBean] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
sSessionContainer.java:472)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInstanceInterceptor.java:87)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:17
7)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
> [SubNetIntfBean] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:271)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:471)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(Stateless
SessionProxy.java:152)
> [SubNetIntfBean] at $Proxy39.findAllSubNetworksInDomain(Unknown Source)
> [SubNetIntfBean] at
com.softalia.neoems.srvrinterfaces.ServerCache.updateCache(ServerCache.java:
240)
> [SubNetIntfBean] at
com.softalia.neoems.srvrinterfaces.ServerCache.initialize(ServerCache.java:1
88)
> [SubNetIntfBean] at
com.softalia.neoems.srvrinterfaces.ServerCache.<init>(ServerCache.java:109)
> [SubNetIntfBean] at
com.softalia.neoems.server.NeoEmsStarterBean.startServerCache(NeoEmsStarterB
ean.java:160)
> [SubNetIntfBean] at
com.softalia.neoems.server.NeoEmsStarterBean.ejbCreate(NeoEmsStarterBean.jav
a:107)
> [SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager.createSession(St
atefulSessionFilePersistenceManager.java:172)
> [SubNetIntfBean] at
org.jboss.ejb.StatefulSessionContainer.createHome(StatefulSessionContainer.j
ava:375)
> [SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
> [SubNetIntfBean] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invokeHome(State
fulSessionContainer.java:514)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:151)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(Stateful
SessionInstanceInterceptor.java:99)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [SubNetIntfBean] at
org.jboss.ejb.StatefulSessionContainer.invokeHome(StatefulSessionContainer.j
ava:311)
> [SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:358)
> [SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
> [SubNetIntfBean] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [SubNetIntfBean] at sun.rmi.transport.Transport$1.run(Transport.java:152)
> [SubNetIntfBean] at java.security.AccessController.doPrivileged(Native
Method)
> [SubNetIntfBean] at
sun.rmi.transport.Transport.serviceCall(Transport.java:148)
> [SubNetIntfBean] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
> [SubNetIntfBean] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
> [SubNetIntfBean] at java.lang.Thread.run(Thread.java:484)
>
>
> The Database Table Structure is defined Below
>
> Name Type
> ------------------------------
> NAME VARCHAR2(30)
> DOMAIN_NAME VARCHAR2(20)
> TYPE VARCHAR2(20)
> DISCV_STATUS NUMBER
> DISCV_DATE_TIME VARCHAR2
> CONFIGURATION NUMBER
> NE_LIST VARCHAR2(250)
>
> Please find my Finder inside the jaws.xml
>
>
> <entity>
> <ejb-name>SubNetworkBean</ejb-name>
> <table-name>SUBNETWORK</table-name>
> <create-table>false</create-table>
> <debug>true</debug>
>
> <cmp-field>
> <field-name>m_name</field-name>
> <column-name>NAME</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR2(30)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>m_domainName</field-name>
> <column-name>DOMAIN_NAME</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR2(20)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>m_type</field-name>
> <column-name>TYPE</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR2(20)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>m_discvStatus</field-name>
> <column-name>DISCV_STATUS</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>NUMBER</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>m_discvDateTime</field-name>
> <column-name>DISCV_DATE_TIME</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR2(30)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>m_neListString</field-name>
> <column-name>NE_LIST</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR2(250)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>m_configuration</field-name>
> <column-name>CONFIGURATION</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>NUMBER</sql-type>
> </cmp-field>
>
> <finder>
> <name>findAllSubNetworks</name>
> <query></query>
> <order></order>
> </finder>
> <finder>
> <name>findByPrimaryKey</name>
> <query>m_name = {0}</query>
> <order></order>
> </finder>
> <finder>
> <name>findAllSubNetworksInDomain</name>
> <query>m_domainName = {0}</query>
> <order></order>
> </finder>
> </entity>
>
>
> I am unable to understand as to why I am getting the invalid column name
> Exception.
>
> I will be very thank ful, if somebody can help me out.
> Regards,
> Madhu
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
