MQSeries.net :: View topic - An unrecognized CHARSET property was specified: ISO-8859-1

DTran · Posted: Mon Feb 02, 2009 4:42 am Post subject:

Hi,

I am facing a problem. We have the broker running on Z/os and using JavaComputeNode to get messages of a Sybase running on Unix. In the flow I use JDBC with stored procedure to access Sybase. This is part of the coding:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.ListResourceBundle;
import java.util.Properties;

import com.ibm.broker.javacompute.MbJavaComputeNode;
import com.ibm.broker.plugin.MbDate;
import com.ibm.broker.plugin.MbElement;
import com.ibm.broker.plugin.MbException;
import com.ibm.broker.plugin.MbMessage;
import com.ibm.broker.plugin.MbMessageAssembly;
import com.ibm.broker.plugin.MbOutputTerminal;
import com.ibm.broker.plugin.MbUserException;
import com.ibm.broker.plugin.MbXPath;

public class OphalenUitstelIBS_JavaCompute extends MbJavaComputeNode {

private static final String JAAR =
"jaar";

/* (non-Javadoc)
* @see
com.ibm.broker.javacompute.MbJavaComputeNode#evaluate(com.ibm.broker.plugin.MbMessageAssembly)
*/
public void evaluate(MbMessageAssembly contact admin) throws MbException
{

String methodName = "evaluate";

// haal de user defined properties op
String IBS_QUERY =
(String)getUserDefinedAttribute("IBS_QUERY");
String IBS_CONNECTION_STRING =
(String)getUserDefinedAttribute("IBS_CONNECTION_STRING");
String JDBC_KLASSE =
(String)getUserDefinedAttribute("JDBC_KLASSE");
String USER =
(String)getUserDefinedAttribute("USER");
String PASS =
(String)getUserDefinedAttribute("PASS");
String LOG_USER = "USER"; // het userid
dat gelogged zal worden in de stored procedure

// vooralsnog is dit 'USER', in de nabije

// toekomst krijgen we dit userid in het request mee

// call naar IBS faalt omdat IBS charSet
ISO-8859-1 gebruikt terwijl Broker ebcidic verstuurt.
// zet user en pass onder property.
Properties props = new Properties();
props.put("user",USER);
props.put("password",PASS);
props.put("charSet","ISO-8859-1"); // file encoding is
ISO-8859-1

MbOutputTerminal out = getOutputTerminal("out");
MbOutputTerminal alt = getOutputTerminal("alternate");

MbMessage inMessage = contact admin.getMessage();

// create new message
MbMessage outMessage = new MbMessage();
MbMessageAssembly outAssembly = new MbMessageAssembly(
contact admin , outMessage);

Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;

try {

Class.forName(JDBC_KLASSE);

//DT: aanroep naar IBS en doorgeven juiste codepage dmv
property
connection =
DriverManager.getConnection(IBS_CONNECTION_STRING, props);
statement = connection.prepareStatement(IBS_QUERY);

once i run this, I get the error:

EXCPT JZ0I5: An unrecognized CHARSET property was specified:
ISO-8859-1.,com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)

Could some one tell me what i have done wrong here?

Thx in advance
Tran
_________________
There are 10 types of people in this world - those who understand binary and those who don't