Calculate a String md5 hash using Ubuntu

user@my-laptop:~/Desktop$ echo "your text" | md5sum
1c2ca0d36c59960f2a94efab4080f423  -

See also: a Monline post : Quick MD5 hash of a string

Check if an Interval (time) is contained in another (java)

Here how I check if a Interval (time) is contained into another.

import org.apache.commons.lang.math.LongRange;
import org.apache.commons.lang.math.Range;
...

externalBeginDate = new java.utilDate();
...
Range externalRange = new LongRange(externalBeginDate.getTime(),externalEndDate.getTime());
Range internalRange = new LongRange(internalBeginDate.getTime(),internalEndDate.getTime());

if (externalRange.containsRange(internalRange)) {
			//ok internal range is internal 
}

Thanks to Apache Commons Lang

Postgresql: backUp from one user/owner and restore into another user/owner


#> pg_dump -f noOwner.dmp -O -x -h localhost -U user1 dbname1
#> psql -h localhost -U user2 -d dbname2 < noOwner.dmp


Installing Apache James on Ubuntu

• Download, extract Apache James bin.tar.gz, see here
• Create a init.d script, see here for Debian
• Configure via telnet the James server, I hope there is another way, see here
• Connect your email client on smtp and pop

Using SchemaSpy for generating HTML db schema docs

With SchemaSpy, it’s easy to generate HTML schema documentation of your favorite dbms
SchemaSpy

es.
$ java -jar schemaSpy_4.1.1.jar -t pgsql -host 127.0.0.1 -db sms -u sms -p sms -o /tmp -dp /hopostgresql/8.3-603.jdbc4/postgresql-8.3-603.jdbc4.jar -s public


Installing Subversion 1.5 on Ubuntu 8.04

Using the new Eclipse version 3.4.0 and its subeclipse plugin, I found that my linux svn client has been too old:
svn: This client is too old to work with working copy '.'; please get a newer Subversion client

So, I have followed “cylindric.net” (the page do not exists anymore) instructions installing via apt-get the 1.5 version of svn client: it works fine for me.

Thanks to cylindric.net

L’Ingegnere Informatico e gli Aspetti Giuridico Penali

Indicazioni: sui Contratti, sui riferimenti normativi, sulle responsabilità della professione dell’Ingegnere Informatico; sono ben esposti nella sezione download del sito Web dell’Avv. Cesare Triberti .
Consigliato e utile chi si occupa di contratti e/o consulenza in ambito ICT.

Grazie ad Alessandro per il link.

Universal JDBC GUI Client

I’ve found Squirrel Client very useful and mature product.

What I like in Squirrel Client:

1. Autocomplete during sql writing for table names and fields, see below a screenshot.
2. Automatically Keep your queries history also with the results
3. …

Video Registratore Canali Italiani (TV e Radio)

Personal Podcast for Tv & Radio Recording

Faucet has been created in order to allow Radio and TV to be usable:
“when, what, where, how you want” by way of the new portable media players.

Faucet allows you to record your favourite broadcast and receive them
as podcasts, to be watched whenever and wherever on your personal player.

Faucet

Thanks to Roberto.

Tomcat 5.5 JNDI DataSource definition for Mysql

I share with you a DataSource definition for Tomcat 5.5 and Mysql that works fine for me. Before this version I found some problems because Mysql, under Debian, closes the connections after 8 hours of inactivity… so after a night the connection pools has not been available.

<Context
  path="/webappname"
  docBase="webappname"
  debug="5"
  reloadable="true" crossContext="true">
   <Resource
       name="jdbc/webappname"
       auth="Container" type="javax.sql.DataSource"
       maxActive="100"
       maxIdle="20"
       maxWait="10000"
       validationQuery="SELECT 1"
       testOnBorrow="true"
       testWhileIdle="true"
       timeBetweenEvictionRunsMillis="900"
       minEvictableIdleTimeMillis="65000"
       username="yourUsername"
       password="yourPassword"
       driverClassName="com.mysql.jdbc.Driver"
     url="jdbc:mysql://127.0.0.1:3306/dbName?autoReconnectForPools=true"/>
</Context>
  

Hope it can help you.