Find Database Developer (Information Systems Specialist 6) Job in Salem, Oregon | Snaprecruit

Find Database Developer Job in Salem, Oregon
image
  • Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Database Developer (Information Systems Specialist 6)

  • ... Salem, Oregon, United States
  • ... Full time
  • ... Salary: 8572 per year
  • Posted on: Feb 29, 2024       Expires on: Apr 14, 2024

Database Developer (Information Systems Specialist 6)   

JOB TITLE:

Database Developer (Information Systems Specialist 6)

JOB TYPE:

Full-time

JOB LOCATION:

Salem Oregon United States

JOB DESCRIPTION:

Full job description

Initial Posting Date:
02/29/2024
Application Deadline:
03/14/2024
Agency:
Department of Consumer & Business Services
Salary Range:
$5,660 - $8,572
Position Type:
Employee
Position Title:
Database Developer (Information Systems Specialist 6)
Job Description:
Our mission.
.
.
To protect and serve Oregon's consumers and workers while supporting a positive business climate.
The
Department of Consumer and Business Services
(DCBS) is a progressive business regulatory state agency dedicated to the mission of protecting and serving Oregon's consumers and workers while supporting a positive business climate.
The department administers state laws and rules governing workers' compensation, occupational safety and health, financial institutions, insurance companies and building codes.
The department has consumer protection and education programs, offices, and ombuds to help consumers, injured workers, and businesses.
This position is with the
Information Technology and Research
(IT&R) Section of the Central Services Division.
IT&R provides a broad range of specialized technical services in the areas of information systems, data analysis/dissemination, and computer/telecommunication services for a large, diverse agency.
The staff support the collection, processing, analysis, and dissemination of statewide and regional data about workers' compensation, accident prevention, insurance, financial institutions, corporate securities, building codes, and senior health insurance benefits.
The section supports a number of critical systems to meet the regulatory requirements for each program and interact with other state and federal agencies.
This position is represented by the Service Employees International Union (SEIU).
Whats in it for you:
  • Rewarding work in a productive and creative environment
  • Colleagues who are passionate about public service
  • Work/life balance, 11 paid holidays a year, and a
    competitive benefits package
  • Advancement and learning opportunities that will help grow your career with the State of Oregon
  • Possible eligibility for the
    Public Service Loan Forgiveness Program
This position is eligible for
hybrid remote work
on a part-time basis once the incumbent has gained the proficiency to perform work independently.
However, regular, scheduled office hours are also required.
Heres what you will do:
As a Database Developer, you will provide technical expertise and support in using database technology for database applications, interfaces, data transfer mechanisms and business intelligence platforms critical to DCBS.
You will work with the Architects and/or Senior DBA on effective data retrieval, resolution of data related incidents and/or requests.
You will also initiate, plan and execute IT projects of small and medium size and complexity under the guidance and direction of manager, PMO manager or project manager.
For a complete listing of the duties and responsibilities of this position, please review the position description by clicking
here
.
Heres what you need to qualify:
Minimum Qualifications:
  • Five (5) years of information systems experience in programming against databases using SQL/PL-SQL
OR
  • An associate degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field AND three (3) years of information systems experience in programming against databases using SQL/PL-SQL
OR
  • A bachelor's degree in Information Technology, Computer Science, or related field AND one (1) year of information systems experience in programming against databases using SQL/PL-SQL
Requested Skills:
  • A profound understanding of the importance of teamwork
  • Good communication skills: written, oral, presentation and nonverbal
  • Ability to define problems, collect data, establish facts, and draw valid conclusions
  • Expertise on DDL/DML/DCL queries, query tuning & optimization
  • Ability to create complex stored procedures, packages, views, functions and triggers
  • Database modeling, design, and programming against databases using T-SQL
  • Understanding of data management (e.
    g.
    permissions, recovery, security and monitoring)
Application information:
  • A resume and cover letter are required for this job posting.
    Please attach them in the Resume / Cover Letter section of the application.
  • Please ensure that you clearly demonstrate in your application materials that you meet the qualifications listed and that you follow all instructions carefully.
    Only complete applications received by the posted application deadline date will be considered.
  • You may be asked to submit a skills assessment, a writing sample, or a video interview as part of the application screening process.
Additional information:
  • Per the Pay Equity Law passed in 2017, a pay equity analysis will be conducted to determine what pay step the successful candidate will be offered.
    The analysis will be based on the relevant experience, education, training, and certifications documented in the application materials.
    On average, candidates new to state service will most likely be offered compensation in the lower to mid-level of the salary range.
  • This position is subject to a fingerprint background check for any convictions directly related to its duties and responsibilities.
    Only job-related convictions will be considered and will not automatically disqualify the candidate.
  • Eligible veterans who meet the qualifications will be given veterans' preference.
    For further information, please see the following website:
    Veterans Resources
    .
    NOTE: If claiming veterans preference please be sure to check your Workday account for pendin

    ???errorPage.heading???

    org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update `job_archive_partner` set `alias`=?, `alternateJobEmail`=?, `archived`=?, campaign_id=?, `checkedAt`=?, `city`=?, `company_name`=?, `confirmedEmail`=?, country_id=?, `created_at`=?, `currentBoost`=?, `deleted`=?, `descUrl`=?, `description`=?, `dummy`=?, `dummy2`=?, `emailScraped`=?, `employerJobFeedId`=?, `employerJobURL`=?, `employment`=?, `exclude`=?, `inBoosted`=?, `industry`=?, `isExpired`=?, `jobBoard`=?, `jobEmail`=?, `jobOrigin`=?, `jobSyncDate`=?, `jobTags`=?, `lastUpdateAt`=?, `linkedin`=?, `notification_email`=?, `notifiedAt`=?, `partnerEmail`=?, `partnerJobFeedId`=?, `partnerJobURL`=?, `payment_type`=?, `position_id`=?, `pricingOption`=?, `qcFlag`=?, `qcReason`=?, `qualityAssuranceFlag`=?, `rate`=?, `referenceNumber`=?, `salary`=?, `salaryunit`=?, `snaprecruit_id`=?, `snapxSync`=?, `socialPilotBoost`=?, `state`=?, `tags`=?, `title`=?, `totalBoost`=?, `twitter`=?, user_id=?, `from_date`=?, `zipCode`=? where `id`=?]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
    	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:648)
    	at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:793)
    	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:664)
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:394)
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    	at com.sun.proxy.$Proxy76.getUserDetails(Unknown Source)
    	at net.jumpspire.app.webapp.taglib.CustomLabelTag.doStartTag(CustomLabelTag.java:47)
    	at org.apache.jsp.WEB_002dINF.jsp.job.archive_002djob_jsp._jspx_meth_sp_005fcustomLabel_005f0(archive_002djob_jsp.java:6046)
    	at org.apache.jsp.WEB_002dINF.jsp.job.archive_002djob_jsp._jspService(archive_002djob_jsp.java:643)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepareFilter.java:82)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at net.jumpspire.core.webapp.filter.MessageFilter.doFilter(MessageFilter.java:48)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
    	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
    	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
    	at org.apache.struts2.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:164)
    	at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)
    	at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:374)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:278)
    	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
    	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:236)
    	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:90)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:192)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
    	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:511)
    	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    	at org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter(StrutsExecuteFilter.java:88)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:134)
    	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:81)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepareFilter.java:82)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at net.jumpspire.core.webapp.filter.MessageFilter.doFilter(MessageFilter.java:48)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
    	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
    	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
    	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at net.jumpspire.core.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:75)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:139)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
    	at psiprobe.Tomcat90AgentValve.invoke(Tomcat90AgentValve.java:35)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:375)
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639)
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.base/java.lang.Thread.run(Thread.java:829)
    Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
    	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
    	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
    	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
    	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
    	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
    	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
    	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
    	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
    	... 154 more
    Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'pricingOption' at row 1
    	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
    	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
    	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    	... 162 more
    Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'pricingOption' at row 1
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
    	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
    	... 167 more