Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with jconnect55

27 views
Skip to first unread message

Start Software s.r.l.

unread,
Apr 14, 2004, 12:12:15 PM4/14/04
to
i have upgraded a db from asa8 to the latest asa9, downloaded the latest
jconnect 55 driver and started to test my web application. Everything works
fine but this query:

SELECT A.id_articolo, A.codice, A.descrizione , G.id_web_gruppi
FROM articolo A, web_art_grp G
WHERE A.id_cat_com_articolo = 15
AND A.id_Articolo *= G.id_Articolo
and G.id_web_gruppi = 3
and 1=1
GROUP BY A.codice, A.id_Articolo, A.descrizione , G.id_web_gruppi
having id_web_gruppi is null and count(*) <= 1000
order by A.codice

when i run this query i get this error:
java.sql.SQLException: JZ006: Caught IOException: java.io.IOException:
JZ0TC: Attempted conversion between an illegal pair of types.
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:485)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2966)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2029)
at com.sybase.jdbc2.tds.TdsResultSet.nextResult(TdsResultSet.java:512)
at com.sybase.jdbc2.tds.TdsResultSet.next(TdsResultSet.java:298)
at com.sybase.jdbc2.jdbc.SybResultSet.next(SybResultSet.java:137)
at com.sybase.jisql.ResultSetVectors.getVector(ResultSetVectors.java:73)
at com.sybase.jisql.ResultSetVectors.<init>(ResultSetVectors.java:27)
at com.sybase.jisql.ExecQueryThread.executeIt(ExecQueryThread.java:162)
at com.sybase.jisql.ExecQueryThread.run(ExecQueryThread.java:85)

I tried with Jisql and get the same error. If i run the same query using the
old asa8 db everything works fine.

any suggestions???


Simone Olianti Start Software srl ( 0575382792 Cell. 3292771392 Via delle
Biole, 2 * starts...@virgilio.it 52100 AREZZO (AR) &
http://xoomer.virgilio.it/startsoftware


J

unread,
Apr 16, 2004, 9:13:22 PM4/16/04
to
On 14 Apr 2004 08:12:15 -0800, "Start Software s.r.l."
<starts...@virgilio.it> wrote:


Not sure. Can you run the same query successfully with the jisql
utility? Did you install the metadata on the new server?

If you can't figure out something from this, you would probably want
to run with debugging and the jconn2d.jar and then next open a support
case with Sybase support and your reproduction information.

J

Start Software s.r.l.

unread,
Apr 22, 2004, 3:52:09 AM4/22/04
to
I can't run the same query in Jisql utility because i get the same error..
How do i install the metadata on the new server??


"J" <jtotall...@sbcglobal.net> ha scritto nel messaggio
news:408077cc...@forums.sybase.com...

J

unread,
Apr 23, 2004, 8:33:10 PM4/23/04
to
On 22 Apr 2004 00:52:09 -0700, "Start Software s.r.l."
<starts...@virgilio.it> wrote:

Under your jConnect dir there is a "sp" dir. The metadata is
sql_asa.sql

Jay

0 new messages