-
Bug
-
Resolution: Done
-
Major
-
14.0.2.Final
-
None
The section https://infinispan.org/docs/14.0.x/titles/configuring/configuring.html#sql-store-query-configuration_persistence has some wrong configurations:
The following query
CREATE TABLE Person ( name VARCHAR(255) NOT NULL, picture VARBINARY(255), sex VARCHAR(255), birthdate TIMESTAMP, accepted_tos BOOLEAN, notused VARCHAR(255), PRIMARY KEY (name) );
picture VARBINARY(255) should be picture BYTEA. Also let make it more explicit that this example is for postgres
Missing ; after Protobuff package
It's missing connection-pool connection-url="" on the cache configuration
Schema on cache configuration is wrong:
Schema is wrong
<query-jdbc-store xmlns="urn:infinispan:config:store:jdbc:14.0"
Should be
Schema is wrong
<query-jdbc-store xmlns="urn:infinispan:config:store:sql:14.0"