[jira] [Created] (NETBEANS-2611) MySQL connection doesn't use just one database and autocomplete doesn't work

["Joshua Bakker (JIRA)" <ji...@apache.org>]

Joshua Bakker created NETBEANS-2611:
---------------------------------------

             Summary: MySQL connection doesn't use just one database and autocomplete doesn't work
                 Key: NETBEANS-2611
                 URL: https://issues.apache.org/jira/browse/NETBEANS-2611
             Project: NetBeans
          Issue Type: Bug
          Components: db - MySQL
    Affects Versions: 11.0
         Environment: Windows 8.1, MySQL 5.5, Netbeans 11.0
            Reporter: Joshua Bakker
         Attachments: bug_autocomplete.png, connection_properties.png

I'm developing in PHP in Netbeans (which works fine). Since I'm using MySQL I tried making a database connection to my database locally, in order to "autocomplete" queries.

The problem is, I created my database connection (database URL is jdbc:mysql://localhost:3306/CMS?zeroDateTimeBehavior=convertToNull) and CMS is obviously the database.

However, when the connection is created I can see all my databases, and when I try to autocomplete in a query, all I'm seeing is _headers _(_alias to ____UNKNOWN__) 

Steps I took:
 # Went over to the Services tab
 # Right mouseclick on Databases -> New connection
 # Select MySQL (Connector/J driver)
 # Database: CMS (after clicking Next
 # Select schema: <No schema> (can't select anything, after clicking Next)
 # Click Next

I didn't have problems with it in Netbeans 10 IIRC. I've attached a screenshot of how my autocomplete looks like and the properties of my connection. In case I need to provide something else or clear something up I'll be willing to.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists