[ffkiller]

Hi,

May i know how to connect to MSSQL2000 database tables that belong to a specified owner? All developers in our team share the same database instance and each has the same set of tables created under his/her name. With SQL Server Enterprise Manager i can easily sort all tables in a database instance accordingly to owner name, but in MyEclipse I can’t find any option related to table owner.

————————————————————————————————————

MyEclipse configuration:
*** Date: Fri Oct 28 18:11:32 GMT+08:00 2005

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.4.1_05

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.0.3 GA
Build id: 20051025-4.0.3-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.1
Build id: M20050929-0840

Eclipse Platform

Version: 3.1.1
Build id: M20050929-0840

Eclipse RCP

Version: 3.1.1
Build id: M20050929-0840

Eclipse Java Development Tools

Version: 3.1.1
Build id: M20050929-0840

Eclipse Plug-in Development Environment

Version: 3.1.1
Build id: M20050929-0840

Eclipse Project SDK

Version: 3.1.1
Build id: M20050929-0840

Eclipse Graphical Editing Framework

Version: 3.1
Build id: 200509301327

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
92c_80
-vm
C:\j2sdk1.4.1_05\bin\javaw.exe

[Riyad Kalla]

After you login with your user name and login, what are you see as far as table listings? What would you expect to see? Because our tool is not MSSQL Server specific it may not support the functionality you are seeking.

[ffkiller]

After login I’m able to see all tables created by different developers in a single instance. Unlike MSSQL Enterprise Manager which can sort tables in a database instance accordingly to owner’s name, MyEclipse DB Browser can only list all the table names without any additional table attributes in a tree view structure. If there is no filter kind of functionality, it is a bit hard to find the exact tables which are created by me since each develope has a set of identical table schemas.

[Riyad Kalla]

Ahh, I better understand what you are asking now, we do not currently support that. I have filed this enhancement for us to look into, however if it is deemed that this is a limitation of the JDBC driver, we won’t be able to add this functionality.

[Author]

Posts