Tech Logs

Oracle Export : Using QUERY parameter in expdp/impdp

2011-07-04T17:57:00.001+10:00

Oracle Export : Using QUERY parameter in expdp/impdp

expdp test/test directory=test_dir dumpfile=test.dmp query=emp:\"where salary\>10000\ order by salary" tables=emp

Easy a would be pass the query parameter through a file.

exp test@testdb tables=test_export parfile=test_query.par

Inside of test_query.par, it contains only one parameter query:

Query=”where salary >10000 order by salary"

http://wiki.oracle.com/page/Oracle+export+and+import+
http://www.orafaq.com/wiki/Import_Export_FAQ

To verify user privileges:
select * from dba_sys_privs;
select * from dba_role_privs;
select * from dba_tab_privs;

select * from user_sys_privs;
select * from user_role_privs;
select * from user_tab_privs;

select * from all_sys_privs;
select * from all_role_privs;
select * from all_tab_privs;

select * from role_sys_privs;
select * from role_role_privs;
select * from role_tab_privs;

Create Mule Project with Maven

2011-03-04T11:26:00.000+11:00

Create Mule Project with Maven
mvn org.mule.tools:mule-project-archetype:create -DartifactId=message-enricher-1 -DmuleVersion=3.1.1
or
Add "org.mule.tools" to setting.xml as pluginGroup and run following command
mvn mule-project-archetype:create -DartifactId=CES-DataX -DmuleVersion=3.1.0

Search a string in directory

2011-02-21T09:55:00.000+11:00

Search a string in directory

Shell Script

for i in `ls *`
do
echo $i
cat $i | grep search-string
done

Linux/Unix Cheat Sheet

2010-04-16T13:40:00.002+10:00

http://www.redhat.com/docs/manuals/linux/RHL-6.2-Manual/getting-started-guide/ch-doslinux.html

ORA-29541: class could not be resolved

2009-11-24T14:52:00.001+11:00

Load/Drop java

dropjava -verbose -user test/test@test_1 test.jar
loadjava -resolve -verbose -grant public -user test/test@test_1 test.jar

loadjava -verbose -user test/test@test_1 JavaTest.class ??
loadjava -verbose -user test/test@test_1 c:\JavaTest.java

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "JavaTest" AS
   public class JavaTest {
   public static String sayHello (String name) {
   return "Hello, " + name+ "!";
     }
};

check the status of object

select * from all_objects where object_type like '%JAVA%';

Eclipse Java Color Themes

2009-11-24T10:27:00.000+11:00

http://srand2.blogspot.com/2009/08/eclipse-color-themes.html

Enabling or Disabling Directory Listings using web.xml

2009-11-23T13:45:00.002+11:00

http://wiki.metawerx.net/wiki/EnablingOrDisablingDirectoryListingsUsingWeb.xml

Adding context

add an entry to conf/sever.xml
context
- path = "/test"
- reloadabe = "false"
- docBase="/homt/test/output"
-workDir="/homt/test/output/workdir"

X forwarding. : Error - xterm Xt error: Can't open display:

2009-11-09T13:21:00.000+11:00

ERROR:
connection to "host23.0" refused by server
Xlib: Client is not authorized to connect to Server
xhost: unable to open display "host23.0"

xterm Xt error: Can't open display:

You should enable X forwarding. Note that should be enabled in ssh daemon settings.

$ ssh -X user@host

Link
http://www.linuxquestions.org/questions/linux-software-2/xterm-xt-error-cant-open-display-697237/

JAXB & Ant : package-info.java compilation problem of JAXB generated classes.

2009-10-27T18:43:00.001+11:00

package-info.class not generated

1.Generate the class
  xjc -p test.xsd -d C:/workspace/Test/src
2. Compile the project . package-info.class is generated.
3. Then call the clean task to remove .class files and rebuild the project. package-info.class is not generated.

Note on package-info.java from Ant Manual [http://ant.apache.org/manual/CoreTasks/javac.html]

package-info.java files were introduced in Java5 to allow package level annotations. On compilation, if the java file does not contain runtime annotations, there will be no .class file for the java file. Up to Ant 1.7.1, when the task is run again, the task will try to compile the package-info java files again.

In Ant 1.7.1 the package-info.java will only be compiled if:

   1. If a package-info.class file exists and is older than the package-info.java file.
   2. If the directory for the package-info.class file does not exist.
   3. If the directory for the package-info.class file exists, and has an older modification time than the the package-info.java file. In this case will touch the corresponding .class directory on successful compilation.


Related Links
http://ant.apache.org/manual/CoreTasks/javac.html
http://article.gmane.org/gmane.comp.jakarta.ant.devel/52586
http://www.javalinux.it/wordpress/?p=261

JAVA Compiler error : class file has wrong version 49.0, should be 48.0

2009-10-26T14:23:00.000+11:00

Compiler error message :

    [javac] class file has wrong version 49.0, should be 48.0
    [javac] Please remove or make sure it appears in the correct subdirectory of the classpath.
    [javac] import com.common.dao.QueueDAO;
    [javac]                         ^
    [javac] 1 error

Reason :

Java 1.4 creates class files labeled with version 48.0
Java 1.5 creates class files labeled with version 49.0
Check the java compiler versions

Related links :
http://forums.sun.com/thread.jspa?threadID=644158
http://www.dreamincode.net/forums/showtopic49155.htm

How does log4j load the config files ?

2009-10-15T12:33:00.000+11:00

Add -Dlog4j.debug to the command line.

trace file :

log4j: Trying to find [log4j.xml] using context classloader sun.misc.Launcher$AppClassLoader@11b86e7.
log4j: Trying to find [log4j.xml] using sun.misc.Launcher$AppClassLoader@11b86e7 class loader.
log4j: Trying to find [log4j.xml] using ClassLoader.getSystemResource().
log4j: Trying to find [log4j.properties] using context classloader sun.misc.Launcher$AppClassLoader@11b86e7.
log4j: Trying to find [log4j.properties] using sun.misc.Launcher$AppClassLoader@11b86e7 class loader.
log4j: Trying to find [log4j.properties] using ClassLoader.getSystemResource().
log4j: Could not find resource: [null].
ControlListener Created

Links :
http://jaitechwriteups.blogspot.com/2006/07/know-how-log4j-tries-to-configure.html
http://jaikiran.wordpress.com/2006/07/05/i-get-log4jwarn-no-appenders-could-be-found-for-logger-message-2/

Eclips Shortcut Key

2009-10-02T13:56:00.000+10:00

       I do not have patient to browse through the files, I always look for shortcuts and customize the editor shortcut keys as I wish.

You can assign or edit the shortcut key binding.
Goto , Window --> Preferences --> General --> Keys, Just play around with that window.

List of shortcut keys : CTRL+SHIFT+L

List of shortcut key list

Open a Resource : Ctrl+Shift+Y
Open a Type:    Ctrl+Shift+T

Go to Method :     Ctrl+O , Shift+O,O
Go to Line:           Ctrl+L

Lower Case:    Ctrl+Shift+Y
Upper Case:        Ctrl+Shift+X

Expand:              Ctrl+Numpad_Add
Expand All:         Ctrl+Numpad_Multiply
Collapse:            Ctrl+Numpad_Subtract
Collapse All:       Ctrl+Shift+Numpad_Divide

ORACLE Error : ORA-00972: identifier is too long

2009-09-25T15:57:00.000+10:00

Check the following link

http://www.dba-oracle.com/sf_ora_00972_identifier_is_too_long.htm

How to email the file attachment from unix ?

2009-09-21T15:49:00.000+10:00

/usr/bin/uuencode daily.zip daily.zip | /usr/bin/mailx -s "Daily Report" xyz@yahoo.com

Ref Link:
http://www.cyberciti.biz/faq/howto-unix-sending-files-as-mail-attachments/

How to change date format in oracle?

2009-09-21T10:04:00.000+10:00

ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY hh:mi:ss AM';

Ref links:

http://www.dba-oracle.com/sf_setting_parameters_tips.htm
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:351017764854

How to Execute SQL Scripts using sh file ?

2009-09-15T18:01:00.002+10:00

sqlplus $DBUSERNAME/$DBPASSWORD@$DBNAME @/home/test/query/test.sql

Eclipse Warning : "The type MobTest collides with a package"

2009-09-15T10:04:00.000+10:00

Reason : The package name is same as class name.

Eclipse Error : Access restriction:The method ..

2009-09-11T18:03:00.000+10:00

Error message ..

Access restriction: The method createJPEGEncoder(OutputStream) from the type JPEGCodec is not accessible due to restriction on required library C:\Program Files\Java\jdk1.6.0_11\jre\lib\rt.jar

Access restriction: The method getDefaultJPEGEncodeParam(BufferedImage) from the type JPEGImageEncoder is not accessible due to restriction on required library C:\Program Files\Java\jdk1.6.0_11\jre\lib\rt.jar

Access restriction: The method setJPEGEncodeParam(JPEGEncodeParam) from the type JPEGImageEncoder is not accessible due to restriction on required library C:\Program Files\Java\jdk1.6.0_11\jre\lib\rt.jar    ImageUtil.java

Solution

Go to Project properties -->Java Compiler --> Errors Warnings, Then enable project specific settings,
Expand Deprecated and restrited APIs category
-Forbidden reference (acess rule) , Change to warning or ignore.

Spell checker for Eclipse

2009-09-11T17:34:00.003+10:00

Create the text file or Down load this file

Edit Eclipse Preferences:
- Window -> Preferences -> General-> Editors-> Text Editors-> Spelling
- Browse to the text file or downloaded file.

Click on the word and type CTRL+1, It will show context menu in eclipse editor.You can click your option.

Ref
Eclipse: Catch Those Spelling Errors

Eclipse Error : "Java compiler level does not match the version of the installed Java project facet"

2009-09-11T17:21:00.001+10:00

Go o Project ->Properties -> Project Facets panel and set java facet version to match the java compiler compliance level.

How to increase java heap size in Maven2?

2009-09-11T17:08:00.001+10:00

Set an environment variable to increase the heap size.

set MAVEN_OPTS=-Xmx1024m

How to increase java heap size in NetBeans?

2009-09-11T16:44:00.001+10:00

Edit the file NETBEANS_HOME/etc/netbeans.conf. Current conf file contents given below

netbeans_default_options="-J-Dorg.glassfish.v3.installRoot=\"C:\Program Files\sges-v3-prelude\" -J-Dcom.sun.aas.installRoot=\"C:\Sun\AppServer\" -J-client -J-Xss2m -J-Xms32m -J-Xmx1024m -J-XX:PermSize=32m -J-XX:MaxPermSize=200m -J-Xverify:none -J-Dapple.laf.useScreenMenuBar=true -J-Dsun.java2d.noddraw=true --fontsize 14 --laf com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel"

Description
--fontsize 14 [to change the default font size in editor]
--laf com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel [to change the Look And Feel]
Some other look an feel values,
javax.swing.plaf.metal.MetalLookAndFeel
javax.swing.plaf.metal.MetalLookAndFeel
com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel
com.sun.java.swing.plaf.motif.MotifLookAndFeel
com.sun.java.swing.plaf.windows.WindowsLookAndFeel
com.sun.java.swing.plaf.windows.WindowsClassicLookAndFeel

How to increase java heap size in Eclipse?

2009-09-11T16:29:00.003+10:00

Add following entries to eclipse.ini file.Current eclipse.int contents given below

-vmargs
-Xms512m [minimum memory ]
-Xmx1024m [maximum memory]
-Duser.name=Thillakan Sabanayakam [Eclipse uses you OS user name in the @author java doc tag for default ]

Contents
-showsplash
org.eclipse.platform
--launcher.XXMaxPermSize
256M
-clean
-framework
plugins\org.eclipse.osgi_3.4.3.R34x_v20081215-1030.jar
-vmargs
-Dosgi.requiredJavaVersion=1.5
-Xms512m
-Xmx1024m
-Duser.name=Thillakan Sabanayakam

Explore process Information in unix

2009-09-11T15:54:00.000+10:00

Each process has an entry in the /proc filesystem identified by its PID. The following are the important files in /proc directory:

pid/cmdline contains the command that was used to start the process (using null characters to separate the arguments).
/proc/pid/cwd contains a link to the current working directory of the process.
/proc/pid/environ contains a list of the environment variables that the process has available.
/proc/pid/exe contains a link to the program that is running in the process.
/proc/pid/fd/ is a directory containing a link to each of the files that the process has open.
/proc/pid/mem contains the memory contents of the process.
/proc/pid/stat contains process status information.
/proc/pid/statm contains process memory usage information.
/proc/pid/lwp contains the threads running in the process with the process id

Commands :
ls -l /proc/pid/fd | wc -l
ls -l /proc/pid/lwp | wc -l

How to insert single or double quote into Oracle DB?

2009-09-10T15:57:00.000+10:00

Using q-quote string syntax, It can be done

Example :

INSERT INTO T(test)

values (q'[single's quote and "double" quotes]');

How To Override Hibernate Configuration Settings?

2009-09-07T15:52:00.000+10:00

The following code segment will override the some properties. [hibernate.connection.driver_class, hibernate.connection.url ,hibernate.connection.url, hibernate.connection.password]

    public static void createSessionFactory(String driverclass,String url, String username, String password, String configFile) throws HibernateException {
        if (sessionFactory != null) {
            sessionFactory.close();
        }
        Configuration cfg = new AnnotationConfiguration().addResource(configFile);
        cfg.configure(configFile);
        cfg.setProperty("hibernate.connection.driver_class", driverclass);
        cfg.setProperty("hibernate.connection.url", url);
        cfg.setProperty("hibernate.connection.url", username);
        cfg.setProperty("hibernate.connection.password", password);
        sessionFactory = cfg.buildSessionFactory();
    }

       Hibernate configuration files properties used in following implementation.

    public static void createSessionFactory(String driverclass,String url, String username, String password, String configFile) throws HibernateException {
        if (sessionFactory != null) {
            sessionFactory.close();
        }
        Configuration cfg = new AnnotationConfiguration().addResource(configFile);
        cfg.setProperty("hibernate.connection.driver_class", driverclass);
        cfg.setProperty("hibernate.connection.url", url);
        cfg.setProperty("hibernate.connection.url", username);
        cfg.setProperty("hibernate.connection.password", password);
cfg.configure(configFile);
        sessionFactory = cfg.buildSessionFactory();
    }

How To Add Your Linkedin Profile Button To Your Blogger Blog

2009-09-03T21:02:00.001+10:00

Check the following links..
http://smallworkarounds.blogspot.com/2008/11/adding-linkedin-button-to-blogger-or.html
http://salesittech.blogspot.com/2009/02/include-your-linkedin-button-in-blogger.html

Optimize Firefox Speed

2009-08-28T12:28:00.005+10:00

You can use pipelinning to speed up page load.Which allows Firefox to load multiple things at once.

    * Type “about:config” into the address bar and hit return.
    * Type “network.http.*pipe” in the filter field, and change the following settings.
(Double-click on them to change them):
    * Set “network.http.pipelining” to “true”
    * Set “network.http.proxy.pipelining” to “true”
    * Set “network.http.pipelining.maxrequests” to "8".

Helpful Links
http://egonitron.com/2007/05/25/the-truth-about-the-firefox-pipelining-trick/

Packge once. Deploy everywhere

2009-08-26T11:57:00.007+10:00

I was looking for a software to bundle my application as one installer. So it can deploy it any where. I found open source product IzPack. It requires only a Java virtual machine to deploy.

IzPack : http://izpack.org/

There are some commercial product available, Following products are used to create windows installer (msi) package.

InstallShield
Advanced Installer

Some more free tools ..

Windows Installer XML (WiX)
InstEd
NSIS

Eclipse Plug-In - Easy Explorer

2009-08-22T22:58:00.036+10:00

Easy Explorer is a very useful plug in, Which helps you to browse resources with the native Operating system explorer. In the Eclipse, select a file, right-mouse click, and select the 'Easy Explore...'

I am using Galileo & easy-explore-1.0.4.

Image Magnification Testing :(

Plug-In details links

Easy Explorer Home
Download Plug-in

How to enable Log4j logging in Eclipse console window?

2008-11-22T00:32:00.006+11:00

Problems:

Could not see the log message in eclipse console window but it shows following warning message

log4j:WARN No appenders could be found for logger (com.test.HelloWorld).

log4j:WARN Please initialize the log4j system properly.

Reasons:
Log4j is not initialised.

Solution:
Add a ConsoleAppender or Appender

Code Sample:
BasicConfigurator.configure();
or
PropertyConfigurator.configure("log4j.xml");

Ref:

Log4j Manual
Log4j API
BasicConfigurator
PropertyConfigurator

Log4j warning message [log4j:WARN No appenders could be found for logger]

2008-11-20T15:51:00.000+11:00

Log4j:

Log4j is a logging or tracing API, large number of applications and framework use Log4j for logging.

Problems:

Sometimes application do not generate log files and generate the following warning message.

log4j:WARN No appenders could be found for logger (com.test.HelloWorld).
log4j:WARN Please initialize the log4j system properly.

Reasons:

Log4j is not initialised properly. The Log4j library files are in application class path but Log4j configuration file is not in application class path.

Solution:

Add log4j configuration file [log4j.properties or log4j.xml] to class path.

More Info:

Log4j priority order,
FATAL: 50000
ERROR: 40000
WARN: 30000
INFO: 20000
DEBUG: 10000

Ref:
log4j Manual
log4j API

WELCOME :Testing - சோதனை பதிவு :)

2006-11-24T23:23:00.001+11:00

WELCOME : Testing

சோதனை பதிவு

Success !!! :)