Hi.
I need help with following problem. I have set up database (other than
default), and I try to use my ObjectPeer class to retrieve objects from
it. I do this that way:
Criteria = new Criteria("mydatabase");
criteria.add(ObjectPeer.objectId,objId);
Vector v = ObjectPeer.doSelect(criteria);
and I get this exception:
java.sql.SQLException: Error during query: Unexpected Exception:
java.sql.SQLException message given: Column not found: Unknown column
'Object.url' in 'field list'
java.sql.SQLException: Error during query: Unexpected Exception:
java.sql.SQLException message given: Column not found: Unknown column
'Object.url' in 'field list'
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:807)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:740)
at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:159)
at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:982)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:949)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:908)
at
org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:855)
at
pl.com.epoint.u235.om.peer.NavigationPeer.doSelect(NavigationPeer.java:80)
at
pl.com.epoint.u235.NavigationFactory.getNavigationHolder(NavigationFactory.java:124)
at
pl.com.epoint.u235.NavigationTree.buildTree(NavigationTree.java:72)
at
pl.com.epoint.u235.NavigationTree.<init>(NavigationTree.java:60)
at
pl.com.epoint.u235.NavigationFactory.getNavigationTree(NavigationFactory.java:243)
at
pl.com.epoint.u235.modules.layouts.U235Layout.getNavigationTree(U235Layout.java:173)
at
pl.com.epoint.u235.modules.layouts.U235Layout.doBuild(U235Layout.java:117)
at org.apache.turbine.modules.Layout.build(Layout.java:93)
at
org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:120)
at
pl.com.epoint.u235.modules.pages.U235Page.doBuild(U235Page.java:142)
at org.apache.turbine.modules.Page.build(Page.java:92)
at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:119)
at org.apache.turbine.Turbine.doGet(Turbine.java:347)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:484)
All stuff in BasePeer seems to be working ok (FWIChecked).I
doublechecked my Turbine.properites (at least connection is properly
obtained :) and Object table definition to contain url column. When I
query database by hand with "select" stuff generated by
BasePeer.createQueryString(criteria) everything works perfectly.
Does anybody has any idea what could be wrong ?
Any help would be appreciated.
Regards
Scooter
BTW. I use MySQL with "org.gjt.mm.mysql.Driver" JDBC driver.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
