NoClassDefFoundError: com/sap/sql/log/OpenSQLException

[wanlin_hau]

I have developed a Java project. It consists of 2 SQLJ files and then a Java class. When I try to execute the Java program, I get a Java error:

java.lang.NoClassDefFoundError: com/sap/sql/log/OpenSQLException

at com.mbb.crrs.business.report.dao.ReportDAO.<init>(ReportDAO.sqlj:23)

at com.mbb.crrs.business.report.dao.Test.main(Test.java:24)

Exception in thread "main"

I notice a similar problem on message:

Is that something that I need to maintain for it to work? Thank you.

[Former Member]

Hi,

I guess there is nothing we can do about it. But wait for the next release.

Regards, Astrid

[Former Member]

Hi Astrid,

Even I'm facing the same problem of

classnotfoundexception:com.sap.sql.log.SQLException.

Did you find any solution to this.Is it that I've not added a certain DC that I'm getting such an exception

[Former Member]

Hi,

the problem one year ago was that the SQLException class was not available through remote access. I don't know if that might have been changed meanwhile in the latest release.

I implemented a simple work around: I caught every SQL-exception in the method where it was thrown, wrapped the exception message and any nested exception in a self written exception and threw this new exception. That worked fine.

Regards, Astrid