[Database] Type BPCHAR not supported
ThuF opened this issue · 2 comments
ThuF commented
Running the following CSV data against AWS RDS results into the following exception:
- CSVIM file: codbex-countries-data/countries.csvim
- CSV file: codbex-countries-data/countries.csv
- Schema file: codbex-countries/gen/codbex-countries/schema/codbex-countries.schema#L20-L24
Exception:
2024-07-19 10:02:50.569 [INFO ] [main] o.e.d.c.d.c.processor.CsvProcessor - Will insert data into table [CODBEX_COUNTRY] in schema [public]
2024-07-19 10:02:50.579 [ERROR] [main] o.e.d.c.d.c.processor.CsvProcessor - Error occurred while trying to BATCH INSERT CSV records [[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100]] into table [CODBEX_COUNTRY].
org.eclipse.dirigible.database.sql.SqlException: Type BPCHAR not supported
at org.eclipse.dirigible.database.sql.DataTypeUtils.getSqlTypeByDataType(DataTypeUtils.java:392) ~[dirigible-database-sql-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvProcessor.setValue(CsvProcessor.java:355) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvProcessor.setPreparedStatementValue(CsvProcessor.java:336) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvProcessor.insertCsvWithHeader(CsvProcessor.java:243) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvProcessor.populateInsertPreparedStatementValues(CsvProcessor.java:201) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvProcessor.insert(CsvProcessor.java:94) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvimProcessor.insertCsvRecords(CsvimProcessor.java:429) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.processor.CsvimProcessor.process(CsvimProcessor.java:224) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.synchronizer.CsvimSynchronizer.importCsvim(CsvimSynchronizer.java:289) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.data.csvim.synchronizer.CsvimSynchronizer.completeImpl(CsvimSynchronizer.java:218) ~[dirigible-components-data-csvim-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.base.synchronizer.BaseSynchronizer.lambda$complete$0(BaseSynchronizer.java:58) ~[dirigible-components-core-base-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.tenants.tenant.TenantContextImpl.execute(TenantContextImpl.java:63) ~[dirigible-components-core-tenants-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.tenants.tenant.TenantContextImpl.executeForEachTenant(TenantContextImpl.java:96) ~[dirigible-components-core-tenants-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.base.synchronizer.BaseSynchronizer.complete(BaseSynchronizer.java:54) ~[dirigible-components-core-base-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.base.artefact.topology.TopologyWrapper.complete(TopologyWrapper.java:115) ~[dirigible-components-core-base-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.base.artefact.topology.TopologicalDepleter.deplete(TopologicalDepleter.java:47) ~[dirigible-components-core-base-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.initializers.synchronizer.SynchronizationProcessor.processSynchronizers(SynchronizationProcessor.java:264) ~[dirigible-components-core-initializers-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.initializers.synchronizer.SynchronizationInitializer.onApplicationEvent(SynchronizationInitializer.java:67) ~[dirigible-components-core-initializers-10.5.5.jar!/:na]
at org.eclipse.dirigible.components.initializers.synchronizer.SynchronizationInitializer.onApplicationEvent(SynchronizationInitializer.java:25) ~[dirigible-components-core-initializers-10.5.5.jar!/:na]
at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:185) ~[spring-context-6.1.6.jar!/:6.1.6]
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:178) ~[spring-context-6.1.6.jar!/:6.1.6]
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:156) ~[spring-context-6.1.6.jar!/:6.1.6]
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:451) ~[spring-context-6.1.6.jar!/:6.1.6]
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:384) ~[spring-context-6.1.6.jar!/:6.1.6]
at org.springframework.boot.context.event.EventPublishingRunListener.ready(EventPublishingRunListener.java:109) ~[spring-boot-3.2.5.jar!/:3.2.5]
at org.springframework.boot.SpringApplicationRunListeners.lambda$ready$6(SpringApplicationRunListeners.java:80) ~[spring-boot-3.2.5.jar!/:3.2.5]
at java.base/java.lang.Iterable.forEach(Iterable.java:75) ~[na:na]
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:118) ~[spring-boot-3.2.5.jar!/:3.2.5]
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:112) ~[spring-boot-3.2.5.jar!/:3.2.5]
at org.springframework.boot.SpringApplicationRunListeners.ready(SpringApplicationRunListeners.java:80) ~[spring-boot-3.2.5.jar!/:3.2.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:348) ~[spring-boot-3.2.5.jar!/:3.2.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-3.2.5.jar!/:3.2.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-3.2.5.jar!/:3.2.5]
at com.codbex.gaia.GaiaApplication.main(GaiaApplication.java:26) ~[!/:na]
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[na:na]
at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) ~[codbex-gaia.jar:na]
at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) ~[codbex-gaia.jar:na]
at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) ~[codbex-gaia.jar:na] Related to:
iliyan-velichkov commented
PR: #4159