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.

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.

not it..

I was wondering if I would get out of this since I only blog about once every couple months.

Here goes 8 things.

1. First pay back to Carl for tagging me... My son beat Carl at Burnout ( my son was 6 at the time )

2. Made one of these a couple weeks ago with my son.

3. I've jumped out of planes and helicopters
4. I'm a ham , N1JLX. My first post to the internet shows that.

5. I ride a Honda Valkyrie.

6. I drive a mini cooper

7. Served as president of our water company for 1.5 years.

8. Currently playing warhawk So if you see klrice running around that's me.

Now to spread the fun to the sqldev team and tag Barry , Sue and Vadim .

One of many ...

There's lots of little things in the upcoming release of sqldev. Frank's post reminded me of one that I forgot to show at openworld. We have support for the same DVT Gauge component that he mentions in sqldev's next version. However, all you have to do is write a sql statement. It's really simple to use. For example, I took the free space report from Tom Kyte and added guages.

The only you'll need to do in sqldev is select the correct value and it'll turn it into a gauge. In the base sql, the percent used is

((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100 pct_used " .

In order to make it more graphical I just changed it to this

'SQLDEV:GAUGE:0:100:0:0:'||((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100 pct_used

The SQLDEV:GAUGE trigger the check for values. The first 2 numbers are the min and max values. The next 2 are the low and high values. Lastly, the current value to plot.