jaehoo

#! /bin/sh

### BEGIN INIT INFO
# Provides:          JBOSS
# Required-Start:    
# Required-Stop:     
# Default-Start:     5
# Default-Stop:      
# Description:       Start Jboss Aplication Server 6.2
### END INIT INFO

jaehoo

#!/bin/bash

##
# Install Oracle/Sun Java JDK/JRE 6 on openSUSE
##

#JDK_HOME
echo -n "Enter JDK_HOME:"
read path

jaehoo

##
# Install Oracle/Sun Java JDK/JRE 6 on openSUSE
##

# Update this with JDK_HOME
JDK_HOME=/usr/java/jdk1.6.0_29

# Normally not changed. Used to detect architecture, and set helper variables
MACHINE_TYPE=`uname -m`
if [ ${MACHINE_TYPE} == 'x86_64' ]; then

jaehoo

#!/bin/bash

### BEGIN INIT INFO
# Provides:        tomcat7
# Required-Start:  $network
# Required-Stop:   $network
# Default-Start:   2 3 4 5
# Default-Stop:    0 1 6
# Short-Description: Start/Stop Tomcat server
### END INIT INFO

jaehoo

#Create group and user
groupadd tomcat
useradd -r -m -d ${USR_TOMCAT_HOME_DIR} -s /bin/false tomcat -g tomcat

# In debian distro you can use this alternative
useradd -r -m -d ${USR_TOMCAT_HOME_DIR} -s /sbin/nologin tomcat -g tomcat

#set user password
passwd tomcat

jaehoo

-- Get query list to disable restrictions
SELECT 'ALTER TABLE'||' '||owner||'.'||table_name||' DISABLE CONSTRAINT '||constraint_name||' ;' FROM dba_constraints WHERE constraint_type = 'R' and owner='user name' and status = 'ENABLED';

-- Get querys to truncate all tables
SELECT 'TRUNCATE TABLE '||OWNER||'.'||TABLE_NAME||' ;' FROM DBA_TABLES WHERE OWNER='user name';

-- Get query list to enable restrictions 
SELECT 'ALTER TABLE'||' '||owner||'.'||table_name||' ENABLE CONSTRAINT '||constraint_name||' ;' FROM dba_constraints WHERE constraint_type = 'R' and owner='user name' and status = 'ENABLED';

jaehoo

-- Set unlimited tablespace
GRANT UNLIMITED TABLESPACE TO my_tablespace;

-- To access the tablespace
GRANT CREATE SESSION TO my_user WITH ADMIN OPTION;

-- Set premisons for all tables from selected tablespace
declare
  l_SQL varchar2(4000);
begin

jaehoo

-- you nedd to have one or more privileges to see objects

SELECT ANY DICTIONARY
(SELECT | INSERT | UPDATE | DELETE) ANY TABLE;

-- And you can select any with those commands
-- see DBA objects

SELECT DISTINCT OWNER, OBJECT_NAME 
  FROM DBA_OBJECTS

jaehoo

<properties>
    <slf4j.version>1.7.5</slf4j.version>
    <logback.version>1.1.2</logback.version>
</properties>

<repositories>

<!-- ================================= -->
<!-- Logging  -->
<!-- ================================= -->

jaehoo

<?xml version="1.0" encoding="UTF-8"?>

<configuration>

    <!--
        Rolling file pattern
        yyyy-MM-ww          : Per week
        yyyy-MM-dd          : Per Day
        yyyy-MM-dd_HH       : Per Hour
        yyyy-MM-dd_HH-mm    : Per minunte