Hi,

can anyone tell me why this shouldn't work
sqlxml = connection.createSQLXML();

with this

public class Main {

static final String DATABASE_URL = "jdbcdbc:crm";
private Connection connection;
private Statement statement;
private String LOGIN = "crm";
private String PSWD = "crm";
private int numberOfColomns;
private String query;
private SQLXML sqlxml;

public Main() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection(DATABASE_URL, LOGIN, PSWD);
statement = connection.createStatement(ResultSet.TYPE_SCROLL_I NSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
sqlxml = connection.createSQLXML();

the only idea i have is that the database doesn't support xml but it's a simple access data base so it should be fine right

Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odbc.JdbcOdbcConnection.createSQLXML(Jdbc OdbcConnection.java:1821)