RE: OS calls with java stored procedures
Yes, it's exec dbms_java.set_output(2000); Richard Ji -Original Message- Sent: Tuesday, December 09, 2003 8:50 AM To: Multiple recipients of list ORACLE-L I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE. -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OS calls with java stored procedures
ummm ... something like
system('`my_code`'); --- check there are backticks ...
Not sure if it will run, but hey ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Tuesday, December 09, 2003 8:35 AM
To: Multiple recipients of list ORACLE-L
Im playing with the example in tom kytes book. we have alot of korn shell scripts that
we use as functions.
We 'echo' out values to standard out. is there anyway to catch this echo with a java
stored procedure? I thought about redirecting it to a file and reading it in with
utl_file, but that makes it more complex.
any other way to do this?
**
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
**4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OS calls with java stored procedures
I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE. -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OS calls with java stored procedures
Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: c based external procedures vs. Java Stored Procedures
My feeling is that, given the clumsy way external procedures are implemented, the argument of C speed doesn't hold too well. If you must write a function which will be called through IPCs each time you return a row, from instance, C will look javaish in speed. Add to this that static variables cannot be relied upon because the function can be reloaded anytime, that you have to be very careful about the really fun C stuff for fear of interference with Oracle (signals, etc.) - My feeling is that external C functions have no real practical use. If speed is a concern (and it often is) it should be C which calls Oracle, not the reverse. My EUR 0.02 Stephane Faroult >- --- Original Message --- - >From: Jared Still <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Thu, 04 Sep 2003 15:49:26 > >Or Perl... > >On Thu, 2003-09-04 at 14:54, Richard Ji wrote: >> >so my question is, are there things you can do >with external procedures that you cant do with >java? >> >> Yes there are, for instance, Java doesn't support >raw socket, so if you ever need that >> you will have to do it in C with external >procedure. But what's the chance of anyone >> is going to use such a thing, very little. In >general though, you can do most of the >> stuff in Java Stored Procedures. >> >> Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Or Perl... On Thu, 2003-09-04 at 14:54, Richard Ji wrote: > >so my question is, are there things you can do with external procedures that you > >cant do with java? > > Yes there are, for instance, Java doesn't support raw socket, so if you ever need > that > you will have to do it in C with external procedure. But what's the chance of anyone > is going to use such a thing, very little. In general though, you can do most of the > stuff in Java Stored Procedures. > > Richard Ji > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
>so my question is, are there things you can do with external procedures that you cant >do with java? Yes there are, for instance, Java doesn't support raw socket, so if you ever need that you will have to do it in C with external procedure. But what's the chance of anyone is going to use such a thing, very little. In general though, you can do most of the stuff in Java Stored Procedures. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Anything stored is always easier to configure then anything external. It shouldn't be easier to use, though. And you should judge where dies it make sense. For reading a simple file 10 times a day (document scanning application at my previous company), a properly written C program (using fork, readv and writev, without fscanf and fprintf bells and whistles) will outperform almost anything else. For taking to other applications, network communication and alike, Java is not significantly slower and is much easier to program. If you want a simple database script, PL/SQL is by far the best solution. And if your goal is to make me like you, use perl. -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
We have tested a product this winter that was using an external C proc to call cobol programs. Stephane -Original Message- Jared Still Sent: Thursday, September 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach. There are other security implications as well. Even running as 'nobody', you need to ensure that the code is written in a secure manner. As for why you would use them, there are probably more reasons than we can think of here. One that comes to mind is you have data that needs massaged by an algorithm in a purchased library. Rather than writing a whole app to deal with it, you write a wrapper for the purchased functionality and plug it into EXTPROC. You can even do this with Perl. Works very well. :) Jared On Thu, 2003-09-04 at 07:49, [EMAIL PROTECTED] wrote: > Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. > > So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. > > so my question is, are there things you can do with external procedures that you cant do with java? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Ryan I'm no expert either. What I heard is that the advantage of external procedures were good where you have something that needs the performance of the underlying system. The C code runs directly on the server, whereas Java is on top of Oracle, which is system-independent. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Depends on your developers. We have few JAVA developers, but quite a few C programmers. Plus I've got this great book of math routines in C. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, September 04, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: c based external procedures vs. Java Stored Procedures
One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach. There are other security implications as well. Even running as 'nobody', you need to ensure that the code is written in a secure manner. As for why you would use them, there are probably more reasons than we can think of here. One that comes to mind is you have data that needs massaged by an algorithm in a purchased library. Rather than writing a whole app to deal with it, you write a wrapper for the purchased functionality and plug it into EXTPROC. You can even do this with Perl. Works very well. :) Jared On Thu, 2003-09-04 at 07:49, [EMAIL PROTECTED] wrote: > Ive just started digging into these. Im familiar with Java and C, though Im hardly > an expert. It appears that java stored procedures are much easier to use and far > more forgiving than C based external procedures. > > So then I started looking for functionality that external procedures have over java > and I cant find any. Since I cant find any, I dont see any reason to spend time > learning how to use them. > > so my question is, are there things you can do with external procedures that you > cant do with java? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
c based external procedures vs. Java Stored Procedures
Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
Jated, Okay, because I don't know anything about it and we are supposed to go into staging/load testing by the end of this month? He is a brand new project manager and very smart but very inexperienced in the concepts of project planning and functional specs Rachel --- [EMAIL PROTECTED] wrote: > Rachel, > > From 8i+, I don't think that Intermedia is a separately licensed > product. > > e.g. You already paid for it. > > Jared > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/05/2002 01:33 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: java stored procedures > > > a) because it's not installed or licensed > b) because it won't do the conversions to the data that he wants > c) because unless Oracle Text has significantly improved in speed > since > the last time I tried it, it's not fast enough > > I got him to agree to run the java code that processes the data > OUTSIDE > the database and then sqlload the resultant file into the search > table > > > --- [EMAIL PROTECTED] wrote: > > Why not use intermedia? > > > > Jared > > > > > > > > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 09/05/2002 06:08 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:java stored procedures > > > > > > This really is my week for asking for help. > > > > We have a project lead/developer here who wants to use a java > stored > > procedure, wrapped in a PL/SQL function, to implement a search > > function > > on the site. > > > > Besides the fact that this is the first I've heard of the request, > > and > > that I think he is reinventing the wheel in what he wants to do in > > this > > procedure (normalize text data that we already GET normalized > > elsewhere), and that we are supposed to go into QA testing by the > end > > of the month and he STILL hasn't locked down the schema etc > > > > Personal prejudices aside, I've heard vague rumblings that Java in > > the > > database is not optimal. We'll be in 9iR2, although he's developing > > against an 8.1.7 database (don't ask, I'm not responsible for that > > database other than to provide him with schema ddl, there IS no > real > > development server here). > > > > Before I categorically say no or yes, are there any "gotchas" I > need > > to > > look out for? > > > > Thanks > > > > Rachel > > > > __ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > &g
Re: java stored procedures
Rachel, >From 8i+, I don't think that Intermedia is a separately licensed product. e.g. You already paid for it. Jared Rachel Carmichael <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2002 01:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: java stored procedures a) because it's not installed or licensed b) because it won't do the conversions to the data that he wants c) because unless Oracle Text has significantly improved in speed since the last time I tried it, it's not fast enough I got him to agree to run the java code that processes the data OUTSIDE the database and then sqlload the resultant file into the search table --- [EMAIL PROTECTED] wrote: > Why not use intermedia? > > Jared > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/05/2002 06:08 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:java stored procedures > > > This really is my week for asking for help. > > We have a project lead/developer here who wants to use a java stored > procedure, wrapped in a PL/SQL function, to implement a search > function > on the site. > > Besides the fact that this is the first I've heard of the request, > and > that I think he is reinventing the wheel in what he wants to do in > this > procedure (normalize text data that we already GET normalized > elsewhere), and that we are supposed to go into QA testing by the end > of the month and he STILL hasn't locked down the schema etc > > Personal prejudices aside, I've heard vague rumblings that Java in > the > database is not optimal. We'll be in 9iR2, although he's developing > against an 8.1.7 database (don't ask, I'm not responsible for that > database other than to provide him with schema ddl, there IS no real > development server here). > > Before I categorically say no or yes, are there any "gotchas" I need > to > look out for? > > Thanks > > Rachel > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Dieg
RE: java stored procedures
Not saying it's a good thing to do. You mentioned thin driver doesn't work with MTS which is not true. Just want to point it out. Best Regards -Original Message- Sent: Thursday, September 05, 2002 5:39 PM To: Multiple recipients of list ORACLE-L >From aesthetic point of view, writing the whole TNS descriptor into the code is completely and utterly disgusting, something like mandatory cavity searches as a part of improved airport security. > -Original Message- > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 4:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: java stored procedures > > > No, besides the hostname:sid:port syntax, you can also use > the long connect > string "jdbc:oracle:thin:@(description=(address=(host= ..." syntax. > > And it works with both MTS and dedicated server. > > Richard Ji > > -Original Message- > Sent: Thursday, September 05, 2002 3:24 PM > To: Multiple recipients of list ORACLE-L > > > Last time I checked, it was using the old SQL*Net 1.1 syntax, > namely hostname:sid:port and the server was always a dedicated > one, especially if the connection pooling was turned on. > > > -Original Message- > > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 05, 2002 1:29 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: java stored procedures > > > > > > >b) The thin driver can only use dedicated server connection > > which does > > >miracles for load balancing. > > > > Where did you get that? Thin driver works with MTS. There are > > configuration > > issues working with MTS that only thin driver encounters. > > > > Richard Ji > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ji, Richard > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Netwo
RE: java stored procedures
>From aesthetic point of view, writing the whole TNS descriptor into the code is completely and utterly disgusting, something like mandatory cavity searches as a part of improved airport security. > -Original Message- > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 4:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: java stored procedures > > > No, besides the hostname:sid:port syntax, you can also use > the long connect > string "jdbc:oracle:thin:@(description=(address=(host= ..." syntax. > > And it works with both MTS and dedicated server. > > Richard Ji > > -Original Message- > Sent: Thursday, September 05, 2002 3:24 PM > To: Multiple recipients of list ORACLE-L > > > Last time I checked, it was using the old SQL*Net 1.1 syntax, > namely hostname:sid:port and the server was always a dedicated > one, especially if the connection pooling was turned on. > > > -Original Message- > > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 05, 2002 1:29 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: java stored procedures > > > > > > >b) The thin driver can only use dedicated server connection > > which does > > >miracles for load balancing. > > > > Where did you get that? Thin driver works with MTS. There are > > configuration > > issues working with MTS that only thin driver encounters. > > > > Richard Ji > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ji, Richard > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
a) because it's not installed or licensed b) because it won't do the conversions to the data that he wants c) because unless Oracle Text has significantly improved in speed since the last time I tried it, it's not fast enough I got him to agree to run the java code that processes the data OUTSIDE the database and then sqlload the resultant file into the search table --- [EMAIL PROTECTED] wrote: > Why not use intermedia? > > Jared > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/05/2002 06:08 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:java stored procedures > > > This really is my week for asking for help. > > We have a project lead/developer here who wants to use a java stored > procedure, wrapped in a PL/SQL function, to implement a search > function > on the site. > > Besides the fact that this is the first I've heard of the request, > and > that I think he is reinventing the wheel in what he wants to do in > this > procedure (normalize text data that we already GET normalized > elsewhere), and that we are supposed to go into QA testing by the end > of the month and he STILL hasn't locked down the schema etc > > Personal prejudices aside, I've heard vague rumblings that Java in > the > database is not optimal. We'll be in 9iR2, although he's developing > against an 8.1.7 database (don't ask, I'm not responsible for that > database other than to provide him with schema ddl, there IS no real > development server here). > > Before I categorically say no or yes, are there any "gotchas" I need > to > look out for? > > Thanks > > Rachel > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
No, besides the hostname:sid:port syntax, you can also use the long connect string "jdbc:oracle:thin:@(description=(address=(host= ..." syntax. And it works with both MTS and dedicated server. Richard Ji -Original Message- Sent: Thursday, September 05, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. > -Original Message- > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 1:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: java stored procedures > > > >b) The thin driver can only use dedicated server connection > which does > >miracles for load balancing. > > Where did you get that? Thin driver works with MTS. There are > configuration > issues working with MTS that only thin driver encounters. > > Richard Ji > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
Why not use intermedia? Jared Rachel Carmichael <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2002 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any "gotchas" I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. > -Original Message- > From: Ji, Richard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 1:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: java stored procedures > > > >b) The thin driver can only use dedicated server connection > which does > >miracles for load balancing. > > Where did you get that? Thin driver works with MTS. There are > configuration > issues working with MTS that only thin driver encounters. > > Richard Ji > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ji, Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
oh we are definitely Oracle/Sun, it's just that the servers are just now being installed --- Peter Barnett <[EMAIL PROTECTED]> wrote: > We have several developers using java stored > procedures. No real 'gotchas' other than making sure > all of the java versions are correct. Java is > essentially dumbed down C++. Why folks want to go to > the extra steps coding baffles me since PL/SQL is much > more powerful inside the database. But, there is a > lot to be said for portability. Especially, when the > final envirnoment is yet to be determined. > > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > This really is my week for asking for help. > > > > We have a project lead/developer here who wants to > > use a java stored > > procedure, wrapped in a PL/SQL function, to > > implement a search function > > on the site. > > > > Besides the fact that this is the first I've heard > > of the request, and > > that I think he is reinventing the wheel in what he > > wants to do in this > > procedure (normalize text data that we already GET > > normalized > > elsewhere), and that we are supposed to go into QA > > testing by the end > > of the month and he STILL hasn't locked down the > > schema etc > > > > Personal prejudices aside, I've heard vague > > rumblings that Java in the > > database is not optimal. We'll be in 9iR2, although > > he's developing > > against an 8.1.7 database (don't ask, I'm not > > responsible for that > > database other than to provide him with schema ddl, > > there IS no real > > development server here). > > > > Before I categorically say no or yes, are there any > > "gotchas" I need to > > look out for? > > > > Thanks > > > > Rachel > > > > __ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > = > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Barnett > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Rachel I agree with Mladen. Java as a programming language is good. It has a good long-range forecast compared with alternatives. We are getting ready to dump 20 years our company has invested in COBOL on one system. Making sure you write your code in a language that will be around 20 years from now is more important than most of us know. As to writing database stored procedures in Java, the situation is a little more iffy. Compared with PL/SQL, most reports I hear is that usually PL/SQL is faster. No surprise since PL/SQL is doing exactly what it was developed to do. If speed is critical, I would say go with PL/SQL. If speed isn't so critical, then a Java servlet on an application server may be fast enough. Which means the value of Java stored procedures may not be as great as you might assume. This is what I have figured out so far, look forward to opinions of others. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Actually, Java is not so bad idea. Aurora does pretty much the same thing as PL/SQL and it is very hard to get to OS or network because security doesn't let you. On the plus side, bad programs in Java are more portable then the ones in PL/SQL. IDE software for Java is better suited for duhvelopers then the one for PL/SQL. You will have to increase Java pool and you will have to increase system tablespace because your developers will start abusing loadjava almost instantly and start loading .jar files (like for XML, for instance). Also, your CPU and RAM usage will go up fairly quickly so you might consider convincing your boss to finally do that HW upgrade. Expect attempts to use thin JDBC driver. The nice features of the thin driver are a) It's written entirely in Java, which makes it much slower then an optimized C code like OCI driver and, therefore, preferred by duhvelopers in the name of "generality" and "universality". Stupidity is another very universal thing. b) The thin driver can only use dedicated server connection which does miracles for load balancing. There is "connection pooling", which also requires dedicated server to work. Because it cannot use MTS and TNS in general, thin driver must have a hard-wired connection string written in the code or parameter file, which apparently doesn't diminish "generality" and "universality". > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 9:08 AM > To: Multiple recipients of list ORACLE-L > Subject: java stored procedures > > > This really is my week for asking for help. > > We have a project lead/developer here who wants to use a java stored > procedure, wrapped in a PL/SQL function, to implement a > search function > on the site. > > Besides the fact that this is the first I've heard of the request, and > that I think he is reinventing the wheel in what he wants to > do in this > procedure (normalize text data that we already GET normalized > elsewhere), and that we are supposed to go into QA testing by the end > of the month and he STILL hasn't locked down the schema etc > > Personal prejudices aside, I've heard vague rumblings that Java in the > database is not optimal. We'll be in 9iR2, although he's developing > against an 8.1.7 database (don't ask, I'm not responsible for that > database other than to provide him with schema ddl, there IS no real > development server here). > > Before I categorically say no or yes, are there any "gotchas" > I need to > look out for? > > Thanks > > Rachel > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: java stored procedures
>b) The thin driver can only use dedicated server connection which does >miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
We have several developers using java stored procedures. No real 'gotchas' other than making sure all of the java versions are correct. Java is essentially dumbed down C++. Why folks want to go to the extra steps coding baffles me since PL/SQL is much more powerful inside the database. But, there is a lot to be said for portability. Especially, when the final envirnoment is yet to be determined. --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > This really is my week for asking for help. > > We have a project lead/developer here who wants to > use a java stored > procedure, wrapped in a PL/SQL function, to > implement a search function > on the site. > > Besides the fact that this is the first I've heard > of the request, and > that I think he is reinventing the wheel in what he > wants to do in this > procedure (normalize text data that we already GET > normalized > elsewhere), and that we are supposed to go into QA > testing by the end > of the month and he STILL hasn't locked down the > schema etc > > Personal prejudices aside, I've heard vague > rumblings that Java in the > database is not optimal. We'll be in 9iR2, although > he's developing > against an 8.1.7 database (don't ask, I'm not > responsible for that > database other than to provide him with schema ddl, > there IS no real > development server here). > > Before I categorically say no or yes, are there any > "gotchas" I need to > look out for? > > Thanks > > Rachel > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Mladen, Thanks -- one thing I can be sure of is that they won't start loading files, at least in staging and production, because I haven't given them (nor will the data center do so) permission. Everything has to do through either me or change control procedures. Or both. I knew about the java pool. This is a brand new system so asking for a hardware upgrade is not likely. They want to call this function every time someone does a search on the site. This goes back to the discussion I had a week or so ago about the diacritical marks, the developer thinks people will be entering them... cut and paste? Not likely. Rachel --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > Actually, Java is not so bad idea. Aurora does pretty much the same > thing > as PL/SQL and it is very hard to get to OS or network because > security > doesn't let > you. On the plus side, bad programs in Java are more portable then > the ones > in > PL/SQL. IDE software for Java is better suited for duhvelopers then > the one for PL/SQL. > You will have to increase Java pool and you will have to increase > system > tablespace because your developers will start abusing loadjava > almost > instantly and start loading .jar files (like for XML, for instance). > Also, > your CPU and RAM usage will go up fairly quickly so you might > consider > convincing your boss to finally do that HW upgrade. > Expect attempts to use thin JDBC driver. The nice features of the > thin > driver > are > a) It's written entirely in Java, which makes it much slower then an >optimized C code like OCI driver and, therefore, preferred by > duhvelopers >in the name of "generality" and "universality". Stupidity is > another >very universal thing. > b) The thin driver can only use dedicated server connection which > does > miracles >for load balancing. There is "connection pooling", which also > requires >dedicated server to work. Because it cannot use MTS and TNS in > general, >thin driver must have a hard-wired connection string written in > the code > or >parameter file, which apparently doesn't diminish "generality" and > >"universality". > > > -Original Message- > > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 05, 2002 9:08 AM > > To: Multiple recipients of list ORACLE-L > > Subject: java stored procedures > > > > > > This really is my week for asking for help. > > > > We have a project lead/developer here who wants to use a java > stored > > procedure, wrapped in a PL/SQL function, to implement a > > search function > > on the site. > > > > Besides the fact that this is the first I've heard of the request, > and > > that I think he is reinventing the wheel in what he wants to > > do in this > > procedure (normalize text data that we already GET normalized > > elsewhere), and that we are supposed to go into QA testing by the > end > > of the month and he STILL hasn't locked down the schema etc > > > > Personal prejudices aside, I've heard vague rumblings that Java in > the > > database is not optimal. We'll be in 9iR2, although he's developing > > against an 8.1.7 database (don't ask, I'm not responsible for that > > database other than to provide him with schema ddl, there IS no > real > > development server here). > > > > Before I categorically say no or yes, are there any "gotchas" > > I need to > > look out for? > > > > Thanks > > > > Rachel > > > > __ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > -- > Please see the official OR
RE: java stored procedures
>> You'll be stuck with JDK 1.2.X as it is the common JDK supported by 8.17 and >> 9i versions of SQLJ. However, the 9iR2 OUI will ask for JDK Home for JDK/SDK Ver 1.3.1. Check Note# 201110.1 on Metalink. - Kirti -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:33 AM To: Multiple recipients of list ORACLE-L Rachel, >Personal prejudices aside, I've heard vague rumblings that Java in the >database is not optimal. We'll be in 9iR2, although he's developing >against an 8.1.7 database (don't ask, I'm not responsible for that >database other than to provide him with schema ddl, there IS no real >development server here). I don't have any "gotchas" but some tidbits AFAIK. You'll need the SQLJ, JDBC drivers, and JDK running machine used for development and your 8i running the JServer option as well Net8 or above. You'll be stuck with JDK 1.2.X as it is the common JDK supported by 8.17 and 9i versions of SQLJ. Cheers, Thom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Actually, Java is not so bad idea. Aurora does pretty much the same thing as PL/SQL and it is very hard to get to OS or network because security doesn't let you. On the plus side, bad programs in Java are more portable then the ones in PL/SQL. IDE software for Java is better suited for duhvelopers then the one for PL/SQL. You will have to increase Java pool and you will have to increase system tablespace because your developers will start abusing loadjava almost instantly and start loading .jar files (like for XML, for instance). Also, your CPU and RAM usage will go up fairly quickly so you might consider convincing your boss to finally do that HW upgrade. Expect attempts to use thin JDBC driver. The nice features of the thin driver are a) It's written entirely in Java, which makes it much slower then an optimized C code like OCI driver and, therefore, preferred by duhvelopers in the name of "generality" and "universality". Stupidity is another very universal thing. b) The thin driver can only use dedicated server connection which does miracles for load balancing. There is "connection pooling", which also requires dedicated server to work. Because it cannot use MTS and TNS in general, thin driver must have a hard-wired connection string written in the code or parameter file, which apparently doesn't diminish "generality" and "universality". > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 9:08 AM > To: Multiple recipients of list ORACLE-L > Subject: java stored procedures > > > This really is my week for asking for help. > > We have a project lead/developer here who wants to use a java stored > procedure, wrapped in a PL/SQL function, to implement a > search function > on the site. > > Besides the fact that this is the first I've heard of the request, and > that I think he is reinventing the wheel in what he wants to > do in this > procedure (normalize text data that we already GET normalized > elsewhere), and that we are supposed to go into QA testing by the end > of the month and he STILL hasn't locked down the schema etc > > Personal prejudices aside, I've heard vague rumblings that Java in the > database is not optimal. We'll be in 9iR2, although he's developing > against an 8.1.7 database (don't ask, I'm not responsible for that > database other than to provide him with schema ddl, there IS no real > development server here). > > Before I categorically say no or yes, are there any "gotchas" > I need to > look out for? > > Thanks > > Rachel > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Rachel, >Personal prejudices aside, I've heard vague rumblings that Java in the >database is not optimal. We'll be in 9iR2, although he's developing >against an 8.1.7 database (don't ask, I'm not responsible for that >database other than to provide him with schema ddl, there IS no real >development server here). I don't have any "gotchas" but some tidbits AFAIK. You'll need the SQLJ, JDBC drivers, and JDK running machine used for development and your 8i running the JServer option as well Net8 or above. You'll be stuck with JDK 1.2.X as it is the common JDK supported by 8.17 and 9i versions of SQLJ. Cheers, Thom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farrell, Thomas M.Mr. NGB-ARNG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java stored procedures
This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any "gotchas" I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures and running rsh command
Its either hostname username or vice versa. You really only need the user name if its not the same. For example, almost all my systems use oracle as the Unix account but some turkey decided to make one oracleq. So I need to specify that one. You should be able to do a man on .rhosts or rsh and find out. I don't have outside access to my systems anymore. Also, I believe on most OS's your administrator actually has to enable the ability for rsh. Not 100% on that though. -Original Message- Kevin Sent: Wednesday, January 09, 2002 8:56 AM To: Multiple recipients of list ORACLE-L Kimberly, What is the format for the .rhosts file? I'm actually trying to work on something right as we speak. If I remember correctly the file gets stored on the server that you want to connect to and the contents are just: ip username where username is the name that you are logged in as on the server your COMING from if that makes any sense. Is this correct? Cheers, Kev. 'In Windows none can hear you scream' -Original Message- Sent: 09 January 2002 15:12 To: Multiple recipients of list ORACLE-L You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures and running rsh command
Kimberly, What is the format for the .rhosts file? I'm actually trying to work on something right as we speak. If I remember correctly the file gets stored on the server that you want to connect to and the contents are just: ip username where username is the name that you are logged in as on the server your COMING from if that makes any sense. Is this correct? Cheers, Kev. 'In Windows none can hear you scream' -Original Message- Sent: 09 January 2002 15:12 To: Multiple recipients of list ORACLE-L You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures and running rsh command
You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java stored procedures and running rsh command
I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures very slow
What about the JAVA_POOL? Never put java in to practice myself, but it may be a place to start.. Mark -Original Message- Sent: Friday, June 29, 2001 01:20 To: Multiple recipients of list ORACLE-L We suddenly seem to have a problem with java stored procedures running very, very slow. Tables are very small...so am wondering if tehre is anything in sga configuration for Java that we are no aware of Any one had this problem? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java stored procedures very slow
We suddenly seem to have a problem with java stored procedures running very, very slow. Tables are very small...so am wondering if tehre is anything in sga configuration for Java that we are no aware of Any one had this problem? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
