Home:Learn XQuery:XQuery Examples:Resolving Errors:Checklist

Checklist

If you encounter an error when using fn:collection() with DataDirect XQuery, examine the following checklist to resolve the problem:

• Qualify table names in fn:collection() arguments if you have multiple database tables with the same name or the default catalog and schema associated with the connection do not provide access to the database table.
  
  
  • Make sure that you know the correct catalog name, schema name, and table name (including case).
    
    
  • If you are accessing Microsoft SQL Server or Sybase and the database table is owned by dbo, make sure that you qualify the table name with the schema name dbo. For example:
    
    

    collection('FINANCIAL.dbo.HOLDINGS')

  • If you qualify the table name with a catalog name or schema name (or both) and DataDirect XQuery returns an error indicating that multiple collections are found, you may want to qualify the table name with a JDBC connection name.
• Escape special characters in catalog, schema, and table names.
  
  
• Verify connections associated with the XQuery query.
  
  
  • Make sure that the information specified in your connection URL is correct including: database type, server name, port, user, password, and any database-specific connection properties.
    
    
  • If using a DataDirect XQuery source configuration file, make sure that it validates against the source_config.xsd schema shipped with DataDirect XQuery. This schema is located in the examples/config subdirectory of your DataDirect XQuery installation directory. You can validate the configuration file using a tool such as <oXygen> XML Editor for Eclipse (DataDirect XQuery Edition) or Stylus Studio.
    
    
  • If using a DataDirect XQuery source configuration file, make sure that the values of the catalog, schema, and table elements are correct