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: [email protected]
For additional commands, e-mail: [email protected]
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
