db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Armin Waibel (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OJB-115) Cannot Insert Record in SQL SERVER 2000 database
Date Mon, 26 Jun 2006 23:35:30 GMT
    [ 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: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message