RE: MS JDBC Rowset size doubled ?

• Previous message: Carb Simien [MSFT]: "RE: SQL Server 6.5 JDBC Driver"
• In reply to: Bob Horkay: "MS JDBC Rowset size doubled ?"
• Messages sorted by: [ date ] [ thread ]

Date: Wed, 08 Dec 2004 00:14:03 GMT

--------------------
| From: bob@lifeasbob.com (Bob Horkay)
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: MS JDBC Rowset size doubled ?
| Date: 1 Dec 2004 07:47:36 -0800
| Organization: http://groups.google.com
| Lines: 23
| Message-ID: <e310ee8f.0412010747.62bc09ac@posting.google.com>
| NNTP-Posting-Host: 168.137.0.16
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1101916056 12601 127.0.0.1 (1 Dec 2004
15:47:36 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Wed, 1 Dec 2004 15:47:36 +0000 (UTC)
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwi
x.com!newsfeed.cwix.com!news.maxwell.syr.edu!postnews.google.com!not-for-mai
l
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6521
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| 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
|

One possible cause is if the client code requests an updatable resultset.
If you can check the Java code to see if CONCUR_UPDATABLE appears, then it
would explain why the asterisk is present in the Profiler trace. The
driver appends the * to the select list so that it can use a value for
every column in the where clause it generates for the UPDATE statement it
sends to the database to perform the actual update. It does the updates
this way in order to uphold as much data integrity as possible.

Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

• Previous message: Carb Simien [MSFT]: "RE: SQL Server 6.5 JDBC Driver"
• In reply to: Bob Horkay: "MS JDBC Rowset size doubled ?"
• Messages sorted by: [ date ] [ thread ]