Hello all,
I created some classes using Torque and turbine-2.2.-dev.jar, where the
script from schema reference is for the table "Category" is:
<table name="category">
<column name="id" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
<column name="parentid" required="true" type="INTEGER"/>
<column name="level" required="true" type="INTEGER"/>
<column name="status" required="true" default="A" size="1"
type="VARCHAR"/>
</table>
the SQL script created by Torque is:
CREATE TABLE category
(
id INTEGER NOT NULL AUTO_INCREMENT,
parentid INTEGER NOT NULL,
level INTEGER NOT NULL,
status VARCHAR (1) default 'A' NOT NULL,
PRIMARY KEY(id)
);
When using the following Java code in TDK 2.1:
Criteria crit = new Criteria();
crit.add(CategoryPeer.LEVEL, 1, (String)Criteria.EQUAL);
crit.addOrderByColumn(CategoryPeer.CATEGORYID);
Vector v = null;
DBConnection dbConn = null;
try {
dbConn = TurbineDB.getConnection();
v = CategoryPeer.doSelect(crit, dbConn);
TurbineDB.releaseConnection(dbConn);
} catch(Exception e) {
log.fatal(org.apache.turbine.util.StringUtils.stackTrace(e));
log.debug("error:"+e.getMessage());
}
I get this error:
C2F0707276E803_000758393 - java.lang.NullPointerException
at
org.apache.turbine.om.peer.BasePeer.createQueryString(BasePeer.java:1039)
at
org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:1150)
at
ro.securenet.portal.om.BaseCategorydescriptionPeer.doSelectVillageRecords(BaseCategoryd
escriptionPeer.java:317)
at
ro.securenet.portal.om.BaseCategorydescriptionPeer.doSelect(BaseCategorydescriptionPeer
.java:275)
at
ro.securenet.portal.managers.CatalogManager.getCatalogCategoriesLevel(CatalogManager.ja
va:429)
at
ro.securenet.portal.modules.actions.Welcome.doListCategoriesLevel2(Welcome.java:85)
at
ro.securenet.portal.modules.actions.Welcome.doPerform(Welcome.java:67)
at ro.securenet.portal.modules.Action.perform(Action.java:30)
at
de.securenet.turbine.extensions.SnActionLoader.exec(SnActionLoader.java:75)
at
ro.securenet.portal.PortalServlet.doGet(PortalServlet.java:483)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain
.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:19
3)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
If I comment out the line
crit.addOrderByColumn(CategorydescriptionPeer.CATEGORYID); everithing is
working well.
So, I cannot order the results and I need that.
Also I have other errors if I don't put a DBConnection object as second
parameter for doSelect() or doUpdate() methods.
I use a mySQL database.
Can anyone help me?
Thank you.
--
Sorin Scortan
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
