haul 2002/11/06 10:19:27
Added: src/blocks/databases/java/org/apache/cocoon/util
BlobHelper.java ClobHelper.java
Log:
* Additional documentation
- column types in database actions
- dynamic queries in esql
* Improved BLOB & CLOB support for database actions
* Fixed mod-db sample problem
Revision Changes Path
1.1
xml-cocoon2/src/blocks/databases/java/org/apache/cocoon/util/BlobHelper.java
Index: BlobHelper.java
===================================================================
/*
============================================================================
The Apache Software License, Version 1.1
============================================================================
Copyright (C) 1999-2002 The Apache Software Foundation. All rights reserved.
Redistribution and use in source and binary forms, with or without modifica-
tion, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice,
this list of conditions and the following disclaimer in the documentation
and/or other materials provided with the distribution.
3. The end-user documentation included with the redistribution, if any, must
include the following acknowledgment: "This product includes software
developed by the Apache Software Foundation (http://www.apache.org/)."
Alternately, this acknowledgment may appear in the software itself, if
and wherever such third-party acknowledgments normally appear.
4. The names "Apache Cocoon" and "Apache Software Foundation" must not be
used to endorse or promote products derived from this software without
prior written permission. For written permission, please contact
[EMAIL PROTECTED]
5. Products derived from this software may not be called "Apache", nor may
"Apache" appear in their name, without prior written permission of the
Apache Software Foundation.
THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLU-
DING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
This software consists of voluntary contributions made by many individuals
on behalf of the Apache Software Foundation and was originally created by
Stefano Mazzocchi <[EMAIL PROTECTED]>. For more information on the Apache
Software Foundation, please see <http://www.apache.org/>.
*/
package org.apache.cocoon.util;
import java.sql.Blob;
import java.io.InputStream;
import java.io.OutputStream;
/**
* A minimal implementation just enough to send a BLOB to a
* database. Advanced methods and all methods for modifying the BLOB
* are not implemented.
*/
public class BlobHelper implements Blob{
InputStream in = null;
long length = 0;
public BlobHelper(InputStream is, long len) {
this.in = is;
this.length = len;
}
public InputStream getBinaryStream() {
return this.in;
}
public long length() {
return length;
}
/**
* Not implemented.
*/
public byte[] getBytes(long pos, int length) {
System.out.println("BlobHelper ** NOT IMPLEMENTED ** getBytes");
return null;
}
/**
* Not implemented.
*/
public long position(Blob pattern, long start) {
System.out.println("BlobHelper ** NOT IMPLEMENTED ** position(blog,long)");
return -1; // we don't implement this
}
/**
* Not implemented.
*/
public long position(byte[] pattern, long start) {
System.out.println("BlobHelper ** NOT IMPLEMENTED ** position(byte[],long)");
return -1; // we don't implement this
}
// if ever implemented.... the following are the JDBC3 methods
// since not implemented anyway, included in JDBC2 builds as well.
/* @JDBC3_START@
@JDBC3_END@ */
/**
* Not implemented.
*/
public OutputStream setBinaryStream(long pos) {
System.out.println("BlobHelper ** NOT IMPLEMENTED ** setBinaryStream");
return null;
}
/**
* Not implemented.
*/
public int setBytes(long pos, byte[] bytes) {
System.out.println("BlobHelper ** NOT IMPLEMENTED ** setBytes(long,byte[])");
return 0;
}
/**
* Not implemented.
*/
public int setBytes(long pos, byte[] bytes, int offset, int len) {
System.out.println("BlobHelper ** NOT IMPLEMENTED **
setBytes(long,byte[],int,int)");
return 0;
}
/**
* Not implemented.
*/
public void truncate(long len) {
System.out.println("BlobHelper ** NOT IMPLEMENTED ** truncate");
}
}
1.1
xml-cocoon2/src/blocks/databases/java/org/apache/cocoon/util/ClobHelper.java
Index: ClobHelper.java
===================================================================
/*
============================================================================
The Apache Software License, Version 1.1
============================================================================
Copyright (C) 1999-2002 The Apache Software Foundation. All rights reserved.
Redistribution and use in source and binary forms, with or without modifica-
tion, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice,
this list of conditions and the following disclaimer in the documentation
and/or other materials provided with the distribution.
3. The end-user documentation included with the redistribution, if any, must
include the following acknowledgment: "This product includes software
developed by the Apache Software Foundation (http://www.apache.org/)."
Alternately, this acknowledgment may appear in the software itself, if
and wherever such third-party acknowledgments normally appear.
4. The names "Apache Cocoon" and "Apache Software Foundation" must not be
used to endorse or promote products derived from this software without
prior written permission. For written permission, please contact
[EMAIL PROTECTED]
5. Products derived from this software may not be called "Apache", nor may
"Apache" appear in their name, without prior written permission of the
Apache Software Foundation.
THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLU-
DING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
This software consists of voluntary contributions made by many individuals
on behalf of the Apache Software Foundation and was originally created by
Stefano Mazzocchi <[EMAIL PROTECTED]>. For more information on the Apache
Software Foundation, please see <http://www.apache.org/>.
*/
package org.apache.cocoon.util;
import java.sql.Clob;
import java.io.InputStream;
import java.io.Reader;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.Writer;
/**
* A minimal implementation just enough to send a CLOB to a
* database. Advanced methods and all methods for modifying the CLOB
* are not implemented.
*/
public class ClobHelper implements Clob{
InputStream in = null;
long length = 0;
public ClobHelper(InputStream is, long len) {
this.in = is;
this.length = len;
}
public InputStream getAsciiStream() {
return this.in;
}
public Reader getCharacterStream() {
return new BufferedReader(new InputStreamReader(this.in));
}
public long length() {
return length;
}
/**
* Not implemented.
*/
public String getSubString(long pos, int length) {
System.out.println("ClobHelper ** NOT IMPLEMENTED ** getSubString");
return "";
}
/**
* Not implemented.
*/
public long position(Clob searchstr, long start) {
System.out.println("ClobHelper ** NOT IMPLEMENTED ** position(clob,long)");
return -1; // we don't implement this
}
/**
* Not implemented.
*/
public long position(String searchstr, long start) {
System.out.println("ClobHelper ** NOT IMPLEMENTED ** position(str,long)");
return -1; // we don't implement this
}
// if ever implemented.... the following are the JDBC3 methods
// since not implemented anyway, included in JDBC2 builds as well.
/* @JDBC3_START@
@JDBC3_END@ */
/**
* Not implemented.
*/
public OutputStream setAsciiStream(long pos) {
System.out.println("ClobHelper ** NOT IMPLEMENTED ** setAsciiStream");
return null;
}
/**
* Not implemented.
*/
public Writer setCharacterStream(long pos) {
System.out.println("ClobHelper ** NOT IMPLEMENTED ** setCharacterStream");
return null;
}
/**
* Not implemented.
*/
public int setString(long pos, String str){
System.out.println("ClobHelper ** NOT IMPLEMENTED ** setString(long,str)");
return 0;
}
/**
* Not implemented.
*/
public int setString(long pos, String str, int offset, int len){
System.out.println("ClobHelper ** NOT IMPLEMENTED **
setString(long,str,int,int)");
return 0;
}
/**
* Not implemented.
*/
public void truncate(long len){
System.out.println("ClobHelper ** NOT IMPLEMENTED ** truncate");
}
}
----------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
