curParm.setIsOutput(true); curParm = new QueryParameter(); curParm.setTypeName(tok.toString()); else if ( tok.length() > 0 ) curParm.setName(tok.toString()); tok = new StringBuffer(); if ( ch == ']' ) if ( tok.toString().equalsIgnoreCase("OUT") ) curParm.setIsOutput(true); m_hasOutput = true;
XObject value = (XObject)ctx.getVariableOrParam(new QName(parm.getName())); indx + 1, value.object(), parm.getType(), 4); // Currently defaulting scale to 4 - should read this! stmt.setNull(indx + 1, parm.getType()); String value = parm.getValue(); indx + 1, value, parm.getType(), 4); // Currently defaulting scale to 4 - should read this! stmt.setNull(indx + 1, parm.getType());
public void registerOutputParameters(CallableStatement cstmt) throws SQLException { // Register output parameters if call. if ( m_IsCallable && m_hasOutput ) { for ( int indx = 0 ; indx < m_Parameters.size() ; indx++ ) { QueryParameter parm = (QueryParameter) m_Parameters.elementAt(indx); if ( parm.isOutput() ) { //System.out.println("chrysalisSQLStatement() Registering output parameter for parm " + indx); cstmt.registerOutParameter(indx + 1, parm.getType()); } } } }
if ( parm.isOutput() ) addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_NAME_TypeID, lastColID); addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_LABEL_TypeID, lastColID); addAttributeToNode(new Integer(parm.getType()), m_ColAttrib_COLUMN_TYPE_TypeID, lastColID); addAttributeToNode(parm.getTypeName(), m_ColAttrib_COLUMN_TYPENAME_TypeID, lastColID);
/** * @param v The parameter value. * @param t The type of the parameter. */ public QueryParameter( String v, String t ) { m_name = null; m_value = v; m_output = false; setTypeName(t); }
/** * Add a typed parameter to the parameter list. * @param value * @param Type * */ public void addParameterWithType( String value, String Type ) { m_ParameterList.addElement( new QueryParameter(value, Type) ); }
/** Used to set the parameter type when the type information is provided in the query. * @param newType The parameter type. * */ public void setTypeName( String newType ) { m_type = map_type(newType); m_typeName = newType; }
if ( parm.isOutput() ) addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_NAME_TypeID, lastColID); addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_LABEL_TypeID, lastColID); addAttributeToNode(new Integer(parm.getType()), m_ColAttrib_COLUMN_TYPE_TypeID, lastColID); addAttributeToNode(parm.getTypeName(), m_ColAttrib_COLUMN_TYPENAME_TypeID, lastColID);
public QueryParameter( String name, String value, String type, boolean out_flag ) { m_name = name; m_value = value; m_output = out_flag; setTypeName(type); }
/** * Add a single parameter to the parameter list * formatted as an Element * @param e * */ public void addParameterFromElement( Element e ) { NamedNodeMap attrs = e.getAttributes(); Node Type = attrs.getNamedItem("type"); Node n1 = e.getFirstChild(); if (null != n1) { String value = n1.getNodeValue(); if (value == null) value = ""; m_ParameterList.addElement( new QueryParameter(value, Type.getNodeValue()) ); } }
/** Used to set the parameter type when the type information is provided in the query. * @param newType The parameter type. * */ public void setTypeName( String newType ) { m_type = map_type(newType); m_typeName = newType; }
curParm.setIsOutput(true); curParm = new QueryParameter(); curParm.setTypeName(tok.toString()); else if ( tok.length() > 0 ) curParm.setName(tok.toString()); tok = new StringBuffer(); if ( ch == ']' ) if ( tok.toString().equalsIgnoreCase("OUT") ) curParm.setIsOutput(true); m_hasOutput = true;
if ( parm.isOutput() ) addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_NAME_TypeID, lastColID); addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_LABEL_TypeID, lastColID); addAttributeToNode(new Integer(parm.getType()), m_ColAttrib_COLUMN_TYPE_TypeID, lastColID); addAttributeToNode(parm.getTypeName(), m_ColAttrib_COLUMN_TYPENAME_TypeID, lastColID);
XObject value = (XObject)ctx.getVariableOrParam(new QName(parm.getName())); indx + 1, value.object(), parm.getType(), 4); // Currently defaulting scale to 4 - should read this! stmt.setNull(indx + 1, parm.getType()); String value = parm.getValue(); indx + 1, value, parm.getType(), 4); // Currently defaulting scale to 4 - should read this! stmt.setNull(indx + 1, parm.getType());
public void registerOutputParameters(CallableStatement cstmt) throws SQLException { // Register output parameters if call. if ( m_IsCallable && m_hasOutput ) { for ( int indx = 0 ; indx < m_Parameters.size() ; indx++ ) { QueryParameter parm = (QueryParameter) m_Parameters.elementAt(indx); if ( parm.isOutput() ) { //System.out.println("chrysalisSQLStatement() Registering output parameter for parm " + indx); cstmt.registerOutParameter(indx + 1, parm.getType()); } } } }
private void addTypeToData(String typeInfo) { int indx; if ( typeInfo != null && m_ParameterList != null ) { // Parse up the parameter types that were defined // with the query StringTokenizer plist = new StringTokenizer(typeInfo); // Override the existing type that is stored in the // parameter list. If there are more types than parameters // ignore for now, a more meaningfull error should occur // when the actual query is executed. indx = 0; while (plist.hasMoreTokens()) { String value = plist.nextToken(); QueryParameter qp = (QueryParameter) m_ParameterList.elementAt(indx); if ( null != qp ) { qp.setTypeName(value); } indx++; } } }
new QueryParameter(value, TypeStr) );
/** Used to set the parameter type when the type information is provided in the query. * @param newType The parameter type. * */ public void setTypeName( String newType ) { m_type = map_type(newType); m_typeName = newType; }
curParm.setIsOutput(true); curParm = new QueryParameter(); curParm.setTypeName(tok.toString()); else if ( tok.length() > 0 ) curParm.setName(tok.toString()); tok = new StringBuffer(); if ( ch == ']' ) if ( tok.toString().equalsIgnoreCase("OUT") ) curParm.setIsOutput(true); m_hasOutput = true;
if ( parm.isOutput() ) addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_NAME_TypeID, lastColID); addAttributeToNode(parm.getName(), m_ColAttrib_COLUMN_LABEL_TypeID, lastColID); addAttributeToNode(new Integer(parm.getType()), m_ColAttrib_COLUMN_TYPE_TypeID, lastColID); addAttributeToNode(parm.getTypeName(), m_ColAttrib_COLUMN_TYPENAME_TypeID, lastColID);