Package org.apache.derby.iapi.types

Examples of org.apache.derby.iapi.types.HarmonySerialClob

4452
4453
4454
4455
4456
4457
4458
4459
       
        out[0] = new HarmonySerialBlob( new byte[] { (byte) 1, (byte) 2, (byte) 3 } );
    }

    public static void pmap(Clob in, Clob[] inout, Clob[] out) throws SQLException {
        inout[0] = new HarmonySerialClob( in.getSubString( 1L, (int) in.length() ) + inout[0].getSubString( 1L, (int) inout[0].length() ) );
        out[0] = new HarmonySerialClob( "abc" );
    }
View Full Code Here
4466
4467
4468
4469
4470
4471
4472
    {
        result[ 0 ] = getClobValue( c );
    }
    public static void clobOut( Clob[] c ) throws SQLException
    {
        c[ 0 ] = new HarmonySerialClob( "abc" );
    }
View Full Code Here
4475
4476
4477
4478
4479
4480
4481
        String value = getClobValue( c[ 0 ] );
       
        char[] inValue = value.toCharArray();
        char[] outValue = reverse( inValue );

        c[ 0 ] = new HarmonySerialClob( new String( outValue ) );
    }
View Full Code Here
9745
9746
9747
9748
9749
9750
9751
    public  static  Clob  reverse( Clob inputClob )
        throws SQLException
    {
        if ( inputClob == null ) { return null; }

        return new HarmonySerialClob( reverse( inputClob.getSubString( 1L, (int) inputClob.length() ) ) );
    }
View Full Code Here
9780
9781
9782
9783
9784
9785
9786
9787
        throws SQLException
    {
        if ( left ==  null ) { return null; }
        if ( right == null ) { return null; }

        return new HarmonySerialClob
            ( left.getSubString( 1L, (int) left.length() ) + right.getSubString( 1L, (int) right.length() ) );
    }
View Full Code Here
9832
9833
9834
9835
9836
9837
9838
        for ( int i = 0; i < repeatCount; i++ )
        {
            for ( String val : inputs ) { buffer.append( val ); }
        }

        return new HarmonySerialClob( buffer.toString() );
    }
View Full Code Here
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
        cs.execute();
        assertEquals( "def", cs.getString( 1 ) );
        cs.close();

        cs = chattyPrepareCall( conn, "call clobIn( ?, ? )" );
        cs.setClob( 1, new HarmonySerialClob( "ghi" ) );
        cs.registerOutParameter( 2, Types.VARCHAR );
        cs.execute();
        assertEquals( "ghi", cs.getString( 2 ) );
        cs.close();

        //
        // Clob output parameter
        //
        ps = chattyPrepare
            (
             conn,
             "create procedure clobOut\n" +
             "( out c clob )\n" +
             "language java\n" +
             "parameter style java\n" +
             "no sql\n" +
             "external name '" + getClass().getName() + ".clobOut'\n"
             );
        ps.execute();
        ps.close();
       
        cs = chattyPrepareCall( conn, "call clobOut( ? )" );
        cs.registerOutParameter( 1, Types.CLOB );
        cs.execute();
        outVal = cs.getClob( 1 );
        assertEquals( "abc", outVal.getSubString( 1L, (int) outVal.length() ) );
        cs.close();

        //
        // Clob inout parameter
        //
        ps = chattyPrepare
            (
             conn,
             "create procedure clobInOut\n" +
             "( inout c clob )\n" +
             "language java\n" +
             "parameter style java\n" +
             "no sql\n" +
             "external name '" + getClass().getName() + ".clobInOut'\n"
             );
        ps.execute();
        ps.close();
       
        cs = chattyPrepareCall( conn, "call clobInOut( ? )" );
        cs.setClob( 1, new HarmonySerialClob( "ghi" ) );
        cs.registerOutParameter( 1, Types.CLOB );
        cs.execute();
        outVal = cs.getClob( 1 );
        assertEquals( "ihg", outVal.getSubString( 1L, (int) outVal.length() ) );
View Full Code Here
750
751
752
753
754
755
756
                value[ idx++ ] = template[ j ];
            }
                         
        }
       
        return new HarmonySerialClob( new String( value ) );
    }
View Full Code Here
4357
4358
4359
4360
4361
4362
4363
4364
       
        out[0] = new HarmonySerialBlob( new byte[] { (byte) 1, (byte) 2, (byte) 3 } );
    }

    public static void pmap(Clob in, Clob[] inout, Clob[] out) throws SQLException {
        inout[0] = new HarmonySerialClob( in.getSubString( 1L, (int) in.length() ) + inout[0].getSubString( 1L, (int) inout[0].length() ) );
        out[0] = new HarmonySerialClob( "abc" );
    }
View Full Code Here
4371
4372
4373
4374
4375
4376
4377
    {
        result[ 0 ] = getClobValue( c );
    }
    public static void clobOut( Clob[] c ) throws SQLException
    {
        c[ 0 ] = new HarmonySerialClob( "abc" );
    }
View Full Code Here
TOP

Related Classes of org.apache.derby.iapi.types.HarmonySerialClob

  • org.apache.derby.vti.StringColumnVTI
  • org.apache.derbyTesting.functionTests.tests.jdbc4.CallableStatementTest
  • org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest42
  • org.apache.derbyTesting.functionTests.tests.jdbcapi.ClobTest
  • org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMappingTest
  • org.apache.derbyTesting.functionTests.tests.jdbcapi.ProcedureTest
  • org.apache.derbyTesting.functionTests.tests.lang.AnsiSignatures
  • org.apache.derbyTesting.functionTests.tests.lang.CollationTest
  • org.apache.derbyTesting.functionTests.tests.lang.MergeStatementTest
  • org.apache.derbyTesting.functionTests.tests.lang.UserDefinedAggregatesTest
    • Copyright © 2018 www.massapicom. 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.