Phil,
I would of sworn that I solved this before but now that I look at my notes
I see big question marks... Although I have an idea if you are willing to give it a try ??
Get the document with DTMIterator ni = ((DTMNodeIterator) sqldoc).getDTMIterator();
DTM doc = ni.getDTM(ni.getCurrentNode());
The only thing I am not sure about is if we are always dealing with a DTMNodeIterator.
Regards John G
Phil Friedman wrote:
John,
In the suggested code, if (d == sqldoc) never evaluates true so SQLDocuments are never closed and I did not see a way to get from sqldoc which seems to be a DTMNodeIterator to the SQLDocuments in the vector m_OpenSQLDocuments. I checked my XSLT and it seemed that I always used connections like a stack, so I hacked the code to:
public void close( Object sqldoc )throws SQLException { int size = m_OpenSQLDocuments.size(); Object o = m_OpenSQLDocuments.elementAt(size-1); ((SQLDocument)o).close(); m_OpenSQLDocuments.removeElementAt(size-1); }
This works as far as closing connections. HOWEVER, because of Xalan's "lazy" evaluation, it is not straightforward to determine when a connection-query can be closed. XSLT like this fails:
...
<xsl:variable name="TyXplObjTyMn" select="$COWQy/sql/row-set/row[1]/col['TyXplObjTyMn'[EMAIL PROTECTED]"/>
...
<xsl:value-of select="sql:close( $DbCon, $COWQy)"/>
...
<xsl:call-template name="ICowPrevAKOut">
<xsl:with-param name="TyXplObjTyMn" select="$TyXplObjTyMn"/>
</xsl:call-template>
...
not until inside the ICowPrevAKOut template does $COWQy/sql/row-set/row[1]/col['TyXplObjTyMn'[EMAIL PROTECTED] get evaluated, but we get an exception because $COWQy has already been closed.
Once again, I'm not sure what or why this was changed from the 2.0.1 sql extension. But it has been a great deal of effort to make it work. I hope we're almost there.
Regards, Phil Friedman - Terralink Software - 1-207-772-6500 x101
John Gentilin wrote:
Phil,
This was an issue I posted to the Dev list a while back and finally found an answer, I think, a while back working on another project. The proposed fix would be to change the method signature from SQLDocument to just Object. The problem is, the original SQLDocument object can be casted to one of its many interfaces depending on what operation you are currently performing, here it was casted to an XNodeSet. The code should just work since I am just comparing the object to all the open documents, the closing the SQLDocument in the list that matches the incoming object.
If you feel up to it, give it a try. I also have the official changes for your other fix as well as a skipRec enhancement function to help out with pagination. The ToDo item to check those changes in are on my list to do RSN. :-)
change public void close( SQLDocument sqldoc )throws SQLException { if (DEBUG) System.out.println("Entering XConnection.close(" + sqldoc + ")");
int size = m_OpenSQLDocuments.size();
for(int x=0; x<size; x++) { SQLDocument d = (SQLDocument) m_OpenSQLDocuments.elementAt(x); if (d == sqldoc) { d.close(); m_OpenSQLDocuments.removeElementAt(x); } } }
to
public void close( Object sqldoc )throws SQLException { if (DEBUG) System.out.println("Entering XConnection.close(" + sqldoc + ")");
int size = m_OpenSQLDocuments.size();
for(int x=0; x<size; x++) { Object o = m_OpenSQLDocuments.elementAt(x); if (o == sqldoc) { ((SQLDocument)d).close(); m_OpenSQLDocuments.removeElementAt(x); } } }
Phil Friedman wrote:
John,
I'm back at it. What is the XSL to call close( SQLDocument sqldoc ), XConnection line 1084? I need to reales just one query and it's connection, while leaving other queries active.
Here is a simplified version of what I need to do. I connect with:
<xsl:variable name="DbCon" select="sql:new()"/>
<xsl:value-of select="sql:setFeature( $DbCon, 'default-pool-enabled', 'true')"/>
<xsl:value-of select="sql:setFeature( $DbCon, 'streaming', 'false')"/>
<xsl:if test="not( sql:connect( $DbCon, $DbDrvr, $DbUrl, $DbUsr, $DbPwd))" >
<xsl:copy-of select="sql:getError($DbCon)/ext-error" />
</xsl:if>
Then I run a parent query
<xsl:variable name="SQL">
select Ix from List
</xsl:variable>
<xsl:variable name="Qy" select="sql:query( $DbCon, $SQL)"/>
<xsl:if test="$msg-sql or not( $Qy)">
<xsl:message terminate="no"><xsl:value-of select="$SQL"/>= <xsl:value-of select="$Qy/sql/row-set/row[1]/col[1]"/></xsl:message>
</xsl:if>
<xsl:if test="not( $Qy)" >
<xsl:apply-templates select="sql:getError( $DbCon)/ext-error"/>
</xsl:if>
<xsl:for-each select="$Qy/sql/row-set/row">
Then, for each row, I run a child query like this:
<xsl:variable name="SQL">
select * from Table where Ix= <xsl:value-of select="col['Ix'[EMAIL PROTECTED]"/>
</xsl:variable>
<xsl:variable name="Qy" select="sql:query( $DbCon, $SQL)"/>
<xsl:if test="$msg-sql or not( $Qy)">
<xsl:message terminate="no"><xsl:value-of select="$SQL"/>= <xsl:value-of select="$Qy/sql/row-set/row[1]/col[1]"/></xsl:message>
</xsl:if>
<xsl:if test="not( $Qy)" >
<xsl:apply-templates select="sql:getError( $DbCon)/ext-error"/>
</xsl:if>
<!-- return value -->
<xsl:value-of select="$Qy/sql/row-set/row[1]/col[1]"/>
Then I want to close just the child query, because I'm still in the middle of the parent resultset:
<xsl:value-of select="sql:close( $DbCon, $Qy)"/>
Gives me:
(Location of error unknown)XSLT Error (javax.xml.transform.TransformerException): java.lang.NoSuchMethodException: For extension function, could not find method static org.apache.xalan.lib.sql.XConnection.close([ExpressionContext, ]#UNKNOWN (org.apache.xalan.lib.sql.XConnection), #NODESET) nor
class org.apache.xalan.lib.sql.XConnection.close([ExpressionContext,] #NODESET).
While: <xsl:value-of select="sql:close( $DbCon)"/>
releases both the parent and child connection and Gives me:
XSLT Error (javax.xml.transform.TransformerException): java.lang.ArrayIndexOutOfBoundsException: -1
because the parent connection has been closed so there is nothing there for the <xsl:for-each select="$Qy/sql/row-set/row"> to evaluate <xsl:value-of select="col['Ix'[EMAIL PROTECTED]"/>
If I comment out the <xsl:value-of select="sql:close( $DbCon)"/>
The results are correct. However, this is impractical because if I leave out ALL the closes I get many, many connections opened, which leads to other problems.
Any Ideas? Thanks.
Regards, Phil Friedman - Terralink Software - 1-207-772-6500 x101
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
