[ http://issues.apache.org/jira/browse/OJB-115?page=comments#action_12417927 ]
Armin Waibel commented on OJB-115: ---------------------------------- > PB-API: version 1.1 Do you really use the unreleased 1.1 version from SVN trunk or is it a typo and you mean OJB version 1.0.1? 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] This indicates the problem. Your platform attribute entry in jdbc-connection-descriptor should look like platform="MsSQLServer" not platform="MSSQL" > Cannot Insert Record in SQL SERVER 2000 database > ------------------------------------------------ > > Key: OJB-115 > URL: http://issues.apache.org/jira/browse/OJB-115 > Project: OJB > 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]
