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.nextGlobalException(SelectObse
rver.java:154)
at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:310)
at
org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:280
)
at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:6
59)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:666
)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.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(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java: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(FilterChainServlet.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(HttpRequest.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(OracleStatement.java:1581)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1807)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:332)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:283)
at
org.objectstyle.cayenne.access.DefaultResultIterator.<init>(DefaultResultIte
rator.java:103)
at
org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:335)
at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:257)
at
org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:280
)
at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:6
59)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:666
)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.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(RequestProcessor.java:266)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: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(FilterChainServlet.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(HttpRequest.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(OracleStatement.java:1581)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1807)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:332)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:283)
at
org.objectstyle.cayenne.access.DefaultResultIterator.<init>(DefaultResultIte
rator.java:103)
at
org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:335)
at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:257)
at
org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:280
)
at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:6
59)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:666
)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.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(RequestProcessor.java:266)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: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(FilterChainServlet.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(HttpRequest.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.nextQueryException(SelectObser
ver.java:145)
at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:267)
at
org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:280
)
at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:6
59)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:666
)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.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(RequestProcessor.java:266)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: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(FilterChainServlet.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(HttpRequest.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.nextQueryException(SelectObser
ver.java:145)
at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:267)
at
org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:280
)
at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:6
59)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:666
)
at
org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.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(RequestProcessor.java:266)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: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(FilterChainServlet.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(HttpRequest.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 archive was generated by hypermail 2.0.0 : Thu Aug 22 2002 - 08:25:07 EDT