RE: Get Java from database?

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Fri, 16 Feb 2001 10:02:27 -0800
Message-ID: <F001.002B68C3.20010216085550@fatcity.com>

Hi, Paul
No Oracle supported tool, as far as I understand. You may try to get content of CREATE$JAVA$LOB$TABLE, field LOB. This supposed to be java binary. This table could be found in the same schema, where do you have Java classes. You may need to write a small client code (Java, C, PL/SQL). Never did it before, but it seems for me to work.
Regards,
Vadim Gorbounov
Oracle DBA

-----Original Message-----
Sent: Friday, February 16, 2001 10:30 AM To: Multiple recipients of list ORACLE-L

What about a binary (i.e., class) file? Any way to extract it to an OS file?

I'm asking because we have some Java stored procedures of uncertain origin and we're trying to locate the source. They're stored in the DB as classes.

Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)

-----Original Message-----
Sent: Thursday, February 15, 2001 5:36 PM To: Multiple recipients of list ORACLE-L

Something like

select text from dba_source (or user_source) where owner = .. and dbms_java.longname(name) = .. and type = 'JAVA SOURCE'

should help.

Vadim Gorbounov
Oracle DBA

-----Original Message-----
Sent: Thursday, February 15, 2001 4:42 PM To: Multiple recipients of list ORACLE-L

No, I wasn't clear enough; I mean retrieve into a file.

Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)

-----Original Message-----
Sent: Thursday, February 15, 2001 4:16 PM To: Multiple recipients of list ORACLE-L

You mean, drop? dropjava.

-----Original Message-----
Sent: Thursday, February 15, 2001 3:02 PM To: Multiple recipients of list ORACLE-L

I'm new to Java in the DB. Once a class or source has been loaded into Oracle, is there any way to get it back out?

Thanks.

Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: PaulB_at_instipro.com

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: ListGuru_at_fatcity.com (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: Vadim Gorbounov
INET: vgorbounov_at_simplyengineering.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------