I can't seem to retrieve database content in a LiveSite (V2.2.1) component.
The component content XML is set up as follows:
<br><Data><br> <External><br> <Parameters><br> <Datum Exposed="true" ID="DT1" Name="Pool" Type="String">POOL1</Datum><br> <Datum Exposed="true" ID="DT2" Name="Select" Type="SelectSingle"><br> <Option Order="1" Selected="true"><br> <Display>Dummy</Display><br> <Value>dummy</Value><br> </Option><br> </Datum><br> <Datum Exposed="true" ID="DT3" Name="From" Type="String">dual</Datum><br> </Parameters><br> <Object>com.interwoven.livesite.external.impl.SQL</Object><br> <Method>GetJDBCXML</Method><br> </External><br></Data><br><br><br>I have also setup the connection pool as follows:<br><br> <pool name="POOL1" <br> initConn="1" <br> maxConn="1" <br> timeOut="10" <br> checkInterval="600" <br> inactiveTime="10" <br> default="Y"><br> <description></description><br> <driver>oracle.jdbc.driver.OracleDriver</driver><br> <url>jdbc
racle:thin:
@servername:1521:sidname</url><br> <user>username</user><br> <password>password</password><br> <testable>select 1 from dual</testable><br> </pool><br><br>I have tested a simple Oracle thin client connection (in a jsp page) from the TeamSite server to the database server and it works fine.<br><br>Each time I try to preview or execute the component it causes java errors with Null pointer exceptions.<br><br>Does anyone know how to get this to work?
