🚀 go-pugleaf

SET SQL DIALECT is not a SQL command the interbase server understands. 
So, you cannot do it with interclient. use datasource.setSQLDialect(n) 
to set the SQL Dialect.

Luzem wrote:
> 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?