Thursday, April 17, 2008

Who needs to store a password.

In sqldeveloper 1.5, if you don't want to have the option of saving the password for a connection try this:

Edit the sqldeveloper/bin/sqldeveloper.conf and add this:

AddVMOption -Dsqldev.savepasswd=false

Adding this will remove the checkbox to have the ability to save the password. I added this a while back and forgot until a recent post on the forums reminded me. A customer needed to for some complicity they had to meet.

Wednesday, April 16, 2008

Sorta off topic

This is only Oracle in that it's at HQ in the lobby of the 500 building. I've been loading my pictures to flickr and found this one that I had forgotten about.

Which tnsnames?

It seems to come up often that some people are unsure where the list of connections get picked up from. So, if your not sure which tnsnames file sqldev is using try this:

1) Open any worksheet

Sqldev just needs someplace to process the next command and doesn't actually use the connection for anything.

2) Enter : setloglevel oracle.dbtools.raptor.utils INFO

This sets the java logging level on for this package so you can avoid putting the entire tool into debug and being inundated withe log messages. setloglevel is something I put in to help debugging using the same method I had blogged on before.

3) open the new connection dialog

The tnsnames are read everytime the dialog opens. This is handy for testing changes to the tns files.

4) check the log

You should end up with something like this. The log will show where it's checking for the tnsnames.