Common classes for processing blob and clob

1. Public class lobutil {
3. Private Static final int buffer_size = 4096;
5. Private lobutil (){
6. }
8. Public static synchronized void writeblob (resultset RS, string fieldname,
9. Byte [] BUF) throws sqlexception, ioexception {
10. If (BUF = NULL ){
11. Return;
12. }
13. Outputstream OS = NULL;
14. Blob B = Rs. getblob (fieldname );
15. If (B = NULL ){
16. Throw new sqlexception ("The Blob pointer just inserted or updated is null! ");
17. } Else {
18. // If (conn. isuseconnectionpool ()){
19. // OS =
20. // (Weblogic. JDBC. Vendor. Oracle. oraclethinblob) B). getbinaryoutputstream ();
21. //}
22. // Else {
23. // OS = (Oracle. SQL. Blob) B). getbinaryoutputstream ();
24. //}
25. /**
26. * @ Todo needs to be transformed into a universal database processing interface.
27. */
28. // <Modify author = "jdyao" time = "2005-07-26">
29. Try {
30. Method methodtoinvoke = B. getclass (). getmethod (
31. "Getbinaryoutputstream", (class []) null );
32. OS = (outputstream) methodtoinvoke. Invoke (B, (object []) null );
33. } Catch (exception e ){
34. Throw new sqlexception (E. getmessage ());
35. }
36. // OS = (Oracle. SQL. Blob) B). getbinaryoutputstream ();
37. // </Modify>
39. Bufferedoutputstream Bos = new bufferedoutputstream (OS );
40. Bos. Write (BUF );
41. Bos. Flush ();
42. Bos. Close ();
43. }
44. }
46. Public static synchronized void writeblob (resultset RS, string fieldname,
47. Inputstream in) throws sqlexception, ioexception {
48. If (in = NULL ){
49. Return;
50. }
51. Outputstream OS = NULL;
52. Blob B = Rs. getblob (fieldname );
53. If (B = NULL ){
54. Throw new sqlexception ("The Blob pointer just inserted or updated is null! ");
55. } Else {
56. // If (conn. isuseconnectionpool ()){
57. // OS =
58. // (Weblogic. JDBC. Vendor. Oracle. oraclethinblob) B). getbinaryoutputstream ();
59. //}
60. // Else {
61. // OS = (Oracle. SQL. Blob) B). getbinaryoutputstream ();
62. //}
63. // <Modify author = "jdyao" time = "2005-07-26">
64. Try {
65. Method methodtoinvoke = B. getclass (). getmethod (
66. "Getbinaryoutputstream", (class []) null );
67. OS = (outputstream) methodtoinvoke. Invoke (B, (object []) null );
68. } Catch (exception e ){
69. Throw new sqlexception (E. getmessage ());
70. }
71. // OS = (Oracle. SQL. Blob) B). getbinaryoutputstream ();
72. // </Modify>
74. Bufferedoutputstream Bos = new bufferedoutputstream (OS );
75. Bufferedinputstream Bis = new bufferedinputstream (in );
76. Byte Buf [] = new byte [buffer_size];
77. Int Len =-1;
78. While (LEN = bis. Read (BUF ))! =-1 ){
79. Bos. Write (BUF, 0, Len );
80. }
81. Bis. Close ();
82. Bos. Flush ();
83. Bos. Close ();
84. }
85. }
87. Public static synchronized void writeclob (resultset RS, string fieldname,
88. String BUF) throws sqlexception, ioexception {
90. If (BUF = NULL ){
91. Return;
92. }
93. Writer wR = NULL;
94. Clob c = Rs. getclob (fieldname );
95. If (C = NULL ){
96. Throw new sqlexception ("The clob pointer just inserted or updated is null! ");
97. } Else {
98. // <Modify author = "jdyao" time = "2005-07-26">
99. Try {
100. Method methodtoinvoke = C. getclass (). getmethod (
101. "Getcharacteroutputstream", (class []) null );
102. WR = (writer) methodtoinvoke. Invoke (C, (object []) null );
103. } Catch (exception e ){
104. Throw new sqlexception (E. getmessage ());
105. }
106. // WR = (Oracle. SQL. clob) c). getcharacteroutputstream ();
107. // </Modify>
108. Bufferedwriter BW = new bufferedwriter (WR );
109. Bw. Write (BUF );
110. Bw. Flush ();
111. Bw. Close ();
112. }
113. }
115. Public static synchronized void writeclob (resultset RS, string fieldname,
116. Inputstream in) throws sqlexception, ioexception {
118. If (in = NULL ){
119. Return;
120. }
121. Writer wR = NULL;
122. Clob c = Rs. getclob (fieldname );
123. If (C = NULL ){
124. Throw new sqlexception ("The clob pointer just inserted or updated is null! ");
125. } Else {
126. // <Modify author = "jdyao" time = "2005-07-26">
127. Try {
128. Method methodtoinvoke = C. getclass (). getmethod (
129. "Getcharacteroutputstream", (class []) null );
130. WR = (writer) methodtoinvoke. Invoke (C, (object []) null );
131. } Catch (exception e ){
132. Throw new sqlexception (E. getmessage ());
133. }
134. // WR = (Oracle. SQL. clob) c). getcharacteroutputstream ();
135. // </Modify>
137. Bufferedwriter BW = new bufferedwriter (WR );
138. Bufferedreader BR = new bufferedreader (New inputstreamreader (in ));
139. Char Buf [] = new char [buffer_size];
140. Int Len =-1;
141. While (LEN = Br. Read (BUF ))! =-1 ){
142. Bw. Write (BUF, 0, Len );
143. }
144. BR. Close ();
145. Bw. Flush ();
146. Bw. Close ();
147. }
148. }
149. }