Subject Re: [Firebird-Java] What is this exception?
Author Francisco Antonio Vieira Souza
Jim Starkey wrote:

>
>
> Francisco Antonio Vieira Souza wrote:
>
> > Please, could anybody tell me why I get this exception?
> >
> > org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321. No
> > message for code 335544321 found.
> > at
> >
> org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:453)
> > at
> >
> org.firebirdsql.jdbc.AbstractCallableStatement.internalExecute(AbstractCallableStatement.java:284)
> > at
> >
> org.firebirdsql.jdbc.AbstractCallableStatement.execute(AbstractCallableStatement.java:150)
> > at
> >
> br.com.modulos.conhecimentos.setSalvarConhecimento2(conhecimentos.java:4643)
> >
> You had an "arithmetic exception" -- a catch all for almost any string
> or numeric overflow.
>
> --
>
> Jim Starkey
> Netfrastructure, Inc.
> 978 526-1376

Yes, indeed it is exactly what you said, the question is: why this just
happens in a single machine?
In the other ones everything goes fine.

Following is the block where the exeception occurs (which I dont know
exactly WHERE):
try
{
p = co.prepareCall("{call SP_SET_SALVAR_CONHECIMENTO(?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?,
?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,
?, ?, ?, ?, ?, ?, ?)}");
p.setString(1, remetente );
p.setString(2, destinatario );
p.setString(3, tomador );
p.setString(4, redespacho );
p.setString(5, pago);
p.setString(6, placa_veiculo1);
p.setString(7, placa_veiculo2);
p.setInt(8, codigo_tarifa);
p.setString(9, especie);
p.setString(10, natureza);
p.setString(11, mensagem);
p.setDouble(12, valor_notas );
p.setDouble(13, total_peso );
p.setDouble(14, comprimento );
p.setDouble(15, largura );
p.setDouble(16, altura );
p.setDouble(17, medida );
p.setDouble(18, quantidade );
p.setString(19, pago_pagar);
p.setDouble(20, metros_cubicos );
p.setDouble(21, valor_frete_peso_volume );
p.setDouble(22, taxa_sobre_frete );
p.setDouble(23, valor_sec_cat );
p.setDouble(24, valor_despacho );
p.setDouble(25, valor_pedagio );
p.setDouble(26, valor_gris );
p.setDouble(27, valor_autonomo );
p.setDouble(28, valor_coleta );
p.setDouble(29, valor_outros );
p.setDouble(30, total_prestacao );
p.setDouble(31, base_calculo_icms );
p.setDouble(32, aliquota_icms );
p.setDouble(33, valor_icms );
p.setDouble(34, aliquota_cofins );
p.setDouble(35, aliquota_pis );
p.setDouble(36, aliquota_irpj );
p.setDouble(37, aliquota_cssl );
p.setDouble(38, aliquota_inss );
p.setDouble(39, aliquota_darf );
p.setDouble(40, subst_tributaria );
p.setDouble(41, aliquota_taxa_servicos );

if (campoDataEmissao.getText().length()==0)
p.setNull(42,java.sql.Types.DATE);
else
p.setDate(42, data_emissao);

if (horaEmissao.getText().length()==0)
p.setNull(43,java.sql.Types.TIME);
else
p.setTime(43, java.sql.Time.valueOf(horaEmissao.getText()+":00"));

p.setNull(44,java.sql.Types.DATE);
p.setNull(45,java.sql.Types.TIME);
p.setNull(46,java.sql.Types.DATE);
p.setNull(47,java.sql.Types.TIME);
p.setString(48, calculado_ate );
p.setString(49, cfop );
p.setString(50, quem_faturou );
p.setDouble(51, valor_da_faixa_frete_peso );
p.setString(52, cpf_motorista );
p.setDouble(53, percentual_sobre_notas );
p.setDouble(54, valor_frete );
p.setInt(55, id_end_remetente);
p.setInt(56, id_end_destinatario);
p.setInt(57, id_end_tomador);
p.setInt(58, id_end_redespacho);
p.execute(); }