select substr(utl_raw.cast_to_varchar2(at.column_name), 341, 41) as MSISDN from archive_tbl at
where utl_raw.cast_to_varchar2(at.column_name) like '%01287392728%';
Java Programming Reference
Tuesday, January 22, 2013
Wednesday, January 9, 2013
CURL Response Time
Http post message which store in request.xml. This command support for SOAP action as well.
curl -o /dev/null -w '\nLookup time:\t%{time_namelookup}\nConnect time:\t%{time_connect}\nPreXfer time:\t%{time_pretransfer}\nStartXfer time:\t%{time_starttransfer}\nRedirect time:\t%{time_redirect}\n\nTotal time:\t%{time_total}\n' -H 'SOAPAction: ""' --header "Content-type: application/soap+xml" -i -d @request.xml -X POST http://www.google.com
curl -o /dev/null -w '\nLookup time:\t%{time_namelookup}\nConnect time:\t%{time_connect}\nPreXfer time:\t%{time_pretransfer}\nStartXfer time:\t%{time_starttransfer}\nRedirect time:\t%{time_redirect}\n\nTotal time:\t%{time_total}\n' -H 'SOAPAction: ""' --header "Content-type: application/soap+xml" -i -d @request.xml -X POST http://www.google.com
Friday, January 4, 2013
OracleValidConnectionChecker - Unexpected error in pingDatabase
Error
[org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker] Unexpected error in pingDatabase
Resolution
Remove the Oracle lib (ojdbc14.jar) from your Ear or War and place it at jboss server/lib directory
[org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker] Unexpected error in pingDatabase
Resolution
Remove the Oracle lib (ojdbc14.jar) from your Ear or War and place it at jboss server/lib directory
Tuesday, August 7, 2012
Include xml file in Maven
Update pom.xml file as below:-
<build>
...
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
...
</build>
<build>
...
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
...
</build>
Friday, March 2, 2012
Check Oracle DB CharacterSet
SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET'
Sunday, December 4, 2011
Wednesday, November 2, 2011
Clean Up Oracle DB Space
Free up oracle db space by delete below log:-
/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
using this command :
cat /dev/null > /oracle/oracle/product/10.2.0/db_1/network/log/listener.log
This log was more than 4GB of size. Emptying this file is harmless as it only contains the connection log to the DB.
/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
using this command :
cat /dev/null > /oracle/oracle/product/10.2.0/db_1/network/log/listener.log
This log was more than 4GB of size. Emptying this file is harmless as it only contains the connection log to the DB.
Subscribe to:
Posts (Atom)