01: /*
02: * Copyright (c) JForum Team
03: * All rights reserved.
04: *
05: * Redistribution and use in source and binary forms,
06: * with or without modification, are permitted provided
07: * that the following conditions are met:
08: *
09: * 1) Redistributions of source code must retain the above
10: * copyright notice, this list of conditions and the
11: * following disclaimer.
12: * 2) Redistributions in binary form must reproduce the
13: * above copyright notice, this list of conditions and
14: * the following disclaimer in the documentation and/or
15: * other materials provided with the distribution.
16: * 3) Neither the name of "Rafael Steil" nor
17: * the names of its contributors may be used to endorse
18: * or promote products derived from this software without
19: * specific prior written permission.
20: *
21: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT
22: * HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
23: * EXPRESS OR IMPLIED WARRANTIES, INCLUDING,
24: * BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
25: * MERCHANTABILITY AND FITNESS FOR A PARTICULAR
26: * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
27: * THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
28: * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
29: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES
30: * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
31: * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA,
32: * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
33: * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
34: * IN CONTRACT, STRICT LIABILITY, OR TORT
35: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
36: * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
37: * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE
38: *
39: * Created on 24/05/2004 01:07:39
40: * The JForum Project
41: * http://www.jforum.net
42: */
43: package net.jforum.dao.oracle;
44:
45: import java.sql.PreparedStatement;
46: import java.sql.ResultSet;
47: import java.sql.SQLException;
48:
49: import net.jforum.JForumExecutionContext;
50: import net.jforum.dao.generic.GenericPrivateMessageDAO;
51: import net.jforum.entities.PrivateMessage;
52: import net.jforum.util.preferences.SystemGlobals;
53:
54: /**
55: * @author Dmitriy Kiriy
56: * @version $Id: OraclePrivateMessageDAO.java,v 1.10 2007/08/31 22:56:40 rafaelsteil Exp $
57: */
58: public class OraclePrivateMessageDAO extends GenericPrivateMessageDAO {
59: /**
60: * @see net.jforum.dao.generic.GenericPrivateMessageDAO#addPmText(net.jforum.entities.PrivateMessage)
61: */
62: protected void addPmText(PrivateMessage pm) throws Exception {
63: PreparedStatement p = JForumExecutionContext
64: .getConnection()
65: .prepareStatement(
66: SystemGlobals
67: .getSql("PrivateMessagesModel.addText"));
68: p.setInt(1, pm.getId());
69: p.executeUpdate();
70: p.close();
71:
72: OracleUtils.writeBlobUTF16BinaryStream(SystemGlobals
73: .getSql("PrivateMessagesModel.addTextField"), pm
74: .getId(), pm.getPost().getText());
75: }
76:
77: /**
78: * @see net.jforum.dao.generic.GenericPrivateMessageDAO#getPmText(java.sql.ResultSet)
79: */
80: protected String getPmText(ResultSet rs) throws SQLException {
81: return OracleUtils.readBlobUTF16BinaryStream(rs,
82: "privmsgs_text");
83: }
84: }
|