Shell Programming and Scripting

Hi

I want to include in my script a test for DB connection with jdbc:thin connection string(not using tnsnames.ora)

For example:

Code:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=dsu1a)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ODS)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES=20)(DELAY=5))))

Thanks

Cool! So what's the question ?

tyler_durden

the question is how I can implement it in bash script...

Well, that's a JDBC url, so it would be understood only by the Java compiler i.e. in a Java program. You could also use that syntax in languages that are bytecode-compatible with Java e.g. Scala, Groovy etc.

Bash shell does not fall in any of those categories, so you cannot *implement* it in Bash script per se, but you can write a Bash script that calls a compiled Java class that uses the JDBC syntax.

tyler_durden