Hi Marian,
It seems like you are connecting to the database with no problems, so I
don't believe it's your oracle driver.
Are you sure you ran the script to create the cayenne tables?
Eric
> -----Original Message-----
> From: Marian Simpetru [mailto:mos..solutions.ro]
> Sent: Thursday, August 22, 2002 8:26 AM
> To: cayenne-use..bjectstyle.org
> Subject: Did I miss anything?
>
>
> Hello!
>
> I'm new to cayenne.
> I tryed the web examples
>
> I deploy-it, I change the sample
> cayene.hml and driverinfo.xml with apropriate values (oracle...)
> I tryed both with classes111.zip and classes 12_01.zip (versions of
> OracleDriver) - same result
>
> Thanks,
> Marian Simpetru
>
> here is what I have in the webpage (when try to 'view galleries):
>
> 500 Servlet Exception
> java.sql.SQLException: ORA-00903: invalid table name
>
> at
> org.objectstyle.cayenne.access.SelectObserver.nextGlobalExcept
> ion(SelectObse
> rver.java:154)
> at
> org.objectstyle.cayenne.access.DataNode.performQueries(DataNod
> e.java:310)
> at
> org.objectstyle.cayenne.access.DataDomain.performQueries(DataD
> omain.java:280
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQueries(Data
> Context.java:6
> 59)
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:666
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:588
> )
> at action.GalleryPageAction.execute(GalleryPageAction.java:30)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProces
> sor.java:446)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProce
> ssor.java:266)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1292)
> at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at
> com.caucho.server.http.FilterChainServlet.doFilter(FilterChain
> Servlet.java:9
> 6)
> at
> com.caucho.server.http.Invocation.service(Invocation.java:312)
> at
> com.caucho.server.http.CacheInvocation.service(CacheInvocation
> .java:135)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
> at
> com.caucho.server.http.HttpRequest.handleConnection(HttpReques
> t.java:163)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
> at java.lang.Thread.run(Thread.java:536)
>
> Here is the console:
>
>
>
> http listening to *:8080
> srun listening to 127.0.0.1:6802
> Aug 22, 2002 3:17:08 PM
> org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing,
> config='org.apache.struts.taglib.html.LocalStrings',
> returnNull=true
> Aug 22, 2002 3:17:08 PM
> org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing, config='org.apache.struts.util.LocalStrings',
> returnNull=true
> Aug 22, 2002 3:17:08 PM
> org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing,
> config='org.apache.struts.taglib.bean.LocalStrings',
> returnNull=true
> Aug 22, 2002 3:17:08 PM
> org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing,
> config='org.apache.struts.taglib.html.LocalStrings',
> returnNull=true
> Aug 22, 2002 3:17:08 PM
> org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing,
> config='org.apache.struts.taglib.logic.LocalStrings',
> returnNull=true
> Aug 22, 2002 3:17:11 PM
> org.apache.struts.action.RequestProcessor process
> INFO: Processing a 'GET' for path '/browseGalleries'
> Aug 22, 2002 3:17:11 PM org.objectstyle.cayenne.access.QueryLogger
> logQueryStart
> SEVERE: --- will run 1 query.
> Aug 22, 2002 3:17:11 PM
> org.objectstyle.cayenne.access.QueryLogger logQuery
> SEVERE: SELECT t0.GALLERY_NAME, t0.GALLERY_ID FROM .GALLERY t0
> Aug 22, 2002 3:17:12 PM org.objectstyle.cayenne.access.QueryLogger
> logQueryError
> SEVERE: *** error.
> java.sql.SQLException: ORA-00903: invalid table name
>
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
> at
> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatem
> ent.java:1581)
> at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.j
> ava:1758)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.java
> :1807)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl
> ePreparedState
> ment.java:332)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle
> PreparedStatem
> ent.java:283)
> at
> org.objectstyle.cayenne.access.DefaultResultIterator.<init>(De
> faultResultIte
> rator.java:103)
> at
> org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:335)
> at
> org.objectstyle.cayenne.access.DataNode.performQueries(DataNod
> e.java:257)
> at
> org.objectstyle.cayenne.access.DataDomain.performQueries(DataD
> omain.java:280
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQueries(Data
> Context.java:6
> 59)
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:666
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:588
> )
> at action.GalleryPageAction.execute(GalleryPageAction.java:30)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProces
> sor.java:446)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProce
> ssor.java:266)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1292)
> at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at
> com.caucho.server.http.FilterChainServlet.doFilter(FilterChain
> Servlet.java:9
> 6)
> at
> com.caucho.server.http.Invocation.service(Invocation.java:312)
> at
> com.caucho.server.http.CacheInvocation.service(CacheInvocation
> .java:135)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
> at
> com.caucho.server.http.HttpRequest.handleConnection(HttpReques
> t.java:163)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
> at java.lang.Thread.run(Thread.java:536)
> Aug 22, 2002 3:17:12 PM
> org.objectstyle.cayenne.access.DefaultOperationObserver
> nextQueryException
> WARNING: query exception
> java.sql.SQLException: ORA-00903: invalid table name
>
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
> at
> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatem
> ent.java:1581)
> at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.j
> ava:1758)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.java
> :1807)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl
> ePreparedState
> ment.java:332)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle
> PreparedStatem
> ent.java:283)
> at
> org.objectstyle.cayenne.access.DefaultResultIterator.<init>(De
> faultResultIte
> rator.java:103)
> at
> org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:335)
> at
> org.objectstyle.cayenne.access.DataNode.performQueries(DataNod
> e.java:257)
> at
> org.objectstyle.cayenne.access.DataDomain.performQueries(DataD
> omain.java:280
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQueries(Data
> Context.java:6
> 59)
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:666
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:588
> )
> at action.GalleryPageAction.execute(GalleryPageAction.java:30)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProces
> sor.java:446)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProce
> ssor.java:266)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1292)
> at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at
> com.caucho.server.http.FilterChainServlet.doFilter(FilterChain
> Servlet.java:9
> 6)
> at
> com.caucho.server.http.Invocation.service(Invocation.java:312)
> at
> com.caucho.server.http.CacheInvocation.service(CacheInvocation
> .java:135)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
> at
> com.caucho.server.http.HttpRequest.handleConnection(HttpReques
> t.java:163)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
> at java.lang.Thread.run(Thread.java:536)
> Aug 22, 2002 3:17:12 PM org.objectstyle.cayenne.access.QueryLogger
> logQueryError
> SEVERE: *** error.
> java.sql.SQLException: ORA-00903: invalid table name
>
> at
> org.objectstyle.cayenne.access.SelectObserver.nextQueryExcepti
> on(SelectObser
> ver.java:145)
> at
> org.objectstyle.cayenne.access.DataNode.performQueries(DataNod
> e.java:267)
> at
> org.objectstyle.cayenne.access.DataDomain.performQueries(DataD
> omain.java:280
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQueries(Data
> Context.java:6
> 59)
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:666
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:588
> )
> at action.GalleryPageAction.execute(GalleryPageAction.java:30)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProces
> sor.java:446)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProce
> ssor.java:266)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1292)
> at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at
> com.caucho.server.http.FilterChainServlet.doFilter(FilterChain
> Servlet.java:9
> 6)
> at
> com.caucho.server.http.Invocation.service(Invocation.java:312)
> at
> com.caucho.server.http.CacheInvocation.service(CacheInvocation
> .java:135)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
> at
> com.caucho.server.http.HttpRequest.handleConnection(HttpReques
> t.java:163)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
> at java.lang.Thread.run(Thread.java:536)
> Aug 22, 2002 3:17:12 PM
> org.objectstyle.cayenne.access.DefaultOperationObserver
> nextGlobalException
> WARNING: global exception
> java.sql.SQLException: ORA-00903: invalid table name
>
> at
> org.objectstyle.cayenne.access.SelectObserver.nextQueryExcepti
> on(SelectObser
> ver.java:145)
> at
> org.objectstyle.cayenne.access.DataNode.performQueries(DataNod
> e.java:267)
> at
> org.objectstyle.cayenne.access.DataDomain.performQueries(DataD
> omain.java:280
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQueries(Data
> Context.java:6
> 59)
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:666
> )
> at
> org.objectstyle.cayenne.access.DataContext.performQuery(DataCo
> ntext.java:588
> )
> at action.GalleryPageAction.execute(GalleryPageAction.java:30)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProces
> sor.java:446)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProce
> ssor.java:266)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1292)
> at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at
> com.caucho.server.http.FilterChainServlet.doFilter(FilterChain
> Servlet.java:9
> 6)
> at
> com.caucho.server.http.Invocation.service(Invocation.java:312)
> at
> com.caucho.server.http.CacheInvocation.service(CacheInvocation
> .java:135)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
> at
> com.caucho.server.http.HttpRequest.handleConnection(HttpReques
> t.java:163)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
> at java.lang.Thread.run(Thread.java:536)
> Aug 22, 2002 3:17:12 PM org.apache.struts.action.RequestProcessor
> processException
> WARNING: Unhandled Exception thrown: class
> org.objectstyle.cayenne.CayenneRuntimeException
>
**********************************************************************
This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies. You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
TIAA-CREF
**********************************************************************
This archive was generated by hypermail 2.0.0 : Thu Aug 22 2002 - 09:46:39 EDT