cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Bachta" <tbac...@kopent.com>
Subject RE: esql:query problem
Date Wed, 25 Jun 2003 14:53:08 GMT
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:haul@dvs1.informatik.tu-darmstadt.de] 
Sent: Wednesday, June 25, 2003 7:37 AM
To: cocoon-users@xml.apache.org
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
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message