piątek, 10 października 2014

pljava GCJ

apt-get install gcj-jdk

Kompilacja do .class
gcj -g -C UtlDir.java

----------------
Kompilacja do .so
gcj -fPIC -shared -o UtlDir.so UtlDir.java


Plik Manifest.txt
Main-Class: UtlDir


Pakowanie do JAR
jar cfm UtlDir.jar Manifest.txt UtlDir.class


----------------
SELECT sqlj.install_jar('file:///local/css-utf8/baza/pljava/UtlDir.jar', 'utldir_jar',  true);

SELECT sqlj.set_classpath('hurt_stp', 'utldir_jar');
SELECT sqlj.set_classpath('smok', 'utldir_jar');
SELECT sqlj.set_classpath('mb', 'utldir_jar');

----
ALBo
SELECT * FROM "sqlj"."replace_jar"('file:///local/css-utf8/baza/pljava/UtlDir.jar','utldir_jar',false);
-------------------
CREATE OR REPLACE FUNCTION hurt_stp.iswindows_ (
)
RETURNS integer AS
$body$
UtlDir.IsWindows
$body$
LANGUAGE 'java'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER

COST 100;

---------
SELECT * FROM hurt_stp.iswindows_();

DB link in RPD

http://obiee-oracledb.blogspot.com/2014/07/using-db-link-in-obiee.html


środa, 10 września 2014

OBIEE date settings

http://locksnlatches.blogspot.com/2011/02/date-configuration-in-obiee.html


Working with dates in OBIEE

Here are several options to set date formats in OBIEE. Option #1 is the best way to work with dates and comparison of dates to strings containing dates in a particular format.

See also: http://gerardnico.com/wiki/dat/obiee/cast_as_date

The most important settings (with example values) are:
  • DATE_DISPLAY_FORMAT parameter in nqsconfig.ini: YYYY/MM/DD
  • DATESHORTFORMAT parameter in localedefinitions.xml (based on the locale set in nqsconfig.ini): M/D/YYYY
  • NLS_DATE_FORMAT parameter of the session (or database default): DD-MON-RR
Do not confuse these with parameters in dbfeatures.ini. There this format is the default for almost all database platforms in parameter DATE_FORMAT parameter.

Ginekolog dr n. med. Piotr Siwek

Gabinet ginekologiczny specjalista ginekolog - położnik dr n. med. Piotr Siwek