imo the columns defined as int(7) are the problem. according to hsqldb doc BIGINT is used for long.
hth jakob
Glauber Andrade wrote:
Hi,
I was using Mysql and everything works fine. Now i am changing to Hsqldb and i got some problems.
When I try to get the object "NotaRecibo" i got the exception: java.sql.SQLException: Wrong data type
What could be wrong ? "create table"? "class-descriptor" ? "object definition" ?
PLEASE
Thanks,
Glauber
-----------------------------------------------------------------------------
<class-descriptor
class="c.m.s.d.NotaRecibo"
table="notasrecibos"
>
<field-descriptor
name="id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/>
<field-descriptor
name="id_prestador"
column="prestador"
jdbc-type="BIGINT"
/>
<reference-descriptor
name="prestador"
class-ref="c.m.s.d.Prestador"
>
<foreignkey field-ref="id_prestador"/>
</reference-descriptor>
<field-descriptor
name="id_servico"
column="servico"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="servico"
class-ref="c.m.s.d.ServicoJuridico"
>
<foreignkey field-ref="id_servico"/>
</reference-descriptor>
<field-descriptor
name="data"
column="DATA"
jdbc-type="DATE"
/>
<field-descriptor
name="valor"
column="VALOR"
jdbc-type="DOUBLE"
/>
<collection-descriptor
name="excessoes"
element-class-ref="c.m.s.d.NotaRecibo_Excessao"
auto-retrieve="true"
auto-update="true"
auto-delete="true"
refresh="true" >
<inverse-foreignkey field-ref="id_notaRecibo"/>
</collection-descriptor>
</class-descriptor>
-----------------------------------------------------------------------------
public class NotaRecibo {
private long id;
private Prestador prestador;
private ServicoJuridico servico;
private Date data;
private double valor;
private long id_prestador;
private int id_servico;
private Vector excessoes;
-----------------------------------------------------------------------------
CREATE TABLE notasrecibos (" +
"id INTEGER IDENTITY," +
"prestador INT(7) NOT NULL," +
"servico INT(7) NOT NULL," +
"valor FLOAT(8,2) NOT NULL," +
"data DATE NOT NULL," +
"FOREIGN KEY (prestador) REFERENCES Prestadores(id),"+
"FOREIGN KEY (servico) REFERENCES ServicosJuridico(id))"
);
-----------------------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
