Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

jaguar.sql.JServerResultSetMetaData.setColumnType

2 posts in General Discussion (old) Last posting was on 2000-03-22 20:59:15.0Z
Phil Marchello Posted on 2000-03-22 20:29:59.0Z
Newsgroups: sybase.public.easerver
From: "Phil Marchello" <pmarchello@noblestar.com>
Subject: jaguar.sql.JServerResultSetMetaData.setColumnType
Date: Wed, 22 Mar 2000 15:29:59 -0500
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 206.138.153.250
Message-ID: <347_lBvTYyDl$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25898
Article PK: 155932

The "jaguar.sql.JServerResultSetMetaData.setColumnType(int colindex, int
SQLtype) method sets the column data type (by position) for a resultset.
According to the Jaguar documentation, the SQL types suported do not include
the java.sql.Date type (unless this was accidently left out of the
documentation). I have an application that requires the use of a date (in
the result set). When I do specify "Types.Date", I get an exception- which
seems to confirm that this is unsupported.

What data type should I use to represent date in this column? Thanks,

-Phil


John Childs Posted on 2000-03-22 20:59:15.0Z
Newsgroups: sybase.public.easerver
From: "John Childs" <john.childs@sybase.com>
Subject: Re: jaguar.sql.JServerResultSetMetaData.setColumnType
Organization: Sybase
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Wed, 22 Mar 2000 15:59:15 -0500
Lines: 22
NNTP-Posting-Host: childs-pc.sybase.com 172.31.141.190
Message-ID: <347_01bf9440$da4c8950$be8d1fac@childs-pc>
References: <347_lBvTYyDl$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25891
Article PK: 155927

Phil,

I'm not sure if this is the problem or not, but it should be
java.sql.Types.DATE not java.sql.Types.Date.

FYI

John

Phil Marchello <pmarchello@noblestar.com> wrote in article
<lBvTYyDl$GA.285@forums.sybase.com>...
> The "jaguar.sql.JServerResultSetMetaData.setColumnType(int colindex, int
> SQLtype) method sets the column data type (by position) for a resultset.
> According to the Jaguar documentation, the SQL types suported do not
include
> the java.sql.Date type (unless this was accidently left out of the
> documentation). I have an application that requires the use of a date (in
> the result set). When I do specify "Types.Date", I get an exception-
which
> seems to confirm that this is unsupported.
>
> What data type should I use to represent date in this column? Thanks,
>
> -Phil
>
>
>
>