Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 4.0.2 ignores socks proxy options

user13086221May 7 2014 — edited Oct 21 2014

Hello.

I have a problem with SQL Developer 4.0.2 working through socks proxy server. SQL Developer 3.2 works good with same settings.

OS: Windows 8 Pro, 64-bit

Version: Oracle SQL Developer 4.0.2 (4.0.2.15.21) - sqldeveloper-4.0.2.15.21-no-jre

JDK: 1.7.0_55, 64-bit

I've added additional options for JVM into %USERPROFILE%\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf

# Proxy settings

AddVMOption -DsocksProxyHost=localhost

AddVMOption -DsocksProxyPort=3129

(I also tried all *.conf files, e.g. ide.conf, sqldeveloper.conf, jdk.conf, etc.)

And these options are enabled (see listing below)

But no result, SQL Developer 4.0.2 uses only direct connection.

Socks proxy server on localhost works fine, another version of SQL Developer works through it.

Could you please help me?

Thanks!

P.S. .\sqldeveloper64.exe -verbose

Processing Hotspot specific options

Processing Hotspot JDK 7 specific options

savedArg0 = .\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe

VM to launch C:\Program Files\Java\jdk1.7.0_55\jre\bin\server\jvm.dll

JNI Option: -Xbootclasspath/a:C:\Program Files\Java\jdk1.7.0_55\lib\tools.jar;C:\Program Files\Java\jdk1.7.0_55\lib\dt.jar

JNI Option: -Dsun.java2d.noddraw=true

JNI Option: -Dnetbeans.home=./Software/sqldeveloper/netbeans/platform/

JNI Option: -Dnetbeans.logger.console=true

JNI Option: -Dexcluded.modules=org.eclipse.osgi

JNI Option: -Dide.cluster.dirs=./Software/sqldeveloper/netbeans/fcpbridge/:./Software/sqldeveloper

/netbeans/ide/:./Software/sqldeveloper/netbeans/../

JNI Option: -Xverify:none

JNI Option: -Doracle.ide.extension.HooksProcessingMode=LAZY

JNI Option: -Dorg.eclipse.equinox.simpleconfigurator.configUrl=file:bundles.info

JNI Option: -Dosgi.bundles=file:./Software/sqldeveloper/ide/ide/lib/oracle.ide.osgi.jar@3:start

JNI Option: -Dosgi.bundles.defaultStartLevel=1

JNI Option: -Dosgi.configuration.cascaded=false

JNI Option: -Dosgi.noShutdown=true

JNI Option: -Dorg.osgi.framework.bootdelegation=*

JNI Option: -Dosgi.parentClassloader=app

JNI Option: -Dosgi.locking=none

JNI Option: -Xbootclasspath/p:./Software/sqldeveloper/rdbms/jlib/ojdi.jar

JNI Option: -Dosgi.classloader.type=parallel

JNI Option: -Dosgi.bundlefile.limit=500

JNI Option: -Dide.feedback-server=ide.us.oracle.com

JNI Option: -Djavax.xml.transform.TransformerFactory=oracle.ide.xml.switchable.SwitchableTransformerFactory

JNI Option: -Djavax.xml.stream.XMLInputFactory=com.ctc.wstx.stax.WstxInputFactory

JNI Option: -Djavax.xml.stream.util.XMLEventAllocator=oracle.ideimpl.xml.stream.XMLEventAllocatorImpl

JNI Option: -Doracle.ide.reportEDTViolations=bug

JNI Option: -Doracle.ide.reportEDTViolations.exceptionsfile=./Software/sqldeveloper/ide/bin/swing-thread-violations.conf

JNI Option: -Xms128M

JNI Option: -Xmx800M

JNI Option: -Dide.update.usage.servers=http://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml

JNI Option: -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

JNI Option: -Dsun.java2d.ddoffscreen=false

JNI Option: -Dwindows.shell.font.languages=

JNI Option: -XX:MaxPermSize=256M

JNI Option: -Doracle.ide.startup.features=sqldeveloper

JNI Option: -Doracle.ide.osgi.boot.api.OJStartupHook=oracle.dbtools.raptor.startup.HomeSupport

JNI Option: -Doracle.jdbc.mapDateToTimestamp=false

JNI Option: -Doracle.jdbc.autoCommitSpecCompliant=false

JNI Option: -Doracle.jdbc.useFetchSizeWithLongColumn=true

JNI Option: -Dsun.locale.formatasdefault=true

JNI Option: -Dorg.netbeans.CLIHandler.server=false

JNI Option: -Dide.AssertTracingDisabled=true

JNI Option: -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

JNI Option: -Djava.util.logging.config.file=logging.conf

JNI Option: -Dsqldev.debug=false

JNI Option: -Xms128m

JNI Option: -Xmx800m

JNI Option: -DsocksProxyHost=localhost

JNI Option: -DsocksProxyPort=3129

JNI Option: -Dide.startingArg0=.\Software\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe

JNI Option: -Dide.startingArg1=-verbose

JNI Option: -Dide.launcherProcessId=3068

JNI Option: -Dide.config_pathname=.\Software\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

JNI Option: -Dide.startingcwd=.\Software\sqldeveloper\sqldeveloper\bin

JNI Option: -Duser.conf=C:\Users\.user\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf

JNI Option: -Dtool.user.conf=C:\Users\.user\AppData\Roaming\sqldeveloper\1.0.0.0.0\sqldeveloper.conf

JNI Option: -Dide.shell.enableFileTypeAssociation=.\Software\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe

JNI Option: -Dide.pref.dir.base=C:\Users\.user\AppData\Roaming

JNI Option: -Dide.work.dir.base=C:\Users\.user\Documents

JNI Option: -Dsun.java.command=oracle.ide.osgi.boot.OracleIdeLauncher

JNI Option: -Djava.class.path=.\Software\sqldeveloper\ide\lib\ide-boot.jar;.\Software\sqldevel

oper\netbeans\platform\lib\boot.jar;.\Software\sqldeveloper\netbeans\platform\lib\org-openide-util.jar;

.\Software\sqldeveloper\netbeans\platform\lib\org-openide-util-lookup.jar;.\Software\sqldeveloper\

netbeans\platform\lib\org-openide-modules.jar;.\Software\sqldeveloper\ide\lib\fcpboot.jar;.\So

ftware\sqldeveloper\ide\lib\xml-factory.jar;.\Software\sqldeveloper\ide\lib\woodstox-core-asl-4.2.0.jar;

.\Software\sqldeveloper\ide\lib\stax2-api-3.1.1.jar;.\Software\sqldeveloper\sqldeveloper\lib\orac

le.sqldeveloper.homesupport.jar

JVM path is C:\Program Files\Java\jdk1.7.0_55\jre\bin\server\jvm.dll

LOAD TIME : 394

Comments

Billy Verreynne

Simple answer - no.

The machine name (and other client details) is set by the client driver. Not the client application.

BTW, why this requirement?

1009739

I am working in ORACLE 11 g Release 2 using PL/SQL Developer Tool

Every time i am logging in i could find my machine name in OSUSER in v$session table.

So i want to stop is there any other tool or any other way to stop it

JustinCave
Answer

Why do you want to prevent the DBA from determining what machine you are connected from?

Given that this information is coming from your client machine, it is certainly possible to hack your machine so that it reports a different name assuming you have root/ Administrator access.  But that's something that an attacker would normally want to do, not something that a normal user would want to do.  That's why we're trying to determine why you are trying to hide this information.

Justin    

Marked as Answer by 1009739 · Sep 27 2020
1009739

See when i am accessing via guest account it take the name into it. So i don't want to insert guest name instead it must enter my machine name or null.

Billy Verreynne

So. What?

What is The Problem?

If you want to obfuscate what the OCI client driver reports to the server, you will need some low level hacks that are not easy and trivial. So why do you want to tackle such a hack complexity, instead of just doing your job via that database connection?

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2014
Added on May 7 2014
8 comments
6,362 views