DrillDown feature in JasperServer

Add a hyperlink having type ReportExecution with parameter _report="sdfsdf"

Granting access from any IP on Mysql

mysql> grant all privileges on *.* to youruser@"%" identified by "yourpassword";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit
Bye

TCP Monitoring

A nice TCP Monitoring application. You can download the debugger from http://www.itsamples.com/software/tcp.html

Datamodeling tool

"Toad Data Modeller" is a very nice ER tool. you can generate SQL scripts as well to generate your database.

Opensource Project Management tool

openproj is an opensource project management tool. It has most of the MSProject features at no cost.

Another opensource project management system is gnome planner.

Another project management tool is openworkbench.

Business Growth

Source: Success in Store: How to Start Or Buy a Retail Business, Enjoy Running It ... by Heard and Woolf.

Open Source Content Management Software

Liferay is an opensource content management software with portlet feature.

DEBUGGING YOUR SQLs WITH A JDBC DRIVER

• Download the SQL Spy from http://sozlux.org/download/p6spy-install.zip.
• Extract the file and copy the spy.properties and spy.jar files to your TOMCAT_HOME/lib directory.
• Edit spy.properties directory and change the real driver to your original driver on the following line

realdriver=com.mysql.jdbc.Driver

• Edit your connection pool settings and use now this driver as your jdbc driver

com.p6spy.engine.spy.P6SpyDriver

How to search and replace text in big files

you can also use sed. I used the following command

perl -pi -w -e 's/search/replace/g;' *.sql
-e means execute the following line of code.
-i means edit in-place
-w write warnings
-p loop

for example you can convert oracle dates to mysql in the following way

Free alternatives to TOAD

If you are using simple SQL functions you do not need to pay full TOAD license to use the ORACLE database. You can find alternatives to toad below :

TOra

from http://tora.sourceforge.net/

TOra has also have a nice exporter. If you want to develop applications at home where you can not install a complete oracle, you can export your tables in tora and import them in e.g. mysql

dbVisualizer

from http://www.minq.se

TADO

from http://tado.sourceforge.net/

Squirrel SQL Client

from http://squirrel-sql.sourceforge.net/

Preparing a JAVA development environment

• Install 7-zip from http://www.7-zip.org/download.html
• Install pspad from http://www.pspad.com/de/
• Download and install JDK 5+ (make sure your JAVA_HOME environment variable points to the JDK, not a JRE). URL: http://java.sun.com/javase/downloads/index.jsp
• For your local environment - download and install MySQL 5.x. ( we will use a central instance later). URL : http://dev.mysql.com/downloads/mysql/5.0.html#downloads
• Set the root password as an empty string by using the following command: mysql --user=root --pass='' mysql -e "update user set password=password('newpw') where user='root'; flush privileges;"
• Download and install eclipse EE from http://www.eclipse.org 
• Download Maven 2.0.5+ from http://maven.apache.org/download.html . Unzip the maven to your home directory and use the following configuration to install the maven.

• Download and unzip tomcat and configure the following environment variables.

SQLite

Click To Play

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

SQLite is the most widely deployed SQL database engine in the world. It is used in countless desktop computer applications as well as consumer electronic devices including cellphones, PDAs, and MP3 players. The source code for SQLite is in the public domain. [1]

Cordinating the offshore team activities with Screenstream

Click to play

ScreenStream lets others 'watch' your screen on their computers over the network or the internet. It is the modern equivalent of the overhead projector. When you turn on screen sharing others on your network (or even the internet) can view what is on your screen by typing the link (and optional access code) into their internet browser. They can continue to watch your screen until turn off screen sharing.[1]

[1] http://www.nchsoftware.com/screen/index.html

This video is prepared by Koray Güclü

http://www.korayguclu.de

Web Debugging with Fiddler

Click to play

Fiddler is a Web Debugging Proxy which logs all HTTP(S) traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP(S) traffic, set breakpoints, and "fiddle" with incoming or outgoing data. [1]

[1] http://www.fiddler2.com/fiddler2/

The video is prepared by Koray Güclü

http://www.korayguclu.de