were opened. You should also go to external connection pools. The way you are
using the internal connection pool, you are going to have a ton of memory
turn over because the JDBC driver will probably be unregistered / discarded
for each transformation, not to mention the time it takes to build up the
connection pool.
Regards John G
Phil Friedman wrote:
John,
Is there something to this? I finally got eclipse to display my source, rather than the JDK source. I looks like executeSQLStatement() finds the previous connection inUse and opens another. Is there something I need to do in my XSLT or in SQLDocument.java to free the connection? Remember, I've changed SQLDocument.java line 400 or so to:
if (! m_QueryParser.hasParameters() ) { m_Statement = conn.createStatement(); //if (! m_Statement.execute(m_QueryParser.getSQLQuery())) //{ // throw new SQLException("Error in Query"); //} m_ResultSet = m_Statement.executeQuery(m_QueryParser.getSQLQuery()); }
This is running from org.apache.xalan.xslt.Process. I connect with: sql:connect( $DbCon, $DbDrvr, $DbUrl, $DbUsr, $DbPwd).
Do I need a <xsl:value-of select="sql:close($DbCon)"/> after processing the results of each sql batch?
[EMAIL PROTECTED] wrote:
Quoting Phil Friedman <[EMAIL PROTECTED]>:
It seems that after a large number --hundreds, but I have not counted-- of
queries on the same db connection, the SQL extension starts returning empty
result sets with no errors thrown.
I'm at 2.6.0 connecting to Sybase SQL Anywhere 8. There are no problems with
the SQL as I've run similar statements earlier and can restart and run the
same statements w/o errors later.
Any ideas on what to look for? Regards, Phil Friedman - Terralink Software - 1-207-772-6500 x101
Perhaps you are not closing the resultsets/statements and you are running out of
server side cursors, or other db objects?
-- -------------------------------------- John Gentilin Eye Catching Solutions Inc. 18314 Carlwyn Drive Castro Valley CA 94546
Contact Info [EMAIL PROTECTED] Ca Office 1-510-881-4821 NJ Office 1-732-422-4917
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
