What sort of field are you accessing. Not a BLOB, CLOB or LONG field is it?
Matt
Matthew L. Wright
Java Internet Programmer
Jupiter One
Web World Studios West Coast
www.jupiterone.com
(818) 763-2927
----- Original Message -----
From: "Mike Viens" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 4:53 PM
Subject: RE: JRun JDBC drivers
> I can successfully using JDBC-ODBC to access my extended ASCII strings,
but
> just not via the JRun JDBC drivers. No, I have not tried contacting
Merant
> yet. I was planning on downloading their trial version drivers and plug
> them into JRun and see what happens.
>
> Mike Viens
> Lead Java Developer
> iConvention, Inc.
> http://www.iconvention.com
> Extraordinary results through unconventional means!
>
>
> -----Original Message-----
> From: Vitaly Shorin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001 4:36 PM
> To: JRun-Talk
> Subject: Re: JRun JDBC drivers
>
>
> I have another problem with this drivers. It seems to me driver change the
> position of ')'- right parenthesis - and places it at the end of the SQL
> query string. Therefore, query like
> "if exists(select * from MyDB) select begin res=1 end else begin select
> res=0 end"
> after processing by driver sent to SQL Server as
> "if exists(select * from MyDB select begin res=1 end else begin select
res=0
> end)"
> and SQL Server obviously returns error.
>
> Did you try to get help directly from Merant? I tried to register at their
> support forum, but website asked me for serial number, and I was not sure
> they expected JRun's serial number (in any case, I can't obtain JRun's
> serial from my hosting provider).
>
> As for your errors, I've reproduced error with TDS_SMALLDATETIME
>
> java.sql.SQLException: [Allaire JRun][SQLServer JDBC Driver]Unhandled data
> type: TDS_SMALLDATETIME
>
> when I used column name containing Alt ASCII symbols, I was unable to
> retrieve values even with JDBC-ODBC bridge (I've got column values by col
> number, not col name...)
>
> Vitalik.
>
> ----- Original Message -----
> From: "Mike Viens" <[EMAIL PROTECTED]>
> To: "JRun-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 17, 2001 2:42 AM
> Subject: RE: JRun JDBC drivers
>
>
> > I have been using the JDBC drivers with JRun for SQLServer and have
> > significant problems with them. I am working with a guy at Allaire to
> > resolve the issues, but it is really tough when he is unable to
reproduce
> > any of the issues. The errors I am getting are:
> >
> > 1) When querying a field that contains extended ASCII (128-255), the
> > character(s) are returned as ?
> > 2) Unable to select a field of type SMALLDATETIME. The driver reports
> that
> > is can not handle this type even though the documentation says it can.
> >
> > If anyone has seen this, and/or knows a fix for it, please contact me.
> >
> > Mike Viens
> >
> > -----Original Message-----
> > From: Vitaly Shorin [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 16, 2001 3:30 PM
> > To: JRun-Talk
> > Subject: JRun JDBC drivers
> >
> >
> > Hi,
> > does anybody use JDBC drivers shipped with JRun (AE/EE)?
> > Do you have any problems with them?
> >
> > regards,
> > Vitalik.
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
