If anybody stumbles onto this - adding the mysql jdbc connector as a dependency in the generated pom.xml works. Just go to maven to get the exact XML for it. for example, mine is:
*<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.12</version> </dependency>* On 6 August 2018 at 10:02, Orel Weinstock (ExposeBox) <[email protected]> wrote: > Hi all, > > I've set up a single node cluster using the docker image from the web > console. > I've set the correct property values in secret properties, and see that > Ignite has the table metadata that I've imported from MySQL in the queries > sidebar. > > I understand that I need to have data pre-loaded in order to run SQL > SELECT queries - that makes sense. But I wanted to make sure the > write-through works, so I typed in an INSERT query. I got the following > error: > > [IgniteSQLException] Failed to execute DML statement [stmt=insert into > "ProductsCache".Products (id, company_id) VALUES (1234, 5258), params=null] > [CachePartialUpdateCheckedException] Failed to update keys (retry > update if possible).: [com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258]] > [IgniteCheckedException] Failed to update keys. > [IgniteCheckedException] Runtime failure on search row: > org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89 > [IgniteCheckedException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [CacheWriterException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [SQLException] Connections could not be acquired from the underlying > database! > [CannotAcquireResourceException] A ResourcePool could not acquire a > resource from its primary factory or source. > [SQLException] No suitable driver > [IgniteCheckedException] Runtime failure on search row: > org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89 > [IgniteCheckedException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [CacheWriterException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [SQLException] Connections could not be acquired from the underlying > database! > [CannotAcquireResourceException] A ResourcePool could not acquire a > resource from its primary factory or source. > [SQLException] No suitable driver > [IgniteCheckedException] Failed to update keys. > [IgniteCheckedException] Runtime failure on search row: > org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89 > [IgniteCheckedException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [CacheWriterException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [SQLException] Connections could not be acquired from the underlying > database! > [CannotAcquireResourceException] A ResourcePool could not acquire a > resource from its primary factory or source. > [SQLException] No suitable driver > [IgniteCheckedException] Runtime failure on search row: > org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89 > [IgniteCheckedException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [CacheWriterException] Failed to write entry to database > [table=production_v2.products, entry=Entry > [key=com.exposebox.model.ProductsKey > [idHash=1025007579, hash=-1839834713, id=1234, companyId=5258], > val=com.exposebox.model.Products [idHash=494073819, hash=1]]] > [SQLException] Connections could not be acquired from the underlying > database! > [CannotAcquireResourceException] A ResourcePool could not acquire a > resource from its primary factory or source. > [SQLException] No suitable driver > > As far as I can tell, it boils down to simply having the MySQL JDBC driver > not available. I've tried putting the JAR in the jdbc_drivers folder in the > docker folder - still doesn't work. I'll try adding it manually to the > pom.xml file, but I don't think that's how it's supposed to work. > > Did anyone else manage to integrate MySQL automatically with Ignite via > web-console? > Thanks, > > -- > > -- > *Orel Weinstock* > Software Engineer > Email: [email protected] <[email protected]> > Website: www.exposebox.com > > -- -- *Orel Weinstock* Software Engineer Email: [email protected] <[email protected]> Website: www.exposebox.com
