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

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Cannot Reproduce
    • 2.1.1, 1.6.4
    • N/A
    • JDBC 4.2 compatibility
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.