----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
You should use the classesXX files that are shipped with your database.
How are sDataBase,sUser and sPwd defined?
Why not do:
con = DriverManager.getConnection("jdbc:oracle:thin:@"+ sDBHost +":1521:" +
sDataBase + ":" + sUser + ":" + sPwd);
instead?
What you want to make sure, is that you end up with a string looking like
this:
jdbc:oracle:thin:@machine:1521:databaseSID
Are the listner etc running - can you TNSping (not ping) the database ?
The name of the server could be darko as well as www.darko.xyz.
You just have to make sure that you do not conflict with any
existing names, and possibly (?) that the name is registered on an
DNS-server. Since you run NT Server, you could run the DNS yourself.
Regards,
Kim
-----Oprindelig meddelelse-----
Fra: Darko Stankovic [mailto:[EMAIL PROTECTED]]
Sendt: 16. januar 2001 17:21
Til: Java Apache Users
Emne: RE: ApacheJServ-oracle
----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hello,
First of all I want to thank everybody that bears with me here.
Kim, I tried to ping that server and I am able to. Ok here is a situation,
yes I am using 8.1.6 on nt server. My linux server has only ip address, and
here is how I try to connect to that database on nt server :
con = DriverManager.getConnection("jdbc:oracle:thin:@"+ sDBHost +":1521:" +
sDataBase,sUser,sPwd);
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCCUR_UPDATABLE);
Also I set up wrapper.classpaths to point to classes111.zip and
nls_charset11.zip in my jserv.properties file.
Where everything is predefined. Somewhere in these lines is an error. I
should mention if I use an ip for sDBHost it gives an error, and if I use a
name I get that exception. Also sDBHost is just a name, and lets call it
"name" because it is also not registered name, but it can be accessed thru
the internet.
Is it possible to use an ip address or I need to use a name or should that
be a registered name such as www.name.com.
If anybody could help, I would apreciate it.
Thanx for your help.
Darko
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kim
Anthonisen
Sent: January 16, 2001 10:34 AM
To: 'Java Apache Users'
Subject: SV: ApacheJServ-oracle
----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Changing from classes ...12 to ..111 indicates that you are connecting to an
Oracle 8.1.6 Database - right?
The exception indicates that your connectstring is not correct.
Can you ping & TNSping the database ?
Regards,
Kim
-----Oprindelig meddelelse-----
Fra: Darko Stankovic [mailto:[EMAIL PROTECTED]]
Sendt: 16. januar 2001 16:26
Til: Java Apache Users
Emne: RE: ApacheJServ-oracle
----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hello,
I changed classes12.zip to classes111.zip, and it seems to be working
better, but I still get this error now :
java.sql.SQLException: Io exception: The Network Adapter could not establish
the connection
Well it looks like my network card is no good, but it is since I am able to
telnet, ftp and so on. Also there is nothing in my logs that says anything
about this.
Does anybody know why it could not establish a connection ?
Thanx,
Darko
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ben Ricker
Sent: January 15, 2001 5:36 PM
To: Java Apache Users
Subject: Re: ApacheJServ-oracle
----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
I do not think so, that is, I never set it in my LD_LIBRARY path.
Anyway, if you can send me the complete error trace from the log I can
help you a little bit better.
Ben Ricker
Darko Stankovic wrote:
> ----------------------------------------------------------------
> BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> WHEN YOU POST, include all relevant version numbers, log files,
> and configuration files. Don't make us guess your problem!!!
> ----------------------------------------------------------------
>
> Also here is the catch I think.
>
> Well ai have nost set LD_LIBRARY_PATH, do I need this in order for
> oracle-jdbc-thin driver to work ?
>
> Thanx
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
The information in this e-mail and any attached files is confidential. It
is intended solely for the use of the addressee. Any unauthorised
disclosure or use is prohibited. If you are not the intended recipient of
the message, please notify the sender immediately and do not disclose the
contents to any other person, use it for any purpose, or store or copy the
information in any medium. The views of the author may not necessarily
reflect those of the Company.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
The information in this e-mail and any attached files is confidential. It
is intended solely for the use of the addressee. Any unauthorised
disclosure or use is prohibited. If you are not the intended recipient of
the message, please notify the sender immediately and do not disclose the
contents to any other person, use it for any purpose, or store or copy the
information in any medium. The views of the author may not necessarily
reflect those of the Company.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
