[JBoss JIRA] (TEIID-3715) MongoDB metadata import fails
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3715?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3715.
---------------------------------
> MongoDB metadata import fails
> -----------------------------
>
> Key: TEIID-3715
> URL: https://issues.jboss.org/browse/TEIID-3715
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7.1.6_2
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Fix For: 8.12.5
>
>
> Deploying the following dynamic vdb fails when Teiid Connection importer is used:
> {code}
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="mongo" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="mongo-vdb.xml" />
> <model name="importVDBSrcModel">
> <source name="importVDBSrcModel" translator-name="mongodb" connection-jndi-name="java:/mongoDS" />
> </model>
> </vdb>
> {code}
> The resource adapter is defined as:
> {code}
> <resource-adapter id="mongoDS">
> <module slot="main" id="org.jboss.teiid.resource-adapter.mongodb"/>
> <transaction-support>NoTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory" jndi-name="java:/mongoDS" enabled="true" use-java-context="true" pool-name="mongoDS">
> <config-property name="Database">
> bqt
> </config-property>
> <config-property name="RemoteServerList">
> vmgdb01.mw.lab.eng.bos.redhat.com:27017
> </config-property>
> <config-property name="Username">
> dv
> </config-property>
> <config-property name="Password">
> dv
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> Server log:
> {code}
> 08:26:05,590 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB mongo.1 model "importVDBSrcModel" metadata failed to load. Reason:not authorized for query on bqt.system.users: com.mongodb.MongoException: not authorized for query on bqt.system.users
> at com.mongodb.MongoException.parse(MongoException.java:82)
> at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:292)
> at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:273)
> at com.mongodb.DBCursor._check(DBCursor.java:368)
> at com.mongodb.DBCursor._hasNext(DBCursor.java:459)
> at com.mongodb.DBCursor.hasNext(DBCursor.java:484)
> at org.teiid.translator.mongodb.MongoDBMetadataProcessor.process(MongoDBMetadataProcessor.java:58)
> at org.teiid.translator.mongodb.MongoDBMetadataProcessor.process(MongoDBMetadataProcessor.java:39)
> at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:935) [teiid-api-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_60]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_60]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3837) AS400 deployVDB
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3837?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3837.
---------------------------------
> AS400 deployVDB
> ---------------
>
> Key: TEIID-3837
> URL: https://issues.jboss.org/browse/TEIID-3837
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
>
> I'm using Teiid 8.11.3 and db2i translator,
> I'm connecting to an AS400 DB containing around 1000 tables, the deployvdb remained running for 2 hours and it did not finish.
> Is there a way to speed up the deployvdb treatment? or to know more details on the vdb deployment progress?
> I'm able to fetch the DB information schema via a jdbc connection and it is not taking that much time.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3718) Add Log4j 2 Logger Adapter
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3718?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3718.
---------------------------------
> Add Log4j 2 Logger Adapter
> --------------------------
>
> Key: TEIID-3718
> URL: https://issues.jboss.org/browse/TEIID-3718
> Project: Teiid
> Issue Type: Sub-task
> Components: Embedded
> Affects Versions: 8.11.4
> Environment: Apache Maven 3.3.3 (7994120775791599e205a5524ec3e0dfe41d4a06; 2015-04-22T04:57:37-07:00)
> Maven home: C:\Java\apache-maven-3.3.3
> Java version: 1.7.0_79, vendor: Oracle Corporation
> Java home: C:\Program Files\Java\jdk1.7.0_79\jre
> Default locale: en_US, platform encoding: Cp1252
> OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows"
> Reporter: Gary Gregory
> Assignee: Kylin Soong
> Fix For: 8.13
>
> Attachments: Log4j2LoggerAdapter.java
>
>
> Add a Log4j 2 Logger Adapter. See attached.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3863) upgrade spring version
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3863?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3863.
---------------------------------
> upgrade spring version
> ----------------------
>
> Key: TEIID-3863
> URL: https://issues.jboss.org/browse/TEIID-3863
> Project: Teiid
> Issue Type: Sub-task
> Components: Misc. Connectors
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Ramesh Reddy
> Fix For: 8.13
>
>
> The spring version(current use 3.0.7.RELEASE) need to be update, as
> http://mvnrepository.com/artifact/org.apache.cxf/cxf-core/3.0.5
> CXF 3.0.5 compatible spring version is 3.2.6.RELEASE. This cause ws resource adapter run failed in embedded
> {code}
> Caused by: java.lang.NoSuchMethodError: org.springframework.util.ClassUtils.isCglibProxyClass(Ljava/lang/Class;)Z
> at org.apache.cxf.common.util.SpringAopClassHelper.getRealClassInternal(SpringAopClassHelper.java:86)
> at org.apache.cxf.common.util.ClassHelper.getRealClass(ClassHelper.java:85)
> at org.apache.cxf.jaxrs.provider.ProviderFactory.setCommonProviders(ProviderFactory.java:498)
> at org.apache.cxf.jaxrs.client.ClientProviderFactory.setProviders(ClientProviderFactory.java:85)
> at org.apache.cxf.jaxrs.provider.ProviderFactory.initBaseFactory(ProviderFactory.java:137)
> at org.apache.cxf.jaxrs.client.ClientProviderFactory.initBaseFactory(ClientProviderFactory.java:77)
> at org.apache.cxf.jaxrs.client.ClientProviderFactory.createInstance(ClientProviderFactory.java:56)
> at org.apache.cxf.jaxrs.client.JAXRSClientFactoryBean.initClient(JAXRSClientFactoryBean.java:377)
> at org.apache.cxf.jaxrs.client.JAXRSClientFactoryBean.createWebClient(JAXRSClientFactoryBean.java:225)
> at org.teiid.resource.adapter.ws.WSConnectionImpl$HttpDispatch.createWebClient(WSConnectionImpl.java:141)
> at org.teiid.resource.adapter.ws.WSConnectionImpl$HttpDispatch.invoke(WSConnectionImpl.java:168)
> at org.teiid.resource.adapter.ws.WSConnectionImpl$HttpDispatch.invoke(WSConnectionImpl.java:123)
> at org.teiid.translator.ws.BinaryWSProcedureExecution.execute(BinaryWSProcedureExecution.java:155)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:349)
> ... 17 more
> {code}
> run [1] will reproduce this issue.
> [1] https://github.com/teiid/teiid-embedded-examples/tree/master/restservice-...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3961) Can't use TEIID with Websphere 8.5.5
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3961?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3961.
---------------------------------
> Can't use TEIID with Websphere 8.5.5
> ------------------------------------
>
> Key: TEIID-3961
> URL: https://issues.jboss.org/browse/TEIID-3961
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.12.3
> Environment: Websphere 8.5.5 with Teiid 8.12.3
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
>
> If I deploy Teiid on websphere 8.5.5, Teiid embedded server cannot start. It throws the following exception.
> Caused by: java.lang.VerifyError: JVMVRFY013 class loading constraint violated; class=org/jboss/staxmapper/XMLExtendedStreamReaderImpl, method=getAttributeName(I)Ljavax/xml/namespace/QName;, pc=0
> at java.lang.J9VMInternals.verifyImpl(Native Method)
> at java.lang.J9VMInternals.verify(J9VMInternals.java:93)
> at java.lang.J9VMInternals.initialize(J9VMInternals.java:170)
> at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:69)
> at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:77)
> at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:353)
> at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:326)
> at org.teiid.runtime.EmbeddedConfiguration.getCacheFactory(EmbeddedConfiguration.java:180)
> at org.teiid.runtime.EmbeddedServer.start(EmbeddedServer.java:386)
> at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.teiid.TeiidEmbeddedServer.<init>(TeiidEmbeddedServer.java:113)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3998?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3998.
---------------------------------
> EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
> ------------------------------------------------------------
>
> Key: TEIID-3998
> URL: https://issues.jboss.org/browse/TEIID-3998
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12
> Environment: eds-5.3.1_1_2015-jdbc
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server1.log
>
>
> We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance.
> The problem is caused by virtual procedure execution.
> Query performed:
> EXEC View.hiddenUpdate(456,'changed')
> View definition:
> {code}
> <model name="View" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN
> MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME);
> END
> ]]> </metadata>
> </model>
> {code}
> NPE excepton:
> {code}
> Exception in thread "main" java.lang.NullPointerException
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342)
> at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59)
> at jdbcdriver.JDBCClient.main(JDBCClient.java:52)
> {code}
> Client code:
> {code}
> @Test
> public void procedureInvalidateCacheTest(){
> String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;";
> try{
>
> Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');");
>
> ResultSet empty = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(empty.next(), "ResultSet should be empty");
>
> try{
> Thread.sleep(3000);
> }catch(InterruptedException ie){
>
> }
>
> Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')");
>
> ResultSet full = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(full.next(), "ResultSet shouldn't be empty");
>
> int custId = full.getInt(1);
> String custName = full.getString(2);
> Assert.assertEquals(custId, 456,"Returned row with wrong customer id");
> Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name");
>
>
> }catch(SQLException se){
> LOG.error("Error during performing sql query on teiid",se);
> Assert.fail("Error during performing sql query on teiid", se);
> }
> }
> static Connection getTeiidConnectionUser1() throws SQLException {
> LOG.info("Getting Teiid connection for user1.");
> return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null);
> }
> static int executeUpdate(Connection con, String sql) throws SQLException{
> LOG.info("Executing update [connection: " + con + "]: " + sql + ".");
> Statement s = con.createStatement();
> return s.executeUpdate(sql);
> }
> {code}
> Server log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months