Posts tagged: database

Productivity : Use Keypass to keep track of your environment’s credentials,

 

Some use Excel, Others simply use text files to keep track of their passwords, but I use keepass .

It is simply a vault for your logins and passwords which you can unlock with a single password. However I use it also for auto-piloting my login procedure.

keepass main window

keepass main window

 

The whole idea is not to have to use a pool of passwords for all systems and also to auto-start you log-in procedure and save waring off your precious fingers in typing useless usernames and passwords.

In this article I will show how to use keepass to auto-login to:

  • Putty
  • WinScp
  • Toad
  • SQLPLUS
  • SiebelTools
  • FieZilla

And from the examples above you would be able to use it with any command line tool as well.

You could also use it for keeping track of your web site usernames ,passwords and URL’s

It is available on Windows, Mac, Linux, Android and iPhone.

Read more »

Java and Oracle : JDBC Layers and Connection types

I know no body does that, but I did it anyway :

I read through the JDBC connection types “http://download.oracle.com/javase/6/docs/technotes/guides/jdbc/getstart/intro.html#1019423” and thought I summarize the deferences between JDBC drivr types in this diagram:

JDBC Layers and types from Oracle drivers

Diagram Showing Layers of JDBC and Types with Oracle drivers

In short, there are 4 types of JDBC Connection, but only two are important from my experience:

Read more »