You'll need to contact the extension developer. We don't support 3rd party extensions here.
Thank you. i have small doubts
1) is there any data theft possible by this Extension.
2) By default time T is 600 sec , after completing 600 seconds connection is alive or closed?
3) How can i Un-install this.
I think these are silly doubt but it's imp to me.
Ramu - data theft is NOT A SILLY concern. I would see if you can download the extension source, inspect it, and validate that it is clear of trap doors. Especially look for third-party jars that it needs.
I think you can deactivate or uninstall from within sql developer. However, you can also remove the extension jar from the sqldeveloper extension directories.
Thank you.very much..
Hi, I'm the developer of the extension.
When I first posted, it was deleted from OTN. Now a post about it survives here, even though for some reason it is closed: SQL Developer 4 keepalive extension
Check this discussion about it, the concerns about its validity have been thoroughly discussed: Useful post was rejected
To reply to Ramuplsql10's doubts:
1) There always is this risk when you install 3rd party software. I guarantee that the extension is malware free, but you might not trust me. That's why I made the extension open source: if you're not happy with installing the ZIP file, go ahead and recompile the code yourself. I have not published instructions yet (I have spent free time for the extension development arguing with the moderators of OTN), but if you install JDeveloper 12c and look around the Internet you'll see that compiling an extension is not too hard. If you don't trust me and you don't want to recompile, you can always download a Java decompiler and open the ZIP... the code is not obfuscated, I have nothing to hide.
2) Every time the timeout is triggered, a query is sent on every open connection in order to keep it alive. I thought this was clear from the project's wiki. If it is not, well it is a wiki, please edit it in a way that you think is understandable.
3) Interesting question, I haven't really figured it out yet. If you do, please contribute to the project by writing it in the wiki.
SchemaCzar, your suggestions are right. I invite you all to inspect the code before using it... it's literally TWO Java classes, shouldn't take long.
EDIT: if you look at the MANIFEST.MF in the META-INF, you'll see that the only external JARs used are from Oracle.
You're free to developer 3rd party extensions as you see fit. However, this topic touches upon something we fundamentally disagree with - issuing fake activity to get around network and database settings and procedures. Hence the locked posts, rejected exchange items, etc. I believe in full disclosure, so I don't mind sharing this. If you want to discuss this extension further, please do so via the author's or the distribution site's page.