Re: [Resin-interest] Problem with relation

[Rodrigo Westrupp]

--- Sergey Plehov <[EMAIL PROTECTED]> wrote:
>
> This issue with Resin 3.1.2 and  Resin 3.1.3
> 
> I send in attachment source files.
> 

  Thanks Sergey. I have filed a new bug report:

  http://bugs.caucho.com/view.php?id=2048

  At the moment, there is not a good workaround, i.e. you would need to send
the SQL explicitly like:

...
public class UserDAOBean implements UserDAO {
  ...
  @javax.annotation.Resource(name="jdbc/test") // (*) Change to your database
JNDI
  private DataSource _ds;

  ...
  public void delApp(int userId, int appId) {

    Connection conn = null;
    try {
      conn = _ds.getConnection();
      PreparedStatement pstmt = conn.prepareStatement("DELETE FROM APP_ACCESS
WHERE USER_ID = ? AND APP_ID = ?");
      pstmt.setInt(1, userId);
      pstmt.setInt(2, appId);
      pstmt.executeUpdate();
      conn.commit();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        if (conn != null)
          conn.close();
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
}

  -- Rodrigo



_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest