RE: esql:query problem

[Tim Bachta]

I thought the same but that did not work.  The Int declares the types so
if you look in the java code it is transformed into
_esql_query.getCallableStatement().setInt(1,(number));

Tim Bachta
 
(913)693-0538 Office
(913)486-5213 Mobile
 

-----Original Message-----
From: Roger I Martin PhD [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 25, 2003 10:11 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem

Guessing a little; should it be little case int instead of Int at
esql:parameter direction="in"
type="Int"><xsp:expr>number</xsp:expr></esql:parameter>
-Roger
----- Original Message ----- 
From: "Tim Bachta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 10:53 AM
Subject: RE: esql:query problem


Here is my code in plain Java:

import java.util.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import java.text.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;


public class Test
{
    public static void main(String args[])
    {
    
        boolean retVal = false;
        try
        {
            Connection con = makeConnection();
            if (con != null)
            {

                try
                {

                    CallableStatement stmt = con.prepareCall("{call
rptLocationDeviations(?,?,?,?)}");
                    stmt.setInt(1, 199);
                    stmt.setString(2, "Rm 130 B");
                    stmt.setString(3, "5-20-2003");
                    stmt.setString(4, "6-20-2003");
                    ResultSet res = stmt.executeQuery();
                    while (res.next())
                    {
                        System.out.println("Result set is working");
                    }
                    res.close();
                    stmt.close();

                    retVal = true;
                }
                catch (SQLException ex)
                {
                    ex.printStackTrace();

                }
                finally
                {
                    try {
                        con.close();
                    }
                    catch (SQLException ex) {
                        ex.printStackTrace();
                    }
                }
            }
            else
            {
                System.out.println("noConnection");
            }
        }
        catch(SQLException sql)
        {
            sql.printStackTrace();
        }
        System.out.println("Return val ="+ retVal);
    }
    
    
  
    
    public static Connection makeConnection() throws SQLException
    {
        
        System.setProperty("jdbc.drivers",
"com.microsoft.jdbc.sqlserver.SQLServerDriver");
        return
DriverManager.getConnection("jdbc:microsoft:sqlserver://kopentpdc:1433;D
atabaseName=vyzo", "user", "password");
    }    
}

////////////////////////////////////////////////////////////////////
End Java
///////////////////////////////////////////////////////////////////

Here is what I have in my xsp:

<esql:execute-query>
<esql:call>{call
rptLocationDeviations(<esql:parameter direction="in"
type="Int"><xsp:expr>number</xsp:expr></esql:parameter>, <esql:parameter
direction="in" type="String"><xsp:expr>room</xsp:expr></esql:parameter>,
<esql:parameter direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,
<esql:parameter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}</esql:call
>
<esql:call-results>
<esql:use-results>
<esql:result>

<xsp:expr>(ResultSet)<esql:get-object column="1" from-call="true"/>

</xsp:expr>
</esql:result>
<esql:results>

<esql:row-results>

<test>

<esql:get-string column="1"/>

</test>

</esql:row-results>
</esql:results>
</esql:use-results>
</esql:call-results>
</esql:execute-query>

//////////////////////////////////////////////////////////////////////
End XSP
/////////////////////////////////////////////////////////////////////
This procedure should return a result set. And it does in my Java
version.  I have looked at the Java code that cocoon compiles from my
xsp and everything looks fine there, granted it is a little confusing to
look through since the formatting is not the greatest.  

Thanks for the help.

Tim Bachta
 

-----Original Message-----
From: Christian Haul [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 25, 2003 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem

On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
> Here is what I am trying, I am getting an invalid parameter bindings
> error, do I need to register the out parameters?  

Yes -- unless your driver returns a result set. This is highly
dependent on the jdbc driver :-( 

If you know how to do it in plain java, we'll be able to help you
transfer this knowledge to esql.

Chris.
-- 
C h r i s t i a n       H a u l
[EMAIL PROTECTED]
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

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


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




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


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