, , , ,

Java properties in Oracle DB

четверг, 28 октября 2010 г. Оставить комментарий

Sometimes you need to know Java-machine settings for the proper coding.

To do this, use the function dbms_java.get_ojvm_property.


SQL> set pagesize 1000
SQL>
SQL> with java_properties as
2 (
3 select 'java.version' as property, q'~Java Runtime Environment version~' as description from dual union all
4 select 'java.vendor' as property, q'~Java Runtime Environment vendor~' as description from dual union all
5 select 'java.vendor.url' as property, q'~Java vendor URL~' as description from dual union all
6 select 'java.home' as property, q'~Java installation directory~' as description from dual union all
7 select 'java.vm.specification.version' as property, q'~Java Virtual Machine specification version~' as description from dual union all
8 select 'java.vm.specification.vendor' as property, q'~Java Virtual Machine specification vendor~' as description from dual union all
9 select 'java.vm.specification.name' as property, q'~Java Virtual Machine specification name~' as description from dual union all
10 select 'java.vm.version' as property, q'~Java Virtual Machine implementation version~' as description from dual union all
11 select 'java.vm.vendor' as property, q'~Java Virtual Machine implementation vendor~' as description from dual union all
12 select 'java.vm.name' as property, q'~Java Virtual Machine implementation name~' as description from dual union all
13 select 'java.specification.version' as property, q'~Java Runtime Environment specification version~' as description from dual union all
14 select 'java.specification.vendor' as property, q'~Java Runtime Environment specification vendor~' as description from dual union all
15 select 'java.specification.name' as property, q'~Java Runtime Environment specification name~' as description from dual union all
16 select 'java.class.version' as property, q'~Java class format version number~' as description from dual union all
17 select 'java.class.path' as property, q'~Java class path~' as description from dual union all
18 select 'java.library.path' as property, q'~List of paths to search when loading libraries~' as description from dual union all
19 select 'java.io.tmpdir' as property, q'~Default temp file path~' as description from dual union all
20 select 'java.compiler' as property, q'~Name of JIT compiler to use~' as description from dual union all
21 select 'java.ext.dirs' as property, q'~Path of extension directory or directories~' as description from dual union all
22 select 'os.name' as property, q'~Operating system name~' as description from dual union all
23 select 'os.arch' as property, q'~Operating system architecture~' as description from dual union all
24 select 'os.version' as property, q'~Operating system version~' as description from dual union all
25 select 'file.separator' as property, q'~File separator ("/" on UNIX)~' as description from dual union all
26 select 'path.separator' as property, q'~Path separator (":" on UNIX)~' as description from dual union all
27 select 'line.separator' as property, q'~Line separator ("\n" on UNIX)~' as description from dual union all
28 select 'user.name' as property, q'~User's account name~' as description from dual union all
29 select 'user.home' as property, q'~User's home directory~' as description from dual union all
30 select 'user.dir' as property, q'~User's current working directory~' as description from dual
31 )
32 select dbms_java.get_ojvm_property(java_properties.property) as value, java_properties.property, java_properties.description
33 from java_properties
34 /

VALUE PROPERTY DESCRIPTION
-------------------------------------------------------------------------------- ----------------------------- ----------------------------------------------
1.5.0_10 java.version Java Runtime Environment version
Oracle Corporation java.vendor Java Runtime Environment vendor
http://www.oracle.com/java/ java.vendor.url Java vendor URL
D:\ORACLE\DB112\JAVAVM\ java.home Java installation directory
1.0 java.vm.specification.version Java Virtual Machine specification version
Sun Microsystems Inc. java.vm.specification.vendor Java Virtual Machine specification vendor
Java Virtual Machine Specification java.vm.specification.name Java Virtual Machine specification name
1.5.0_01 java.vm.version Java Virtual Machine implementation version
Oracle Corporation java.vm.vendor Java Virtual Machine implementation vendor
JServer VM java.vm.name Java Virtual Machine implementation name
1.5 java.specification.version Java Runtime Environment specification version
Sun Microsystems Inc. java.specification.vendor Java Runtime Environment specification vendor
Java Platform API Specification java.specification.name Java Runtime Environment specification name
48.0 java.class.version Java class format version number
java.class.path Java class path
d:\oracle\db112\bin;.;C:\WINDOWS\system32;C:\WINDOWS;D:\oracle\db112\bin;C:\WIND java.library.path List of paths to search when loading libraries
C:\WINDOWS\TEMP\ java.io.tmpdir Default temp file path
java.compiler Name of JIT compiler to use
java.ext.dirs Path of extension directory or directories
Windows XP os.name Operating system name
x86 os.arch Operating system architecture
5.1 os.version Operating system version
\ file.separator File separator ("/" on UNIX)
; path.separator Path separator (":" on UNIX)
line.separator Line separator ("\n" on UNIX)
user.name User's account name
user.home User's home directory
D:\ORACLE\DB112 user.dir User's current working directory

28 rows selected

SQL>

0 коммент. »

Оставьте Ваш комментарий