🚀 go-pugleaf

Thanks
Quinn Wildman escribi�:
> 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?