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)