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

  • [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 ...
  • 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] SQL Error: ORA-00997: illegal use of LONG datatype
    ISSUE SQL Error: ORA-00997: illegal use of LONG datatype SOLUTION Consider I have a table with values as below and need to copy t...
  • Factory Method Design Pattern in Java
    INTRODUCTION Factory Method Design pattern is categorized under Creational Patterns. It deals with the creation of object based on t...

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.