Problem Creating Java Source

2003-12-15 Thread Mark Burgess
Hi, im currently running the following code inside a sql script: . CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "TimeZoneConvert" AS public class TimeZoneConvert { public static int get_utc_offset (String p_tz) { java.util.TimeZone tz = java.util.TimeZone.getTim

Oracle Java stored procedure question

2003-12-11 Thread AdamDonahue
Folks, Anyone know if it's possible to pass a package record type as a parameter to a Java stored procedure? e.g., create or replace package el_zip_pkg is type file_rec_type is record ( namevarchar2(255) , datablob );

RE: Creating the Java System

2003-12-10 Thread Mercadante, Thomas F
se full export and then executing "create database controlfile reuse datafile.logfile..." command before "initjvm" and everything will work. On 12/09/2003 03:44:26 PM, "Mercadante, Thomas F" wrote: > All, > > I am attempting to install the Java system in a 9.2 dat

Re: Creating the Java System

2003-12-09 Thread Jared . Still
I have been in this situation a couple times. You *can* fix your system so that java can be built successfully. It requires perusal of a few articles on MetaLink, and some persistance. Jared Mladen Gogala <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  12/09/2003 01:49 PM  

RE: OS calls with java stored procedures

2003-12-09 Thread Richard Ji
s 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

Re: Creating the Java System

2003-12-09 Thread Mladen Gogala
Well, if you cannot create or replace Java system, then you have a problem with the data dictionary. The table that is returning too many records is, quite likely, a SYS-owned table. You may beat me to the pulp but I still think that it will probably be necessary to re-create your database

RE: Creating the Java System

2003-12-09 Thread Bobak, Mark
I would advise full export and then executing "create database controlfile reuse datafile.logfile..." command before "initjvm" and everything will work. On 12/09/2003 03:44:26 PM, "Mercadante, Thomas F" wrote: > All, > > I am attempting to install the Java sy

RE: Creating the Java System

2003-12-09 Thread Michael Boligan
tate.ny.us> cc: Sent by: Subject: RE: Creating the Java System

RE: Creating the Java System

2003-12-09 Thread Mercadante, Thomas F
t and then executing "create database controlfile reuse datafile.logfile..." command before "initjvm" and everything will work. On 12/09/2003 03:44:26 PM, "Mercadante, Thomas F" wrote: > All, > > I am attempting to install the Java system in a 9.2 database on

Re: Creating the Java System

2003-12-09 Thread Mladen Gogala
I would advise full export and then executing "create database controlfile reuse datafile.logfile..." command before "initjvm" and everything will work. On 12/09/2003 03:44:26 PM, "Mercadante, Thomas F" wrote: > All, > > I am attempting to install t

Creating the Java System

2003-12-09 Thread Mercadante, Thomas F
All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL> create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive

RE: OS calls with java stored procedures

2003-12-09 Thread Jamadagni, Rajendra
ions. 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

RE: OS calls with java stored procedures

2003-12-09 Thread John Flack
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

OS calls with java stored procedures

2003-12-09 Thread ryan_oracle
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

Oracle, GPG, PGP, Java...

2003-12-08 Thread Daniel Hanks
ec madness, and use something a little closer to the database. I was glancing at Chapter 22 in Feuerstein's "Oracle PL/SQL Programming" (3rd. ed.), and thought it might not be too hard to find an existing Java library that can manage the decryption, and call the Java library from

RE: java package to run OS command

2003-12-05 Thread Bob Lofstrand
Title: RE: java package to run OS command Take a look at metalink doc 222079.1 -Original Message- From: John Dunn [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 04, 2003 7:49 AM To: Multiple recipients of list ORACLE-L Subject: java package to run OS command I need a java

RE: java package to run OS command

2003-12-05 Thread Jamadagni, Rajendra
Our Unix guys create 'safe' versions of normal utilities and installed them in a special folder. So, we use the full path to invoke them from *that* folder. Some commands get logged to audit files. I'd say, yeah, specify full path, you don't loose much (well some electrons, but who cares). Raj

RE: java package to run OS command

2003-12-05 Thread John Dunn
ons in the wrong hands. But don't blame the toolmaker. John, the reason that running an OS command is such a hassle is that it can be horribly destructive to your server. An OS command that runs from a Java Stored Procedure such as the one from www.oracle-base.com that I gave you or the one

RE: java package to run OS command

2003-12-04 Thread John Flack
John, the reason that running an OS command is such a hassle is that it can be horribly destructive to your server. An OS command that runs from a Java Stored Procedure such as the one from www.oracle-base.com that I gave you or the one that Tom Kyte wrote and published on Ask Tom will hav

RE: java package to run OS command

2003-12-04 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: > That wouldn't do much harm since it's relatively static and probably > frequently backed up. Restoring $ORACLE_HOME would be an easy > excercise. Now passing datafiles or copying /etc/motd onto > /oradata/SID/system01.dbf would cause much m

RE: java package to run OS command

2003-12-04 Thread Jesse, Rich
By default, no user accounts in the Oracle DB have any privs to do anything to the OS. Privs -- including privs to execute, read, and write OS files -- must explicitly be granted (and rightly so!). Do not grant the JAVASYSPRIV or JAVAUSERPRIV to the schema that will own the ExecOS Java code, as

RE: java package to run OS command

2003-12-04 Thread Jesse, Rich
Bingo! Right on the money. 1) Limit java.fileio.FilePermission("execute") to a single non-system directory. 2) Control the contents of that directory. This *should* be easy -- make oracle the owner and set security on it to 700. Now where's the hassle in that? :) Rich Rich Jesse

RE: java package to run OS command

2003-12-04 Thread Jamadagni, Rajendra
OS command is such a hassle is that it can be horribly destructive to your server. An OS command that runs from a Java Stored Procedure such as the one from www.oracle-base.com that I gave you or the one that Tom Kyte wrote and published on Ask Tom will have all the permissions of the oracle data

RE: java package to run OS command

2003-12-04 Thread John Flack
Dick, harsh words, hmmm? Powerful tools can also be powerful weapons in the wrong hands. But don't blame the toolmaker. John, the reason that running an OS command is such a hassle is that it can be horribly destructive to your server. An OS command that runs from a Java Stored Proc

Re: java package to run OS command

2003-12-04 Thread Mladen Gogala
nto $ORACLE_HOME/bin/oracle would take some time to discover. On 12/04/2003 12:29:25 PM, "Goulet, Dick" wrote: > John, > > I agree and am encouraging the external C procedures since their simpler, and > can create log files as well. BTW: Whoever authored the Java pr

RE: java package to run OS command

2003-12-04 Thread Jesse, Rich
It really isn't that much of a hassle once you have Java itself setup. I have a problem with the lack of security placed on the Java code from the oracle-base.com article though. What we did (are in the process of doing) is to restrict execute access to a single directory that we creat

RE: java package to run OS command

2003-12-04 Thread Goulet, Dick
John, I agree and am encouraging the external C procedures since their simpler, and can create log files as well. BTW: Whoever authored the Java procedure on that web page should be shot. I can just see someone passing 'rm -fr $ORACLE_HOME' to it. Dick Goulet Senior Oracle

RE: java package to run OS command

2003-12-04 Thread Jamadagni, Rajendra
) / create or replace and compile java source named "DirList" as import java.io.*; import java.sql.*; import oracle.sql.*; import oracle.jdbc.driver.*; public class DirList { public static ARRAY getList(String directory) throws SQLException { File path

RE: java package to run OS command

2003-12-04 Thread John Dunn
yeah, I'm trying to get away from C external procedures ...but java is beginning to look just as much a hassle. Why is running a OS command such hassle? -Original Message- Sent: 04 December 2003 15:40 To: Multiple recipients of list ORACLE-L Here's another link to a good J

RE: java package to run OS command

2003-12-04 Thread Igor Neyman
ts of list ORACLE-L its in tom kytes first book. might be on his webpage. > > From: John Dunn <[EMAIL PROTECTED]> > Date: 2003/12/04 Thu AM 08:49:25 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: java package to run OS command > > I ne

RE: java package to run OS command

2003-12-04 Thread Hately, Mike (LogicaCMG)
L I need a java package that will allow me to run OS commands(Unix) from a stored procedure. Anyone got one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: java package to run OS command

2003-12-04 Thread John Dunn
nts of list ORACLE-L <[EMAIL PROTECTED]> > Subject: java package to run OS command > > I need a java package that will allow me to run OS commands(Unix) from a > stored procedure. > > Anyone got one? > > > -- > Please see the official ORACLE-L FAQ: http://www

RE: java package to run OS command

2003-12-04 Thread Jamadagni, Rajendra
recipients of list ORACLE-L its in tom kytes first book. might be on his webpage. > > From: John Dunn <[EMAIL PROTECTED]> > Date: 2003/12/04 Thu AM 08:49:25 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: java package to run OS command >

RE: java package to run OS command

2003-12-04 Thread John Flack
Here's another link to a good Java Stored Procedure for this: http://www.oracle-base.com/Articles/8i/ShellCommandsFromPLSQL.asp But the same caveats apply. We're using an external procedure written in C for this instead of Java, and I use a shell that checks PRODUCT_PROFILE for author

Re: RE: java package to run OS command

2003-12-04 Thread ryan_oracle
expert one on one. check asktom.oracle.com might be on there also. > > From: John Dunn <[EMAIL PROTECTED]> > Date: 2003/12/04 Thu AM 09:44:29 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: java package to run OS comm

RE: java package to run OS command

2003-12-04 Thread Guerra, Abraham J
John, Try this: Process p = Runtime.getRuntime().exec("/usr/bin/df -Pk"); Abraham -Original Message- Sent: Thursday, December 04, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I need a java package that will allow me to run OS commands(Unix) from a stored procedur

Re: java package to run OS command

2003-12-04 Thread ryan_oracle
its in tom kytes first book. might be on his webpage. > > From: John Dunn <[EMAIL PROTECTED]> > Date: 2003/12/04 Thu AM 08:49:25 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: java package to run OS command > > I need a java pac

java package to run OS command

2003-12-04 Thread John Dunn
I need a java package that will allow me to run OS commands(Unix) from a stored procedure. Anyone got one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Delete Java Classes

2003-12-02 Thread Tanel Poder
use drop java class ""; Use quotation marks and case-sensitive class names. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2003 9:09 AM > Hi! > > How do I delete Java

Delete Java Classes

2003-12-02 Thread Daiminger, Helmut
Hi! How do I delete Java classes from a schema? I have a script that queries user_objects and genereates "drop table", "drop synonym" etc. statements. After the script is run, there are still java classes left in the schema. I can use Enterprise Manager to drop them, but I

RE: OT - MVS / Java / Oracle 9iAS

2003-12-01 Thread babette.turnerunderwood
java.lang.Thread.run(Thread.java:513) Process Description: 1. A standalone Java client is executing on the OS390 USS (version info is included below)2. It is trying to make an RMI call to a Session EJB residing on Oracle 9IAS (Release 2 - 9.0.3) residing on HP Unix (environment info is included

OT - MVS / Java / Oracle 9iAS

2003-11-28 Thread babette.turnerunderwood
Title: OT - MVS / Java / Oracle 9iAS I am a Java-idiot. I am hoping some of the brilliant people on this list can help me A developer came to me with a problem they are having. He is setting up a JVM to run under USS (Unix System Services) on OS/390 v2.10 He has java code that uses

RE: Conflicting Java VM after Oracle 9.2 client install

2003-10-28 Thread babette.turnerunderwood
We had a similar problem with a IE application using a particular version of Java - it broke once we did an Oracle 9i client install. Not sure if the same thing might help you. The workaround that I used was to export the registry for the Java Version (HKEY_LOCAL_MACHINE -> JavaSoft ->

Conflicting Java VM after Oracle 9.2 client install

2003-10-27 Thread Daiminger, Helmut
client. Because it can then use the Microsoft Virtual Machine that comes with Internet Explorer. But if we also install the Oracle Client 9.2, the Sun Java VM is installed as well and then the PVCS client doesn't work anymore. The question is: can I install the Oracle Client without having th

Re: Oracle 9.2 on AIX 5.2 : which java?

2003-10-21 Thread Joe Testa
i guess the answer to your question is /usr/java131 should work just fine, since it will find ./bin/java file. joe John Dunn wrote: When the install prompts for the path to java, which path should I specify? There seem to be several on my system : ./usr/lib/java ./usr/bin/java ./usr/java ./usr

Re: Oracle 9.2 on AIX 5.2 : which java?

2003-10-21 Thread Joe Testa
anyplace that has a /bin/java at the end, i've faked it out in the past when we didnt have java, had no intentions on using java, i picked a directory, did a mkdir $THATDIR/bin, cd $THATDIR/bin; vi java, put in some garbage, saved the file and put $THATDIR as the jdk directory and

Oracle 9.2 on AIX 5.2 : which java?

2003-10-21 Thread John Dunn
When the install prompts for the path to java, which path should I specify? There seem to be several on my system : ./usr/lib/java ./usr/bin/java ./usr/java ./usr/jdk_base/bin/aix/native_threads/java ./usr/jdk_base/bin/java ./usr/idebug/jre/bin/java ./usr/idebug/jre/sh/java ./usr/java130/bin/java

Re: Experiences setting OPEN_CURSORS for Java applications

2003-10-03 Thread Prem Khanna J
Craig, Thanx for your tool. Right now,let us (developers) use it with Jboss and let u know if there is any issue. Thanx a lt for your support. Regards, Jp. 02-10-2003 21:41:15, Craig Munday <[EMAIL PROTECTED]> wrote: >Jp, >I've forwarded you a separate email with the tool included as an a

AW: AW: Experiences setting OPEN_CURSORS for Java applications

2003-10-02 Thread Stefan Jahnke
Hi Craig The whole point of an interceptor is basically to add functionality to a certain type or protocol without changing the interface the client works with. In Java, this is usually accomplished by implementing an extra interface to add things like security or billing based on transactions

Re: AW: Experiences setting OPEN_CURSORS for Java applications

2003-10-02 Thread Craig Munday
be log4j might do the job ?). Stefan -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications Tanel, I've implemented it as a

Re: Experiences setting OPEN_CURSORS for Java applications

2003-10-02 Thread Craig Munday
Jp, I've forwarded you a separate email with the tool included as an attached zip file. In answer to your questions: The JDK version is 1.4.1 and above. I do not expect any problems with JBOSS 3.2.1 and higher although I would be interested in hearing about any problems should you come across

AW: Experiences setting OPEN_CURSORS for Java applications

2003-10-01 Thread Stefan Jahnke
hricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications Tanel, I've implemented it as a JDBC driver that is installed as a layer between your

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Tanel Poder
ndor driver that you are using (eg. Oracle, > Postgress, SQL Server, etc.) > > [Java application] - Layer 1 > [JDBC Expert] - Layer 2 > [Oracle Thin Driver] - Layer 3 > | > network > | > [Oracle Server] - Layer 4 > > > It does not parse Java source code a

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Craig Munday
Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [O

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Prem Khanna J
Craig, CM>I can send you a copy if you are interested - CM>you will have to forward me your JDK version and details about any app CM>server that you are using. I would , sure , be very much interested in having a copy of that tool. developers here use diff. versions of JDK & apache/tomcat/jboss

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Tanel Poder
> I've encountered this problem so often that I decided to write a tool > (called JDBC Expert) that would help us DBAs (and developers) detect > Statement and ResultSet "leaks" in Java applications. I've found this > tool so useful and effective at finding res

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Craig Munday
Hi there, I've supported a number of systems implemented in Java running on Oracle and on nearly all of the projects the developers have asked me to increase the number of open_cursors. In most of the cases I have found that the developers were not using the JDBC API efficiently. The

Experiences setting OPEN_CURSORS for Java applications

2003-09-26 Thread Hemant K Chitale
I would just like to know what are your experiences setting OPEN_CURSORS for Java applications / middle-tier application servers ? We're rolling out a bunch of applications on WebMethods, Tivoli Identity Manager, Plumtree, Documentum etc --- all non-Oracle clients accessing the database th

RE: Java for Alpha Linux

2003-09-24 Thread Mladen Gogala
Have you tried jikes? That is IBM implementation of Java2 platform which was not checked by SUN, so it can't use name Java. It is the result of the same dispute that caused MS to stop supporting Java. Allegedly, jikes is much better software then the original sun's JDK. -- Mladen Gog

Java for Alpha Linux

2003-09-24 Thread Jesse, Rich
I'm looking for Java for Linux on an Alpha box. This really isn't OT because I need it in order to connect my Perl programs on the Alpha to Oracle via DBI/DBD::JDBC, which requires Java. I had downloaded it from www.compaq.com at one point, but it's gone from www.hp.com ( htt

V$session program column value for Java Thin driver and OCI driver

2003-09-16 Thread Oracle DBA
Hi List Does anyone have an idea about the value in V$session program column value for Java Thin driver and OCI driver Any help would be really appreciated. TIA Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http

RE: RE: c based external procedures vs. Java Stored Procedures

2003-09-05 Thread Stephane Faroult
gt;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 nee

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Jared Still
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

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Richard Ji
>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 g

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Mladen Gogala
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

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Stephane Paquette
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

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread DENNIS WILLIAMS
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 Wil

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Goulet, Dick
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 recipien

Re: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Jared Still
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 >

c based external procedures vs. Java Stored Procedures

2003-09-04 Thread rgaffuri
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

Re: Inactive Sessions/Java

2003-08-30 Thread cornichepark
> - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Saturday, August 30, 2003 3:14 PM > > >> Nuala, >> >> I have been on this damn Java Client connections for quite a while. >> >> If

Re: Inactive Sessions/Java

2003-08-30 Thread Tanel Poder
If the problem is with idle sessions remaining open, then you can use profile IDLE_TIME to kill them. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, August 30, 2003 3:14 PM > Nuala, > > I have been

RE: Inactive Sessions/Java

2003-08-30 Thread Corniche Park
Nuala, I have been on this damn Java Client connections for quite a while. If it is development , you can use PROFILES/SESSIONS_PER_USER and prevent init.ora setting from being reached and hog the system. The unfortunate thing is the connection pool is that the code is not proven in most of the

RE: Inactive Sessions/Java

2003-08-29 Thread DENNIS WILLIAMS
Nuala I think many of us are struggling to understand the new Web/Internet/Java world. Many times the Java program is hosted by an application server. I don't think that is essential though. There are many different application servers, so you might ask around. Popular ones are Oracle

RE: Inactive Sessions/Java

2003-08-29 Thread Nuala Cullen
Hi Dennis, I'm not too sure what you are asking so I will give you a brief overview of the set up; The oracle server (version 8.1.7.4) (running on windows2000) The java process is running on this server. Users connect to the java process via Radio Data Terminals.(RDT's) The java pr

RE: Inactive Sessions/Java

2003-08-29 Thread DENNIS WILLIAMS
Naula Are these Java processes being hosted by an application server or do they just connect directly to your Oracle database? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 29, 2003 4:49 AM To: Multiple recipients of

RE: Inactive Sessions/Java

2003-08-29 Thread Nuala Cullen
Hi Tanel, Thanks for the reply. The "Java process" is an application that allows the users to connect via Radio Data Terminals to the Database. The only thing is the number of processes is increasing the whole time and when it's reaches the limit sent in the init.ora no more

Re: Inactive Sessions/Java

2003-08-28 Thread Tanel Poder
What is "Java process"? Is it a java class running in some kind of application server? If yes, then your application server is keeping your connections open and using connection pooling to share them between your "processes", somewhat reducing the overhead to create & dro

Inactive Sessions/Java

2003-08-28 Thread Nuala Cullen
Hi All, I have a problem with inactive sessions (despite having set the sqlnet.expire parameter) Some of the users connect to the database via a java process - when I stop this process from running the number of sessions just shots right down. Short of scheduling a start and restart of this

RE: java permissions

2003-07-08 Thread Richard Ji
Multiple recipients of list ORACLE-L All, > I'm getting a java exception in Oracle 8.1.7 > > ORA-29532: Java call terminated by uncaught Java exception: > java.security.AccessControlException: the Permission > (java.net.SocketPermission localhost:1024- listen,resolve) has not be

FW: java permissions

2003-07-08 Thread John Dunn
All, > I'm getting a java exception in Oracle 8.1.7 > > ORA-29532: Java call terminated by uncaught Java exception: > java.security.AccessControlException: the Permission > (java.net.SocketPermission localhost:1024- listen,resolve) has not been > granted by dbms_j

Re: Questions on java

2003-07-04 Thread Tanel Poder
y, July 04, 2003 12:59 PM > > Yes, but you may not get any answers. > > On Friday 04 July 2003 00:59, purushottam krishna hegde wrote: > > hi all, > > > > can i post questions on java and j2ee PF here? > > waiting for +ve

Re: Questions on java

2003-07-04 Thread Ryan
best pl,ace ive seen for java questions are the sun.com forums. - Original Message - From: purushottam krishna hegde To: Multiple recipients of list ORACLE-L Sent: Friday, July 04, 2003 3:59 AM Subject: Questions on java hi all,   can i post questions on

Re: Questions on java

2003-07-04 Thread Jared Still
Yes, but you may not get any answers. On Friday 04 July 2003 00:59, purushottam krishna hegde wrote: > hi all, > > can i post questions on java and j2ee PF here? > waiting for +ve response for all of u > thanking all > purushottam hegde > > > > > > > ---

Questions on java

2003-07-04 Thread purushottam krishna hegde
hi all,   can i post questions on java and j2ee PF here? waiting for +ve response for all of u thanking all purushottam hegde         Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!

Re: How to enable Java on ORACLE 9ir2 database???

2003-04-02 Thread Joan Hsieh
Mike, Hope this is not too late. I just had time to read some email from the list. Please check note:102717.1 and 149393.1. That's what you needed. joan mike mon wrote: > > We have ORACLE 9ir2 on SUN Solaris. We plan to use > Java on ORACLE very soon and need you help. >

Re: OT: PLSQL question, JAVA, JDBC

2003-03-28 Thread Chip
Hi list, this is a question for JAVA/PLSQL programmers. I need to pass an array object from my code in Java using JDBC to a stored procedure in Oracle. I do not know how to do that, could you give me a call example so I can figure out how to achieve this ? TIA

Re: OT: PLSQL question, JAVA, JDBC

2003-03-27 Thread Darrell Landrum
I'd take a look on http://java.sun.com, there are some great forums there. Also try http://devtrends.oracle.com. >>> [EMAIL PROTECTED] 03/27/03 11:03AM >>> Hi list, this is a question for JAVA/PLSQL programmers. I need to pass an array object from my code in Java

OT: PLSQL question, JAVA, JDBC

2003-03-27 Thread Gabriel Aragon
Hi list, this is a question for JAVA/PLSQL programmers. I need to pass an array object from my code in Java using JDBC to a stored procedure in Oracle. I do not know how to do that, could you give me a call example so I can figure out how to achieve this ? TIA Gabriel Aragon

Re: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread Govindan K
--- mike mon <[EMAIL PROTECTED]> wrote: > We have ORACLE 9ir2 on SUN Solaris. We plan to use > Java on ORACLE very soon and need you help. > > 1. how to check the database we have is "java enable"? > connect as system/sys and SQL> desc dbms_java > 2

RE: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread Stephane Paquette
1. Check in dba_objects, you should have java objects as the object type. You should have java class, java data, java resource, java source 2. It depends what you want to do, at minimum run initjvm. You have to run more scripts to use xml and other stuff, check on metalink. 3. At least 50M 4

RE: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread DENNIS WILLIAMS
Mike How are you planning to use Java? Generally, there are 3 ways: 1. Java stored procedures, like PL/SQL stored procedures. This is where the java_pool_size setting becomes very important. Otherwise, set it low after installation so it doesn't waste memory. Most sites don't

Re: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread Darrell Landrum
On your system, look in your $ORACLE_HOME/javavm/doc/readme.txt; I think it answers all of these questions and provides other necessary information regarding Java in Oracle. Darrell Landrum Database Administrator Zale Corporation >>> [EMAIL PROTECTED] 03/24/03 01:44PM >>> W

How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread mike mon
We have ORACLE 9ir2 on SUN Solaris. We plan to use Java on ORACLE very soon and need you help. 1. how to check the database we have is "java enable"? 2. If database on "java enable", which files we need run to make it "java" enable"? 3. on init.ora file the

java script and pl/sql again ???

2003-03-13 Thread Janet Linsy
Hi, Thank you to all those answering my java script question. As I said, all the html and java script are generated by pl/sql package. I'd like to know can the onClick method below call a pl/sql procedure? If it cann't, I suppose onClick needs to call a java script function first, a

Re: pl/sql and java script ???

2003-03-13 Thread Darrell Landrum
Janet, Try the forums at http://java.sun.com or inquire at http://devtrends.oracle.com Darrell >>> [EMAIL PROTECTED] 03/13/03 10:59AM >>> Hi, Our app is strange. :-( We use pl/sql(9i) package to create all the html and java script. I have two drop down boxes on a form,

pl/sql and java script ???

2003-03-13 Thread Janet Linsy
Hi, Our app is strange. :-( We use pl/sql(9i) package to create all the html and java script. I have two drop down boxes on a form, the values for the second box changes dynamically depends on the value of the first box. The values for the boxes are from cursors written in pl/sql. We

Java routine for data validation

2003-02-13 Thread Helen Mitchell
I have been asked to request the following: Does anyone have information for a JAVA date validation routine in Oracle? Helen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: java

2003-02-06 Thread Henry Poras
It worked once and I'm not going to try it again (why bother?). The setup.aix is just an executable that execs a java process using setup.jar. I'm not really happy and this system is pretty unstable, but so it goes. I'm still struggling with igoring the problems I see or I wouldn

AW: java

2003-02-06 Thread Stefan Jahnke
Hi Henry So, it's basically working now ? Or are you still trying to figure out the "why" part ? What does this setup.aix do ? Is it an executable that execs a java process starting setup.jar ? Or is it a script you could post here so I can take a look at it ? Regarding the logs

  1   2   3   4   >