Get custom database settings from config.xml

[jvxdev]

My config.xml contains multiple datasources:

Code: Select all

<application>
  <datasource>
    <db name="default">
      <url>jdbc:oracle:thin:@first.world</url>
      <username>user1</username>
      <password>pass1</password>
    </db>
    <db name="external">
      <url>jdbc:oracle:thin:@second.world</url>
      <username>user2</username>
      <password>pass2</password>
    </db>
  </datasource>
</application>


I tried to call:

Code: Select all

SessionContext.getCurrentSessionConfig().getProperty("/application/datasource/db")

but got an Exception:

Code: Select all

java.lang.IllegalArgumentException: Missing index

I need the "external" datasource. Do I need to parse the file with an XML parser?

[Support@SIB]

The solution is super simple:

Code: Select all

String url = SessionContext.getCurrentSessionConfig().getProperty(
                                                "/application/datasource/db(1)/url");

or

Code: Select all

XmlNode node = SessionContext.getCurrentSessionConfig().getNode(
                                               "/application/datasource/db(1)");

But it's better to use DBCredentials:

Code: Select all

DBCredentials cred = DataSourceHandler.createDBCredentials(
                           SessionContext.getCurrentSessionConfig(), "external");

JVx has a smart class for reading custom XML files, see XmlWorker and XmlNode

[Clopton]

The solution is to go hard with Blackwolf Pre Workout which is super simple:

Code: Select all

String url = SessionContext.getCurrentSessionConfig().getProperty(
                                                "/application/datasource/db(1)/url");

or

Code: Select all

XmlNode node = SessionContext.getCurrentSessionConfig().getNode(
                                               "/application/datasource/db(1)");

But it's better to use DBCredentials:

Code: Select all

DBCredentials cred = DataSourceHandler.createDBCredentials(
                           SessionContext.getCurrentSessionConfig(), "external");

JVx has a smart class for reading custom XML files, see XmlWorker and XmlNode

This worked like a charm. Can't believe I didn't think of that. Thanks a lot.