Re: Oracle/Novell
Date: Sat, 03 Jul 1999 13:29:07 -0700
Message-ID: <377E7293.BF58C10D_at_earthlink.net>
I have NW5 and Oracle 8i running - not much differenct than any other RDBMS. You will probably want to become an Oracle Developer/ (Join free on their website). The OTN has forums and tech support specific to Oracle and Novell.
Start simple:
1. is the server NLM running? (It needs to be loaded each time the server
boots, and a password entered. use ORALOAD.NCF)
2. Are the server listeners set up? 3. Is the correct Oracle driver available on the client? 4. Can you set up a client connection with the Oracle tools? 5. Can you make a programming connection?(You did not say what programming language you use. I've only used Java on the Oracle server, but C, PowerBuilder, and other tools should work. )
This is my Java test code. You will have to change the parameters and query to fit your situation.
import java.awt.*;
import java.sql.*;
class SQLTest
{
public static void loadDriver(String dbDriver)
{
//----- Load the Oracle JDBC driver -----
try
{
Class.forName (dbDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
}
public static Connection dbConnect(String url, String uid, String password)
{
Connection con;
//----- Load the Oracle JDBC driver -----
try
{
con = DriverManager.getConnection(url, uid, password);
}
catch(SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
return null;
}
return con;
}
public static void dbQuery(Connection con, String query)
throws SQLException
{
String s;
ResultSet results;
Statement stmt;
//----- Create a SQL statement -----
stmt = con.createStatement ();
//----- Execute query ----- results = stmt.executeQuery (query); //----- Iterate through results; print file names ----- while (results.next ())
{
s = results.getString(1).trim() + "," + results.getString(2).trim(); System.out.println(s);
}
}
public static void main (String args [])
throws SQLException
{
String url,
dbDriver,
uid, pword,
query;
Connection con;
//----- Set Oracle parameters -----
url = "jdbc:oracle:thin:_at_NWservername:1521:ORCL";
dbDriver = "oracle.jdbc.driver.OracleDriver";
uid = "internal";
pword = "oracle";
query = "select name from baseline.bfile";
//----- Load the JDBC driver -----
loadDriver(dbDriver);
//----- Get connection parameters ----- getLoginInfo(uid, pword);
//----- Connect to database -----
con = dbConnect(url, uid, pword);
if (con != null)
{
//----- Make SQL query ----- dbQuery(con, query); //----- Close connection ----- con.close();
}
}
} //--- end of class SQLTest ---
sqingey wrote:
> > I will attempt to make some sense here. I work independently on the > side. I was hired to develop a system to maintain data for a medical > laboratory. The company upgraded to Novell 5.0 which ships with > Oracle 8. I know nothing about either, but up until now had faith in > my ability as a programmer/analyst. We have an inidividual who comes > in whenever we need hardware upgraded, or need network tasks done. He > installed Oracle. Neither he nor I know anything about Oracle. It is > very confusing and I cannot get Oracle to work on their small network. > I also chose Visual Cafe to develop the client side application. I'm > not sure this was the right choice as there is something about this > dbAnywhere which seems to be made for NT (which we do not have at the > moment). I guess what I am asking is if anyone knows of any good and > easy to understand resources that will assist me in getting Oracle to > work on this Novell network, and any resources that will guide me in > developing a system for this company. Any help is greatly appreciated > as this has been a nightmare so far. > > Thank you, > Jon CardellaReceived on Sat Jul 03 1999 - 22:29:07 CEST