Topic
25 replies Latest Post - ‏2009-05-30T14:54:11Z by SystemAdmin
SystemAdmin
SystemAdmin
11979 Posts
ACCEPTED ANSWER

Pinned topic Odd ant error when using the sql task in WSAD 5.1.1

‏2004-02-19T17:04:13Z |
I am trying to get the ant sql task to work in WSAD. It will work the
first time I try it but if I try it again I get the following error.

BUILD FAILED: java.lang.VerifyError: class loading constraint violated
(class: oracle/jdbc/driver/OracleResultSet method:
updateBFILE(ILoracle/sql/BFILE;)V) at pc: 0

If I close WSAD and reopen it the task will run but only once. Any ideas?

Thanks
Updated on 2009-05-30T14:54:11Z at 2009-05-30T14:54:11Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    11979 Posts
    ACCEPTED ANSWER

    Re: Odd ant error when using the sql task in WSAD 5.1.1

    ‏2004-10-11T11:36:42Z  in response to SystemAdmin
    I have the same error. In the sql task, i make a jdbc connection to Oracle. The following is the error message when i run ant script in WSAD; however, i have no such error when running ant script in command prompt.
    Can any IBM expert help ??? Thanks a lot.
    java.lang.VerifyError: class loading constraint violated (class: oracle/jdbc/driver/OracleConnection method: unwrap()Loracle/jdbc/OracleConnection;) at pc: 0
    at java.lang.Throwable.<init>(Throwable.java)
    at java.lang.Throwable.<init>(Throwable.java)
    at java.lang.VerifyError.<init>(VerifyError.java:51)
    at java.lang.Class.verifyImpl(Native Method)
    at java.lang.Class.verify(Class.java)
    at java.lang.Class.initialize(Class.java)
    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
    at java.sql.DriverManager.getConnection(DriverManager.java:543)
    at java.sql.DriverManager.getConnection(DriverManager.java:194)
    • SystemAdmin
      SystemAdmin
      11979 Posts
      ACCEPTED ANSWER

      Re: Odd ant error when using the sql task in WSAD 5.1.1

      ‏2005-07-22T23:18:27Z  in response to SystemAdmin
      I too am having the same problem. Has anyone had any luck in getting it resolved?
  • SystemAdmin
    SystemAdmin
    11979 Posts
    ACCEPTED ANSWER

    Re: Odd ant error when using the sql task in WSAD 5.1.1

    ‏2004-12-01T15:18:11Z  in response to SystemAdmin
    I am also facing the same problem.

    Environment : ANT 1.5.3, WSAD 5.1.2 and JDK 1.4

    java.lang.VerifyError: class loading constraint violated (class: oracle/jdbc/driver/OracleConnection method: unwrap()Loracle/jdbc/OracleConnection;) at pc: 0

    Do you find any solution for this?

    Thanks,
    Venkat
    • SystemAdmin
      SystemAdmin
      11979 Posts
      ACCEPTED ANSWER

      Re: Odd ant error when using the sql task in WSAD 5.1.1

      ‏2005-03-21T18:40:45Z  in response to SystemAdmin
      Just chiming in. I get the "class loading constrain violated" VerifyError everytime I try to use the DB2 JCC Driver more than once. Hopefully somebody else will have found a solution by now.
      • SystemAdmin
        SystemAdmin
        11979 Posts
        ACCEPTED ANSWER

        Re: Odd ant error when using the sql task in WSAD 5.1.1

        ‏2005-03-22T22:27:20Z  in response to SystemAdmin
        Hi,

        I too, am getting the error message in WSAD (Version: 5.1.1
        Build id: 20031120_1915) via my Ant 1.5.3 build file:

        BUILD FAILED: java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/c/o method: a(Lcom/ibm/db2/jcc/c/jc;Lcom/ibm/db2/jcc/c/pd;)V) at pc: 0

        The error is pointing to an IBM DB2 JDBC driver issue.

        Does anyone have any ideas?

        Cheers,
        Aron
        • SystemAdmin
          SystemAdmin
          11979 Posts
          ACCEPTED ANSWER

          Re: Odd ant error when using the sql task in WSAD 5.1.1

          ‏2005-04-18T18:22:16Z  in response to SystemAdmin
          I get similar behavior except in the context of running Middlegen twice.

          java.lang.VerifyError: class loading constraint violated (class: oracle/jdbc/driver/OracleConnection method: unwrap()Loracle/jdbc/OracleConnection;) at pc: 0

          Unfortunately, it doesn't look like anyone is watching this thread.
          • SystemAdmin
            SystemAdmin
            11979 Posts
            ACCEPTED ANSWER

            Re: Odd ant error when using the sql task in WSAD 5.1.1

            ‏2005-04-25T23:52:39Z  in response to SystemAdmin
            I have the same error

            4/25/05 16:49:41:184 PDT 00000034 ServletWrappe E SRVE0068E: Could not invoke the service() method on servlet AutomotiveServlet. Exception thrown : java.lang.VerifyError: class loading constraint violated (class: oracle/jdbc/driver/OracleConnection method: unwrap()Loracle/jdbc/OracleConnection;) at pc: 0
            at java.lang.Class.verifyImpl(Native Method)
            at java.lang.Class.verify(Class.java:253)
            at java.lang.Class.initialize(Class.java:315)
            at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
            at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
            at java.sql.DriverManager.getConnection(DriverManager.java:539)
            I am using Rational Application Developer 6.0.0.1
            and the Websphere 6.0 Test Environment.
            • SystemAdmin
              SystemAdmin
              11979 Posts
              ACCEPTED ANSWER

              Re: Odd ant error when using the sql task in WSAD 5.1.1

              ‏2005-06-24T15:25:24Z  in response to SystemAdmin
              I have the same error, but like martin.davidsson, this is with DB2. I am using RAD v6.0, DB2 v8.2, and while adding a connection to DB2, when I test the connection, I get:

              java.lang.reflect.InvocationTargetException
              class loading constraint violated (class: com/ibm/db2/jcc/b/o method: a(Lcom/ibm/db2/jcc/b/hc;)V) at pc:0

              what kinda error message is that?
              • SystemAdmin
                SystemAdmin
                11979 Posts
                ACCEPTED ANSWER

                Re: Odd ant error when using the sql task in WSAD 5.1.1

                ‏2005-06-24T15:48:12Z  in response to SystemAdmin
                Follow up:
                if I stop RAD and restart it, then enter the connection info again, it works. Just don't get it wrong the first time and you will avoid this error.
            • pjmorris
              pjmorris
              1 Post
              ACCEPTED ANSWER

              Re: Odd ant error when using the sql task in WSAD 5.1.1

              ‏2007-09-07T05:08:38Z  in response to SystemAdmin
              I had a similar error in WAS 6.1. A war file (contained within a deployed ear) contained a copy of the jdbc driver jar that was also used as a WebSphere JDBC Provider. Removing the jdbc driver from the war fixed the problem.
            • jinzongnan
              jinzongnan
              2 Posts
              ACCEPTED ANSWER

              Re: Odd ant error when using the sql task in WSAD 5.1.1

              ‏2007-09-22T03:26:45Z  in response to SystemAdmin
              I got the similar error on my test environment WAS 6.1.0.3 DB2 V9.1, when test datasource conntetions in WAS admin console. Finally I found the changing the dirver position may resolve this problem, at least on my environment :). Load db2jcc.jar prior to db2jcc_license_cu.jar. Good Luck!!!

              Error message when load db2jcc_license_cu.jar first:
              The test connection operation failed for data source profiles on server nodeagent at node lccn24Node01 with the following exception: java.sql.SQLException: java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/c/p method: getSQLJLogWriter()Lcom/ibm/db2/jcc/SQLJLogWriter;) at pc: 0. View JVM logs for further details.

              Message when load db2jcc.jar first:
              The test connection operation for data source profiles on server nodeagent at node lccn25Node01 was successful.
        • SystemAdmin
          SystemAdmin
          11979 Posts
          ACCEPTED ANSWER

          java.lang.VerifyError: class loading constraint violated

          ‏2006-06-02T09:21:30Z  in response to SystemAdmin
          Could anyone help me solve this unusual error... and i tried a lot with all aspect but no results.
          exception

          javax.servlet.ServletException: Servlet execution threw an exception

          root cause

          java.lang.VerifyError: class loading constraint violated (class: org/apache/derby/client/am/ResultSet method: earlyCloseComplete(Lorg/apache/derby/client/am/Sqlca;)V) at pc: 0
          java.lang.J9VMInternals.verifyImpl(Native Method)
          java.lang.J9VMInternals.verify(J9VMInternals.java:42)
          java.lang.J9VMInternals.verify(J9VMInternals.java:40)
          java.lang.J9VMInternals.initialize(J9VMInternals.java:111)
          org.apache.derby.client.net.NetStatementReply.parseOPNQRYRM(Unknown Source)
          org.apache.derby.client.net.NetStatementReply.parseResultSetCursor(Unknown Source)
          org.apache.derby.client.net.NetStatementReply.parseResultSetProcedure(Unknown Source)
          org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
          org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)
          org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source)
          org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source)
          org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source)
          org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
          org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source)
          org.apache.derby.client.am.DatabaseMetaData.metaDataInfoCall(Unknown Source)
          org.apache.derby.client.am.DatabaseMetaData.getMetaDataInfoBooleanWithType(Unknown Source)
          org.apache.derby.client.am.DatabaseMetaData.supportsResultSetType(Unknown Source)
          org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:81)
          org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1885)
          org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1178)
          com.ibm.sampletest1.actions.InputAction.execute(InputAction.java:39)
          org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
          org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
          org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
          org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
          javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
          javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

          cheers,
          Irfan
          • SystemAdmin
            SystemAdmin
            11979 Posts
            ACCEPTED ANSWER

            Re: java.lang.VerifyError: class loading constraint violated

            ‏2007-07-18T16:02:05Z  in response to SystemAdmin
            Although I am not using Ant, I am seeing this error quite randomly. The temporary fix seems to be:
            1. Stop the server
            2. Remove all applications and EARs fromthe server
            3. Republish with no applications or EARs
            4. Republish the application
  • SystemAdmin
    SystemAdmin
    11979 Posts
    ACCEPTED ANSWER

    Re: Odd ant error when using the sql task in WSAD 5.1.1

    ‏2005-07-11T07:54:05Z  in response to SystemAdmin
    I am now facing similar problem with WSAD. I could able to see that this is the problem of setting up the correct environment or library needed for Ant during runtime. But I could not resolve the problem. Have anyone of you got solution for this ?
    If so, please let me know.

    thanks,
    Ravi
    • SystemAdmin
      SystemAdmin
      11979 Posts
      ACCEPTED ANSWER

      Re: Odd ant error when using the sql task in WSAD 5.1.1

      ‏2005-12-27T13:32:18Z  in response to SystemAdmin
      I found something in RAD which was giving same error but with sensible message.
      Problem is that, if we use the same JRE for ant and for workspace, it say "Library is already loaded in another class loader".
      That means, if we run the ant for the first time, it will work fine as this will be the first time that we are loading the db2 library.

      In RAD I went to
      run->external tools->external tools
      selected a ant build file
      Went to JRE tab and selected a different JRE (not the same as workspace)

      With these steps it works fine everytime.

      But I couldn't find how to specify a different JRE in WSAD!!!..

      If anybody knows how to specify a different JRE for ant, we can solve this problem.

      Hope this helps...
      For now, I'm running on command line to execute the ant script.
  • SystemAdmin
    SystemAdmin
    11979 Posts
    ACCEPTED ANSWER

    Solution for this : Re: Odd ant error when using the sql task in WSAD 5.1.1

    ‏2006-04-04T14:32:39Z  in response to SystemAdmin
    I resolved this error by fork="true" so it run on a different virtual machine and no error occur :)
    • SystemAdmin
      SystemAdmin
      11979 Posts
      ACCEPTED ANSWER

      Re: Solution for this : Re: Odd ant error when using the sql task in WSAD 5.1.1

      ‏2006-06-18T09:17:19Z  in response to SystemAdmin
      > I resolved this error by fork="true" so it run on a
      > different virtual machine and no error occur :)

      This solution is really bad, since you loose the the GUI of eclipse for launching ant files.

      How come no one from IBM solved this already??

      Asaf Mesika
      • SystemAdmin
        SystemAdmin
        11979 Posts
        ACCEPTED ANSWER

        Re: Solution for this : Re: Odd ant error when using the sql task in WSAD 5.1.1

        ‏2007-04-02T16:42:44Z  in response to SystemAdmin
        IBM, please if you have the answer, tell us...

        This is your forum, and we are talking about your software.
        In fact I'm having the same problem with the java.lang.VerifyError with WebSphere 6.1 and classes12.jar for OracleDriver.

        If I restart the WAS completely, my WebApp works fine, but when I restart only the WebApp from WAS console, the following error is arised:
        (I put the class loader with Application First, but it doesn't work.)

        4/2/07 12:34:02:395 AST 00000035 ServletWrappe E SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet: sDirectorio. Exception thrown : java.lang.VerifyError: class loading constraint violated (class: oracle/jdbc/driver/OracleResultSet method: updateARRAY(ILoracle/sql/ARRAY;)V) at pc: 0
        at java.lang.J9VMInternals.verifyImpl(Native Method)
        at java.lang.J9VMInternals.verify(J9VMInternals.java:59)
        at java.lang.J9VMInternals.verify(J9VMInternals.java:57)
        at java.lang.J9VMInternals.verify(J9VMInternals.java:57)
        at java.lang.J9VMInternals.initialize(J9VMInternals.java:120)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:624)
        at oracle.jdbc.dbaccess.DBAccess.setNlsParamsClient(DBAccess.java:1684)
        at oracle.jdbc.ttc7.TTC7Protocol.initNls(TTC7Protocol.java:1592)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:406)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
        • SystemAdmin
          SystemAdmin
          11979 Posts
          ACCEPTED ANSWER

          Re: Solution for this : Re: Odd ant error when using the sql task in WSAD 5.1.1

          ‏2007-04-02T16:49:44Z  in response to SystemAdmin
          eislas wrote:
          > IBM, please if you have the answer, tell us...
          >

          This is not an official way for requesting answers with problems. If you
          need support and an answer, go through the Support route:

          http://www-306.ibm.com/software/websphere/support/probsub.html
        • SystemAdmin
          SystemAdmin
          11979 Posts
          ACCEPTED ANSWER

          Re: Solution for this : Re: Odd ant error when using the sql task in WSAD 5.1.1

          ‏2007-04-24T07:33:40Z  in response to SystemAdmin
          You can use the oracledriver from a oracle9i to connect to a oracle 8. I try with ojdbc14.jar in place of classes12.zip and all works fine.
          • SystemAdmin
            SystemAdmin
            11979 Posts
            ACCEPTED ANSWER

            Re: Solution for this : Re: Odd ant error when using the sql task in WSAD 5.1.1

            ‏2007-06-29T07:02:25Z  in response to SystemAdmin
            Hi,
            I am getting the following error when loading db29.jar in websphere 6.1 with jdk1.5.

            WebApp E Servlet Error-action: java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/c/p method: getSQLJLogWriter()Lcom/ibm/db2/jcc/SQLJLogWriter;) at pc: 0
            at java.lang.J9VMInternals.verifyImpl(Native Method)
            at java.lang.J9VMInternals.verify(J9VMInternals.java:59)
            at java.lang.J9VMInternals.verify(J9VMInternals.java:57)
            at java.lang.J9VMInternals.initialize(J9VMInternals.java:120)
            at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)
            Please give me a good solution to overcome this issue. Please take it as an urgency and do reply me.

            Thanks,
            Ram
  • jinzongnan
    jinzongnan
    2 Posts
    ACCEPTED ANSWER

    Solution: Odd ant error when using the sql task in WSAD 5.1.1

    ‏2007-09-22T03:33:00Z  in response to SystemAdmin
    I got the similar error on my test environment WAS 6.1.0.3 & DB2 V9.1, when test datasource conntetions in WAS admin console. Finally I found that changing the dirver position may resolve this problem, at least on my environment :). Load db2jcc.jar prior to db2jcc_license_cu.jar. Good Luck!!!

    Error message when load db2jcc_license_cu.jar first:
    The test connection operation failed for data source profiles on server nodeagent at node lccn24Node01 with the following exception: java.sql.SQLException: java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/c/p method: getSQLJLogWriter()Lcom/ibm/db2/jcc/SQLJLogWriter;) at pc: 0. View JVM logs for further details.

    Message when load db2jcc.jar first:
    The test connection operation for data source profiles on server nodeagent at node lccn25Node01 was successful.
  • luiguiparedes
    luiguiparedes
    1 Post
    ACCEPTED ANSWER

    Re: Odd ant error when using the sql task in WSAD 5.1.1

    ‏2008-04-07T15:30:35Z  in response to SystemAdmin
    Upgrade or remove los JDBC Provider that have another version of libraries in classpath
    • SystemAdmin
      SystemAdmin
      11979 Posts
      ACCEPTED ANSWER

      Re: Odd ant error when using the sql task in WSAD 5.1.1

      ‏2009-04-24T19:18:59Z  in response to luiguiparedes
      Below is the error I got,
      java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/b/eb method: b(Ljava/lang/String;IIII[Ljava/lang/String;)Lcom/ibm/db2/jcc/b/uk;) at pc: 0
      at java.lang.J9VMInternals.verifyImpl(Native Method)

      Below ibm site helped me in fixing my issue,

      http://www-01.ibm.com/support/docview.wss?uid=swg21242385

      I deleted all occurrences of db2cc.jar files which came with RAD installation to prevent IDE from preloading them. And passed a copy of it in classpath from my project folder. It solved my issue.

      Thanks
      Nagaraju Bheemaneni
    • SystemAdmin
      SystemAdmin
      11979 Posts
      ACCEPTED ANSWER

      Re: Odd ant error when using the sql task in WSAD 5.1.1

      ‏2009-05-30T14:54:11Z  in response to luiguiparedes
      Check if there is classes12.jar in the classpath. If it is available Please remove it from the classpath then try with the ojdbc14_g.jar. It is available in www.oracle.com

      Finally... It Works!