2 Replies Latest reply on Feb 4, 2013 5:19 AM by Horia Chiorean

    Cannot query anything after restart

    Oliver Zhou Newbie

      Hi Author,

       

      I configured the inifinispan's configuration to use MySQL. After the application restart, I cannot query anything, but if I get node by path, I can get the node.

       

      Here's my repository configuration:

       

      {
          "name" : "My Repository",
          "jndiName" : "",
          "workspaces" : {
              "predefined" : ["otherWorkspace"],
              "default" : "default",
              "allowCreation" : true
          },
          "storage" : {
              "cacheConfiguration" : "src/main/resources/infinispan-mysql.xml",
              "cacheName" : "databasePersistedRepository"
          },
          "security" : {
              "anonymous" : {
                  "roles" : ["readonly","readwrite","admin"],
                  "useOnFailedLogin" : false
              }
          },
          "node-types" : ["nodeTypes.cnd"]
      }
      
      

       

      The query is like this: SELECT * FROM [pd:product]

       

      Am I missing something in the configuration?