ERROR: Invalid UNICODE character sequence found (0xc000)

[Antonio Gallardo]

Hi:

I am getting this error while quering a simple table in a PostgreSQL
database.  Interesting enough the error does not happen when we access the
database using other JDBC application.

The database was coded using:

createdb -E UNICODE myDBname

If I sent in the following code the variable filtro with "z" or "Z" it
throws an exception.

The problem occurs at this line:

Iterator qIter = broker.getIteratorByQuery(query);

The Java code is:

public void getList(Auth_userList bean, String filtro) throws Exception {
  PersistenceBroker broker = null;

  try {
    broker = PersistenceBrokerFactory.defaultPersistenceBroker();
    // Define criterio
    Criteria criterio = new Criteria();
    if (filtro.length() > 0)
      criterio.addLike(FILTRO, filtro + "*");
    criterio.addNotEqualTo(FILTRO, "admin");
    criterio.addOrderBy(FILTRO, true);

    Query query = new QueryByCriteria(Auth_user.class, criterio);
    Iterator qIter = broker.getIteratorByQuery(query);

    while (qIter.hasNext()) {
      Auth_user temp = new Auth_user();
      PropertyUtils.copyProperties((Object)temp, (Object)qIter.next());
      bean.add(temp);
    }
  } catch (Exception e) {
    throw e;
  } finally {
    if (broker != null && !broker.isClosed()) {
      broker.close();
    }
  }
}

Here is the full exception:

Note: The same apply for the drivers:

pg73jdbc.jar
pg74jdbc.jar
pg74.1jdbc.jar

Please explain.

Best Regards,

Antonio Gallardo

at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuery(Unknown
Source)
at test.miclassAuth_userHandler.getList(Auth_userHandler.java:81)

......

Caused by: java.sql.SQLException: ERROR:  Invalid UNICODE character
sequence found (0xc000)

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]