facebook

Table owners in SQL Server

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #222500 Reply

    aroncox
    Member

    When generating Hibernate mapping files using tables in SQL Server that are not owned by dbo (for example: rpt.report_headers) the owner is lost in two places like so:

    1. In the DBExplorer the list of tables is sorted by owner, but the owner can’t be seen anywhere making it hard to find the table you want

    2. The mapping XML file lists the tablename but not the owner, and won’t work until the owner is added

    Also, it would be great if there was a way to script externally the code that is generated in the Java object files. For example, we might want to add code to each Getter and Setter to trigger events.

    Thanks, and keep up the great work!

    Aron Cox
    aroncox@bigfoot.com

    #222507 Reply

    support-jeff
    Member

    Plans for qualifying table names in the mapping files is afoot. On #1, not sure I catch what you mean: the table names under TABLES in the db browser are sorted in order of the table owner? as in the user, not the schema? Must be a SQLServer thing. If there ever comes a day that a SQLServer extension is created (as now exists for Oracle, and soon Postgresql), I am sure this is info that could be added to the views.

    As for “externally scripting”, go for it. The templates for classes and mappings are just velocity templates inside the plugin directory.

    THanx for the thanx!

    #238735 Reply

    vagamond
    Member

    Hi there!

    Any news on Fully Qualified Table Names in the Hibernate mapping files?
    It seems that this feature is still unavailable in the 4.0 G.A.
    Is there any smart workaround????

    Thanks and Regards

    #238738 Reply

    Riyad Kalla
    Member

    There is no workaround at this point but we are evaluating some HIbernate revamping for 4.1 and 5.0, which is why we held off on any minor changes for 4.0

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Table owners in SQL Server

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