Databases
StackOverflow2013
Postsdbo
POJava DataType mismatch between Oracle and hibernate
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJava DataType mismatch between Oracle and hibernate
    primarykey
    data
    text
    <p>My java application is using hibernate with Oracle 10g as the database. I have landed into an issue and not able to proceed and i need your help here. Below is the issue that i am facing.</p> <p>I have a Column in one of my Oracle table which has a datatype of <code>Varchar2(1 byte)</code>. I want to know the proper dataype that i need to use in my pojo class. Also in the hibernate mapping file what should be the datatype for the same property. when i am running the file hibernate keeps on giving error like cannot do a conversion. below are my pojo and <code>.hbm</code> file</p> <pre><code>public class destination implements Serializable{ private String configId; private String isCurrent; //other properties and getter, setters } </code></pre> <p>destination.hbm.xml</p> <pre><code>&lt;class name="com.testing" table="configuration"&gt; &lt;id name="configID" type="java.lang.Integer"&gt; &lt;column name="configuration_id" /&gt; &lt;generator class="identity" /&gt; &lt;/id&gt; &lt;property name="isCurrent" type="Not-SURE"&gt; &lt;column name="is_current" not-null="true" /&gt; &lt;/property&gt; </code></pre> <p>The column i am talking about is the <code>isCurrent</code> property in the pojo and <code>.hbm.xml</code> file. Its defined as <code>Varchar2(1 byte)</code> in the db. I ma not sure about the datatype and marked it a <code>String</code> but the issue still persists.</p> <p>I have searched the net but have not got any proper solution for this issue.</p> <p>Can you please help me here as its really eating my head a lot.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBhesh Gurung
    1. USvikeng21
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJava DataType mismatch between Oracle and hibernate
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COIt would help if you posted the exact error message.
      singulars
      1. POJava DataType mismatch between Oracle and hibernate
      1. USAaron Kurtzhals
    2. COWhat datatypes did you try?
      singulars
      1. POJava DataType mismatch between Oracle and hibernate
      1. USdevang
    3. COhi gotuskar, I have tried String, Char and Byte as the datatype for isCurrent property in the pojo class but no luck. Also my main concern is the mapping in the hbm.xml file. here also tried but same issue. Hey Arron, i dont have the exact error message with me now but hibernate is trying t do a conversion for the isCurrent field by using the mapping in the hbm file.
      singulars
      1. POJava DataType mismatch between Oracle and hibernate
      1. USvikeng21
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload