[jbosstools-dev] RE: JBIDE-1173

[Vitali Yemialyanchyk]

Max,

Other question. 

CachedMetaDataTest is a good example, so for me CachedMetaDataDialect seems
ready to use - here only the question only about special dialect cases -
like H2MetaDataDialect, OracleMetaDataDialect and MySQLMetaDataDialect - as
I see these items I can't understood is CachedMetaDataDialect ready for use
or not, did JDBCMetaDataDialect cover all other cases?
If that is right - other question -
How do you expect I should resolve 1173? - should I make it only for java
code completion or you expected it should be  resolution for more wide case
including hbm.xml's code completion - in this case I think the solution is
to modify HibernateNature - getTables, getMatchingTables; modify
ColumnNameHandler, TableNameHandler; and of course - modify
HQLJavaCompletionProposalComputer.

Vitali

-----Original Message-----
From: Max Rydahl Andersen [mailto:max.andersen at redhat.com] 
Sent: Monday, March 17, 2008 10:55 PM
To: Vitali Yemialyanchyk
Cc: Exadel List; jbosstools-dev at lists.jboss.org
Subject: Re: JBIDE-1173

> according your suggestions - I look at HibernateNature - it is suitable to
> fix the issue;
> I remember, you told what it has some drawbacks with performance for DB
with
> many tables -
> as I see this problem could also be in xml code completion - cause it uses
> HibernateNature - so
> may be it will be right to use HibernateNature here and create new issue
to
> fix/workaround performance problem?
>
> [ Show > ]
>
>  <http://jira.jboss.com/jira/secure/ViewProfile.jspa?name=vyemialyanchyk>
> Vitali Yemialyanchyk [17/Mar/08 02:04 PM] Max, according your suggestions
-
> I look at HibernateNature - it is suitable to fix the issue; I remember,
you
> told what it has some drawbacks with performance for DB with many tables -
> as I see this problem could also be in xml code complition - so may be it
> will be right to use HibernateNature here and create new issue to
> fix/workaround performance problem?

Well, I don't want us to be causing performance problems in the Java editor
because of table/column code completion.....so need to fix that performance
first.

For that look into the CachedMetaDataDialect in hibernatetools and there are
tests that I started working on that does incremental reading of
jdbcmetadata
that could be used. But I havent looked at it for a while so not sure how
much
is missing.

-max