Tuesday, April 19, 2011

Spring MVC

Spring MVC Fast Tutorial (with sources for download)
http://maestric.com/doc/java/spring

Postgres::Drop connections

--List all of the open connections to a given database
select * from pg_stat_activity where datname='database';

--Drop all of the open connections to a given database:
select pg_terminate_backend(procpid) from pg_stat_activity where datname='database';
--More samples
select * from pg_stat_activity where date(backend_start)='2011-04-19';
select pg_terminate_backend(procpid) from pg_stat_activity where date(backend_start)='2011-04-19';

--One sample more specific
select * from pg_stat_activity where backend_start < '2011-05-04 10:00' and waiting=false order by backend_start desc
select pg_terminate_backend(procpid) from pg_stat_activity where backend_start < '2011-05-04 10:00' and waiting=false

select pg_terminate_backend(procpid) from pg_stat_activity where backend_start < '2011-08-05 07:00' and datname='' and waiting=false

References:
http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

Friday, April 15, 2011

Default Setting of SMTP

Gmail
Outing Server:smtp.googlemail.com
port:465
Connection Security:SSL/TLS

Thursday, March 31, 2011

Amy MacDonald

2007 This is the life
http://linkto.net/?2952626344cf0f4eeeae854.45628949
2010 A curious thing
http://linkto.net/?19645296464cf0f5026f0bb4.43062513

.NET Dynamic Reports

http://www.gotreportviewer.com/DynamicMatrix.zip
Render Report
http://weblogs.asp.net/rajbk/archive/2006/03/02/How-to-render-client-report-definition-files-_28002E00_rdlc_2900_-directly-to-the-Response-stream-without-preview.aspx

iPhone Developers::Resources

XCode under Windows
http://www.ifans.com/forums/showthread.php?t=267007
http://ipodtoucher55.blogspot.com/2010/12/installing-ios-sdk-and-xcode-on-windows.html

Tutorials
http://www.cristalab.com/tutoriales/fundamentos-de-programacion-para-iphone-c260l/
http://www.scribd.com/doc/12684298/Building-PhotoKast-Creating-an-iPhone-app-in-one-month
http://iproyectoiphone.blogspot.com/

Hello World on iPhone
http://developer.apple.com/library/ios/#documentation/IDEs/Conceptual/xcode_quick_start/000-About_Xcode/introduction.html#//apple_ref/doc/uid/TP40010575

http://developer.apple.com/library/ios/navigation/

How to connect to a MySQL database from an iPhone?
http://stackoverflow.com/questions/468618/how-to-connect-to-a-mysql-database-from-an-iphone

Mysql and Objective-C
http://www.karlkraft.com/index.php/2010/06/02/mysql-and-objective-c/

MySQL.framework for iPhone
http://www.eval-art.com/2009/06/22/mysqlframework-for-iphone/

CocoaMySQL
http://sourceforge.net/projects/cocoamysql/files/CocoaMySQL%20source/CocoaMySQL%20source%20v0.7b4%20%28BETA%29/

MySQL on MAC OS X
http://developer.apple.com/internet/opensource/osdb.html
iMy (mySQL client for iphone)
http://www.spanware.com/iphonedb/iMy/iMy.html
iAMPS (webserver on your iPhone)
http://iamps.byethost24.com/index.php?postid=15

iPhone & Web Service

How can I connect iPhone and web service and get XML data?
http://stackoverflow.com/questions/352676/how-can-i-connect-iphone-and-web-service-and-get-xml-data

iPhone Programming Tutorial – Intro to SOAP Web Services
http://www.icodeblog.com/2008/11/03/iphone-programming-tutorial-intro-to-soap-web-services/

Creating an iPhone-based Web
http://blogs.oreilly.com/iphone/2008/09/creating-an-iphone-based-web-s.html

http://es.w3support.net/index.php?db=so&id=352676

Wednesday, March 30, 2011

Disable Popup at Yahoo Messenger started

1. Login using the Yahoo messenger.
2. Go to Messenger >> Preferences >> General category.
3. Uncheck [ ] Show Yahoo! Messenger Insider.

References
[1]http://txpress.blogspot.com/2007/03/remove-yahoo-messenger-insider-popup.html

Monday, March 28, 2011

Install Java + Tomcat on Linux CentOS

I. Installing Java

#yum install jpackage-utils

#wget url/jdk-6u13-linux-i586-rpm.bin [1]

#chmod +x jdk-6u13-linux-i586-rpm.bin

#./jdk-6u13-linux-i586-rpm.bin

#java -version

II. Installing Tomcat

#wget http://apache.mirror.testserver.li/tomcat/tomcat-6/v6.0.32/bin/apache-tomcat-6.0.32.tar.gz

#cp apache-tomcat-6.0.32.tar.gz /var/

#cd /var

#tar -zxvf apache-tomcat-6.0.32.tar.gz

# ln -s /var/apache-tomcat-6.0.32 tomcat

#/var/tomcat/bin/startup.sh

References:
[1]Java Download http://www.oracle.com/technetwork/java/javase/downloads/index.html
[2]Java + Tomcat + startup in CentOS
http://wiki.openbluedragon.org/wiki/index.php/Apache_Tomcat_on_CentOS/RedHat
[3]Java 6 + Tomcat in CentOS
http://www.satollo.net/how-to-install-tomcat-and-java-6-on-centos-5-2
[4]Java SE
http://www.oracle.com/technetwork/java/javase/downloads/index.html
[5]Tomcat (download core tar.gz)
http://tomcat.apache.org/download-60.cgi
[6]Mirror
http://apache.mirror.testserver.li/tomcat/tomcat-6/v6.0.32/bin/apache-tomcat-6.0.32.tar.gz

CSS Templates

http://www.woothemes.com/themes/

Videos Graciosos

http://video.latam.msn.com/watch/video/gato-cansado-se-desmaya/1jb3dt5rq

http://video.latam.msn.com/watch/video/sonrie-cuando-le-dicen/1jbyn00k1

http://video.latam.msn.com/watch/video/perro-ladra-mas-bajo-a-pedido/1jb65jo8z

http://video.latam.msn.com/watch/video/precision-japonesa/1jb7ufffb

http://video.latam.msn.com/watch/video/carrera-de-31-piernas/1jb3la8c6

http://video.latam.msn.com/watch/video/gato-contra-perro-en-camara-lenta/1jbatlyp9

http://video.latam.msn.com/watch/video/la-mejor-imitadora-de-animales-del-mundo/p4fej3h3

Ubuntu Forware port 80

  #!/bin/bash iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8069 iptables -t nat -A PREROUTING -i eth0 -p tc...