• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to conncect oracle 11g server from another local machine using java

 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
we have Oracle 11g Server on one machine and we want to connect that Oracle DB server using java program i have code to connect oracle db that located on same machine.. but i am confused how to connect the oracle server to java program
1.what we required for this setup.
2.How to connect.

Please help waiting for your reply. I Google but i am confused how to do this.
 
Bartender
Posts: 3648
16
Android Mac OS X Firefox Browser Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Sagar Deshmukh wrote:we have Oracle 11g Server on one machine and we want to connect that Oracle DB server using java program i have code to connect oracle db that located on same machine.. but i am confused how to connect the oracle server to java program
1.what we required for this setup.
2.How to connect.

Please help waiting for your reply. I Google but i am confused how to do this.



If you know how to connect to "localhost" then you should able to figure out how to connect to remote IP server.
 
Sagar Deshmukh
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What we required on every machin...know but confused
1.VPN access
2.or anything else
Please give some sample code....
 
author
Posts: 23951
142
jQuery Eclipse IDE Firefox Browser VI Editor C++ Chrome Java Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Sagar Deshmukh wrote:What we required on every machin...know but confused
1.VPN access
2.or anything else
Please give some sample code....



A VPN is only needed if the host is not reachable without it. If it is reachable, then you just use the hostname (or the IP address if the hostname can't be resolved).

As for example code, it is exactly the same as with the same machine setup -- except it is using the hostname (or the IP address if hostname can't be resolved), instead of localhost (or 127.0.0.1).

Henry
 
Sagar Deshmukh
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks man i will try and let know, thank you very much
 
Sagar Deshmukh
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Do you have any idea , how to call jar file from oracle database that located on /home/somepath/Runfirst.jar
We tried but we are getting below error
 
Henry Wong
author
Posts: 23951
142
jQuery Eclipse IDE Firefox Browser VI Editor C++ Chrome Java Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Sagar Deshmukh wrote:Do you have any idea , how to call jar file from oracle database that located on /home/somepath/Runfirst.jar
We tried but we are getting below error




The complaint isn't that it can't run the jar file. The complaint is that it can't run java. You need to configure the machine / database process so that it has access.

Henry
 
Sagar Deshmukh
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear Henry Wong
We are facing this problem from last 1 month,
Will you please help me what i need to do.
Please
 
Bartender
Posts: 612
7
Mac OS X Python
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Greetings

Have you gone through all of the scenarios in the full installation guides from here Oracle Setup Documents

-steve
 
reply
    Bookmark Topic Watch Topic
  • New Topic