[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin commented on TEIID-6037:
--------------------------------------
Need to place quotes around wrapper name :)
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforce;
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
> {code}
> {"jboss.deployment.unit.\"sf-vdb.ddl\".PARSE" => "WFLYSRV0153: Failed to process phase PARSE of deployment \"sf-vdb.ddl\" Caused by: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting: <EOF> | \"options\" | \"type\" | \"handler\" | \";\" Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting: <EOF> | \"options\" | \"type\" | \"handler\" | \";\""}}
> {code}
> 5. Got the exception
> {code}
> 17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin updated TEIID-6037:
---------------------------------
Description:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
{code}
{"jboss.deployment.unit.\"sf-vdb.ddl\".PARSE" => "WFLYSRV0153: Failed to process phase PARSE of deployment \"sf-vdb.ddl\" Caused by: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting: <EOF> | \"options\" | \"type\" | \"handler\" | \";\" Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting: <EOF> | \"options\" | \"type\" | \"handler\" | \";\""}}
{code}
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
was:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforce;
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
> {code}
> {"jboss.deployment.unit.\"sf-vdb.ddl\".PARSE" => "WFLYSRV0153: Failed to process phase PARSE of deployment \"sf-vdb.ddl\" Caused by: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting: <EOF> | \"options\" | \"type\" | \"handler\" | \";\" Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting: <EOF> | \"options\" | \"type\" | \"handler\" | \";\""}}
> {code}
> 5. Got the exception
> {code}
> 17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin updated TEIID-6037:
---------------------------------
Description:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
was:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforce;
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
> 5. Got the exception
> {code}
> 17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin updated TEIID-6037:
---------------------------------
Description:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
was:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforce;
> CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL
> 5. Got the exception
> {code}
> 17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin updated TEIID-6037:
---------------------------------
Description:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
was:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforcefour;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforce;
> CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> 5. Got the exception
> {code}
> 17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin updated TEIID-6037:
---------------------------------
Description:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforcefour;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}
was:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforcefour;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:51:34,243 ERROR [org.teiid.RUNTIME] (Worker1) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @6f613a85; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
{code}
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforcefour;
> CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
> CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> 5. Got the exception
> {code}
> 17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
> at org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-6037?page=com.atlassian.jira.plugi... ]
Renat Eskenin updated TEIID-6037:
---------------------------------
Description:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforcefour;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:51:34,243 ERROR [org.teiid.RUNTIME] (Worker1) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @6f613a85; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
{code}
was:
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforcefour;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:51:34,243 ERROR [org.teiid.RUNTIME] (Worker1) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-34(a)15.0.0' @6f613a85; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
{code}
> Cannot start translator salesforce-41
> -------------------------------------
>
> Key: TEIID-6037
> URL: https://issues.redhat.com/browse/TEIID-6037
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 15.0
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> I try to use wildfly+teiid and get strange exception
> 1. Download wildfly-teiid-server V15 (last released)
> 2. Add resource adapter to standalone config
> {code}
> <resource-adapter id="salesforcefour">
> <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
> <config-property name="connectTimeout">30000</config-property>
> <config-property name="password">ppp</config-property>
> <config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
> <config-property name="requestTimeout">120000</config-property>
> <config-property name="username">uuu</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> 3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
> 4. Try to deploy ddl
> {code}
> CREATE DATABASE db;
> USE DATABASE db;
> CREATE FOREIGN DATA WRAPPER salesforcefour;
> CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
> CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
> CREATE SCHEMA salesforce SERVER salesforce;
> IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
> {code}
> 5. Got the exception
> {code}
> 17:51:34,243 ERROR [org.teiid.RUNTIME] (Worker1) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @6f613a85; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
> at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
> at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIID-6037) Cannot start translator salesforce-41
by Renat Eskenin (Jira)
Renat Eskenin created TEIID-6037:
------------------------------------
Summary: Cannot start translator salesforce-41
Key: TEIID-6037
URL: https://issues.redhat.com/browse/TEIID-6037
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 15.0
Reporter: Renat Eskenin
Assignee: Steven Hawkins
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sfDS41" enabled="true" connectable="true" use-java-context="true" pool-name="sfDS41">
<config-property name="connectTimeout">30000</config-property>
<config-property name="password">ppp</config-property>
<config-property name="URL">https://test.salesforce.com/services/Soap/u/45.0</config-property>
<config-property name="requestTimeout">120000</config-property>
<config-property name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforcefour;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforcefour OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
{code}
5. Got the exception
{code}
17:51:34,243 ERROR [org.teiid.RUNTIME] (Worker1) TEIID30021 Uncaught exception processing work: java.lang.ClassCastException: class org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class org.teiid.translator.salesforce.SalesforceConnection (org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of loader 'org.jboss.teiid.resource-adapter.salesforce-34(a)15.0.0' @6f613a85; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
{code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial
by Ramesh Reddy (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ]
Ramesh Reddy commented on TEIIDSB-227:
--------------------------------------
yes, Postgres translator is reading as Geometry type, so no conversion is needed. But since Teiid may need a SpatialDialect, IMO the workaround could be as Steve suggesting use ` st_ conversion` to read in as text then convert to `MultilineText`. For example:
{code:java}
@Entity
@SelectQuery("SELECT gid, ST_AsText(geom), name FROM nyc.nyc_streets")
public class Street {
@Id
int gid;
@Column
String geom;
@Column
String name;
public MultilineString getMultilineString(){
// this could be more complex than what I am showing here, but I am not sure of the details.
return new MultilineString(...);
}{code}
> Information about support for Hibernate-Spatial
> -----------------------------------------------
>
> Key: TEIIDSB-227
> URL: https://issues.redhat.com/browse/TEIIDSB-227
> Project: Teiid Spring Boot
> Issue Type: Task
> Components: datasource
> Affects Versions: 1.6.0
> Reporter: Fabian Knoll
> Priority: Major
> Labels: hibernate, spatial, types
> Fix For: 1.7.0
>
>
> Hi,
> in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example.
> Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example?
> Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields.
>
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0
[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ]
Steven Hawkins commented on TEIIDSB-227:
----------------------------------------
I needed to review more of this. My assumption about what was going on here was not correct.
> The database is a PostGis and the type is a geometry, not a blob.
It should then be imported as a teiid geometry type. Calling st_geomfromwkb on something that is already a geometry value is expected fail as there is no implicit conversion from geometry to blob.
> One workaround, based on using a clob is:
That confirms that the value is being imported as a teiid geometry and that you can apply the st_ conversion function to text.
> With version 1.7.0-SNAPSHOT and for this class (code-snippet) I still get an error:
Our GeometryType values are serializable, but based upon https://stackoverflow.com/questions/48946230/java-io-streamcorruptedexcep... that seems similar to issues hibernate has had with serdes and geometry types in the past. It shouldn't be a classloading issue as teiid spring boot and hibernate spatial are both depending upon org.locationtech.jts:jts-core 1.16
However Teiid is only providing a regular dialect, not a SpatialDialect. Some of the other comments on stackoverflow post and related indicate that the postgis dialect is required, so we may similarly need to provide a SpatialDialect.
> Information about support for Hibernate-Spatial
> -----------------------------------------------
>
> Key: TEIIDSB-227
> URL: https://issues.redhat.com/browse/TEIIDSB-227
> Project: Teiid Spring Boot
> Issue Type: Task
> Components: datasource
> Affects Versions: 1.6.0
> Reporter: Fabian Knoll
> Priority: Major
> Labels: hibernate, spatial, types
> Fix For: 1.7.0
>
>
> Hi,
> in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example.
> Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example?
> Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields.
>
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years
- 1
- 0