This discussion is archived
4 Replies Latest reply: May 6, 2013 12:32 AM by TonieD RSS

Example of Config using db.customURL Please

teedub Newbie
Currently Being Moderated
Hi

Will someone please post a Listener v2 config file that successfully connects using db.customURL?

Thank you
~t
  • 1. Re: Example of Config using db.customURL Please
    TonieD Newbie
    Currently Being Moderated
    Hi,

    What do you mean? Do you want a saved zip from SQL developer APEX listener config?

    Regards
  • 2. Re: Example of Config using db.customURL Please
    teedub Newbie
    Currently Being Moderated
    Hi

    Just a cut-and-paste of the relevant xml file (eg default.xml) will be great.
    What I have (which does not work despite the fact trhat the connection string works fine from SQLDeveloper and other programs):

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
    <properties>
    <comment>Saved on Tue Mar 12 12:41:59 WST 2013</comment>
    <entry key="db.connectionType">advanced</entry>
    <entry key="db.hostname">exadr-scan</entry>
    <entry key="db.password">password</entry>
    <entry key="db.servicename">comntst_apex.rac.com.au</entry>
    <entry key="db.username">APEX_PUBLIC_USER</entry>
    <entry key="db.customURL">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=exadr-scan)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=comntst_apex.rac.com.au)))</entry>
    </properties>

    It all works fine if I stick to host/port/service.

    I just want to compare what I have here with what actually works.

    cheers
    ~trevor
  • 3. db.customURL error in install guide
    teedub Newbie
    Currently Being Moderated
    It seems that, despite what the listener2 install guide omits to say on page A-4, there is a connection type of 'customurl' which seems to work fine.
  • 4. Re: Example of Config using db.customURL Please
    TonieD Newbie
    Currently Being Moderated
    Hi, hereby a working example

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
    <properties>
    <comment>Saved on Wed Apr 24 15:17:40 CEST 2013</comment>
    <entry key="cache.duration">days</entry>
    <entry key="db.sid">orcl</entry>
    <entry key="jdbc.InitialLimit">3</entry>
    <entry key="debug.printDebugToScreen">false</entry>
    <entry key="cache.procedureNameList"/>
    <entry key="db.tnsDirectory"/>
    <entry key="cache.maxEntries">500</entry>
    <entry key="apex.excel2collection.name"/>
    <entry key="log.maxEntries">50</entry>
    <entry key="apex.excel2collection">false</entry>
    <entry key="log.logging">true</entry>
    <entry key="security.verifySSL">false</entry>
    <entry key="db.password">secret</entry>
    <entry key="procedure.postProcess"/>
    <entry key="error.maxEntries">50</entry>
    <entry key="db.username">APEX_PUBLIC_USER</entry>
    <entry key="icap.server"/>
    <entry key="apex.docTable">FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$</entry>
    <entry key="cache.monitorInterval">60</entry>
    <entry key="misc.compress"/>
    <entry key="jdbc.MaxStatementsLimit">10</entry>
    <entry key="sqldev.name">Administration Settings</entry>
    <entry key="security.inclusionList"/>
    <entry key="jdbc.MinLimit">1</entry>
    <entry key="apex.excel2collection.onecollection">true</entry>
    <entry key="cache.type">lru</entry>
    <entry key="db.servicename">SID</entry>
    <entry key="apex.extensions"/>
    <entry key="error.keepErrorMessages">true</entry>
    <entry key="debug.debugger">true</entry>
    <entry key="db.tnsAliasName"/>
    <entry key="apex.excel2collection.useSheetName">false</entry>
    <entry key="jdbc.MaxLimit">10</entry>
    <entry key="procedure.preProcess"/>
    <entry key="security.validationFunctionType">plsql</entry>
    <entry key="security.disableDefaultExclusionList">true</entry>
    <entry key="cache.expiration">7</entry>
    <entry key="jdbc.statementTimeout">900</entry>
    <entry key="icap.port"/>
    <entry key="log.procedure">false</entry>
    <entry key="db.customURL"/>
    <entry key="sqldev.version">3.2.20.09.87</entry>
    <entry key="cache.directory">/tmp/apex/cache</entry>
    <entry key="sqldev.description"/>
    <entry key="cache.caching">false</entry>
    <entry key="jdbc.DriverType">thin</entry>
    <entry key="misc.defaultPage">apex</entry>
    <entry key="security.requestValidationFunction"/>
    <entry key="db.port">1521</entry>
    <entry key="db.hostname">hostname</entry>
    <entry key="jdbc.InactivityTimeout">1800</entry>
    <entry key="security.exclusionList"/>
    <entry key="security.maxEntries">2000</entry>
    <entry key="db.connectionType">basic</entry>
    <entry key="jdbc.MaxConnectionReuseCount">1000</entry>
    </properties>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points