Examples of gbBlob


Examples of com.GestDB.sql.Types.gbBlob

                case java.sql.Types.DATALINK:
                    stmt.setURL(indice, new URL(sValor));
                    break;
                case java.sql.Types.BLOB:
                    if(jdbcDriverURL.indexOf("oracle") == -1) // en oracle tenemos un error
                        stmt.setBlob(indice,  new gbBlob(sValor).getBinaryStream(), sValor.length());
                    else
                        stmt.setBlob(indice, (Blob)getlobOracle(stmt.getConnection(), false, sValor, 2));
                    break;
                case java.sql.Types.NCLOB:
                    if(jdbcDriverURL.indexOf("oracle") == -1) // en oracle tenemos un error
                        stmt.setNClob(indice, new gbClob(sValor).getCharacterStream(), sValor.length());
                    else
                    {
                        // tenemos que indicar el formchar
                        SetFormOfUseNationalOracle(stmt, indice);
                        stmt.setClob(indice, (Clob)getlobOracle(stmt.getConnection(), false, sValor, 1));
                    }
                    break;
                case java.sql.Types.CLOB:
                    if(jdbcDriverURL.indexOf("oracle") == -1) // en oracle tenemos un error
                        stmt.setClob(indice, new gbClob(sValor).getCharacterStream(), sValor.length());
                    else
                        stmt.setClob(indice, (Clob)getlobOracle(stmt.getConnection(), false, sValor, 0));
                    break;
                case java.sql.Types.OTHER:
                    if(dataTypeSQL.toLowerCase().equals("float") || dataTypeSQL.toLowerCase().equals("real") || dataTypeSQL.toLowerCase().equals("double"))
                    {
                        stmt.setObject(indice, oValor);
                        break;
                    }
                    else if(dataTypeSQL.toLowerCase().equals("clob"))
                    {
                        if(jdbcDriverURL.indexOf("oracle") == -1) // en oracle tenemos un error
                            stmt.setClob(indice, new gbClob(sValor).getCharacterStream(), sValor.length());
                        else
                            stmt.setClob(indice, (Clob)getlobOracle(stmt.getConnection(), false, sValor, 0));
                        break;
                    }
                    else if(dataTypeSQL.toLowerCase().equals("nclob"))
                    {
                        if(jdbcDriverURL.indexOf("oracle") == -1) // en oracle tenemos un error
                            stmt.setNClob(indice, new gbClob(sValor).getCharacterStream(), sValor.length());
                        else
                        {
                            // tenemos que indicar el formchar
                            SetFormOfUseNationalOracle(stmt, indice);
                            stmt.setClob(indice, (Clob)getlobOracle(stmt.getConnection(), false, sValor, 1));
                        }
                        break;
                    }
                    else if(dataTypeSQL.toLowerCase().equals("blob"))
                    {
                        if(jdbcDriverURL.indexOf("oracle") == -1) // en oracle tenemos un error
                            stmt.setBlob(indice,  new gbBlob(sValor).getBinaryStream(), sValor.length());
                        else
                            stmt.setBlob(indice, (Blob)getlobOracle(stmt.getConnection(), false, sValor, 2));
                        break;
                    }
                    else if(dataTypeSQL.toLowerCase().equals("nvarchar2"))
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.