Announcement Announcement Module
Collapse
No announcement yet.
Trying to access OS400/DB2 Stored Procedure Output Parameters with JdbcTemplate Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trying to access OS400/DB2 Stored Procedure Output Parameters with JdbcTemplate

    Trying to access OS400/DB2 Stored Procedure Output Parameters with JdbcTemplate

    Trying to access OS400/DB2 Stored Procedure Output Parameters from Java with Spring JdbcTemplate. My Stored Procedure last parameter is a input/out parameter if the record is updated I will get back "Y" from the main frame. Can someone please give me a close on how to access the 2nd parameter and see if it is a "Y"

    Code:
    XmlBeanFactory beanFactory = new XmlBeanFactory(new ClassPathResource("as400.xml"));
    DataSource ds = (DataSource) beanFactory.getBean("dataSource");
    jdbc = new JdbcTemplate(ds);
    int res= jdbc.update("{CALL TESTONE(?,?)}", new Object[] { new String("JOHN"), new String("N") });
Working...
X