Topic
  • 8 replies
  • Latest Post - ‏2017-09-11T09:07:25Z by ManfredN
ManfredN
ManfredN
6 Posts

Pinned topic RSA 9.5 SQLJ-Errors occurred during the build

‏2015-10-21T07:57:51Z | 9.5 rsa sqlj

I am using SQLJ in IBM Rational Software Architect 9.5.

By building the workspace with webprojects including sqlj-files following error occured:

 

Building workspace' has encountered a Problem. Errors occurred during the build.

Errors occurred during the build.
Errors running builder 'SQLJ Translation Builder' on project 'JavaTests'.
###Error..com.ibm.datatools.sqlj.build.SQLJTranslateBuilder.translateSqlj
java.lang.reflect.InvocationTargetException
###Error..com.ibm.datatools.sqlj.build.SQLJTranslateBuilder.translateSqlj
java.lang.reflect.InvocationTargetException

 

In Version RSA 9.1 does it work perfect.

How to resolve this compile and translation error?

  • ManfredN
    ManfredN
    6 Posts
    ACCEPTED ANSWER

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2017-09-11T09:07:25Z  

    The SQLJ-Compilation uses external programs of "DB2 Data Server Client" (C:\Program Files\IBM\SQLLIB\java\sqlj.zip)

    I have upgrade the "IBM DB2 Data Server Client" to 11.1.0.1528 and now it works fine.

  • bobdy
    bobdy
    20 Posts

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2015-10-21T23:34:13Z  

    That's a fairly generic ibm datatools SQLJ compile/translate error

    RAD v9.5.0 is based on Eclipse 4.4 w/ IBM Java 8.0.1
    RAD 9.1 is  based on Eclipse 4.2 w/ IBM Java 7.0

    You may want to see if there is any Java80  incompatibilty?

    Do you have a small testcase and recreate scenario to show this?

    You may still need to submit a  PMR to IBM RAD support with a small testcase to investigate

     

     

  • ManfredN
    ManfredN
    6 Posts

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2015-10-22T05:01:04Z  
    • bobdy
    • ‏2015-10-21T23:34:13Z

    That's a fairly generic ibm datatools SQLJ compile/translate error

    RAD v9.5.0 is based on Eclipse 4.4 w/ IBM Java 8.0.1
    RAD 9.1 is  based on Eclipse 4.2 w/ IBM Java 7.0

    You may want to see if there is any Java80  incompatibilty?

    Do you have a small testcase and recreate scenario to show this?

    You may still need to submit a  PMR to IBM RAD support with a small testcase to investigate

     

     

    Thanks for your answer.

     

    My project uses Java 7.0 (in the Java-Compiler-options)

    I have attached a sqlj-file to recreate this problem.

     

    --Manfred

    Attachments

  • bobdy
    bobdy
    20 Posts

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2015-10-23T12:28:58Z  

    Hi

    I was able to create a Java project with your Static.sqlj and recreate the workspace Build  error in RAD 9.5.

    The Problems view also showed:

    The declared package does not match the expected package javatests/db2test.    Static.sqlj    /TestJavaSQLJ/SQLJJavaSource/javatests/db2test    line 1    Java Problem

    , where ;line 1 is:
    //  Source File Name: Static.sqlj  %I%


    This may be a defect and/or regression.

    In order to submit a customer defect/APAR and assuming you have a support contract, contact IBM Support (or use the IBM SR web tool if subscrbed)
    to submit a PMR against Rational Application Developer (RAD) 9.5.

    Reference this dW forum item/url and mention  bobdy is involved.
     

    Once there is an APAR an official fix for the next RAD 9.5 fixpack can be scheduled.
    As if  it may also be possible to get an interim testfix.
     

    NOTE: IBM is moving away from these older dW product specific forums such as this one
    In the future please use IBM dW Answers - ask a question and use an available  product specific "tag" such as:  RAD

    https://developer.ibm.com/answers/questions/ask.html

     

    Regards,

  • LeilaE
    LeilaE
    24 Posts

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2016-06-02T18:00:11Z  

    you may be experiencing the following "open" defect:

    https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI58408

    There is no workaround for this.

    For a test fix you need to contact IBM support.

  • FFX-XP
    FFX-XP
    1 Post

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2016-06-21T12:36:18Z  

    Hi,

    I have the same problem:

    before update: all works fine, after update: the same error message.

    Any idea when the bug will be fixed?

  • LeilaE
    LeilaE
    24 Posts

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2016-06-21T15:55:36Z  
    • FFX-XP
    • ‏2016-06-21T12:36:18Z

    Hi,

    I have the same problem:

    before update: all works fine, after update: the same error message.

    Any idea when the bug will be fixed?

    I believe it is planned for RAD 9503 but these plan are subject to change.

  • smithkenny
    smithkenny
    1 Post

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2016-06-29T15:20:14Z  

    This is the first time in 10 years I've ever heard of anyone using SQLJ. 

    I'm curious. Why SQLJ? Why not use JPA and entities?

  • ManfredN
    ManfredN
    6 Posts

    Re: RSA 9.5 SQLJ-Errors occurred during the build

    ‏2017-09-11T09:07:25Z  

    The SQLJ-Compilation uses external programs of "DB2 Data Server Client" (C:\Program Files\IBM\SQLLIB\java\sqlj.zip)

    I have upgrade the "IBM DB2 Data Server Client" to 11.1.0.1528 and now it works fine.