.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Getting JDBC metadata for synonyms

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Using the Latest JDBC Driver from SQLExpress I'm attempting to get use the getTable() method to get information about database objects that the user can access/alter.   Works fine for for tables and views, but can't seem to get any information returned for synonyms.Is it possible to get information for synonyms, e.g. column definitions? or am I'm missing some setting in the connection.Any Help would be appreciated!Dave.

View Complete Post

More Related Resource Links

Import Managed Metadata with Synonyms

I want to import some taxonomy values. I have seen the csv import format, but it doesn't include synonyms (does it?). eg: I want to import a list of Countries & their associated Country-Codes as Synonyms a list of NAICS & their associated NAICS-Codes as Synonyms same for SICs, Clients, etc, etc I always want to bring in description & code. Is there a same powershell script that can do this,... etc....

Conversion error in the JDBC 3.0 driver when accessing metadata


I am using SQL Server 2008 R2 and the SQL Server JDBC driver 3.0.1301.101.

When reading meta data for a table I get the following SQLServerException on column 22 (SOURCE_DATA_TYPE)

The conversion from char to SMALLINT is unsupported.

The following code demonstates the problem.

import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerDataSource;

public class SQLJDBCTest {

 public static void main(String[] args) {
  SQLServerDataSource ds = new SQLServerDataSource();

  Connection cn = null;
  ResultSet rs = null;
  try {
   cn = ds.getConnection();
   rs = cn.getMetaData().getColumns("Archive25", "dbo", "CountryCode", null);
   if(rs != null) {
    ResultSetMetaData rsm = rs.getMetaData();
    while(rs.next()) {
     for(int i = 1; i <= rsm.getColumnCount(); ++i) {
      String cname = rsm.getColumnName(i);
      Object obj = rs.getObject(i);
      System.out.println(cname + " " +obj);
  }catch(Exception ex) {


Compiler Error Message : CS0006: Metadata file 'System.EnterpriseServices.dll' could not be found


I get this error when i Debug my web application....


I followed these steps.,

  • Ended the aspnet_wp.exe process in the Windows Task Manager
  • Then deleted the application`s folder in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\
  • Then started Visual Studio 2008 again

I also rebooted my system but no use....

Plz help !

Extreme ASP.NET: Model Validation & Metadata in ASP.NET MVC 2


Scott Allen shows how to improve your user input validation with new features coming out in ASP.NET MVC 2 that easily allow validation on both the client and server.

Scott Allen

MSDN Magazine March 2010

"Oslo" Basics: Build Metadata-Based Applications With The "Oslo" Platform


We introduce you to "Oslo" and demonstrate how MSchema and MGraph enable you to build metadata-driven apps. We'll define types and values in "M" and deploy them to the repository.

Chris Sells

MSDN Magazine February 2009

Office Development: Manage Metadata with Document Information Panels


Here the author uses Document Information Panels in the Microsoft 2007 Office system to manipulate metadata from Office docs for better discovery and management.

Ashish Ghoda

MSDN Magazine April 2008

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

Avoiding DLL Hell: Introducing Application Metadata in the Microsoft .NET Framework


The Microsoft .NET platform uses metadata and assemblies to store information about components, enabling cross-language programming and resolving the infamous DLL Hell problem. This article describes the use of metadata for easy linking and loading of assemblies, the relationship between metadata and concepts such as IDL and type libraries, and the metadata hierarchy. The process of reading metadata from assemblies for easy versioning is also described. Although Microsoft provides the MSIL disassembler, IDLASM, and MetaInfo.exe for accessing metadata, the author provides two sample programs that read metadata using the unmanaged metadata interfaces and the Reflection API.

Matt Pietrek

MSDN Magazine October 2000

Which ComponentModel.DataAnnotations attributes are used in the Dynamic Data metadata classes?


This namespace contains a lot of attributes for use in, I'm sure, many different applications. I'm curious to know which subset of the attributes in this namespace can be and are used in the Dynamic Data proxy class system, where the entity class is given an attribute that specifies a metadata type. That type contains properties with the same names as properties in the entity class, and the metadata provider builds MetaColumns using attributes on properties in these 'buddy' (proxy') classes.

So far my list includes, from System.ComponentModel.DataAnnotations:

Required, Range, DisplayFormat, StringLength, UIHint, DataType, Regular Expression, Display Column, Editable, and CustomValidation.

And from System.ComponentModel:

DisplayName, Description, and DefaultValue.

Am I missing any?

This was originally asked by myself on StackOverflow at: http://stackoverflow.com/questions/3537356/which-componentmodel-dataannotations-attributes-are-used-in-the-dynamic-data-meta

How can I prioritise search results to show where document metadata has a hit first and then where t


When my users run a search against a site with a bunch of document libraries they will often search for terms that are in the title of the doc, if they do know the title they will put that in. What I would like to do is have the results ordered such that if any hits are on the document metadata (eg Title) then they are presented first and any results that are from hits on the content of the documents are presented later.

So, if they get the title spot on in their search query that document will appear first .... if they don't get it right then the likelyhood is that the title is something like what they entered so similar titled docs are presented first and then those with matching content ....

How can I achieve this?


sharepoint search pdf files using metadata and also the content inside pdf

I am a novice to sharepoint search can anyone give some ideas on how to integrate search at a subsite level (only to that subsite) which has pdf documents with metadata associated with it the search should also search the content within the pdf and libraries and list metatdata in Moss 2007

Make MetaData READ ONLY



I want to make the metadata of a document set to read only. The business idea is that when the document is created the first time, it is modifyable. However, few years down the line when the document comes up for revision, we want the metadata columns to be set to read only.


You've only got one life; help as many people as you can, and enjoy it while it lasts.

Fed Up With System.Data.Metadata.Edm.ObjectItemAssemblyLoader

I'm fed up with the random errors I'm getting on my ASP.NET 4, Entity Framework 4 web application lately. It seems to stem from something that System.Data.Metadata.Edm is doing with a call to System.Reflection.Assembly.GetTypes(). I keep getting the error that I complained about previously : Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. To display those Loader exceptions, I added the following to my global.asax file: Sub Application_Error...(read more)

A Brief Introduction to Enterprise Metadata Management for SharePoint Server 2010 Developers

Learn about some basic developer tasks that you can use as basic building blocks for more powerful and complex metadata solutions.

Video: SharePoint 2010: ECM and Enterprise Metadata

SharePoint 2010 now supports metadata everywhere, and this video shows you how to use this new capability to tag all of your SharePoint content and data. (Length: 20:38)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend