JDBC And Oracle WS 7.3 (NT)

From: Ralf Zimmermann <ralf.zimmermann_at_zbs.de>
Date: 1997/06/20
Message-ID: <33AAEC30.BE2B7D6B@zbs.de>#1/1

Hi there,

I've got a problem to connect from a java application to Oracle Workgroup Server 7.3 which
is running under NT Server 4.0 via JDBC. (Comment: There are no problems to connect via
JDBC-ODBC-Bridge).

I've tried to connect using Intersolv's SequeLink Java-Edition. The SequeLink server has
been installed as well as the SequeLink client and all necessary settings have been done,
e.g. executing the "oraprep.sql"-script, setting up the
"classpath"-variable, etc.

Well, it seems, that I get an connect - if I believe in the result of the
"acceptsURL"-method - but at least there's an access denial (please have
a look on the
following example):

import java.net.URL;
import java.sql.*;

class JdbcOracle
{

   public static void main (String Args[])    {

      String dbURL = "jdbc:javalink://rzpc01:4003/[Oracle]";

      try
      {
         Driver d = (Driver)Class.forName

("intersolv.jdbc.javalink.JavaLinkDriver").newInstance();

         if (d.acceptsURL (dbURL))
         {
            DriverManager.registerDriver (d);
            System.out.println ("[Driver registration okay]");

            Connection c = DriverManager.getConnection (dbURL, "leser",


"lesen");

            System.out.println ("[Connect successful.]");
         }
         else
            System.out.println ("[Database URL is not valid]");
      }
      catch (Exception e)
      {
         System.err.println ("[Driver-Error]: " + e);
      }

   }
}

Console output is at follows:

[Driver registration okay]
[Driver-Error]: java.sql.SQLException: [INTERSOLV][JavaLink]TCP Connection rejected,
invalid user id or password

My hard- and software configuration:

Windows NT Server 4.0, Service Pack 2
Oracle Workgroup Server 7.3
JDK 1.1.1
JDBC 1.22
Intersolv SequeLink Java-Edition Server 3.50 + Client software

My database configuration:

Database instance  : ORCL
Database alias     : ZBS
Protocol           : TCP/IP
Host name (Server) : RZPC01
Service name       : ZBS.world
User name*         : leser
User password*     : lesen

*I've tried it with SQL*Plus and there are no problems to connect!  I've also tried to connect using several other accounts, e.g. "sys" or
"system". No

chance.

I'll be much obliged for any ideas solving my problems!

Greetings from Heidenheim/Germany
Ralf Zimmermann

---
----------------------------------------------------------------------
| _/_/_/_/_/  _/_/_/_/     _/_/_/_/  | Zimmermann Business Solutions |
|        _/   _/     _/   _/      _/ |                               |
|       _/    _/      _/  _/         | Ralf Zimmermann               |
|      _/     _/     _/   _/         | Emil-Nolde-Strasse 15         |
|     _/      _/_/_/_/     _/_/_/_/  | 89520 Heidenheim              |
|    _/       _/     _/           _/ | Germany                       |
|   _/        _/      _/          _/ |                               |
|  _/         _/     _/   _/      _/ | Phone:   +49 (73 21) 96 66- 0 |
| _/_/_/_/_/  _/_/_/_/     _/_/_/_/  | Fax:     +49 (73 21) 96 66-25 |
----------------------------------------------------------------------

Received on Fri Jun 20 1997 - 00:00:00 CDT