Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Changeset 4943

Show
Ignore:
Timestamp:
07/15/08 14:14:25 (2 months ago)
Author:
jmiranda
Message:

#900 - Made explicit reference to columns. Doesn't actually fix the 'Column count doesn't match value count at row 1' issue. See ticket for more information.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • openmrs/trunk/src/api/org/openmrs/api/db/hibernate/HibernateContextDAO.java

    r4358 r4943  
    260260                        Connection conn = sessionFactory.getCurrentSession().connection(); 
    261261 
    262                         psSelect = conn 
    263                                        .prepareStatement("SELECT * FROM role WHERE UPPER(role) = UPPER(?)"); 
    264                         psInsert = conn.prepareStatement("INSERT INTO role VALUES (?, ?)"); 
     262                        // Ticket #900 - Made explicit reference to columns 
     263                        psSelect = conn.prepareStatement("SELECT role, description FROM role WHERE UPPER(role) = UPPER(?)"); 
     264                        psInsert = conn.prepareStatement("INSERT INTO role (role, description) VALUES (?, ?)"); 
    265265 
    266266                        map = OpenmrsConstants.CORE_ROLES(); 
    …… 
    284284                        Connection conn = sessionFactory.getCurrentSession().connection(); 
    285285 
     286                        // Ticket #900 - Made explicit reference to columns 
    286287                        psSelect = conn 
    287                                         .prepareStatement("SELECT * FROM privilege WHERE UPPER(privilege) = UPPER(?)"); 
     288                                        .prepareStatement("SELECT privilege, description FROM privilege WHERE UPPER(privilege) = UPPER(?)"); 
    288289                        psInsert = conn 
    289                                         .prepareStatement("INSERT INTO privilege VALUES (?, ?)"); 
     290                                        .prepareStatement("INSERT INTO privilege (privilege, description) VALUES (?, ?)"); 
    290291 
    291292                        map = OpenmrsConstants.CORE_PRIVILEGES(); 
    …… 
    309310                        Connection conn = sessionFactory.getCurrentSession().connection(); 
    310311 
     312                        // Ticket #900 - Made explicit reference to columns 
    311313                        psSelect = conn 
    312                                         .prepareStatement("SELECT * FROM global_property WHERE UPPER(property) = UPPER(?)"); 
     314                                        .prepareStatement("SELECT property, property_value, description FROM global_property WHERE UPPER(property) = UPPER(?)"); 
    313315                        psInsert = conn 
    314316                                        .prepareStatement("INSERT INTO global_property (property, property_value, description) VALUES (?, ?, ?)");