I'm tyring to use javaType="object" so I can use null foreign keys. When
javaType="object" is present in the db schema, Torque throws a
java.sql.SQLException - see below. Note that I do _not_ get this error
when javaType="object" is _not_ present in the db schema; instead, I
just get a referential integrity violation! Anyway, how do you get
Torque to work with javaType="object"?
I'm using
TDK 2.2 RC1
PostgreSQL 7.2
Java SDK 1.4.0_01
Ant 1.5.1
Linux
Thanks for your help!
Here's the error.
[Fri Nov 15 00:47:35 EST 2002] -- ERROR -- Turbine.handleException: null
[Fri Nov 15 00:47:35 EST 2002] -- ERROR --
Exception: java.lang.reflect.InvocationTargetException
Stack Trace follows:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityActionEvent.java:159)
at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:107)
at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:110)
at
org.apache.turbine.modules.actions.VelocitySecureAction.perform(VelocitySecureAction.java:100)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
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:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
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:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
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:2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
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.StandardEngineValve.invoke(StandardEngineValve.java:174)
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.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:536)
Caused by: org.apache.torque.TorqueException: ERROR:
app_paymentmethod_seq.currval is not yet defined in this session
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:763)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at
com.company.app.om.BasePaymentMethodPeer.doInsert(BasePaymentMethodPeer.java:226)
at
com.company.app.om.BasePaymentMethodPeer.doInsert(BasePaymentMethodPeer.java:172)
at
com.company.app.om.BasePaymentMethodPeer.doInsert(BasePaymentMethodPeer.java:583)
at
com.company.app.modules.actions.admin.InsertSampleData.doPaymenttypes(InsertSampleData.java:103)
... 48 more
Caused by: java.sql.SQLException: ERROR: app_paymentmethod_seq.currval
is not yet defined in this session
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at com.workingdogs.village.QueryDataSet.<init>(Unknown Source)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsVillageValue(AutoIncrementIdGenerator.java:194)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncrementIdGenerator.java:127)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:754)
... 53 more
--
Eric Emminger
[EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
