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

["William L. Thomson Jr." <wlt@xxxxxxxxxxxxxxxxxxxx>]

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.
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.9509
http://www.obsidian-studios.com