[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-developers] Interbase-JSP-Ultradev

Bruce,
As stated earlier, if you are having trouble connecting to your DB from Dreamweaver UltraDev than you problem is with the installation of the Inerclient JDBC driver, NOT TOMCAT.
You can fool with tomcat and its policy files all day long and get no where as you have. Let's back up.
Did you inspect your /etc/inetd.conf file for a entry? If not the Interclient is not even started or running. 

The Interclient JDBC driver works on and only on port 3060.

It sounds like you are all set in your /etc/services file.
After you have checked inet, and found that the entry is there or added it if not, (instructions & sample below) and restart the inet daemon.
If it still does not work after that, added your complete hostname with domain name to your hosts.equiv file.
Also, when you call your classpath is anything returned? Enter $CLASSPATH and hit enter. If a path is returned check to see that Interclient's jar files are included in the path. 

ONce you have done all that & its still does not work let me know.
Once again, unless you are using Tomcat via a servlet or jsp on the server, the errors you are getting have nothing, absolutely nothing to do with tomcat. 

Let me know how it goes.


Bruce Letterle wrote:


Everyone, thank you for the response to my question. I really appreciate the
help.

I have checked all the files and settings suggested by the group and still
have the same error message. The tomcat.policy file has the entry for
file:/usr/interclient exactly as stated in the email, and an entry for
file:/home/sites/home/web with a SocketPermission set for localhost on port
1024. Should I have an entry for something other than localhost and should
the port be 3060? /etc/services has the entry for interserver on 3060 and
also a line for gds_db on port 3050 that says it's the Interbase Remote
Protocol. Do I need to add something for the gds_db in the tomcat.policy
file?

Bruce Letterle
Creative Web Technologies
eBusiness Web Services
412-415-5217
brucelet@xxxxxxxxxxxxxxxxxxx
http://www.creativewebtech.com


----- Original Message -----
From: "O-S Inc. Support" <support@xxxxxxxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Monday, August 27, 2001 5:36 PM
Subject: Re: [cobalt-developers] Interbase-JSP-Ultradev




Bruce,
Also for the record, connecting to a DB using Interclient JDBC driver for
Interbase directly from Dreamweaver UltraDev is possible, and should
work regardless of tomcat being installed or not.

With that being said, you will need to give tomcat all permissions as
stated in an earlier post in order to use the driver from java via jsp
or a servlet being served by tomcat.

If the problem occurs when you are trying to connect to the DB on your
server from Dreamweaver UltraDev than this has nothing to do with
Tomcat!!!!!!

It will have to do with mostly with your /etc/services file as stated
earlier.

Also make sure your /etc/inetd.conf file contains an uncommented entry


like


interserver stream tcp nowait    root /opt/interclient/bin/interserver #


Interserver JDBC Driver for IB


If its does not, add it, then go to /etc/rc.d/init.d and restart the
inetd daemon (I am not a big fan of restarts)
./inet stop
./inet start

At the moment I can't seem to remember what else we did if anything when
we manually installed interclient to get it to work.

We did add a few entries to host.equiv but I am not sure if that had
anything to do with it working.

Otherwise let me know how it goes.


Bruce Letterle wrote:

 > I am attempting to use Interbase and JSP via Dreamweaver Ultradev on
a RAQ4
 > with the JDK loaded and the Interbase driver that installs by default
with
 > the JDK. I setup Interbase using the instructions in the JDK manual
and am
 > using the interbase.interclient.Driver driver name and the
 > jdbc:interbase://www.creativewebtech.com/home/sites/home/test.gdb
URL. I am
 > getting the following error when attempting a connection from
Ultradev on my
 > PC to my remote test database:
 >
 > [interclient] Your security manager does not allow socket connections


to


 > www.creativewebtech.com on interserver port.
 > The message of the SecurityException is 'access
 > denied[java.net.SocketPermission www.creativewebtech.com resolve]'
 > See API reference for exception
 > interbase.interclient.BadInstallationException
 >
 > I cannot seem to make sense of the User Manual API section and was


hoping


 > someone would recognize the error and be able to point me in the right
 > direction.
 >
 > Bruce Letterle
 > Creative Web Technologies
 > eBusiness Web Services
 > 412-415-5217
 > brucelet@xxxxxxxxxxxxxxxxxxx
 > http://www.creativewebtech.com
 >
 > _______________________________________________
 > cobalt-developers mailing list
 > cobalt-developers@xxxxxxxxxxxxxxx
 > http://list.cobalt.com/mailman/listinfo/cobalt-developers


--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.9509
http://www.obsidian-studios.com

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers




_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers



--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.9509
http://www.obsidian-studios.com