Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-8119492

DataApp mysql script doesn't work with latest mysql

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: P4 P4
    • 8
    • 7u6
    • javafx
    • None

      install mysql-5.1.65-osx10.6-x86_64
      run dataapp server, next error will be shown:

      Invalid Query: Column Count Doesn't Match Value count.


      To fix this: in DataAppLoader/build.xml next lines:


                  INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL);
                  INSERT INTO db VALUES ('localhost','APP','dataapp','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y');


      should be changed to:

      GRANT ALL PRIVILEGES ON APP TO dataapp@localhost IDENTIFIED BY PASSWORD '*B974A83D18BB105D0C9186756F485406E6E6039B';

            dmasada Debra Masada (Inactive)
            sgrinev Sergey Grinev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported: