[jboss-jira] [JBoss JIRA] Created: (JBAS-6264) Typos in Creating a JDBC client

[Martin Malina (JIRA)]

Typos in Creating a JDBC client
-------------------------------

                 Key: JBAS-6264
                 URL: https://jira.jboss.org/jira/browse/JBAS-6264
             Project: JBoss Application Server
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Docs/Installation and Getting Started Guide
    Affects Versions: JBossAS-5.0.0.CR2
            Reporter: Martin Malina
            Assignee: Samson Kittoli
             Fix For: JBossAS-5.0.0.GA


In the chapter called Creating a JDBC client in the Installation and Getting Started Guide, the example jsp page doesn't work correctly - it is probably a legacy code from the time of JBossMQ.
The incorrect source code snippets:

  pr = con.prepareStatement("SELECT USERID, PASSWD FROM JMS_USERS");
  ResultSet rs = pr.executeQuery();
  while (rs.next()) {
  out.println("<br> " +rs.getString("USERID") + " | " +rs.getString("PASSWD")); 
  }

The fixed source code:

  pr = con.prepareStatement("SELECT USER_ID, PASSWD FROM JBM_USER");
  ResultSet rs = pr.executeQuery();
  while (rs.next()) {
  out.println("<br> " +rs.getString("USER_ID") + " | " +rs.getString("PASSWD")); 



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira