Tutorial

TwitterFacebook
Get flash to fully experience Pearltrees
http://adamsquicklog-webissues.blogspot.com/2011/02/connecting-sqldeveloper-to-remote-db.html Security Best Practice As part of your security best practices, your ecommerce database server should not be accessible remotely (across the internet or WAN). For example, assuming standard ports, your firewall should block port 1521 for Oracle and port 3306 for MySQL. There is no need for customers to access your database directly. Applications running locally on the box should access the DB on behalf of the customer. Secure Remote DB Access by Developers and DBA via PuttySSH Tunnels While standard ports are blocked, it may still be necessary for Developers and DBAs to access the DB server remotely and do so securely if they have SSH access to the remote server. PuttySSH Configuration The following shows PuttySSH configuration setup to use SSH Tunnel or port forwarding to create a seemingly local access securely to Oracle and MySQL DB servers running on a remote host.

Connecting Sqldeveloper to remote DB servers via Putty SSH Tunnels-Mozilla Firefox

PostGIS is an open source, freely available, and fairly OGC compliant spatial database extender for the PostgreSQL Database Management System. In a nutshell it adds spatial functions such as distance, area, union, intersection, and specialty geometry data types to the database. PostGIS is very similar in functionality to SQL Server 2008 Spatial support, ESRI ArcSDE, Oracle Spatial, and DB2 spatial extender. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01

Part 1: Getting Started With PostGIS: An almost Idiot's Guide

http://www.vogella.com/articles/EclipseDebugging/article.html

Java Debugging with Eclipse

Debugging allows you to run a program interactively while watching the source code and the variables during the execution. Via breakpoints in the source code you specify where the execution of the program should stop. To stop the execution only if a field is read or modified, you can specify watchpoints . Breakpoints and watchpoints can be summarized as stop points . Once the program is stopped you can investigate variables, change their content, etc. 1.2.
Copyright © 2007, 2008, 2009, 2010, 2011, 2012, 2013 Lars Vogel Eclipse Java IDE This tutorial describes the usage of Eclipse as a Java IDE.

Eclipse IDE Tutorial

http://www.vogella.com/articles/Eclipse/article.html