|
From: jan_bar <her...@ya...> - 2012-01-17 08:32:02
|
In article <MPG...@ne...>,
her...@ya... says...
Do not use sqljdbc_2.0.1803.100_enu driver, use sqljdbc_3.0.1301.101
_enu, at least one bug concerning schemas was fixed:
411695 getSchemas should return schema information
In previous versions of the driver, the driver returned user
information instead of the schema information.The driver will now return
schema information and supports pattern matching for schema name per
JDBC spec.
Jan
>
> In article <4F1...@t-...>, ger...@t-...
> says...
>
> Thanks Gerd, I have found something:
>
> >
> > On 12.01.2012 17:32, jan_bar wrote:
> > > Hi,
> > >
> > > I use SquirrelDB as my primary database tool for many different
> > > databases (PostgreSQL, DB2, Oracle, ...) and I like it. However with MS
> > > SQL it seems that the support is lacking. There are some issues:
> > >
> > > * I cannot see source of stored procedures - is this supposed to work?
> > The MSSQL Plugin supports scripting stored procedures. But there is no
> > source tab in the Object tree details the like they exist for some other
> > RDBMSes.
>
> Already found my way, see the other post.
>
> >
> >
> >
> > >
> > > * I cannot see list of stored procedures. Current user doesn't have
> > > right to see procedure source but he can execute them. In MS SQL
> > > Management Studio I can list procedure names. This is quite unfortunate.
> > >
> > > * Sometimes I cannot list table names even if I can list them in MS SQL
> > > Management Studio with the same user
> > I cannot reproduce these problems though I admit that I have only very
> > limited access to MSSQL right now. Could you please give some more details.
>
> Yes, now I can. The DatabaseMetaData.getSchemas() returns some of the
> schemas with db_* prefix, for instance db_int. However getProcedures()
> returns the procedures in schema called "int" (no db_* prefix). This is
> the reason why I cannot list them, as I cannot select "int" schema. I
> changed the schema name in debugger "db_int" -> "int" and voila, I can
> see the procedures. The SQL Server Manager has no schema with db_*
> prefix, this seems to be artificially added somewhere.
>
> It's not clear if this is bug in JDBC driver or what. I am using JDBC
> driver from Microsoft (sqljdbc_2.0.1803.100_enu) against SQL Server 2008
> R2.
>
> I have found newer Microsoft drive (sqljdbc_3.0.1301.101_en). With this
> driver no schemas are listed at all. The schema level is missing in
> objects tab and the procedures are listed. The fully qualified name
> includes the schema name "int". However I cannot see the procedure
|
