Java & J2EE Technology Blog

Learning the Java, Design Patterns, Spring Framework in simple way with working examples.

Pages

  • HOME
  • JAVA
  • OOPS
  • DESIGN PATTERNS
  • SPRING FRAMEWORK
  • DATABASE
  • ECLIPSE
  • JSON
  • HIVE
  • TOMCAT
  • About Me

DATABASE


GENERAL SOLUTIONS

  1. How to unlock table in SQL
  2. Mass data update on table in SQL

ORACLE

  1. Oracle Tutorial
  2. Oracle System Queries

OPEN SOURCE / IN-MEMORY DATABASE

  1. Apache Derby Database
  2. HypherSQL Database (HSQLDB)
  3. H2 Database

ERRORS & SOLUTION

  1. ORA-01439: column to be modified must be empty to change datatype
  2. ORA-28001: the password has expired
  3. SQL Error: ORA-00997: illegal use of LONG datatype
  4. java.sql.SQLException: ORA-01658: unable to create INITIAL extent for segment in tablespace
Email This BlogThis! Share to X Share to Facebook Share to Pinterest

No comments :

Post a Comment

Home
Subscribe to: Posts ( Atom )

Featured Post

Builder Design Pattern Using Java 8

INTRODUCTION Builder design pattern is mainly focused on creating a complex object. Creation of complex object will be done by the sequ...

Popular Posts

  • Custom Functions using Saxon HE
    INTRODUCTION Saxon is a powerful XSLT and XQuery Processor. Saxon has 3 versions. 1) HE-Home Edition, 2) PE-Professional Edit...
  • [SOLVED] /httpd.conf: ServerRoot must be a valid directory
    ERROR httpd.conf: ServerRoot must be a valid directory REASON Actual apache server installation path not set properly. SOLUTION ...
  • How to install Papyrus plugin in Eclipse Mars
    INTRODUCTION Papyrus is a UML tool which will help the developers to create UML Diagrams like Class Diagram, Use case diagram, Sequence...
  • insert values directly to hive tables
    INTRODUCTION Usually, we will be loading the data into hive table from HDFS file system while creating the table. This post will hel...

Blog Archive

  • ▼  2017 ( 12 )
    • ▼  May ( 1 )
      • Custom Functions using Saxon HE
    • ►  April ( 4 )
    • ►  March ( 7 )
  • ►  2016 ( 4 )
    • ►  August ( 3 )
    • ►  January ( 1 )
  • ►  2015 ( 27 )
    • ►  November ( 4 )
    • ►  October ( 7 )
    • ►  August ( 5 )
    • ►  July ( 2 )
    • ►  June ( 1 )
    • ►  March ( 1 )
    • ►  February ( 5 )
    • ►  January ( 2 )
  • ►  2014 ( 27 )
    • ►  September ( 5 )
    • ►  August ( 3 )
    • ►  July ( 12 )
    • ►  June ( 7 )

Pages

  • Privacy Policy
  • About Me
Powered by Blogger.