Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-2127

Database-error when trying to create an extended field using PGSQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • I53, 4.0
    • None
    • None
    • None
    • Hide

      Create an extended fields for domains:
      name: domainOwner
      default value: N/A
      Press 'save' button
      This should succeed with any exceptions

      Show
      Create an extended fields for domains: name: domainOwner default value: N/A Press 'save' button This should succeed with any exceptions

    Description

      SQL error creating extended field dk.netarkivet.harvester.datamodel.extendedfield.ExtendedField@1c88d13 in database
      SQLException trace:
      SQL State:42804
      Error Code:0
      org.postgresql.util.PSQLException: ERROR: column "mandatory" is of type integer but expression is of type boolean
      Hint: You will need to rewrite or cast the expression.
      Position: 386
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at dk.netarkivet.harvester.datamodel.extendedfield.ExtendedFieldDBDAO.create(ExtendedFieldDBDAO.java:107)
      at dk.netarkivet.harvester.webinterface.ExtendedFieldDefinition.updateExtendedField(ExtendedFieldDefinition.java:193)
      at dk.netarkivet.harvester.webinterface.ExtendedFieldDefinition.processRequest(ExtendedFieldDefinition.java:180)
      at org.apache.jsp.Definitions_002dedit_002dextendedfield_jsp._jspService(org.apache.jsp.Definitions_002dedit_002dextendedfield_jsp:142)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
      at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
      at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
      at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
      at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
      at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      at org.mortbay.jetty.Server.handle(Server.java:322)
      at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
      at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
      at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
      at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      End of SQLException trace

      Details
      NetarchiveSuite Version: 3.21.1 status UNSTABLE (r2534), INFO

      Attachments

        Activity

          People

            svc Søren Vejrup Carlsen (Inactive)
            svc Søren Vejrup Carlsen (Inactive)
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: