Hello,
because of my project for the final exam I must learn Hibernate. Now I have already created a few tables, but I realised that if I create a table as it follows, I never get the type varchar, or char, but always Bigint..
Code:
<class name="User" table="cf_user">
<id name="u_Nr" type="long"> </id>
<property name="u_name" type="java.lang.String">
<column name="U_NAME" sql-type="varchar(25)" not-null="false" />
</property>
<property name="u_Kurzz" type="java.lang.String">
<column name="U_KURZZ" sql-type="varchar(6)" not-null="false" />
</property>
<property name="u_Tele" type="java.lang.String">
<column name="U_TELE" sql-type="varchar(20)" not-null="false" />
</property>
<property name="u_KOST" type="integer" />
<property name="u_Email" type="java.lang.String">
<column name="U_Email" sql-type="varchar(50)" not-null="false" />
</property>
</class>
I also tried
Code:
<property name="u_Email" type="string" />
<property name="u_Email" />
with the same result.
Actually that wouldn't disturb me. I can still insert data as usual, but if I try to update it in Eclipse, I always get these errormessage
Code:
update "DB"."USER" set "U_VORNAME"='Laverna' where "U_NR"=CAST(29609 AS BIGINT)
java.sql.SQLException: ORA-00902: Invalid Datatype
Error saving data
Can somebody please tell me the reason?
Greetings
Christina