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.

New problem with jConnect version 2

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-16 17:32:12.0Z
Fran Evelyn Posted on 1997-04-14 22:17:58.0Z
From: "Fran Evelyn" <frances.evelyn@ons.octel.com>
Subject: New problem with jConnect version 2
Message-ID: <01bc492a$7a04cbc0$14477cce@fran>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.jdbcconnect
Date: Mon, 14 Apr 1997 18:17:58 -0400
Lines: 41
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1018
Article PK: 252769

We bought and installed jConnect version 2. I have a CGI application that
deals with some initial information exchange with the database; once it's
done, the applet talks with the database direct. The application uses
JDK1.1. Problem: something that worked (and still works) fine with the com
directory dated 3/25/97, breaks with the new release version. (There was a
version between the 3/25 version and the release version, but it had a NAG
message that confused the CGI app, so I never used it.)

What breaks is this; I call a stored procedure that returns, among other
things, a datetime value. I can get the date, but when I try to get the
time, it gives me the error:
java.sql.SQLException: Bad conversion : JZ0P7

The code follows:

strDBValues = new StringBuffer();

strDBValues.append(resultSet.getInt(1));
strDBValues.append(strDelim);
strDBValues.append(resultSet.getString(2));
strDBValues.append(strDelim);
strDBValues.append(resultSet.getDate(3));
strDBValues.append(strDelim);
strDBValues.append(resultSet.getTime(3)); // fails here
strDBValues.append(strDelim);

Any ideas why this changed, and what to do about it?

Fran.

----------------------------------------------------------------------
Frances C. Evelyn OcteLink Network Services
(Software Engineer) Engineering
17000 Dallas Parkway, Suite 115
frances.evelyn@ons.octel.com Dallas, TX 75248

----------------------------------------------------------------------


David Clegg Posted on 1997-04-16 17:32:12.0Z
Message-ID: <33550D1C.53331ABD@sybase.com>
Date: Wed, 16 Apr 1997 10:32:12 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Fran Evelyn <frances.evelyn@ons.octel.com>
Subject: Re: New problem with jConnect version 2
References: <01bc492a$7a04cbc0$14477cce@fran>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 50
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:993
Article PK: 252743

If you look at the message text associated with JZ0P7, it should
should read:
"Column is not cached, use RE-READABLE_COLUMNS property"

Are you using the "NO_REPEAT_READ" connection property?

dave

>
> We bought and installed jConnect version 2. I have a CGI application that
> deals with some initial information exchange with the database; once it's
> done, the applet talks with the database direct. The application uses
> JDK1.1. Problem: something that worked (and still works) fine with the com
> directory dated 3/25/97, breaks with the new release version. (There was a
> version between the 3/25 version and the release version, but it had a NAG
> message that confused the CGI app, so I never used it.)
>
> What breaks is this; I call a stored procedure that returns, among other
> things, a datetime value. I can get the date, but when I try to get the
> time, it gives me the error:
> java.sql.SQLException: Bad conversion : JZ0P7
>
> The code follows:
>
> strDBValues = new StringBuffer();
>
> strDBValues.append(resultSet.getInt(1));
> strDBValues.append(strDelim);
> strDBValues.append(resultSet.getString(2));
> strDBValues.append(strDelim);
> strDBValues.append(resultSet.getDate(3));
> strDBValues.append(strDelim);
> strDBValues.append(resultSet.getTime(3)); // fails here
> strDBValues.append(strDelim);
>
> Any ideas why this changed, and what to do about it?
>
> Fran.
>
> ----------------------------------------------------------------------
> Frances C. Evelyn OcteLink Network Services
> (Software Engineer) Engineering
> 17000 Dallas Parkway, Suite 115
> frances.evelyn@ons.octel.com Dallas, TX 75248
>
> ----------------------------------------------------------------------


Fran Evelyn Posted on 1997-04-15 13:18:46.0Z
From: "Fran Evelyn" <frances.evelyn@ons.octel.com>
Subject: More information on problem
References: <01bc492a$7a04cbc0$14477cce@fran>
Message-ID: <01bc49a8$4fd27fe0$bf487cce@fran>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.jdbcconnect
Date: Tue, 15 Apr 1997 09:18:46 -0400
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1012
Article PK: 252765

I tried switching the getDate and getTime statements, and the error still
occurs. So I assume it has something to do with getting the same result
twice.

Any help you can give us would be useful, at this point. Do you already
have a fix for this, or should we do a workaround? It's pretty urgent that
we get this running.

Fran.