admin – Nick4Name

3

Giu

Dynamic Configuration JMS DCJMSCorreleationID

admin One comment

Per i flussi verso JMS Web Logic occorre definire nella dynamic configuration l’attributo DCJMSCorreleationID.
Dal momento che questo attributo non è esposto dalla ASMA occorre valorizzarlo da mapping con la seguente UDF.

public String setCorrelationID(String corID, Container container) throws StreamTransformationException{

container.getTransformationParameters().put(StreamTransformationConstants.CONVERSATION_ID, corID);
DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/JMS", "DCJMSCorreleationID");
conf.put(key, corID);

return "";

}

1

2

3

4

5

6

7

8

9

10

11

public String setCorrelationID(String corID, Container container) throws StreamTransformationException{

container.getTransformationParameters().put(StreamTransformationConstants.CONVERSATION_ID, corID);

DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/JMS", "DCJMSCorreleationID");

conf.put(key, corID);

return "";

}

Dynamic Configuration JMS DCJMSCorreleationID

3

Giu

Dynamic Configuration set FileName

admin No Comments

public String setDynConfFilename(String filename, String dummy, Container container) throws StreamTransformationException{
/**
* Imposta il filename nel dynamic configuration parameter FileName della chiave http://sap.com/xi/XI/System/File.
*/

if ( filename.trim().length() == 0) return "";

DynamicConfiguration conf1 = (DynamicConfiguration) container.getTransformationParameters()
.get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);
DynamicConfigurationKey key1 = DynamicConfigurationKey.create( "http://sap.com/xi/XI/System/File","FileName");

conf1.put(key1,filename);

return filename;
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

public String setDynConfFilename(String filename, String dummy, Container container) throws StreamTransformationException{

/**

* Imposta il filename nel dynamic configuration parameter FileName della chiave http://sap.com/xi/XI/System/File.

*/

if ( filename.trim().length() == 0) return "";

DynamicConfiguration conf1 = (DynamicConfiguration) container.getTransformationParameters()

.get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey key1 = DynamicConfigurationKey.create( "http://sap.com/xi/XI/System/File","FileName");

conf1.put(key1,filename);

return filename;

}

Dynamic Configuration set FileName

2

Giu

Dynamic Configuration get FileName

admin No Comments

UDF per ottenere il nome del file del communication channel file tramite la ASMA, Adapter-Specific Message Attribute, “http://sap.com/xi/XI/System/File” “FileName” delle Dynamic Configuration.

public String getDynConfFilename(Container container) throws StreamTransformationException{
/*
Ritorna la chiave "http://sap.com/xi/XI/System/File" "FileName" delle Dynamic Configuration.
*/
DynamicConfiguration dc = (DynamicConfiguration) container
.getTransformationParameters().get(
StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey k1 = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");
return dc.get(k1);
}

1

2

3

4

5

6

7

8

9

10

11

public String getDynConfFilename(Container container) throws StreamTransformationException{

/*

Ritorna la chiave "http://sap.com/xi/XI/System/File" "FileName" delle Dynamic Configuration.

*/

DynamicConfiguration dc = (DynamicConfiguration) container

.getTransformationParameters().get(

StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey k1 = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");

return dc.get(k1);

}

2

Giu

Mapping record di controllo

admin No Comments

Mapping per la configurazione del record di controllo, EDIDC40, degli IDoc in entrata.

Mapping record di controllo3

3

Mag

SQuirreL – Abilitare info metadata

admin No Comments

Abilitare su SQuirreL l’esposizione delle info descrittive delle colonne di tabella

File > Global Preferences

3

Mag

Duplicare una tabella: solo dati

admin No Comments

INSERT INTO target_table
SELECT * FROM source_table

1 2	INSERT INTO target_table SELECT * FROM source_table

3

Mag

Duplicare una tabella: struttura e dati

admin No Comments

SELECT * INTO target_table FROM source_table

1	SELECT * INTO target_table FROM source_table

3

Mag

Ritorna la dimensione delle colonne di una tabella

admin One comment

Per SQL Server

SELECT TOP 100 PERCENT tables.name AS TableName, cols.name AS ColName, cols.xtype, cols.length, cols.cdefault, cols.isnullable

FROM         dbo.syscolumns cols INNER JOIN dbo.sysobjects tables ON cols.id = tables.id

WHERE     (tables.name = 'LNET_SAP_WBEWBS')

1

2

3

4

5

SELECT TOP 100 PERCENT tables.name AS TableName, cols.name AS ColName, cols.xtype, cols.length, cols.cdefault, cols.isnullable

FROM dbo.syscolumns cols INNER JOIN dbo.sysobjects tables ON cols.id = tables.id

WHERE (tables.name = 'LNET_SAP_WBEWBS')

25

Apr

Mapping campi facoltativi

admin No Comments

Alimentare l’elemento target solo se l’elemento source non è vuoto.

Tutti gli altri campi, gregari dell’elemento master, possono essere mappati senza alcun controllo ulteriore.

25

Apr

Select che ritorna unico record

admin No Comments

public Reference getReference(String idRole,String idUser){

String sql="SELECT * FROM refers WHERE id_role=? AND id_user=?";
Reference ref=(Reference)jdbcTemplate.queryForObject(sql, new Object[]{idRole,idUser},new BeanPropertyRowMapper(Reference.class){
public Reference extractData(ResultSet rs) throws SQLException,DataAccessException{
Reference ref=new Reference();

ref.setId(rs.getInt("id"));
ref.setIdRole(rs.getString("id_role"));
ref.setIdUser(rs.getString("id_user"));
ref.setDescription(rs.getString("description"));

return ref;
}
});

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

public Reference getReference(String idRole,String idUser){

String sql="SELECT * FROM refers WHERE id_role=? AND id_user=?";

Reference ref=(Reference)jdbcTemplate.queryForObject(sql, new Object[]{idRole,idUser},new BeanPropertyRowMapper(Reference.class){

public Reference extractData(ResultSet rs) throws SQLException,DataAccessException{

Reference ref=new Reference();

ref.setId(rs.getInt("id"));

ref.setIdRole(rs.getString("id_role"));

ref.setIdUser(rs.getString("id_user"));

ref.setDescription(rs.getString("description"));

return ref;

}

});

Dynamic Configuration JMS DCJMSCorreleationID

Giu

Dynamic Configuration JMS DCJMSCorreleationID

Giu

Dynamic Configuration set FileName

Giu

Dynamic Configuration get FileName

Giu

Mapping record di controllo

Mag

SQuirreL – Abilitare info metadata

Mag

Duplicare una tabella: solo dati

Mag

Duplicare una tabella: struttura e dati

Mag

Ritorna la dimensione delle colonne di una tabella

Apr

Mapping campi facoltativi

Apr

Select che ritorna unico record

Articoli recenti

Categorie

Archivi