Dear all,
create.sh fails to create JDCB pools and connections
We are trying to use an Oracle cluster we already have in place as the ICAT database. When I tried to replace the sample JDBC string in glassfish.props with one specific to our setup, I got the following error:
Command create-jdbc-connection-pool only accepts one operand
I assume this is a problem with escaping special characters. Our url looks like this (anonymized):
jdbc\:oracle\:thin\:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=databaseserver1)(PORT=1234))(ADDRESS=(PROTOCOL=TCP)(HOST=databaseserver2)(PORT=1234))(ADDRESS=(PROTOCOL=TCP)(HOST=databaseserver3)(PORT=1234))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=somefqdn)(FAILOVER_MODE=(TYPE=NONE)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
which, I am told, is a pretty standard way to reference a cluster.
I managed to work around this issue by just creating the connection pool and JDBC resource manually and went on with the installation. However, if you have any idea what's going wrong here, it would be much appreciated.