Posts

Showing posts with the label RDBMS

ORM features in hibernate

Image
Hibernate is Object Relational Mapping(ORM) framework. Hibernate has the advantages while comparing with JDBC. That advantages will make developer life will be easy were implementing or maintaining the java application. Hibernate ORM features are, Hibernate gives the support of POJO/POJI model programming. It is also API independent. Light weight technology, no need of web or application servers. No byte code enhancement like EJB. Supports inheritance and polymorphism features. EJB component do not support inheritance. Pluggable with any Java/JEE or framework software based applications. The persistence logic of hibernate application can be access from all type of java client application. Gives implicit middleware services like jdbc connection pooling, transaction management etc.., Gives support to work with third party jdbc connection pooling. Support to call stored procedures and functions. Supports database indepen...

structured query language

SQL stands for 'Structured Query Language', which will use to interact with database to perform Create, Read, Update, Delete operations on database tables. SQL is also a language, where as SQL server is a database. To work on SQL, a Database software RDBMS is required. RDBMS stands as Relation Data Base Management System. SQL is not case sensitive. If your using Oracle SQL, you may get the below errors. If your using MySQL, you forget about this errors and move further for commands. Troubleshooting Oracle Error1. The account is locked Steps to rectify the error Login as username - 'system' & password - 'manager' or password - 'tiger' SQL> show user;        User is 'SYSTEM'         SQL> ALTER user<username> account unblock;        Ex:  ALTER  user scott account unlock;        User altered.        To c...