Mark
I dunno if this is really what you had in mind but couldnt you just
adjust your doAdd method to perform the check and set a message with the
appropriate text?
I suppose you could also add a method to validate the data to your om
classes. Have that method return a String that holds the text you want
displayed. Then redefine doInsert in your peer class to perform the
check and return the message String. Then you could set the message in
your action.
On Tue, 2003-03-18 at 11:44, Mark Lybarger wrote:
> I'm using the TDK with the torque om classes and am trying to add a new
> object to the database. I have a column that is numeric in the database.
> When entering character data into the form field, I see the following error
> message:
>
> ORA-01400: cannot insert NULL into
> ("SCORE"."ALGORITHM_VARIABLE"."VARIABLE_EXECUTE_NBR")
>
> I would like to see a message saying something to the effect of
> "VARIABLE_EXECUTE_NBR requires numeric data", is this possible with using
> only torque om classes, or do I need to integrate intake into my project to
> accomplish this functionality?
>
> Here's the java code I'm using to do the insert (when i use the
> algorithmVariable variable below obtained via the setProperties, it's trying
> to use a 0 for that column on insert when i've entered character data on the
> form):
>
> public void doAdd(RunData data, Context context) throws Exception
> {
> Criteria criteria = new Criteria();
> this.buildCriteria(data, criteria);
>
> AlgorithmVariable algorithmVariable = new
> AlgorithmVariable();
> data.getParameters().setProperties( algorithmVariable );
>
> try
> {
> AlgorithmVariablePeer.doInsert( criteria );
> } catch (Exception e)
> {
> context.put("exceptionMessage", e.getMessage());
> criteria = new Criteria();
> }
>
> List algorithmVariableList =
> AlgorithmVariablePeer.doSelect(algorithmVariable);
>
> context.put("algorithmVariableList", algorithmVariableList);
> context.put("method", "doAdd");
> this.setTemplate(data,"algorithm_variable.vm");
> }
>
>
> private void buildCriteria(RunData data, Criteria criteria)
> {
> String algorithmId =
> data.getParameters().getString("algorithmId");
> String variableExecuteNbr =
> data.getParameters().getString("variableExecuteNbr");
> BigDecimal variableExecuteNbri =
> data.getParameters().getBigDecimal("variableExecuteNbr");
> String variableName =
> data.getParameters().getString("variableName");
> String variableType =
> data.getParameters().getString("variableType");
>
> if ( (algorithmId != null) && (algorithmId.length() > 0) )
> criteria.add(AlgorithmVariablePeer.ALGORITHM_ID, (Object)
> algorithmId, Criteria.LIKE);
> if ( (variableExecuteNbri != null) &&
> (variableExecuteNbri.intValue() > 0) )
> criteria.add(AlgorithmVariablePeer.VARIABLE_EXECUTE_NBR,
> (Object) variableExecuteNbri, Criteria.LIKE);
> if ( (variableName != null) && (variableName.length() > 0) )
> criteria.add(AlgorithmVariablePeer.VARIABLE_NAME, (Object)
> variableName, Criteria.LIKE);
> if ( (variableType != null) && (variableType.length() > 0) )
> criteria.add(AlgorithmVariablePeer.VARIABLE_TYPE, (Object)
> variableType, Criteria.LIKE);
>
> }
>
>
> Mark Lybarger
> [EMAIL PROTECTED]
> CBC Companies
> 614.442.3741
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003
>
>
> ---------------------------------------------------------------------
> 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]
