[Dwm-sits] Error Message

[McClellan, Charles]

I get this message after trying to insert and AOC. Can't go any further to
test the AOC related!

 

Error Message

 

TopLinkTransactionManager; SQL []; ORA-01400: cannot insert NULL into
("SIS"."SITE_LOCATIONS"."COLLECTION_DATE")

; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL
into ("SIS"."SITE_LOCATIONS"."COLLECTION_DATE")

 

Stack Trace

 

org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQL
StateSQLExceptionTranslator.java:91)

org.springframework.orm.toplink.TopLinkTransactionManager.convertJdbcAccessEx
ception(TopLinkTransactionManager.java:472)

org.springframework.orm.toplink.TopLinkTransactionManager.doCommit(TopLinkTra
nsactionManager.java:404)

org.springframework.transaction.support.AbstractPlatformTransactionManager.pr
ocessCommit(AbstractPlatformTransactionManager.java:496)

org.springframework.transaction.support.AbstractPlatformTransactionManager.co
mmit(AbstractPlatformTransactionManager.java:469)

org.springframework.transaction.interceptor.TransactionAspectSupport.doCommit
TransactionAfterReturning(TransactionAspectSupport.java:266)

org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tra
nsactionInterceptor.java:106)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflecti
veMethodInvocation.java:170)

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProx
y.java:176)

$Proxy15.createSiteConcern(Unknown Source)

dwm.sits.web.aoc.AocBean.createAction(AocBean.java:55)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.
java:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)

org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListene
rImpl.java:63)

javax.faces.component.UICommand.broadcast(UICommand.java:106)

javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:94)

javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:168)

org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.ja
va:343)

org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)

com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.jav
a:64)

org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.j
ava:144)

com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispat
cher.java:629)

com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequ
estDispatcher.java:376)

com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandl
er.java:870)

com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler
.java:451)

com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandle
r.java:218)

com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:119)

com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)

oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketRead
Handler.java:260)

oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAc
ceptHandler.java:230)

oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHa
ndler.java:33)

oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSo
cketAcceptHandler.java:831)

com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableRes
ourcePooledExecutor.java:303)

java.lang.Thread.run(Thread.java:595)

 

 

 

Charles A. McClellan

Department of Enviromental Protection

Division of Waste Management

Office (850)245-8985

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/dwm-sits/attachments/20070207/31b5d5fd/attachment.htm