Examples of StoredProcedure

Examples of com.scooterframework.orm.sqldataexpress.object.StoredProcedure

582
583
584
585
586
587
588
589
590
591
592
    public static StoredProcedure lookupAndRegisterStoredProcedure(String storedProcedure) {
        if (storedProcedure == null)
            throw new IllegalArgumentException("Stored procedure name is empty.");
       
        String errorMessage = "Failed to get meta data info for stored procedur " + storedProcedure;
        StoredProcedure sp = DBStore.getInstance().getStoredProcedure(storedProcedure);
        if (sp == null) {
          UserDatabaseConnection udc = null;
            try {
                udc = SqlExpressUtil.getUserDatabaseConnection();
                sp = lookupStoredProcedure(udc, storedProcedure);
View Full Code Here

Examples of liquibase.structure.core.StoredProcedure

19
20
21
22
23
24
25
26
    @Override
    public Sql[] generateSql(DropProcedureStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        return new Sql[] {
                new UnparsedSql("DROP PROCEDURE "+database.escapeObjectName(statement.getCatalogName(), statement.getSchemaName(), statement.getProcedureName(), StoredProcedure.class),
                        new StoredProcedure().setName(statement.getProcedureName()).setSchema(new Schema(statement.getCatalogName(), statement.getSchemaName())))
        };
    }
View Full Code Here

Examples of org.apache.directory.shared.ldap.codec.extended.operations.storedProcedure.StoredProcedure

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    }


    public void handleExtendedOperation( LdapSession session, InternalExtendedRequest req ) throws Exception
    {
        StoredProcedure spBean = decodeBean( req.getPayload() );
       
        String procedure = StringTools.utf8ToString( spBean.getProcedure() );
        ClonedServerEntry spUnit = manager.findStoredProcUnit( session.getCoreSession(), procedure );
        StoredProcEngine engine = manager.getStoredProcEngineInstance( spUnit );
       
        List<Object> valueList = new ArrayList<Object>( spBean.getParameters().size() );
       
        for ( StoredProcedureParameter pPojo:spBean.getParameters() )
        {
            byte[] serializedValue = pPojo.getValue();
            Object value = SerializationUtils.deserialize( serializedValue );
           
            if ( value.getClass().equals( LdapContextParameter.class ) )
View Full Code Here

Examples of org.apache.directory.shared.ldap.extras.extended.ads_impl.StoredProcedure

67
68
69
70
71
72
73
     */
    public StoredProcedureRequest( int messageId )
    {
        super( messageId );
        this.setRequestName( EXTENSION_OID );
        this.procedure = new StoredProcedure();
    }
View Full Code Here

Examples of org.jboss.dna.common.jdbc.model.api.StoredProcedure

1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
    }

    public void testAddStoredProcedure() {
        String NAME = "My Name";
        // create
        StoredProcedure object = new DefaultModelFactory().createStoredProcedure();
        // set
        object.setName(NAME);
        // add
        bean.addStoredProcedure(object);
        // check
        assertFalse(bean.getStoredProcedures().isEmpty());
    }
View Full Code Here

Examples of org.springframework.jdbc.object.StoredProcedure

327
328
329
330
331
332
333
334
335
336
            declareParameter(param);
      }
    }
 
  private Map<String,Object> executeSpNative(String spName, SqlParameter[] sqlParameters, Map<String,Object> params){
      StoredProcedure sp = new InnerStoreProcedure(spName, sqlParameters);
      sp.setDataSource(dataSource);
      sp.compile();
      return sp.execute(params);
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.StoredProcedure

726
727
728
729
730
731
732
733
734
735
736
737
          public TupleSource registerRequest(CommandContext context,
              Command command, String modelName,
              String connectorBindingId, int nodeID, int limit)
              throws TeiidComponentException {
            if (command instanceof StoredProcedure) {
              StoredProcedure proc = (StoredProcedure)command;
              List<SPParameter> params = proc.getInputParameters();
              assertEquals(1, params.size());
              int value = (Integer)((Constant)params.get(0).getExpression()).getValue();
              return new FakeTupleSource(command.getProjectedSymbols(), new List[] {
                Arrays.asList(value+2), Arrays.asList(value+5)
              });
View Full Code Here

Examples of org.teiid.query.sql.lang.StoredProcedure

906
907
908
909
910
911
912
913
914
915
916
917
918
919
   * When the user's query is parsed and resolved, the placeholder
   * input params are numbered #1 and #2.  This test tests that this disparity in ordering should not
   * be a problem as long as RELATIVE ordering is in synch.
   */
  @Test public void testStoredQueryParamOrdering_8211() {               
    StoredProcedure proc = (StoredProcedure) helpResolve("EXEC pm1.sq3a('abc', 123)"); //$NON-NLS-1$
   
    // Check number of resolved parameters
    List params = proc.getParameters();
    assertEquals("Did not get expected parameter count", 2, params.size()); //$NON-NLS-1$
       
    // Check resolved parameters
    SPParameter param1 = (SPParameter) params.get(0);
    helpCheckParameter(param1, ParameterInfo.IN, 1, "pm1.sq3a.in", DataTypeManager.DefaultDataClasses.STRING, new Constant("abc")); //$NON-NLS-1$ //$NON-NLS-2$
View Full Code Here

Examples of org.teiid.query.sql.lang.StoredProcedure

48
49
50
51
52
53
54
55
56
57
        assertEquals("procedure_name", sp.getProcedureName()); //$NON-NLS-1$
        assertEquals((returnValue ? "? = ":"") +"EXEC procedure_name(?, ?, ?)", sp.toString()); //$NON-NLS-1$
    }
           
    @Test public void testCallNoParams() throws QueryParserException {
        StoredProcedure sp = (StoredProcedure)QueryParser.getQueryParser().parseCommand("{call procedure_name}"); //$NON-NLS-1$
        assertFalse(sp.returnsScalarValue());
        assertEquals("procedure_name", sp.getProcedureName()); //$NON-NLS-1$
        assertEquals(0, sp.getParameters().size());
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.StoredProcedure

1020
1021
1022
1023
1024
1025
1026
1027
    }   

    /** test omitting a required parameter that has a default value */
    @Test public void testExecNamedParamsOmitRequiredParamWithDefaultValue() {
        Object[] expectedParameterExpressions = new Object[] {new Constant("xyz"), new Constant(new Integer(666)), new Constant("YYZ")};//$NON-NLS-1$ //$NON-NLS-2$
        StoredProcedure sp = helpResolveExec("EXEC pm1.sq3b(\"in\" = 'xyz', in2 = 666)", expectedParameterExpressions);//$NON-NLS-1$
        assertEquals("EXEC pm1.sq3b(\"in\" => 'xyz', in2 => 666)", sp.toString());
    }   
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.