[JBoss JIRA] Created: (JBIDE-6396) Filter wizard/Database Collector should correctly identify catalog, schema, and tables even when tables contain dots (".") in the name
by Michael Walker (JIRA)
Filter wizard/Database Collector should correctly identify catalog, schema, and tables even when tables contain dots (".") in the name
--------------------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-6396
URL: https://jira.jboss.org/browse/JBIDE-6396
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Reporter: Michael Walker
Attachments: JBIDE-tablename-with-dots-patch-mpw.txt
The DefaultDatabaseCollector uses StringHelper.qualifier(String) to determine the catalog and schema name for each table, given the fully-qualified name.
StringHelper.qualifier() assumes that everything proceeding the final "." in the fully-qualified name represents the qualifier.
This assumption breaks down if a table contains a dot in the name. This is found to be the case when working with MetaMatrix (and possibly Teiid).
The result is that the Filter Wizard will generate invalid filters, based on the incorrect naming of catalog and schema for each table.
As a fix, I modified DefaultDatabaseCollector to form the qualifier by using the known catalog and schema, rather than by using the StringHelper.qualifier method. I rebuilt tools and verified that this fixed the problem when working with MetaMatrix.
This may be better addressed by changing the behavior of StringHelper.qualifier() itself.
See forum discussion for details.
Patch attached.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 10 months
[JBoss JIRA] Created: (JBIDE-1608) Hibernate Configuration view should display all database
by Vitali Yemialyanchyk (JIRA)
Hibernate Configuration view should display all database
---------------------------------------------------------
Key: JBIDE-1608
URL: http://jira.jboss.com/jira/browse/JBIDE-1608
Project: Tools (JBoss Tools)
Issue Type: Bug
Reporter: Vitali Yemialyanchyk
Assigned To: Vitali Yemialyanchyk
Priority: Minor
Fix For: LATER
Look at the attached file hibernate.cfg.xml - if <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mysql</property>
Hibernate Configuration view -> ... -> Database display correctly mysql database - but if
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306</property>
look like this
Hibernate Configuration view -> ... -> Database display nothing and the user can't understand what is wrong - I provide 2 screenshots
the same if
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mysql1</property>
mysql1 - there is no such DB
as I think in first case Hibernate Configuration should display all mysql DBs and in the second case the user should get message -
something like "Can't find shuch DB"
Other thing - then I press right mouse button on Hibernate Configuration view -> ... -> Database - I expect to get possibility to configure
DB URL and may be some other properties - the best thing here if I'll get some dialog - or at least possibility to open hibernate.cfg.xml for edit.
For this I'll create other new issue...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 10 months