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
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
"J" <jtotall...@sbcglobal.net> ha scritto nel messaggio
news:408077cc...@forums.sybase.com...
Under your jConnect dir there is a "sp" dir. The metadata is
sql_asa.sql
Jay