This page contains an archived post to the Java Answers Forum made prior to February 25, 2002.
If you wish to participate in discussions, please visit the new
Artima Forums.
Message:
server and SID
Posted by Henry Minsky on February 12, 2001 at 8:45 PM
> > I want to make a Database Connection to Personal oracle 8 using thin driver classes12.zip I am using windows98 and personal oracle 8. I have set my autoexec.bat file properly.I am told I will have to use the foll syntax > Class.forName("oracle.jdbc.driver.OracleDriver"); > conn=DriverManager.getConnection > ("jdbc:oracle:thin:@Servername:1528:ora8); > Now instead of servername what do I put since I am not working on a server I am working on a stand alone machine(win98) and instead of ora8 which I am told is the SID what do I put in since I havent made a SID. It the SID necessary ? > > If you have a database installed and running, then it does have a SID. You just need to find it. I only use Oracle on Unix so I don't know where environment vars etc are stored on a Windows box. You should be able to specify a hostname of "localhost", or 127.0.0.1, check your windows HOSTS file to make sure localhost is defined. your machine does have an IP address, and may have a hostname as well, or you can give it a hostname in the hosts file, which will be sufficient for local use.
Replies:
|