2 Replies Latest reply on Jul 16, 2014 7:10 PM by Lbatista-Oracle

    Database Adapter and SQL Server procedure issue

    Lbatista-Oracle

      Hello,


      I am using Jdev 11.1.1.7.0 and SQL Server 2005.


      In the Database Adapter configuration wizard, Specify Stored Procedure step, I choose the “GEACupax” schema and got the following error after a click on “Procedure Browse” button:


      com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'GEACUPAX.INFORMATION_SCHEMA.SCHEMATA'.


      The command Database Adapter tried to execute was:


      (from jdev log:) select schema_name from GEACUPAX.INFORMATION_SCHEMA.SCHEMATA order by schema_name;


      Note, the schema name has changed to uppercase. I think that is the problem. If I try this query in SQLDeveloper, it returns the same error. I can fix it changing the schema name to “GEACupax”. The case matters.


      Any ideas?


      Leandro.