Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-523

java.sql.SQLException: Could not set parameter at position 1 (values was 'admin')

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.1.1, 1.6.4
    • Fix Version/s: N/A
    • Component/s: JDBC 4.2 compatibility
    • Labels:
      None
    • Environment:
      java 1.8 with 2.1.1 version binary.
      java 1.7 with 1.6.4 version binary.

      Description

      Query Execution failed with below error.

      java.sql.SQLException: Could not set parameter at position 1 (values was 'admin')

      below query we are using.
      SELECT CONCAT('<img style=\"width:30px;height:26px;\" src=\"http://${ip}/assets/logos/',IF(image_url IS NULL OR image_url=\"\",'${IP}/assets/images/default-logo.gif',image_url),'\"onmouseout=\"funCloseLogoImage()\" onmouseover=\"funOpenLogoImage(event,\\'',\"${IP}/assets/logos//\",IF(image_url IS NULL OR image_url=\"\",'${IP}/assets/images/default-logo.gif',image_url),'\\')\" style=\"width:30px;height:26px;\"') AS imageurl,CONCAT(' <img class=\"updatePandL\" src=\\'${IP}/as/icons/Edit.png
      ' alt=
      'Edit
      ' title=
      'Edit
      ' onclick=\"funEdit(
      '', CAST(id AS CHAR),'\\')\");\"/> <img class=\"deletePandL\" src=\\'${IP}/Delete.png
      ' alt=\\'View
      ' title=
      'Delete
      ' onclick=\"funDelete(
      '', CAST(id AS CHAR),''',''',pl_name,'\\')\");\"/>') AS Actions table WHERE 1=1 AND created_by=?

      same query executing in 1.5.9 version

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            banesh banesh banna
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: