Re: updateRow() Fails

From: Sue Purkis (suepurkis_at_yahoo.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 16:33:31 -0400

Pete,
  I believe that the problem that you are reporting is that you need to be
able to use string data that includes a single quote. Is this correct?

Sue

"Pete Loveall" <psl@ametx.com.NO_SPAM> wrote in message
news:ua2P6$TfEHA.2028@tk2msftngp13.phx.gbl...
> This driver does not implement prepared statements in a compliant manner.
> Instead of using parameterized operations where there is no conversion of
> strings, the driver converts all parameters to string values for use in
text
> SELECT, INSERT, and UPDATE statements. Very ugly and non-compliant. This
> prevents proper storage and retrieval of strings with apostrophes, using
> updateBytes() for varchar fields, etc.
>
> The jTDS driver works properly with PreparedStatement constructs and I
will
> stick with that.
>
> Pete Loveall
>
> "Pete Loveall" <psl@ametx.com.NO_SPAM> wrote in message
> news:uemDhpJeEHA.4068@TK2MSFTNGP11.phx.gbl...
> > I am using the JDBC SP3 driver. My tables use varchar columns (no
Unicode
> > due to way data is received). I have set
> > SendStringParametersAsUnicode=false. Everything works well except...
> >
> > Updating a varchar column with byte values sometimes fails. The code
does
> a
> > SELECT, then an updateRow() if the data is found. Below is the two
> batches
> > sent by JDBC to the SQL Server (happens with both SelectMethod=Cursor
and
> > SelectMethod=Direct, I used the SelectMethod=Direct batches since they
are
> > simpler to read).
> >
> > One thing I find very wierd: why does the UPDATE have all the extra
stuff
> > added to the WHERE clause? Seems like a waste and probably what is
> killing
> > the update.
>
>

Relevant Pages

  • Re: Cant add a usb Cannon i960 printer
    ... the printer gets defined with a device string like the ... it is hardly interesting to repeat it unless the usblp kernel driver ... >and then the kernel discovers its devcies as it enumerates and probes buses. ...
    (comp.os.linux.setup)
  • Access web cam with multiple web cams
    ... tuner seem to use the same driver ... Private Const WS_VISIBLE As Integer = &H10000000 ... (ByVal lpszWindowName As String, ByVal dwStyle As Integer, ByVal x As ... Dim DriverVersion As String = Space ...
    (microsoft.public.dotnet.languages.vb)
  • AddPrinter in Windows 98
    ... Public Type PRINTER_DEFAULTS ... (ByVal pName As String, ByVal Level As Long, pPrinter As PRINTER_INFO_2) ... ' Driver Name - Driver must be installed already ... pi2.pDriverName = AddString(strDriver, bBuffer) ...
    (microsoft.public.vb.winapi)
  • Re: Is C# support load device driver?
    ... how to manage driver loading/unloading using both PInvoke interop and WMI. ... string driverName; ... IntPtr fileHandle; ... databaseName, uint dwDesiredAccess); ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Is C# support load device driver?
    ... I can see my driver is loaded. ... > string driverName; ... > internal static extern IntPtr OpenSCManager(string machineName, ... > uint dwDesiredAccess, uint serviceType, uint startType, uint ...
    (microsoft.public.dotnet.languages.csharp)
Loading