facebook

Problem with DB explorer. MyEclipse Ver: 2018.9.0

  1. MyEclipse IDE
  2.  > 
  3. Installation, Configuration & Updates

Tagged: ,

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #598047 Reply

    greybeard
    Participant

    Version myeclipse CI 2018.9.0 Build id: 16.0.0-2018090
    MySQL server version: 5.7.20

    Cannot insert / select: get an error:
    <quote>
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=DEFAULT’ at line 1.
    </quote>
    I presume that the faulty syntax is an element of the db explorer. Regret I do not know how to fix that issue.
    Note the graphic of the screen: schema ‘logon’ TABLE appears empty. In reality the tables are in the ‘logon’ db (seen in MySQL Workbench) . They just do not appear in the browser window.
    Thanks and regards
    Bruce Prior
    bruce.prior@greybeard.com.au

    Attachments:
    You must be logged in to view attached files.
    #598050 Reply

    support-swapna
    Moderator

    greybeard,

    Sorry that you are seeing this problem.

    While I investigate further, can you please try removing the use logon statement from the editor and try running the query? Does it work?

    About the missing tables in the Explorer view, do you see the problem only with logon catalog or for all the catalogs?

    Please share with us the workspace log file by clicking on the icon for ‘Export Log’ in the Error Log view (change the extension to .txt) and attach it here to help us check for any errors/exceptions logged.

    Apologies for inconvenience caused.

    –Swapna
    Genuitec Support

    #598051 Reply

    greybeard
    Participant

    Hi

    1. closed the connection.
    2. opened a connection specified schema “logon” via the select list on the edit wndow
    3. checked the db browser tree. Tables now showing OK.
    4. ran: select * from APP_USER
    5 All OK
    6. ran: insert into app_role (ROLE_ID, ROLE_NAME) values (3, ‘ROLE_FOO’);
    7. ran select * from APP_ROLE
    8 All OK.

    I will carry on from here and let u know if the symptoms show themselves again.
    sorry for bother
    Log is attached as requested

    cheerz
    bruce

    Attachments:
    You must be logged in to view attached files.
    #598055 Reply

    support-swapna
    Moderator

    greyboard,

    Glad that you got it working. It looks like the connection timed out previously.
    Thank you for getting back to us.

    –Swapna
    Genuitec Support

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Problem with DB explorer. MyEclipse Ver: 2018.9.0

You must be logged in to post in the forum log in