• class java.lang.ClassNotFoundException: xpages.DBUtil

    By Julian Robichaux 1 decade ago

    This will probably end up being a stupid question with an obvious answer, but...

    Whenever I try to access the Dynamic SQL View, SQL Query, or Meta Data pages in the sample database, I get this error: 

    Error while executing JavaScript computed expression
    javax.faces.FacesException: Can't instantiate class: 'xpages.DBUtil'.. java.lang.ClassNotFoundException: class java.lang.ClassNotFoundException: xpages.DBUtil
    Can't instantiate class: 'xpages.DBUtil'.. java.lang.ClassNotFoundException: class java.lang.ClassNotFoundException: xpages.DBUtil
    java.lang.ClassNotFoundException: class java.lang.ClassNotFoundException: xpages.DBUtil
    class java.lang.ClassNotFoundException: xpages.DBUtil

    If I open the DBUtil.java class, the compiler cannot find the classes com.ibm.xsp.extlib.util.ExtLibUtil or com.ibm.xsp.extlib.util.JdbcUtil. I don't see those classes anywhere either, in the database or in the various plugin files. Did I miss something in the build path of my setup?

    I am using 8.5.3 client and server. The remote access using the JDBC driver works just fine, it's the sample XPages database I'm having trouble with.

     

    • Got it. Needed the Extension Library.

      By Julian Robichaux 1 decade ago

      Okay, I got it worked out. There were a few things going on.

       

      First, the com.ibm.xsp.extlib.util.ExtLibUtil and com.ibm.xsp.extlib.util.JdbcUtil classes are in the relational database plugin of the XPages Extension Library. That's why I couldn't find them.

       

      Second, when I first copied the sample database to my server it gave me some permission errors when I tried to access the pages. So I signed the database. Then some of the pages seemed to work, others just gave errors about the DBUtil class, etc. That's when I looked at the code and saw the compilation errors related to ExtLibUtil and JdbcUtil.

       

      Third, to fix all of this I needed to install the Extension Library plugins into DDE, restart DDE, and do a full Build on the database. Then everything worked (I already had the Extension Library installed on my server). All good now.

       

      It might be good to add something in the readme file about the ExtLib dependencies, if they're not there already. Or, if I totally missed that part of the instructions, good job and please just forget I said anything...  :-)

      • I updated the doc

        By Philippe Riand 1 decade ago

        Thanks for the feedback.

        I will also soon upload a new release with the latest SQLite (3.7.15.2). We are processing the legal stuff now.