Some Trials & a lot of Errors
I tried a bunch of framework and other language and I usually feel overwhelm when its time to do something real with what I've learned. So that why I created this site, to write my progress and help some noob like me that stumble into the sames problems.
Browse: Home / db

db

Update table using Inner Join return ORA-00933

By Chris on September 13, 2014

I was trying to update a table that using sql join but I kept getting ORA-00933   I tried the following: Using A SQL JOIN In A SQL UPDATE Statement Using A SQL JOIN In A SQL UPDATE Statement (www.bennadel.com) update table using inner join (venushuynh.wordpress.com) but I kept getting the ORA-00933 then tried this Oracle […]

Posted in db | Tagged db, error, oracle | Leave a response

Hibernate Session saveOrUpdate does not update

By Chris on September 7, 2014

Another problem I’ve it recently with saveOrUpdate that can be fix by using the same saveOrUpdate but give the class name. Using the session.saveOrUpdate(myObject) might give you a unknown entity while using the same method with the class name in parameter won’t. session.saveOrUpdate(myObject); //give a unknown entity session.saveOrUpdate(“MyObjectClassName”, MyObject); //Work The important difference between the […]

Posted in db, prog | Tagged db, hibernate | Leave a response

[Oracle Fun] Converting ORACLE to mySQL datatype

By Chris on August 2, 2014

  I had in the past had to work with oracle and had to convert it to mysql. Unfortunately (or fortunately) that project was cancel but here are the bit of information I’ve found that I didn’t know about and made me lost a lot of time.   Oracle vs mySQL datatype edition From mySQL […]

Posted in db, prog | Tagged db, migration, mysql, oracle | Leave a response

Tags

2018 2022 app apparment baby book books cleaner date daycare db fantasy draft fantasy sports food foods fridge games gifts grocery hibernate hockey hockey pools ideas inspiration java java.util.List learning List meal plan meal planner motivation mysql oracle productivity retail shopping reviews service social games sql String students The Practice to_date uber wedding

Recent Comments

  • pawan on How to update an entry in an array in mongodb with java MongoTemplate?
  • kevin on Oracle have no Boolean, how to fix this

Calendar

March 2023
MonTueWedThuFriSatSun
 12345
6789101112
13141516171819
20212223242526
2728293031 
« Dec  

Archives

  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • March 2021
  • February 2021
  • May 2020
  • January 2019

Copyright © 2023 Some Trials & a lot of Errors.

Powered by WordPress and Hybrid.