Datasource Field sequenceName attribute bug

[ditomagticom]

hello team.

I tried to use sequence primary key field and I want to set sequence name. But i got an Exception and page won't load.
I don't want to use sequence name which is generated from table and column names.

Env :
1. OS - Linux, Windows.
2.Browser - Google Chrome 39, Firefox 34, IE 10
3.Database - Oracle 11g, PostgreSQL 9.3.6

4.SmartGWT - 5.0p (Eval)
5.Smart Client - 10.1d (Eval)
6.Also I use Spring Framework - 4.2.2.RELEASE
7.And Spring Security - 3.0.3.RELEASE.

If I remove this attribute "sequenceName" everything works fine.

here is an exception stack trace :

javax.servlet.ServletException: DataSource 'ImageDataDS' failed to load due to an exception on the server:
null
See the server-side log for additional details.
    at com.isomorphic.servlet.DataSourceLoader.processRequest(DataSourceLoader.java:278)
    at com.isomorphic.servlet.DataSourceLoader.doGet(DataSourceLoader.java:107)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:156)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1494)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at com.sodaco.finance.webapp.server.authentication.SodacoConcurrentSessionFilter.doFilter(SodacoConcurrentSessionFilter.java:61)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1482)
    at com.sodaco.finance.webapp.server.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:35)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1482)
    at com.sodaco.finance.webapp.server.filter.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:50)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1482)
    at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:260)
    at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:83)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1474)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:499)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:68)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    at org.eclipse.jetty.server.Server.handle(Server.java:370)
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
    at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949)
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
    at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    at java.lang.Thread.run(Thread.java:745)
=== 2015-11-10 11:36:45,112 [8-37] DEBUG ConfigParser - Matched var name: debug
=== 2015-11-10 11:36:45,113 [8-37] DEBUG ConfigParser - value after substitution: true
=== 2015-11-10 11:36:45,114 [8-37] INFO  Compression - /sodacofinance/sc/DataSourceLoader: 6197 -> 1129 bytes

Thank you,
Regards,
Paata.

[Blama]

Hi Paata,

Isomorphic will most definitely ask you for the detailed version number of your SmartGWT build.

Also, what do you mean by

SmartGWT - 5.0p (Eval)
Smart Client - 10.1d (Eval)

Did you mix versions? Test both versions? Why SmartClient?

Best regards
Blama

[Isomorphic]

Blama is correct, but we would also need to see the server log preceding this exception, as well as the DataSource definition itself.

[ditomagticom]

Thank your for replies.

I have posted SmartClient version incorrectly - I use only SmartGWT.
SmartGWT Version : SNAPSHOT_v10.1d_2015-06-27/EVAL Deployment 2015-06-27
Here is my Datasource XML File :

 <DataSource        
ID="UserManagerDS"        
serverType="sql"        
tableName="users"        
qualifyColumnNames="false"        
dropExtraFields="false">    
      <fields>        
          <field name="user_id" type="sequence" sequenceName="seq_users" title="user_id" hidden="true" primaryKey="true" />        
          <field name="user_name"   type="text"  title="user_name" />
          <field name="user_pwd"     type="text"  title="user_pwd" />    
       </fields>
</DataSource>

after all I tried and found solution : Using DMI and Custom Operation Bindings everything works fine.
I have posted log snippet above because I can't upload files here, forum reject files.

Regards,
Paata.

[Isomorphic]

The forum doesn't reject files; others are posting files (of appropriate types and sizes) without difficulty.

Looks like you have a solution; for the record, having an incorrect sequenceName attribute could cause an issue when an actual save was attempted, but there is no plausible way it would cause a problem during DataSource loading (what you showed). Instead, the exception you reported suggests that your file might have been invalid XML (had a typo), had wrong permission (unreadable by the servlet engine process), or missing entirely (perhaps placed in the wrong directory).

[ditomagticom]

Thank you for your post.
we're trying to upgrade our project version and maybe we have some library missing or something like that. DMI solution is OK for us.

Regards,
Paata.