4 Replies Latest reply: May 6, 2013 2:32 AM by TonieD RSS

    Example of Config using db.customURL Please

    teedub
      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
          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
            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
              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
                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>