1 /***
2 * Redistribution and use of this software and associated documentation
3 * ("Software"), with or without modification, are permitted provided
4 * that the following conditions are met:
5 *
6 * 1. Redistributions of source code must retain copyright
7 * statements and notices. Redistributions must also contain a
8 * copy of this document.
9 *
10 * 2. Redistributions in binary form must reproduce the
11 * above copyright notice, this list of conditions and the
12 * following disclaimer in the documentation and/or other
13 * materials provided with the distribution.
14 *
15 * 3. The name "Exolab" must not be used to endorse or promote
16 * products derived from this Software without prior written
17 * permission of Exoffice Technologies. For written permission,
18 * please contact info@exolab.org.
19 *
20 * 4. Products derived from this Software may not be called "Exolab"
21 * nor may "Exolab" appear in their names without prior written
22 * permission of Exoffice Technologies. Exolab is a registered
23 * trademark of Exoffice Technologies.
24 *
25 * 5. Due credit should be given to the Exolab Project
26 * (http://www.exolab.org/).
27 *
28 * THIS SOFTWARE IS PROVIDED BY EXOFFICE TECHNOLOGIES AND CONTRIBUTORS
29 * ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT
30 * NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
31 * FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
32 * EXOFFICE TECHNOLOGIES OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
33 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
34 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
35 * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
36 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
37 * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
38 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
39 * OF THE POSSIBILITY OF SUCH DAMAGE.
40 *
41 * Copyright 2002 (C) Exoffice Technologies Inc. All Rights Reserved.
42 *
43 * $Id: Importer.java,v 1.4 2001/11/20 20:56:28 tima Exp $
44 */
45
46 package org.exolab.jms.tools.migration.proxy;
47
48 import java.sql.PreparedStatement;
49 import java.sql.ResultSet;
50 import java.sql.SQLException;
51
52 import javax.jms.JMSException;
53 import javax.jms.Message;
54 import javax.jms.TextMessage;
55
56 import org.exolab.jms.message.TextMessageImpl;
57 import org.exolab.jms.persistence.SQLHelper;
58
59
60 class TextMessageHandler extends AbstractMessageHandler {
61
62 public TextMessageHandler(Context context) {
63 super(context);
64 }
65
66 public Message get(String messageId) throws JMSException, SQLException {
67 TextMessage result = new TextMessageImpl();
68 get(messageId, result);
69
70 PreparedStatement select = null;
71 ResultSet set = null;
72 try {
73 select = getConnection().prepareStatement(
74 "select text from exp_text_msg values where message_id = ?");
75 select.setString(1, messageId);
76 set = select.executeQuery();
77 if (set.next()) {
78 String text = set.getString("text");
79 result.setText(text);
80 } else {
81 throw new SQLException("Failed to locate TextMessage content" +
82 ", JMSMessageID=" + messageId);
83 }
84 } finally {
85 SQLHelper.close(set);
86 SQLHelper.close(select);
87 }
88
89 return result;
90 }
91
92 public void put(Message message) throws JMSException, SQLException {
93 super.put(message, TextMessage.class.getName());
94
95 TextMessage textMessage = (TextMessage) message;
96
97 PreparedStatement insert = null;
98 try {
99 String messageId = message.getJMSMessageID();
100 String text = textMessage.getText();
101
102 insert = getConnection().prepareStatement(
103 "insert into exp_text_msg values (?, ?) ");
104
105 insert.setString(1, messageId);
106 insert.setString(2, text);
107 insert.executeUpdate();
108 } finally {
109 SQLHelper.close(insert);
110 }
111 }
112
113 } //-- TextMessageHandler
This page was automatically generated by Maven