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(OraclePreparedStatement.java:57)
[JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(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(JDBCFindEntitiesCommand.java:145)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersistenceManager.java:138)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.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(EntityContainer.java:639)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.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.java: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(JRMPContainerInvoker.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(SubNetIntfBean.java:394)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[JAWS] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.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:177)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:471)
[JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.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:188)
[JAWS] at com.softalia.neoems.srvrinterfaces.ServerCache.<init>(ServerCache.java:109)
[JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.startServerCache(NeoEmsStarterBean.java:160)
[JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.ejbCreate(NeoEmsStarterBean.java:107)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager.createSession(StatefulSessionFilePersistenceManager.java:172)
[JAWS] at
org.jboss.ejb.StatefulSessionContainer.createHome(StatefulSessionContainer.java:375)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invokeHome(StatefulSessionContainer.java:514)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:151)
[JAWS] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(StatefulSessionInstanceInterceptor.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.java:311)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.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:706)
[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(OraclePreparedStatement.java:57)
[JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(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(JDBCFindEntitiesCommand.java:145)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersistenceManager.java:138)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.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(EntityContainer.java:639)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.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.java: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(JRMPContainerInvoker.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(SubNetIntfBean.java:394)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[JAWS] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.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:177)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:471)
[JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.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:188)
[JAWS] at com.softalia.neoems.srvrinterfaces.ServerCache.<init>(ServerCache.java:109)
[JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.startServerCache(NeoEmsStarterBean.java:160)
[JAWS] at
com.softalia.neoems.server.NeoEmsStarterBean.ejbCreate(NeoEmsStarterBean.java:107)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager.createSession(StatefulSessionFilePersistenceManager.java:172)
[JAWS] at
org.jboss.ejb.StatefulSessionContainer.createHome(StatefulSessionContainer.java:375)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invokeHome(StatefulSessionContainer.java:514)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:151)
[JAWS] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(StatefulSessionInstanceInterceptor.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.java:311)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.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:706)
[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(JDBCFindEntitiesCommand.java:145)
[SubNetIntfBean] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersistenceManager.java:138)
[SubNetIntfBean] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.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(EntityContainer.java:639)
[SubNetIntfBean] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
[SubNetIntfBean] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.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.java: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(JRMPContainerInvoker.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(SubNetIntfBean.java:394)
[SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
[SubNetIntfBean] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[SubNetIntfBean] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.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:177)
[SubNetIntfBean] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[SubNetIntfBean] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:471)
[SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.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:188)
[SubNetIntfBean] at
com.softalia.neoems.srvrinterfaces.ServerCache.<init>(ServerCache.java:109)
[SubNetIntfBean] at
com.softalia.neoems.server.NeoEmsStarterBean.startServerCache(NeoEmsStarterBean.java:160)
[SubNetIntfBean] at
com.softalia.neoems.server.NeoEmsStarterBean.ejbCreate(NeoEmsStarterBean.java:107)
[SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
[SubNetIntfBean] at
org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager.createSession(StatefulSessionFilePersistenceManager.java:172)
[SubNetIntfBean] at
org.jboss.ejb.StatefulSessionContainer.createHome(StatefulSessionContainer.java:375)
[SubNetIntfBean] at java.lang.reflect.Method.invoke(Native Method)
[SubNetIntfBean] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invokeHome(StatefulSessionContainer.java:514)
[SubNetIntfBean] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:151)
[SubNetIntfBean] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(StatefulSessionInstanceInterceptor.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.java:311)
[SubNetIntfBean] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.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:706)
[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
