Hi Folks,
thanks for your help, now the Channel connected the database.
but now i have a new problem, i get back no result but in the database we have a set with the value we select.
here the user function, perhaps hers is a mistake:
String Query = " ";
Channel channel = null;
DataBaseAccessor accessor = null;
DataBaseResult resultSet = null;
// Build the Query String
Query = "Select MASTERLANG from D344L where PROGNAME =' " + MG_DESCR_LONG[0] + "'";
try{
//Determine a channel, as created in the Configuration
channel = LookupService.getChannel("OLPE","JDBC_MKA_Receiver_Lookup");
//Get a system accessor for the channel. As the call is being made to an DB, an DatabaseAccessor is obtained.
accessor = LookupService.getDataBaseAccessor(channel);
//Execute Query and get the values in resultset
resultSet = accessor.execute(Query);
for(Iterator rows = resultSet.getRows();rows.hasNext();)
{
Map rowMap = (Map)rows.next();
result.addValue((String)rowMap.get("MASTERLANG"));
}
}
catch(Exception ex){
result.addValue(ex.getMessage());
}
finally{
try{
if (accessor!=null) accessor.close();
}
catch(Exception e){
result.addValue(e.getMessage());
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.