[ http://issues.apache.org/jira/browse/OJB-115?page=all ]

Armin Waibel closed OJB-115.
----------------------------

    Resolution: Invalid

No bug. Seems to be a invalid configuration.

> Cannot Insert Record in SQL SERVER 2000 database
> ------------------------------------------------
>
>                 Key: OJB-115
>                 URL: http://issues.apache.org/jira/browse/OJB-115
>             Project: OJB
>          Issue Type: Bug
>          Components: PB-API
>         Environment: Running on Windows Server 2003 
> Servlet Container: Apache Tomcat 5.5
> Database Server: SQL Server 2000
> PB-API: version 1.1
>            Reporter: Jonathan Albert C. Vallar
>
> Hi!
> I am having problems inserting data onto a SQL Server 2000 database. I am 
> using PB-API 1.1. I think the issue is the Sequence Manager implementation I 
> am using.  I am not really sure though. I am using the 
> "SequenceManagerNativeImpl"  implementation. 
> What should I do?
> Written below is the error log: 
> log4j:WARN No appenders could be found for logger 
> (org.apache.commons.digester.Digester).
> log4j:WARN Please initialize the log4j system properly.
> [DEFAULT] WARN: [PlatformFactory] problems with platform 
> org.apache.ojb.broker.platforms.PlatformMSSQLImpl : 
> org.apache.ojb.broker.platforms.PlatformMSSQLImpl
> [DEFAULT] WARN: [PlatformFactory] OJB will use PlatformDefaultImpl instead
> [org.apache.ojb.broker.core.PersistenceBrokerImpl] 
> ERROR: SQLException during SequenceManager.afterStore call on object 
> 'md.forecast.data.Users': 
> java.lang.UnsupportedOperationException: This feature is not supported by 
> this implementation
> java.lang.UnsupportedOperationException: This feature is not supported by 
> this implementation
> org.apache.ojb.broker.util.sequence.SequenceManagerException: 
> java.lang.UnsupportedOperationException: 
> This feature is not supported by this implementation
>  at 
> org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.getLastInsert 
> (Unknown Source)
>  at 
> org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.afterStore(Unknown
>  Source)
>  at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
>  at org.apache.ojb.broker.core.PersistenceBrokerImpl.store (Unknown Source)
>  at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
>  at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown 
> Source)
>  at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store (Unknown 
> Source)
>  at 
> md.forecast.biz.data.UsersPersistentAccess.insertObject(UsersPersistentAccess.java:109)
>  at md.forecast.beans.actions.UsersAction.saveUsers(UsersAction.java:120)
>  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:585)
>  at 
> org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
>  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
>  at org.apache.struts.action.RequestProcessor.processActionPerform 
> (RequestProcessor.java:421)
>  at 
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
>  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>  at org.apache.struts.action.ActionServlet.doPost (ActionServlet.java:415)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:252)
>  at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>  at 
> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:298)
>  at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>  at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>  at org.apache.catalina.core.StandardWrapperValve.invoke 
> (StandardWrapperValve.java:213)
>  at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>  at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>  at org.apache.catalina.valves.ErrorReportValve.invoke 
> (ErrorReportValve.java:105)
>  at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>  at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>  at org.apache.coyote.http11.Http11Processor.process 
> (Http11Processor.java:869)
>  at 
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>  at 
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java 
> :527)
>  at 
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>  at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>  at java.lang.Thread.run (Thread.java:595)
> Caused by: java.lang.UnsupportedOperationException: This feature is not 
> supported by this implementation
>  at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.getLastInsertIdentityQuery(Unknown
>  Source)
>  at 
> org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.lastInsertSelect(Unknown
>  Source)
>  ... 38 more
> org.apache.ojb.broker.PersistenceBrokerException: 
> org.apache.ojb.broker.util.sequence.SequenceManagerException : 
> java.lang.UnsupportedOperationException: This feature is not supported by 
> this implementation
>  at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
>  at org.apache.ojb.broker.core.PersistenceBrokerImpl.store (Unknown Source)
>  at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
>  at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown 
> Source)
>  at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store (Unknown 
> Source)
>  at 
> md.forecast.biz.data.UsersPersistentAccess.insertObject(UsersPersistentAccess.java:109)
>  at md.forecast.beans.actions.UsersAction.saveUsers(UsersAction.java:120)
>  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:585)
>  at 
> org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
>  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
>  at org.apache.struts.action.RequestProcessor.processActionPerform 
> (RequestProcessor.java:421)
>  at 
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
>  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>  at org.apache.struts.action.ActionServlet.doPost (ActionServlet.java:415)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:252)
>  at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>  at 
> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:298)
>  at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>  at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>  at org.apache.catalina.core.StandardWrapperValve.invoke 
> (StandardWrapperValve.java:213)
>  at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>  at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>  at org.apache.catalina.valves.ErrorReportValve.invoke 
> (ErrorReportValve.java:105)
>  at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>  at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>  at org.apache.coyote.http11.Http11Processor.process 
> (Http11Processor.java:869)
>  at 
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>  at 
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java 
> :527)
>  at 
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>  at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>  at java.lang.Thread.run (Thread.java:595)
> Caused by: org.apache.ojb.broker.util.sequence.SequenceManagerException: 
> java.lang.UnsupportedOperationException: This feature is not supported by 
> this implementation
>  at 
> org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.getLastInsert 
> (Unknown Source)
>  at 
> org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.afterStore(Unknown
>  Source)
>  ... 36 more
> Caused by: java.lang.UnsupportedOperationException: This feature is not 
> supported by this implementation
>  at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.getLastInsertIdentityQuery(Unknown
>  Source)
>  at 
> org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.lastInsertSelect(Unknown
>  Source)
>  ... 38 more
> [org.apache.ojb.broker.core.PersistenceBrokerImpl] ERROR: Broker is still in 
> PB-transaction, do automatic abort before close!

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to