• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Using non-qualified column reference Error

 
Sheriff
Posts: 9707
43
Android Google Web Toolkit Hibernate IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am creating an EJB3 application with jBoss 4.0.2 and MySql 5.0. I recently added a new table to the application and now when I try to update the value of a few columns, then I get this error

Using non-qualified column reference [marksMaths -> ([marksMaths])]


And the update doesn't happen. I am using this kind of query

update StudentMarks sm set sm.marksMaths = 0 where sm.studentId = ?1

The datatype of the column marksMaths in the EJB is short and in the MySql table it is tinyint(4). Can anyone help me with the cause of this error :roll: ...
 
Ankit Garg
Sheriff
Posts: 9707
43
Android Google Web Toolkit Hibernate IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry! It was my mistake :XD: . I was calling this code from an unmanaged object and then didn't refresh that object to reflect the database changes. Then I made a few other changes to the object and then merged the changes to the database so the changes made by this code were overwritten. I posted this question in the ORM forum too and I have said sorry there too ...
 
Check your pockets for water buffalo. You might need to use this tiny ad until locate a water buffalo:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic