Article View: borland.public.interbase.interclient
Article #29Problems with interclient 1.6 and Interbase 6
From: Luzem
Date: Mon, 07 Aug 2006 02:50
Date: Mon, 07 Aug 2006 02:50
43 lines
2410 bytes
2410 bytes
I'm runing Windows XP SP2 and when try move in a ResultSet I Obtain a
SQLException
//I open a connection, loading the driver (I don't put try{}catch(){}):
Class.forName("interbase.interclient.Driver");
Connection
Conexion=DriverManager.getConnection("jdbc:interbase://127.0.0.1/C:/COSA.gdb","pepito","pepito");
//make a Statement
Statement stmArticulos= conecta.getConexion().createStatement();
//make a query (Ok the database desing sucks but isn't my desing)
//change the dialect
stmArticulos.executeQuery("SET SQL DIALECT 1;");
ResultSet rsArticulos=stmArticulos.executeQuery("select
PK_ARTICULO,MODIFICACION,REFERENCIA,NOMBRE,TIPO_IVA,TIPO_RECARGO,PVP1,PVP1_IVA,PVP2,PVP2_IVA,PVP3,PVP3_IVA,PVP4,PVP4_IVA
from articulos")
//and try to move arround the resulset
do{
System.out.println(this.getRsArticulos().getString(1));
}while (this.getRsArticulos().next());
and obtain a dialect error
Ok I read some webs and the problem must be in the Dialect
If Dialect is set to 3,2 or 1 I obtain this exception:
interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Token unknown - line 1, char 4
SQL
If i not set dialect removing the line stmArticulos.executeQuery("SET
SQL DIALECT 1;"); I obtain this exception:
interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -206
Column unknown
TIPO_IVA
Client SQL dialect 1 does not support reference to 64-bit numeric datatype
๏ฟฝSomeone can help me?
Technical Details
Message-ID:
<44d6aa75$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: f54da,23e9c41c93085b9c,start X-Google-Attributes: gidf54da,public X-Google-Language: ENGLISH,ASCII Date: Mon, 07 Aug 2006 04:50:32 +0200 From: Luzem <luzemail@gmail.com> User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 Newsgroups: borland.public.interbase.interclient Subject: Problems with interclient 1.6 and Interbase 6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 83.34.21.128 Message-ID: <44d6aa75$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1154919029 83.34.21.128 (6 Aug 2006 19:50:29 -0700) Lines: 43 Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail