sabato 15 maggio 2010

No SQL database using Groovy

Good tutorial by IBM

in riferimento a: Java development 2.0: NoSQL (visualizza su Google Sidewiki)

Web Workers

Web Workers
New online web 2.0 db

venerdì 16 aprile 2010

Problem windowsupdate


net stop wuauserv
regsvr32 wuapi.dll
regsvr32 wuaueng.dll
regsvr32 wuaueng1.dll
regsvr32 wucltui.dll
regsvr32 wups.dll
regsvr32 wups2.dll
regsvr32 wuweb.dll
net start wuauserv

in riferimento a: AreaAperta » Problemi di Windows Update dopo aver aggiornato XP al SP3? (visualizza su Google Sidewiki)

venerdì 12 febbraio 2010

Oracle How to determine existing objects in db oracle

How to determine existing objects in db oracle

select * FROM DBA_OBJECTS where OBJECT_NAME LIKE '%MYTABLE%'

in riferimento a: ORA-00955: name is already being used by existing object tips (visualizza su Google Sidewiki)

martedì 2 febbraio 2010

Oracle JDBC parameter

Is possible passing other parameter to JDBC url.
Instead of "@host:port:sid" should be used complete tnsname such as :

"jdbc:oracle:thin:@(DESCRIPTION=" +
"(ADDRESS_LIST=" +
"(ADDRESS=(PROTOCOL=TCP)" +
"(HOST=host)" + =
"(PORT=port)" +
")" +
")" +
"(CONNECT_DATA=" +
"(SERVICE_NAME=sid)" +
"(SERVER=DEDICATED)" +
")" +
")"

in riferimento a:

""jdbc:oracle:thin:@(DESCRIPTION=" + "(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)" + "(HOST=host)" + = "(PORT=port)" + ")" + ")" + "(CONNECT_DATA=" + "(SERVICE_NAME=sid)" + "(SERVER=DEDICATED)" + ")" + ")""
- Oracle JDBC database connection problem (visualizza su Google Sidewiki)

mercoledì 20 gennaio 2010

Oracle counting opened cursor

This oracle sql statement count cursor opened by session

select sid, count(*) from V$OPEN_CURSOR group by sid having count(*) > 40 ORDER BY count(*) desc;

The result :



Is used to monitoring  ORA-01000  Maximum cursor exceeded.


domenica 3 gennaio 2010

Java Opensource job scheduler by TERRACOTTA

Good java scheduler includes many enterprise-class features, such as JTA transactions and clustering.

in riferimento a:

"The Quartz Scheduler includes many enterprise-class features, such as JTA transactions and clustering."
- Quartz Scheduler - Home (visualizza su Google Sidewiki)