DBAdaptor for postgres

[Bill <bh...@collaborativefusion.com>]

Hello

Could anybody tell me what the DBAdaptor entry in
TurbineResources.properties should look like to implement postgresql
access?

thanks

-bill






--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Error while saving to Oracle 8i database

[Keshava Murthy <ke...@bigtec.org>]

Hi,
While inserting data to oracle DB using the following method in my action
class -

public void doInsert(RunData data, Context context)
        throws Exception
    {

       SubBldSmplColnDtls entry = new SubBldSmplColnDtls();
       entry.setStudyId("523/02CA");
       entry.setPrdId("P1");
       entry.setDoseNo("1");
       entry.setDrawCnt("1");
       entry.setVacId("V1");
       entry.setSubBarcode("S1");
       entry.setDrawTime(new java.sql.Date(System.currentTimeMillis()));
       entry.save();
    }
 I am getting the following exception :
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(VelocityA
ctionEvent.java:166)
 at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionE
vent.java:114)
 at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.jav
a:114)
 at
org.apache.turbine.modules.actions.VelocitySecureAction.perform(VelocitySecu
reAction.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:447)
 at org.apache.turbine.Turbine.doPost(Turbine.java:537)
 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(Application
FilterChain.java:247)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
 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.ja
va:201)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
 at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:472)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
 at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
 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:2344)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164
)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
 at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
 at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
 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
:163)
 at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
 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:
1011)
 at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106
)
 at java.lang.Thread.run(Thread.java:536)
Caused by: java.lang.NullPointerException
 at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:737)
 at
org.bigtec.lotus.om.BaseSubBldSmplColnDtlsPeer.doInsert(BaseSubBldSmplColnDt
lsPeer.java:132)
 at
org.bigtec.lotus.om.BaseSubBldSmplColnDtlsPeer.doInsert(BaseSubBldSmplColnDt
lsPeer.java:354)
 at
org.bigtec.lotus.om.BaseSubBldSmplColnDtls.save(BaseSubBldSmplColnDtls.java:
284)
 at
org.bigtec.lotus.om.BaseSubBldSmplColnDtls.save(BaseSubBldSmplColnDtls.java:
254)
 at
org.bigtec.lotus.om.BaseSubBldSmplColnDtls.save(BaseSubBldSmplColnDtls.java:
240)
 at
org.bigtec.lotus.modules.actions.SQLRecordZero.doInsert(SQLRecordZero.java:9
7)
 ... 48 more

can somebody tell me how do I overcome this problem

regards,

Keshav




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>