Hi all,
I need to access an Oracle data store using the following parameters:
USER: xxx
PASSWD: xxx
DATABASE: (DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
xxx)(PORT = xxxx))(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT =
xxxx))(LOAD_BALANCE =
yes))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxx.xxx.xxx.xx)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
When you run the OracleNGDataStoreFactory.getJDBCUrl (Map params) protected
method, the execution of the 'lookUp' function throws an IOException as the
HOST and PORT parameters are required.
This is the method code:
...
@Override
protected String getJDBCUrl(Map params) throws IOException {
String host = (String) HOST.lookUp(params);
String db = (String) DATABASE.lookUp(params);
int port = (Integer) PORT.lookUp(params);
if( db.startsWith("(") )
return JDBC_PATH + db;
else if( db.startsWith("/") )
return JDBC_PATH + "//" + host + ":" + port + db;
else
return JDBC_PATH + host + ":" + port + ":" + db;
}
...
In fact, if the DATABASE parameter starts with "(", the HOST and PORT
parameters are not used because the function returns 'JDBC_PATH + db'.
To resolve this problem I used this code:
...
@Override
protected String getJDBCUrl(Map params) throws IOException {
String db = (String) DATABASE.lookUp(params);
if(db.startsWith("("))
return JDBC_PATH + db;
String host = (String) HOST.lookUp(params);
int port = (Integer) PORT.lookUp(params);
if( db.startsWith("/") )
return JDBC_PATH + "//" + host + ":" + port + db;
else
return JDBC_PATH + host + ":" + port + ":" + db;
}
...
Are there any contraindications to change the method 'getJDBCUrl' in this
way ?
Best regards.
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
