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

    Database Adapter and SQL Server procedure issue



      I am using Jdev 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?