From owner-freebsd-database Thu Feb 19 06:26:20 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA20973 for freebsd-database-outgoing; Thu, 19 Feb 1998 06:26:20 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from talon.anteon.com ([205.197.104.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA20943 for ; Thu, 19 Feb 1998 06:26:14 -0800 (PST) (envelope-from rhughes@anteon.com) From: rhughes@anteon.com Received: from talon.anteon.com (root@localhost) by talon.anteon.com (8.7.5/8.7.3) with ESMTP id JAA03003 for ; Thu, 19 Feb 1998 09:08:50 -0500 (EST) Received: from spectrum.anteon.com (spectrum.anteon.com [172.30.104.223]) by talon.anteon.com (8.7.5/8.7.3) with SMTP id JAA02999 for ; Thu, 19 Feb 1998 09:08:49 -0500 (EST) Received: from ffx.anteon.com by spectrum.anteon.com (5.x/SMI-SVR4) id AA02421; Thu, 19 Feb 1998 09:14:41 -0500 Received: from ccMail by ffx.anteon.com (ccMail Link to SMTP R6.00.01) id AA887897434; Thu, 19 Feb 98 09:10:39 -0500 Message-Id: <9802198878.AA887897434@ffx.anteon.com> X-Mailer: ccMail Link to SMTP R6.00.01 Date: Thu, 19 Feb 98 07:43:06 -0500 To: Subject: Oracle Access via JDBC Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk This might be the wrong list for the question, but here goes. I'm trying to use the JDBC Thin drivers (ver 1.1.1, I believe) to connect to an Oracle Database on an HP. The notes from Oracle indicate that the java class must enable UniversalConnect privilege to make the connection from my FreeBSD server to the Oracle server. However, I am unable to get the call to enablePrivilege() to compile. I guess I'm not familiar enough with the security classes of java or Netscape to know exactly what to call and when Has anyone gotten a similar connection to work ?? If so I'd *really* appreciate a scrap of java code to compare to the mess I've made. Many thanks ! R. Hughes Anteon Corp. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Feb 19 19:11:14 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA25665 for freebsd-database-outgoing; Thu, 19 Feb 1998 19:11:14 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from const. (willow20.verinet.com [199.45.181.52]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA25654 for ; Thu, 19 Feb 1998 19:11:08 -0800 (PST) (envelope-from allenc@verinet.com) Received: (from allenc@localhost) by const. (8.8.8/8.8.8) id UAA01530; Thu, 19 Feb 1998 20:11:20 -0700 (MST) (envelope-from allenc) Date: Thu, 19 Feb 1998 20:11:20 -0700 (MST) From: allen campbell Message-Id: <199802200311.UAA01530@const.> To: freebsd-database@FreeBSD.ORG, rhughes@anteon.com Subject: Re: Oracle Access via JDBC Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > I'm trying to use the JDBC Thin drivers (ver 1.1.1, I believe) to > connect to an Oracle Database on an HP. Doesn't the client host need the SQL*Net client to connect to communicate with Oracle? allenc@verinet.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Feb 20 05:43:39 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA21024 for freebsd-database-outgoing; Fri, 20 Feb 1998 05:43:39 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from talon.anteon.com ([205.197.104.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA21014 for ; Fri, 20 Feb 1998 05:43:36 -0800 (PST) (envelope-from rhughes@anteon.com) From: rhughes@anteon.com Received: from talon.anteon.com (root@localhost) by talon.anteon.com (8.7.5/8.7.3) with ESMTP id IAA13909 for ; Fri, 20 Feb 1998 08:43:44 -0500 (EST) Received: from spectrum.anteon.com (spectrum.anteon.com [172.30.104.223]) by talon.anteon.com (8.7.5/8.7.3) with SMTP id IAA13905 for ; Fri, 20 Feb 1998 08:43:44 -0500 (EST) Received: from ffx.anteon.com by spectrum.anteon.com (5.x/SMI-SVR4) id AA06493; Fri, 20 Feb 1998 08:49:40 -0500 Received: from ccMail by ffx.anteon.com (ccMail Link to SMTP R6.00.01) id AA887982386; Fri, 20 Feb 98 08:46:30 -0500 Message-Id: <9802208879.AA887982386@ffx.anteon.com> X-Mailer: ccMail Link to SMTP R6.00.01 Date: Fri, 20 Feb 98 07:36:47 -0500 To: , Subject: Re[2]: Oracle Access via JDBC Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Depends on the JDBC driver, Oracle has two. They provide an OCI based driver that does require the SQL*Net libraries on the client side (I have those, BTW). They also provide what they describe as a "thin" JDBC driver that *does not* require SQL*Net. It's a native Java class and uses Java sockets. I can get either one to work through the AppletViewer provided with the JDK, but NOT through a web browser (the whole point of this exercise). The problems I am encountering seem to be security related. Thanks for the reply! R. Hughes ______________________________ Reply Separator _________________________________ Subject: Re: Oracle Access via JDBC Author: allen campbell at internet Date: 2/19/98 8:11 PM > > I'm trying to use the JDBC Thin drivers (ver 1.1.1, I believe) to > connect to an Oracle Database on an HP. Doesn't the client host need the SQL*Net client to connect to communicate with Oracle? allenc@verinet.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Feb 20 09:21:46 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA27208 for freebsd-database-outgoing; Fri, 20 Feb 1998 09:21:46 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from bamboo.verinet.com (allenc@bamboo.verinet.com [204.144.246.3]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA27176 for ; Fri, 20 Feb 1998 09:21:37 -0800 (PST) (envelope-from allenc@bamboo.verinet.com) Received: (from allenc@localhost) by bamboo.verinet.com (8.8.8/8.7.1) id KAA03422; Fri, 20 Feb 1998 10:21:35 -0700 Date: Fri, 20 Feb 1998 10:21:35 -0700 From: Allen Campbell Message-Id: <199802201721.KAA03422@bamboo.verinet.com> To: allenc@verinet.com, freebsd-database@FreeBSD.ORG, rhughes@anteon.com Subject: Re: Re[2]: Oracle Access via JDBC Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > They provide an OCI based driver that does require the SQL*Net > libraries on the client side (I have those, BTW). > Binaries for FreeBSD? > > They also provide what they describe as a "thin" JDBC driver that > *does not* require SQL*Net. It's a native Java class and uses Java > sockets. > I was not aware of this. This is where the real payoff of Java appears. Vendors such as Oracle neglect the free OSes; here they support us by default. Allen Campbell allenc@verinet.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Feb 20 23:13:15 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA07851 for freebsd-database-outgoing; Fri, 20 Feb 1998 23:13:15 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from const. (willow6.verinet.com [199.45.181.38]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id XAA07842 for ; Fri, 20 Feb 1998 23:13:13 -0800 (PST) (envelope-from allenc@verinet.com) Received: (from allenc@localhost) by const. (8.8.8/8.8.8) id AAA12593 for freebsd-database@freebsd.org; Sat, 21 Feb 1998 00:07:41 -0700 (MST) (envelope-from allenc) Date: Sat, 21 Feb 1998 00:07:41 -0700 (MST) From: allen campbell Message-Id: <199802210707.AAA12593@const.> To: freebsd-database@FreeBSD.ORG Subject: Re: Re[4]: Oracle Access via JDBC Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > The problem I'm really having is in getting the Netscape browser on > the workstation to access the database using the served applet. > (Kinda convoluted, ain't it ???) > Could this be a sandbox issue? What I mean is; the applet on the browsing (Netscape or whatever) client is running inside the Java sandbox. The applet should only be able to connect to the host from which it was served (if I remember the 'sandbox' security stuff correctly.) If I'm reading you right, the applet is being served from a FreeBSD host. By definition, the FreeBSD host can not also be the Oracle host. Since the FreeBSD host served the applet, and its not also the Oracle host, you can't get there from here. If I'm making some egregious error due to I don't know _how_ many assumptions, please be gentle. 8) Allen Campbell allenc@verinet.com BTW, your return address, rhughes@anteon.com, just bounces. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Feb 21 05:06:46 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA22789 for freebsd-database-outgoing; Sat, 21 Feb 1998 05:06:46 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from In-Net.inba.fr (arthur.inba.fr [194.51.120.34]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA22760 for ; Sat, 21 Feb 1998 05:06:27 -0800 (PST) (envelope-from phschack@inba.fr) Received: from uther.inba.fr (uther.inba.fr [194.51.120.62]) by In-Net.inba.fr (8.8.5/8.8.5) with SMTP id OAA07829 for ; Sat, 21 Feb 1998 14:08:31 +0100 (MET) Message-Id: <3.0.1.32.19980221140745.00899360@mail.inba.fr> X-Sender: psc@mail.inba.fr X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Demo [F] Date: Sat, 21 Feb 1998 14:07:45 +0100 To: freebsd-database@FreeBSD.ORG From: Philippe SCHACK Subject: Virtual supermarket Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.freebsd.org id FAA22782 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi, Is there any software to build a virtual supermarket based on Perl/DBI modules ? I know perlshop, but it is based on fixed web pages. Thanks for your answers. -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Vous cherchez un bien immobilier ? consultez http://www.ImmoSearch.inba.fr/ *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Philippe SCHÄCK IN'NET BORDEAUX-AQUITAINE Tél. : + 33 57.24.18.11 Chauveau - CD 239 Fax : + 33 57.24.18.28 33420 ESPIET E-mail : phschack@inba.fr *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message