DERBY

Set Environment Variable
Path=C:\Program Files\Java\jdk1.7.0_04\db\bin;
DERBY_HOME= C:\Program Files\Java\jdk1.7.0_67\db
CLASSPATH=%DERBY_HOME%\lib\derby.jar;%DERBY_HOME%\lib\derbytools.jar;.
--------------------------------
VERIFY DERBY
 --------------------------------
sysinfo.bat
--------------------------------
START NETWORK SERVER
--------------------------------
startNetworkServer.bat
--------------------------------
START Command Line Client
--------------------------------
ij
java  org.apache.derby.tools.ij -p ij.properties
--------------------------------
NOTE: EVERY COMMAND END WITH SEMICOLON (;)
--------------------------------
HELP in ij
--------------------------------
ij>help;
ij>SHOW CONNECTIONS;
ij>SHOW TABLES;
ij>SHOW TABLES IN APP;
ij>DESCRIBE APP.CUSTOMERS;
ij>DISCONNECT;
ij>EXIT;
ij>DROP TABLE [TableName]
ij>SET SCHEMA APP
--------------------------------
CREATE & CONNECT NETWORK DATABASE
--------------------------------
ij>connect 'jdbc:derby://localhost:1527/MyDB;create=true;user=APP;password=APP';
ij>connect 'jdbc:derby://localhost:1527/MyDB;user=APP;password=APP';
ij>connect 'jdbc:derby:MyDB;user=APP;password=APP';
--------------------------------
ij command line tool with default settings from file (ij.properties)
--------------------------------
ij.user=APP
ij.database=MyDB;create=true;
ij.protocol=jdbc:derby:
derby.connection.requireAuthentication=true
derby.user.APP=APP
--------------------------------
Loading properties file
--------------------------------
ij>ij -p ij.properties
java org.apache.derby.tools.ij -p ij.properties

java -cp "target/dependency/*"  org.apache.derby.tools.ij -p ij.properties
--------------------------------
CREATE and LOAD database from SQL  File
--------------------------------
ij>run 'create_classicmodels.sql';
ij>run 'load_classicmodels.sql';
java org.apache.derby.tools.ij my_file.sql

--------------------------------
Derby Maven
--------------------------------
mvn dependency:copy-dependencies
--------------------------------
Derby in POM
--------------------------------
 <?xml version="1.0" encoding="UTF-8"? >
 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" >
     <modelVersion >4.0.0 </modelVersion >
     <groupId >com.mastertheboss </groupId >
     <artifactId >EclipseJPAExample </artifactId >
     <version >1.0-SNAPSHOT </version >
     <repositories >
         <repository >
             <id >EclipseLink Repo </id >
             <url >http://download.eclipse.org/rt/eclipselink/maven.repo </url >
             <name >EclipseLink Repo </name >
         </repository >
     </repositories >
     <dependencies >
         <dependency >
             <groupId >org.apache.derby </groupId >
             <artifactId >derby </artifactId >
             <version >10.8.2.2 </version >
         </dependency >
         <dependency >
             <groupId >org.apache.derby </groupId >
             <artifactId >derbytools </artifactId >
             <version >10.8.2.2 </version >
         </dependency >
         <dependency >
             <groupId >org.eclipse.persistence </groupId >
             <artifactId >eclipselink </artifactId >
             <version >2.2.1 </version >
         </dependency >
         <dependency >
             <groupId >org.eclipse.persistence </groupId >
             <artifactId >javax.persistence </artifactId >
             <version >2.0.3 </version >
         </dependency > 
     </dependencies >
 </project >
--------------------------------
Help URL
--------------------------------
http://zetcode.com/db/apachederbytutorial/
--------------------------------
Sample
--------------------------------
ij>connect 'jdbc:derby://localhost:1527/myDB;user=me;password=mine';
ij>create table foo (id integer, name varchar(20));
ij>insert into foo values (1, 'derby');
ij>insert into foo values (2, 'derby plug-ins');
ij>disconnect;
ij>exit;
Derby Embedded Server
ij>connect 'jdbc:derby:myDB;create=true;user=me;password=mine';

SPRING ROO

---------------------
   HINT & HELP
---------------------
- use TAB or CTRL + SPACE regularly for discovering
  mandatory and optional attributes, and their pre-defined values
- help  (ex: help project)
- hint topics (all avilable topics)
- Running Roo script file (ex: roo.bat script --file bikeshop.roo)
- Spring Roo Beginning
- Spring Roo Command Index
---------------------
     PROJECT
---------------------
- project --topLevelPackage sample.roo.flightapp --java 6 --projectName flight-app
---------------------
  PERSISTENCE
---------------------
*************
  ROO DBRE
*************
- osgi start --url file:/C:/driver/mysql-connector-java-5.1.18-bin.jar
- osgi ps
- persistence setup --provider HIBERNATE --database MYSQL --jndiDataSource
- persistence setup --provider HIBERNATE --database MYSQL --databaseName test --userName root --password 123 --hostName localhost
- database introspect --schema test  --file --enableViews
- database introspect --schema test.student  --file --enableViews
- database introspect --schema no-schema-required
- database reverse engineer --schema test --excludeTables jbpm4_*
  --package ~.domain
*************
    JPA 
************* 
- jpa setup --provider HIBERNATE --database HYPERSONIC_IN_MEMORY
- jpa setup --provider HIBERNATE --database MYSQL --databaseName test --userName root --password 123 --hostName localhost
- hint 
- entity jpa --class ~.Timer --testAutomatically
- field string code --notNull --sizeMin 1 --sizeMax 30
- field string email --sizeMax 30
- field number attending --type java.lang.Integer
- field string specialRequests --sizeMax 100
- field date confirmed --type java.util.Date
---------------------
      PERFORM
---------------------
- perform package
- perform eclipse
- perform command --mavenCommand eclipse:eclipse (execute maven goal)
---------------------
      LOGGING
---------------------
- logging setup --level DEBUG --package ROOT
---------------------
---------------------
     SECURITY
---------------------
- security setup
---------------------
---------------------
     E-MAIL
---------------------
- email sender setup --hostServer 127.0.0.1
- field email template --class ~.web.PublicRsvpController
---------------------
     PROPERTIES
---------------------
- modify properties
- properties list --name log4j.properties --path SRC_MAIN_RESOURCES
- database properties list
- database properties set --key database.url --value jdbc:hsqldb:${user.home}/my-wedding
- database properties list
---------------------
         MVC
---------------------
- hint web mvc
- web mvc setup / - web flow
- web mvc scaffold ~.web.TimerController
- web mvc all --package ~.web
- finder list --class ~.domain.Rsvp --filter code,equ
- finder add --finderName findRsvpsByCodeEquals
---------------------
      TOMCAT
---------------------
- mvn clean install tomcat7:run
- mvn tomcat7:run
- perform command --mavenCommand tomcat:run
---------------------
- exit
- quit
----------------------------------
SEQUENCE in ROO SHELL
----------------------------------
project --topLevelPackage com.jini.classicmodels
persistence setup --provider HIBERNATE --database MYSQL --databaseName classicmodels --userName root --password 111
database reverse engineer --schema classicmodels --package ~.domain
web mvc setup
web mvc all --package ~.web
perform package
perform eclipse
quit
mvn clean install tomcat7:run
mvn tomcat7:run

Initialize and access Spring in Web Application

---------------------------------------------------------- 
Initialize Spring  in web.xml
<listener>
    <listener-class>
        org.springframework.web.context.ContextLoaderListener
    </listener-class>
</listener>
<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>/WEB-INF/spring/application-context.xml</param-value>
</context-param>
----------------------------------------------------------
Get Access to Spring Container
- getRequiredWebApplicationContext()
- getWebApplicationContext() of WebApplicationContextUtils:
----------------------------------------------------------

Spring JDBC Logging

# Root logger option
log4j.rootLogger=DEBUG, file, stdout

# Daily rolling file appender
log4j.appender.file=org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.File=logs/jdbc.log
log4j.appender.file.Append=true
log4j.appender.file.DatePattern='.'dd-MM-yyyy
log4j.appender.file.encoding=UTF-8
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{dd-MM-yyyy HH:mm:ss} %-5p %c{1}:%L - %m%n
#log4j.appender.file.layout.ConversionPattern=%p %t %c - %m%n

# Direct log messages to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L -  %m%n`
#log4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p %c - %m%n
#log4j.appender.stdout.layout.ConversionPattern=%p %t %c - %m%n

# Spring JDBC logging
log4j.logger.org.springframework.jdbc=DEBUG
log4j.logger.org.springframework.jdbc.core.JdbcTemplate=DEBUG, file
log4j.logger.org.springframework.jdbc.core.StatementCreatorUtils=TRACE, file

# Spring Transaction logging
log4j.logger.org.springframework.transaction=INFO
log4j.logger.org.springframework.transaction.interceptor=TRACE
#log4j.logger.org.springframework.jdbc.datasource.DataSourceTransactionManager=DEBUG
#log4j.logger.org.springframework.orm.jpa=INFO

# Hibernate Transaction logging
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.engine.transaction=DEBUG
log4j.logger.org.springframework.orm.hibernate3.HibernateTransactionManager=DEBUG

# BoneCP Connection Pooling logging
#log4j.category.com.jolbox=DEBUG,stdout


-------------------------------------------------------------------------------
Note: Spring JDBCTemplate is using common-logging API to log.
And if you are using log4j in your application, you will have to add
common logging bridge for the same. Add following in your pom.xml
<dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-jcl</artifactId>
    <version>2.0-rc1</version>
</dependency>
-------------------------------------------------------------------------------
Note: Logging Spring in IBM Websphere click -------------------------------------------------------------------------------

Hibernate and JPA

• JPA Basics
• Hibernate and JPA Tutorial

Spring with Log4j Initialization

import org.apache.log4j.BasicConfigurator;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class zzZZMain {
    private static ApplicationContext context = null;
    static {
        BasicConfigurator.configure();
        context = new ClassPathXmlApplicationContext("classpath*:com/jini/TESTING/application*.xml");
        }
    public static Object getBean(String beanName) {
        return context.getBean(beanName);
    }
    public static void main(String[] args) throws Exception {
        System.out.println("--------- SpRiNg and lOg4j iNiTiaLiZaTion successfull --------");
    } // end of main()
} // end of class

Annotations Tutorial

• Part 1: Spring Annotations
• Part 2: Hibernate - JPA Annotations
• Part 3: RESTful Web Service - JAX-RS Annotations
• Part 4: JAXB Annotations
• Part 5: Spring - jUnit Annotations 
• Toplink JPA Annotations
• Hibernate / JPA 2 Persistence Annotations Tutorial
• JPA API Reference
• Hibernate Tutorials