Why is just this one field of a Hibernate controlled object/entity not being created or updated?












0















I have an object "Chemical" that is updated according to entries in an HTML page. The data is returned to the Java code correctly, yet this one field is not updating or being created in the database. The chemical entity is defined as follows:



@Entity
@NamedQuery(name="Chemical.findAll", query="SELECT c FROM Chemical c")
public class Chemical implements Serializable {
@Id
@Column(name="chemical_id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int chemicalId;

...
private string formula; <--- THE FIELD THAT WILL NOT UPDATE/BE CREATED

....

public void setFormula(String formula) {
this.formula = formula;
}

public String getFormula() {
return this.formula;
}

.....


The Java code that actually saves/updates the database:



public void saveOrUpdate(final T data) throws CPDPersistenceException {
final EntityManager em = getEntityManager();
try {
final EntityTransaction transaction = em.getTransaction();
transaction.begin();
em.merge(data);
transaction.commit();
} catch (final PersistenceException e) {
throw new PersistenceException(e);
}
}


After the code is executed, other fields have changed in the database if changes have been made. However, "formula" is not changed and remains a NULL field. Can anybody see why?










share|improve this question























  • You need to add @Column(name="formula") above the variable.

    – Jake Stewart
    Nov 20 '18 at 20:03













  • I'll try that, but there are a bunch of other fields that are being populated correctly that do not have the @Column(name = WHATEVER) line above them.

    – calvinnme
    Nov 20 '18 at 20:31











  • Nope, you don't need to define the @Column on a field ... JPA defines defaults (read the JPA spec if not believing me). @Basic is the most that could be needed but most JPA providers don't require that since String is a supported type

    – Billy Frost
    Nov 21 '18 at 8:45













  • Also your post doesnt say whether the object is already persistent, whether you created the schema before adding that field, what the schema is, what SQL is invoked when you invoke a JPA operation. All of this is basic info for debugging

    – Billy Frost
    Nov 21 '18 at 8:59
















0















I have an object "Chemical" that is updated according to entries in an HTML page. The data is returned to the Java code correctly, yet this one field is not updating or being created in the database. The chemical entity is defined as follows:



@Entity
@NamedQuery(name="Chemical.findAll", query="SELECT c FROM Chemical c")
public class Chemical implements Serializable {
@Id
@Column(name="chemical_id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int chemicalId;

...
private string formula; <--- THE FIELD THAT WILL NOT UPDATE/BE CREATED

....

public void setFormula(String formula) {
this.formula = formula;
}

public String getFormula() {
return this.formula;
}

.....


The Java code that actually saves/updates the database:



public void saveOrUpdate(final T data) throws CPDPersistenceException {
final EntityManager em = getEntityManager();
try {
final EntityTransaction transaction = em.getTransaction();
transaction.begin();
em.merge(data);
transaction.commit();
} catch (final PersistenceException e) {
throw new PersistenceException(e);
}
}


After the code is executed, other fields have changed in the database if changes have been made. However, "formula" is not changed and remains a NULL field. Can anybody see why?










share|improve this question























  • You need to add @Column(name="formula") above the variable.

    – Jake Stewart
    Nov 20 '18 at 20:03













  • I'll try that, but there are a bunch of other fields that are being populated correctly that do not have the @Column(name = WHATEVER) line above them.

    – calvinnme
    Nov 20 '18 at 20:31











  • Nope, you don't need to define the @Column on a field ... JPA defines defaults (read the JPA spec if not believing me). @Basic is the most that could be needed but most JPA providers don't require that since String is a supported type

    – Billy Frost
    Nov 21 '18 at 8:45













  • Also your post doesnt say whether the object is already persistent, whether you created the schema before adding that field, what the schema is, what SQL is invoked when you invoke a JPA operation. All of this is basic info for debugging

    – Billy Frost
    Nov 21 '18 at 8:59














0












0








0








I have an object "Chemical" that is updated according to entries in an HTML page. The data is returned to the Java code correctly, yet this one field is not updating or being created in the database. The chemical entity is defined as follows:



@Entity
@NamedQuery(name="Chemical.findAll", query="SELECT c FROM Chemical c")
public class Chemical implements Serializable {
@Id
@Column(name="chemical_id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int chemicalId;

...
private string formula; <--- THE FIELD THAT WILL NOT UPDATE/BE CREATED

....

public void setFormula(String formula) {
this.formula = formula;
}

public String getFormula() {
return this.formula;
}

.....


The Java code that actually saves/updates the database:



public void saveOrUpdate(final T data) throws CPDPersistenceException {
final EntityManager em = getEntityManager();
try {
final EntityTransaction transaction = em.getTransaction();
transaction.begin();
em.merge(data);
transaction.commit();
} catch (final PersistenceException e) {
throw new PersistenceException(e);
}
}


After the code is executed, other fields have changed in the database if changes have been made. However, "formula" is not changed and remains a NULL field. Can anybody see why?










share|improve this question














I have an object "Chemical" that is updated according to entries in an HTML page. The data is returned to the Java code correctly, yet this one field is not updating or being created in the database. The chemical entity is defined as follows:



@Entity
@NamedQuery(name="Chemical.findAll", query="SELECT c FROM Chemical c")
public class Chemical implements Serializable {
@Id
@Column(name="chemical_id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int chemicalId;

...
private string formula; <--- THE FIELD THAT WILL NOT UPDATE/BE CREATED

....

public void setFormula(String formula) {
this.formula = formula;
}

public String getFormula() {
return this.formula;
}

.....


The Java code that actually saves/updates the database:



public void saveOrUpdate(final T data) throws CPDPersistenceException {
final EntityManager em = getEntityManager();
try {
final EntityTransaction transaction = em.getTransaction();
transaction.begin();
em.merge(data);
transaction.commit();
} catch (final PersistenceException e) {
throw new PersistenceException(e);
}
}


After the code is executed, other fields have changed in the database if changes have been made. However, "formula" is not changed and remains a NULL field. Can anybody see why?







java hibernate jpa






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 20 '18 at 19:50









calvinnmecalvinnme

74




74













  • You need to add @Column(name="formula") above the variable.

    – Jake Stewart
    Nov 20 '18 at 20:03













  • I'll try that, but there are a bunch of other fields that are being populated correctly that do not have the @Column(name = WHATEVER) line above them.

    – calvinnme
    Nov 20 '18 at 20:31











  • Nope, you don't need to define the @Column on a field ... JPA defines defaults (read the JPA spec if not believing me). @Basic is the most that could be needed but most JPA providers don't require that since String is a supported type

    – Billy Frost
    Nov 21 '18 at 8:45













  • Also your post doesnt say whether the object is already persistent, whether you created the schema before adding that field, what the schema is, what SQL is invoked when you invoke a JPA operation. All of this is basic info for debugging

    – Billy Frost
    Nov 21 '18 at 8:59



















  • You need to add @Column(name="formula") above the variable.

    – Jake Stewart
    Nov 20 '18 at 20:03













  • I'll try that, but there are a bunch of other fields that are being populated correctly that do not have the @Column(name = WHATEVER) line above them.

    – calvinnme
    Nov 20 '18 at 20:31











  • Nope, you don't need to define the @Column on a field ... JPA defines defaults (read the JPA spec if not believing me). @Basic is the most that could be needed but most JPA providers don't require that since String is a supported type

    – Billy Frost
    Nov 21 '18 at 8:45













  • Also your post doesnt say whether the object is already persistent, whether you created the schema before adding that field, what the schema is, what SQL is invoked when you invoke a JPA operation. All of this is basic info for debugging

    – Billy Frost
    Nov 21 '18 at 8:59

















You need to add @Column(name="formula") above the variable.

– Jake Stewart
Nov 20 '18 at 20:03







You need to add @Column(name="formula") above the variable.

– Jake Stewart
Nov 20 '18 at 20:03















I'll try that, but there are a bunch of other fields that are being populated correctly that do not have the @Column(name = WHATEVER) line above them.

– calvinnme
Nov 20 '18 at 20:31





I'll try that, but there are a bunch of other fields that are being populated correctly that do not have the @Column(name = WHATEVER) line above them.

– calvinnme
Nov 20 '18 at 20:31













Nope, you don't need to define the @Column on a field ... JPA defines defaults (read the JPA spec if not believing me). @Basic is the most that could be needed but most JPA providers don't require that since String is a supported type

– Billy Frost
Nov 21 '18 at 8:45







Nope, you don't need to define the @Column on a field ... JPA defines defaults (read the JPA spec if not believing me). @Basic is the most that could be needed but most JPA providers don't require that since String is a supported type

– Billy Frost
Nov 21 '18 at 8:45















Also your post doesnt say whether the object is already persistent, whether you created the schema before adding that field, what the schema is, what SQL is invoked when you invoke a JPA operation. All of this is basic info for debugging

– Billy Frost
Nov 21 '18 at 8:59





Also your post doesnt say whether the object is already persistent, whether you created the schema before adding that field, what the schema is, what SQL is invoked when you invoke a JPA operation. All of this is basic info for debugging

– Billy Frost
Nov 21 '18 at 8:59












1 Answer
1






active

oldest

votes


















0














There is I think a difference between UPDATE and CREATE.



Try to replace em.merge(data) with em.persist(data)



Does it save the content the first time you create a new row with persist ?
What is the length of your string definition in the database ?
Check the database logs whenever the HQL is run from your code, do the log complain at one point during the persist ?



It might be necessary to first test if the row exists before you can run a merge.






share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400533%2fwhy-is-just-this-one-field-of-a-hibernate-controlled-object-entity-not-being-cre%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    There is I think a difference between UPDATE and CREATE.



    Try to replace em.merge(data) with em.persist(data)



    Does it save the content the first time you create a new row with persist ?
    What is the length of your string definition in the database ?
    Check the database logs whenever the HQL is run from your code, do the log complain at one point during the persist ?



    It might be necessary to first test if the row exists before you can run a merge.






    share|improve this answer




























      0














      There is I think a difference between UPDATE and CREATE.



      Try to replace em.merge(data) with em.persist(data)



      Does it save the content the first time you create a new row with persist ?
      What is the length of your string definition in the database ?
      Check the database logs whenever the HQL is run from your code, do the log complain at one point during the persist ?



      It might be necessary to first test if the row exists before you can run a merge.






      share|improve this answer


























        0












        0








        0







        There is I think a difference between UPDATE and CREATE.



        Try to replace em.merge(data) with em.persist(data)



        Does it save the content the first time you create a new row with persist ?
        What is the length of your string definition in the database ?
        Check the database logs whenever the HQL is run from your code, do the log complain at one point during the persist ?



        It might be necessary to first test if the row exists before you can run a merge.






        share|improve this answer













        There is I think a difference between UPDATE and CREATE.



        Try to replace em.merge(data) with em.persist(data)



        Does it save the content the first time you create a new row with persist ?
        What is the length of your string definition in the database ?
        Check the database logs whenever the HQL is run from your code, do the log complain at one point during the persist ?



        It might be necessary to first test if the row exists before you can run a merge.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 20 '18 at 21:04









        ApolloApollo

        362




        362
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400533%2fwhy-is-just-this-one-field-of-a-hibernate-controlled-object-entity-not-being-cre%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Guess what letter conforming each word

            Port of Spain

            Run scheduled task as local user group (not BUILTIN)