SQLException: ERROR: .ClassNotFoundException:

[Alex B.]

I see these messages in the log from compiere server apps.
It looks like postgresql cannot find those classes during sql query execution.
Can anyone tell how to solve this issue?
thanx
Alex

java.sql.SQLException: ERROR: java.lang.ClassNotFoundException: org.compiere.sqlj.Compiere; State=XX
000; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471
)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
330)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282
)
..........

[Bepi Esposito Vingiano]

Hi Alex.
Have you solved the problem?
I also have sqlj class not found problem.
For me, only using Postgresql.

Bepi

[Carlos Ruiz]

Hi, you haven't installed the necessary sqlj in database:

You can test it with the following query:
select adddays(current_timestamp, 5);

And to install you must execute the following instructions - changing the directory of sqlj.jar:

set client_encoding to 'LATIN1';
SET search_path TO compiere,sqlj;
select sqlj.remove_jar('sqlj', true);
select sqlj.install_jar('file:///C:/Compiere2/lib/sqlj.jar','sqlj',true);
SELECT sqlj.set_classpath('compiere', 'sqlj');

_________________
globalqss - cruiz