Re: MS JDBC Rowset size doubled ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 12/01/04 

Date: Wed, 01 Dec 2004 10:06:34 -0800
To: Bob Horkay <bob@lifeasbob.com>

Hi. This may be the implementation of the RowSet. Whose is it?
Joe Weinstein at BEA

Bob Horkay wrote:

> I'm a SQL Server DBA, doing some profiling and tuning on a SQL Server
> database that is being accessed by a JDBC Driver.
>
> I am often seeing statements executed in the format of:
>
> Select Field1, Field2, Field3, * From TableA
>
> The problem with this is that the Developers explicitely listed the
> fields in the select statement and some other process is appending the
> *. This is doubling the row size returned.
>
> This is a MS JDBC Driver, running under IBM Websphere access SQL
> Server.
>
> The developers claim they are not adding the asterisk and that SQL
> Server is. I've never seen SQL Server add an asterisk to user query.
> We are assuming that is the JDBC Driver.
>
> Unfortunately the developer is of course an off-site contractor, so
> I'm reaching for any help before I call Microsoft PSS for support.
>
> Thanks
> Bob Horkay

Relevant Pages

  • RE: Multiple Access and ODBC connections
    ... We're running Access 2003, SQL 2005. ... server when we deploy a new release. ... We are linked to test SQL and Access DBs, and developers change the links to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Security - give developers read access to prod DBs
    ... > We have a test SQL 2000 server where most developers have their own SQL ... > databases on the prod SQL instance where all development databases are ...
    (microsoft.public.sqlserver.server)
  • Re: WHERE 1=2 with performance nightmares
    ... Application server enabling technology for developers ... WHERE clause in our sql. ... Has that turned on some kind of server setting that cause all ...
    (borland.public.delphi.non-technical)
  • Re: Whats My Password?
    ... When using any instance of SQL Server you can access it via the network ... the database on my computer. ... My book is predominantly for Visual Studio/SQL Server ... developers as it discusses issues that all architectures are likely to see ...
    (microsoft.public.dotnet.framework.adonet)