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.

Large Amount of Data Driver Problem

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-17 22:07:28.0Z
Daniel Kaech Posted on 1997-04-17 07:09:23.0Z
Message-ID: <3355CCA3.70AC@sql.ch>
Date: Thu, 17 Apr 1997 09:09:23 +0200
From: Daniel Kaech <dkaech@sql.ch>
Reply-To: dkaech@sql.ch
Organization: SQL AG
X-Mailer: Mozilla 3.01Gold (WinNT; I)
MIME-Version: 1.0
Subject: Large Amount of Data Driver Problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:979
Article PK: 252732

Hi,

I detected an error in our purchased version of jConnect. When I
want to insert large amount of data a Exception is thrown:

...DriverManager.getConnection("jdbc:sybase:Tds:neptun:5000")
trying
driver[className=com.sybase.jdbc.SybDriver,context=null,com.sybase.jd
bc.SybDriver@1edf28]
getConnection returning
driver[className=com.sybase.jdbc.SybDriver,context=null,
com.sybase.jdbc.SybDriver@1edf28]
Successfully connectedjava.sql.SQLException: LONGVARCHAR parameters not
supporte
d by this Database.: LONGVARCHAR parameters not supported by this
Database.
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.tds.TdsParam.prepareForSend(Unknown Source)
at com.sybase.jdbc.ParamManager.checkParams(ParamManager.java)
at com.sybase.tds.Tds.language(Unknown Source)
at com.sybase.jdbc.SybStatement.sendQuery(SybStatement.java)
at com.sybase.jdbc.SybStatement.executeUpdate(SybStatement.java)
at
com.sybase.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStateme
nt.java)

When I do that with the latest version I downloaded the problem does not
exist.
The problem now is that the unsupported version runs better than the
purchased one.
Are you aware of that problem ?


David Clegg Posted on 1997-04-17 22:07:28.0Z
Message-ID: <33569F20.6AB66495@sybase.com>
Date: Thu, 17 Apr 1997 15:07:28 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: dkaech@sql.ch
Subject: Re: Large Amount of Data Driver Problem
References: <3355CCA3.70AC@sql.ch>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 68
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:969
Article PK: 252721

You'll note that the downloaded "Trial" version of the driver
announces itself as jConnect 2.1, whereas the GA version is
2.0. And, Yes, as you have surmised we have added client-side
support for LONGVARCHAR since the GA release.

As a paying customer, you have the right to ask Tech Support for
fixes etc. However, since this LONGVARCHAR limitation was a
documented limitation in the GA release... they may be a little
hesitant.

What I am pressing T.S. to do is to make available regularly
scheduled rollup's of the GA product (without the "nag" message
and the Time-Bomb) so that customers like you have a low-impact
way to see if a problem that you discover has been fixed:

1) download the latest GA rollup to see if that fixes your problem,
if so... happy you!

2) download the latest trial version to see if the problem goes away,
if so, ask T.S. to make a new rollup version w/the fix available

3) if the latest trial version doesn't solve the problem, open a
support case.

--------- HOWEVER ----------
The Tech Support staff have not accepted this approach (yet?) and
are extremely concerned with the proliferation of "supported" versions
of the driver which they might be asked to try to reproduce cases
against.

dave

>
> Hi,
>
> I detected an error in our purchased version of jConnect. When I
> want to insert large amount of data a Exception is thrown:
>
> ...DriverManager.getConnection("jdbc:sybase:Tds:neptun:5000")
> trying
> driver[className=com.sybase.jdbc.SybDriver,context=null,com.sybase.jd
> bc.SybDriver@1edf28]
> getConnection returning
> driver[className=com.sybase.jdbc.SybDriver,context=null,
> com.sybase.jdbc.SybDriver@1edf28]
> Successfully connectedjava.sql.SQLException: LONGVARCHAR parameters not
> supporte
> d by this Database.: LONGVARCHAR parameters not supported by this
> Database.
> at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
> at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
> at com.sybase.tds.TdsParam.prepareForSend(Unknown Source)
> at com.sybase.jdbc.ParamManager.checkParams(ParamManager.java)
> at com.sybase.tds.Tds.language(Unknown Source)
> at com.sybase.jdbc.SybStatement.sendQuery(SybStatement.java)
> at com.sybase.jdbc.SybStatement.executeUpdate(SybStatement.java)
> at
> com.sybase.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStateme
> nt.java)
>
> When I do that with the latest version I downloaded the problem does not
> exist.
> The problem now is that the unsupported version runs better than the
> purchased one.
> Are you aware of that problem ?