Re: Connection problem to DB2

[Kelly Cole]

Thanks to all who helped with this one (thanks especially to Jon for his
db2/connect help). I finally got it to work for the "esql" example. What I
did was to run the program  C:\Program Files\SQLLIB\java12\usejdbc2.bat
(this causes db2/connect to use jdbc2 instead of jdbc1). THEN I HAD TO
REBOOT. The key thing I missed in trying to get this to work was rebooting.
I think that the db2/connect client requires a reboot when things change.
Nevertheless, it works now.

What's still not working is the sql-page example I was originally trying to
use:
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
        <title>Hello</title>
        <content>
                <para>This is my first Cocoon2 page filled with sql
data!</para>
                <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
                        <query>SELECT a.SYS_GRP_NO, b.DB_SLS_DESC1,
b.DB_SLS_DESC2,  c.sys_grp_name FROM testdb2.covoptdb a, testdb2.sdatbook b,
testdb2.sysgrps c WHERE a.sys_grp_no = '00176' AND xwty_mdl_appl_cd =
'FTLHD' AND a.db_cd = b.db_cd AND a.sys_grp_no = c.sys_grp_no</query>
                </execute-query>
        </content>
</page>

This query should return four rows. 

It works in the esql example:
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
        <page>
                <title>A Database Driven XSP Page</title>
                <content>
                        <esql:connection>
                                <esql:pool>TDB2</esql:pool>
                                <esql:execute-query>
                                        <esql:query>SELECT a.SYS_GRP_NO,
b.DB_SLS_DESC1, b.DB_SLS_DESC2,  c.sys_grp_name FROM testdb2.covoptdb a,
testdb2.sdatbook b, testdb2.sysgrps c WHERE a.sys_grp_no = '00176' AND
xwty_mdl_appl_cd = 'FTLHD' AND a.db_cd = b.db_cd AND a.sys_grp_no =
c.sys_grp_no</esql:query>
                                        <esql:results>
                                                <esql:row-results>
                                                        <para>
        
<esql:get-string column="SYS_GRP_NAME"/>
                                                        </para>
                                                        <esql:get-columns/>
                                                </esql:row-results>
                                        </esql:results>
                                </esql:execute-query>
                        </esql:connection>
                </content>
        </page>
</xsp:page>

Any clues on debugging this? Thanks again for all of the help.

Thanks,
Kelly


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>