where does system.out.println output goes in oracle java class

java oracle loadjava
prabhakar picture prabhakar · Nov 24, 2010 · Viewed 16.1k times · Source

I have loaded a java class into oracle using loadjava utility

This class has some system.out.println messages.

When I execute a method from this class I want to see the the sysout messages.

Can anyone tell me where can I find these messages?

Answer

oluies picture oluies · Nov 24, 2010

System.out and System.err writes to the current trace files

You can enable output to SQL*Plus or similar with

set serveroutput on size 10000

exec dbms_java.set_output(10000)

See the Java Developer's Guide here

That said you should ask yourself, what do I want to log, that my client would not like to see returned in the interface to my procedure. The answer to that is usually nothing.

I have been able to setup http://www.slf4j.org/ with a jdbc database appender (unsure of the specifics)

Related questions

Confusion over class resolution in Oracle java stored procedures

I'm trying to use a third-party java library within oracle. The library seems compatible with the same 1.4 version of the jvm that our Oracle 10g server hosts, since it runs fine outside of Oracle, so I feel like I should …

Read More
Get java class content from oracle database

Is it possible to get the java .class file from a database? I mean java classes, which was loaded via loadjava tool with -r -s -v -g parameters. How to do this? Edit: I need it in readable form ;)

Read More
Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More