3 Replies Latest reply on Mar 19, 2004 2:52 AM by dlux42

    FileEJB LOCATE error on PostgreSQL

    dlux42

      I have just checked out the latest CVS, and I have found that JBoss 3.2.3 cannot translate one of the LOCATE queries in FileEJB for PostgreSQL:

      SELECT DISTINCT SUBSTRING(f.fileId, 1, LOCATE('/', f.fileId, LENGTH(?1) + 2)) FROM file AS f WHERE f.fileId LIKE CONCAT(?1, '%/%')

      The NukesDS was set up correctly to the postgresql data source and is located in the deploy directory.

      Did I miss something in the configuration step?

      To tell the truth I did not find the local.properties file in the CVS.