@Override public void visit(ExceptionExpression obj) { try { if (obj.getErrorCode() != null) { obj.setErrorCode(ResolverUtil.convertExpression(obj.getErrorCode(), DataTypeManager.DefaultDataTypes.INTEGER, metadata)); } obj.setMessage(ResolverUtil.convertExpression(obj.getMessage(), DataTypeManager.DefaultDataTypes.STRING, metadata)); if (obj.getSqlState() != null) { obj.setSqlState(ResolverUtil.convertExpression(obj.getSqlState(), DataTypeManager.DefaultDataTypes.STRING, metadata)); } checkException(obj.getParent()); } catch (QueryResolverException e) { handleException(e); } }
@Override public void visit(ExceptionExpression obj) { try { if (obj.getErrorCode() != null) { obj.setErrorCode(ResolverUtil.convertExpression(obj.getErrorCode(), DataTypeManager.DefaultDataTypes.INTEGER, metadata)); } obj.setMessage(ResolverUtil.convertExpression(obj.getMessage(), DataTypeManager.DefaultDataTypes.STRING, metadata)); if (obj.getSqlState() != null) { obj.setSqlState(ResolverUtil.convertExpression(obj.getSqlState(), DataTypeManager.DefaultDataTypes.STRING, metadata)); } checkException(obj.getParent()); } catch (QueryResolverException e) { handleException(e); } }
@Override public void visit(ExceptionExpression obj) { try { if (obj.getErrorCode() != null) { obj.setErrorCode(ResolverUtil.convertExpression(obj.getErrorCode(), DataTypeManager.DefaultDataTypes.INTEGER, metadata)); } obj.setMessage(ResolverUtil.convertExpression(obj.getMessage(), DataTypeManager.DefaultDataTypes.STRING, metadata)); if (obj.getSqlState() != null) { obj.setSqlState(ResolverUtil.convertExpression(obj.getSqlState(), DataTypeManager.DefaultDataTypes.STRING, metadata)); } checkException(obj.getParent()); } catch (QueryResolverException e) { handleException(e); } }
ee.setSqlState(sqlState); ee.setErrorCode(errCode); ee.setParent(parent);
ee.setSqlState(sqlState); ee.setErrorCode(errCode); ee.setParent(parent);
@Override public void visit(ExceptionExpression exceptionExpression) { if (exceptionExpression.getMessage() != null) { exceptionExpression.setMessage(replaceExpression(exceptionExpression.getMessage())); } if (exceptionExpression.getSqlState() != null) { exceptionExpression.setSqlState(replaceExpression(exceptionExpression.getSqlState())); } if (exceptionExpression.getErrorCode() != null) { exceptionExpression.setErrorCode(replaceExpression(exceptionExpression.getErrorCode())); } if (exceptionExpression.getParent() != null) { exceptionExpression.setParent(replaceExpression(exceptionExpression.getParent())); } }
@Override public void visit(ExceptionExpression exceptionExpression) { if (exceptionExpression.getMessage() != null) { exceptionExpression.setMessage(replaceExpression(exceptionExpression.getMessage())); } if (exceptionExpression.getSqlState() != null) { exceptionExpression.setSqlState(replaceExpression(exceptionExpression.getSqlState())); } if (exceptionExpression.getErrorCode() != null) { exceptionExpression.setErrorCode(replaceExpression(exceptionExpression.getErrorCode())); } if (exceptionExpression.getParent() != null) { exceptionExpression.setParent(replaceExpression(exceptionExpression.getParent())); } }
@Override public void visit(ExceptionExpression exceptionExpression) { if (exceptionExpression.getMessage() != null) { exceptionExpression.setMessage(replaceExpression(exceptionExpression.getMessage())); } if (exceptionExpression.getSqlState() != null) { exceptionExpression.setSqlState(replaceExpression(exceptionExpression.getSqlState())); } if (exceptionExpression.getErrorCode() != null) { exceptionExpression.setErrorCode(replaceExpression(exceptionExpression.getErrorCode())); } if (exceptionExpression.getParent() != null) { exceptionExpression.setParent(replaceExpression(exceptionExpression.getParent())); } }
ee.setSqlState(sqlState); ee.setErrorCode(errCode); ee.setParent(parent);
@Test public void testRaiseErrorStatement() throws Exception { ExceptionExpression ee = new ExceptionExpression(); ee.setMessage(new Constant("Test only")); ee.setSqlState(new Constant("100")); ee.setParent(new ElementSymbol("e")); RaiseStatement errStmt = new RaiseStatement(ee, true); helpStmtTest("RAISE SQLWARNING SQLEXCEPTION 'Test only' SQLSTATE '100' chain e;", "RAISE SQLWARNING SQLEXCEPTION 'Test only' SQLSTATE '100' CHAIN e;", //$NON-NLS-1$ //$NON-NLS-2$ errStmt); }