How to determine existing objects in db oracle
select * FROM DBA_OBJECTS where OBJECT_NAME LIKE '%MYTABLE%'
venerdì 12 febbraio 2010
Oracle How to determine existing objects in db oracle
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:@(
"(ADDRESS_LIST=" +
"(ADDRESS=(PROTOCOL=TCP)" +
"(HOST=host)" + =
"(PORT=port)" +
")" +
")" +
"(CONNECT_DATA=" +
"(SERVICE_NAME=sid)" +
"(SERVER=DEDICATED)" +
")" +
")"
""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)