windows - How to start Oracle SQL Developer 4 using 32 bit JDK on Win 64? -

-

i need connect database , use wallet file. if try sql developer end "ocijdbc.dll: cant load ia 32bit .dll on amd 64-bit platform."

i have both installed jdk 32 bit (in c:prog32bit) , jdk 64 bit (c:prog) development.

i tried set javahome in sqldeveloper/bin/sqldeveloper.conf manually setjavahome c:\program files (x86)\java\jdk1.7.0_51

my next step edit %user_home%/sqldeveloper/sqldeveloper.conf , set setjavahome there too, none didn't work.

next step was, edited sqldeveloper/bin/sqldeveloper.bat , set: 

java_home="c:\program files (x86)\java\jdk1.7.0_51" path="c:\program files (x86)\java\jdk1.7.0_51\bin%"  java.exe -xmx640m -xms128m -xveri....

my last try use command line (as on linux) , run: 

d:\sqldeveloper>path="c:\program files (x86)\java\jdk1.7.0_51\bin" d:\sqldeveloper>java -version java version "1.7.0_51" java(tm) se runtime environment (build 1.7.0_51-b13) java hotspot(tm) client vm (build 24.51-b03, mixed mode, sharing) d:\sqldeveloper>sqldeveloper.exe

but still receive message sqldeveloper running 64 bit java.

i found workarround. older version of sql developer (bundeld jdk) available @ http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-downloads-v322-2080107.html

the main problem in case have installed 32 bits oracle driver connect database in 64 bit machine. there no problem need set setjavahome jdk directory contains 32 bits version.

in sqldeveloper 4 need edit file: 

"c:\users\username\appdata\roaming\sqldeveloper\1.0.0.0.0\product.conf"

and inside config file change default directory jdk1.7.0_71 32 bits this: 

setjavahome c:\program files (x86)\java\jdk1.7.0_71

after use path, check in task manager process sqldeveloper looks this: sqldeveloper.exe *32

if process starts "*32" able connect using 32 bits oracle driver.


Comments

Post a Comment

Popular posts from this blog

c# - How to get the current UAC mode -

-
can check current uac type set in device before running application through c#. i got know approach check whether current user administrator or not. but, need know uac type set (i.e. default/never notify) internal logic. is possible? please help. this article self-elevation , checking level program runs in. due security reasons i'm afraid won't able retrieve uac level set. http://code.msdn.microsoft.com/windowsdesktop/csuacselfelevation-644673d3
Read more

postgresql - Lazarus + Postgres: incomplete startup packet -

-
i've been building lazarus pascal program using postgresql on back-end. used work fine following lines opening db. dbconn:= tpqconnection.create(nil); dbconn.hostname := 'localhost'; dbconn.databasename:= 'dbhrs'; dbconn.username:='mizk'; dbconn.password:='123'; dbconn.open; if dbconn.connected openhrsdb := true else openhrsdb := false; but moment change localhost server's ip (on lan), program stops. no errors or warnings. have no clue happening. here related details may narrow down problem. the program i'm running workstation on same lan server. both machines run ubuntu 12.04 desktop i can access postgres db on server using pgadmin iii, guess it's not firewall issue. i have allowed postgresql ufw , ufw disabled. strangely, when firewall disabled, can ssh server terminal using workstation. when it's enabled, can't my biggest concern right why pascal program not working when i...
Read more

javascript - Ajax jqXHR.status==0 fix error -

-
$.ajax({ url: urlstring, datatype: "json", type: "get", success: function (data) { alert(data); }, error: function (jqxhr, exception) { if (jqxhr.status === 0) { alert('not connect.\n verify network.'); } else if (jqxhr.status == 404) { alert('requested page not found. [404]'); } else if (jqxhr.status == 500) { alert('internal server error [500].'); } else if (exception === 'parsererror') { alert('requested json parse failed.'); } else if (exception === 'timeout') { alert('time out error.'); } else if (exception === 'abort') { alert('ajax request aborted.'); } else { alert('uncaught error.\n' + jqxhr.responsete...
Read more