Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1577

DatabaseBinaryStore several issues

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 3.0.0.Beta3
    • None
    • Storage
    • None

    Description

      • Consider introduction of simple switch over different query types like org.infinispan.loaders.jdbc.TableManipulation. The current impl will fail e.g. on Oracle.
        Here is also a good source for sql datatypes:
        http://www.castor.org/ddlgen-mapping.html
      • getContentLength, at storing the blob, store also the size. query it in this method.
      • Database.tableExists change select * at least to select count(1) or count ( * ). Faster would be to try to create a table and check the errors.
      • In case of non-JNDI: connection opened, but not closed
      • Configuration of table name prefix (When using one DB account for different products, its always better, that tables have component-related prefixes.)

      Attachments

        Activity

          People

            oleg.kulikov Oleg Kulikov (Inactive)
            tfromm_jira Thomas Fromm (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: