Newbie jdbc question on URL error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Fred

    Newbie jdbc question on URL error

    Hi,
    I'm new to Oracle. I've got 9i setup on a Windows 2000 machine, named
    "Jackie", and using the userid of "Scott" with password "Tiger", I can do
    SQLPLus commands to my hearts content. From a second machine, I can even do
    iSQLPlus to "Jackie", great.
    On the second machine, I'm trying to establish a JDBC connection using the
    string Connection conn =
    DriverManager.g etConnection("j dbc:oracle:thin @jackie:1521:Gl obal1","scott", "
    tiger"); (SID is Global1).
    I am receiving the following error: Invalid Oracle URL specified . I'm
    trying to turn tracing on to get more information on the "Jackie" system,
    but I'm not even sure that I'm getting out of the system that the Java app
    is being run on.
    Questions:
    1) Does the database URL look okay?
    2) Is there source for the Oracle JDBA stuff somewhere so I can step through
    in debug?
    3) How does one turn tracing on in Oracle so I can get more information as
    to what is wrong?

    Thanks.


  • Fred

    #2
    Re: Newbie jdbc question on URL error

    Found my problem - missing a ":" between the thin and the "@".
    "Fred" <Fred@isp.comwr ote in message
    news:H6%Ib.2404 0$I07.60172@att bi_s53...
    Hi,
    I'm new to Oracle. I've got 9i setup on a Windows 2000 machine, named
    "Jackie", and using the userid of "Scott" with password "Tiger", I can do
    SQLPLus commands to my hearts content. From a second machine, I can even
    do
    iSQLPlus to "Jackie", great.
    On the second machine, I'm trying to establish a JDBC connection using the
    string Connection conn =
    >
    DriverManager.g etConnection("j dbc:oracle:thin @jackie:1521:Gl obal1","scott", "
    tiger"); (SID is Global1).
    I am receiving the following error: Invalid Oracle URL specified . I'm
    trying to turn tracing on to get more information on the "Jackie" system,
    but I'm not even sure that I'm getting out of the system that the Java app
    is being run on.
    Questions:
    1) Does the database URL look okay?
    2) Is there source for the Oracle JDBA stuff somewhere so I can step
    through
    in debug?
    3) How does one turn tracing on in Oracle so I can get more information as
    to what is wrong?
    >
    Thanks.
    >
    >

    Comment

    Working...