PlatformInformixImpl

[Thomas Franke]

Hello Armin,

I implemented the prepareNextValProcedureStatement() method in the class above.
Now the SequenceManagerStoredProcedureImpl works also together with Informix.
This implementation is tested against Informix Dynamik Server 9.4 and the
Informix JDBC.3.00.JC1 driver.

I attached also the sql statements to create the spl function and the OJB
sequence table.

Maybe you can use it.

Best Regards,

Thomas

drop table ojb_nextval_seq;
create table ojb_nextval_seq
(
    seq_name    varchar(250,0) not null,
    max_key     int8,
    primary key(seq_name)
);


drop function ojb_nextval_proc;
create function ojb_nextval_proc(out arg1 int8, arg2 varchar(250,250))
returns int8;
let arg1 = 0;
update ojb_nextval_seq set max_key = max_key + 1 where seq_name = arg2;
select max_key into arg1 from ojb_nextval_seq where seq_name = arg2;
return arg1;
end function;

package org.apache.ojb.broker.platforms;

/* Copyright 2002-2004 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
import org.apache.ojb.broker.metadata.JdbcConnectionDescriptor;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;

/**
 * This class extends <code>PlatformDefaultImpl</code> and defines specific
 * behavior for the Informix platform.
 * 
 * @version 1.0
 * @author Thomas Mahler
 */
public class PlatformInformixImpl extends PlatformDefaultImpl {
    /**
     * @see Platform#initializeJdbcConnection
     */
    public void initializeJdbcConnection(JdbcConnectionDescriptor jcd,
            Connection conn) throws PlatformException {
        super.initializeJdbcConnection(jcd, conn);
        try {
            Statement stmt = conn.createStatement();
            stmt.execute("SET LOCK MODE TO WAIT");
        } catch (SQLException e) {
            // ignore it
        }
    }

    /**
     * @see 
org.apache.ojb.broker.platforms.PlatformDefaultImpl#prepareNextValProcedureStatement(java.sql.Connection,
     *      java.lang.String, java.lang.String)
     */
    public CallableStatement prepareNextValProcedureStatement(Connection con,
            String procedureName, String sequenceName) throws PlatformException 
{
        try {
            /*
             * Following works for Informix Dynamik Server 9.4 and the Informix
             * JDBC.3.00.JC1 driver. It is important to call the executeQuery()
             * method here because the executeUpdate() method doesn't work
             * correctly and returns an error if it is called alone.
             */
            String sp = "{? = call " + procedureName + "(?,?)}";
            CallableStatement cs = con.prepareCall(sp);
            cs.registerOutParameter(1, Types.BIGINT);
            cs.setString(2, sequenceName);
            cs.executeQuery();
            return cs;
        } catch (SQLException e) {
            throw new PlatformException(e);
        }
    }
}


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]