[JBoss JIRA] (TEIID-3336) Change logging to be disabled by default
by Van Halbert (JIRA)
Van Halbert created TEIID-3336:
----------------------------------
Summary: Change logging to be disabled by default
Key: TEIID-3336
URL: https://issues.jboss.org/browse/TEIID-3336
Project: Teiid
Issue Type: Enhancement
Components: Build/Kits
Affects Versions: 8.10
Reporter: Van Halbert
Assignee: Van Halbert
Priority: Minor
Change the teiid-extension to install logging, which is to change to be disabled by default. This will be done by splitting the current script into to scripts. One to configure the handlers (teiid-add-database-logger.cli). And the second script (teiid-enble-database-logger.cli) can be used to enable. So if someone wants to automate the enabling, the script will be available.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3333.
-----------------------------------
Resolution: Done
Corrected the logic to gracefully drop a fk when the referenced table is not imported.
> Dynamic VDB deployment - JDBCMetadataProcessor NPE
> --------------------------------------------------
>
> Key: TEIID-3333
> URL: https://issues.jboss.org/browse/TEIID-3333
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Fix For: 8.10
>
> Attachments: bad-vdb.xml
>
>
> I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
> The NPE happens with this specific import property
> <property name="importer.TableNamePattern" value="DASHB_A%"/>
> The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
> If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3335) Uniqueidentifier values are casted inside INSERT clause field list
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3335?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3335:
----------------------------------
Fix Version/s: 8.10
Affects Version/s: 7.7
Component/s: JDBC Connector
The affect of the cast will need to be narrowed - it should not affect an insert column.
> Uniqueidentifier values are casted inside INSERT clause field list
> ------------------------------------------------------------------
>
> Key: TEIID-3335
> URL: https://issues.jboss.org/browse/TEIID-3335
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.7
> Reporter: Nicholas D
> Assignee: Steven Hawkins
> Labels: sqlserver2012
> Fix For: 8.10
>
>
> When inserting into SQL Server table which has uniqueidentifier values - Teiid casts these fields to char(36) inside field list.
> Example. When i execute query
> bq. INSERT INTO TABLE(record_id, "time", tag_id, "value")
> VALUES(UUID(), NOW(), '123', 123);}}
> Teiid gives me error
> bq. Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ds: 102 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-12 15:40:18.051'}] SQL: INSERT INTO "dbo"."TABLE" (cast("RECORD_ID" as char(36)), "TIME", "TAG_ID", "VALUE") VALUES (uuid(), ?, '123', 123)]
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3335) Uniqueidentifier values are casted inside INSERT clause field list
by Nicholas D (JIRA)
Nicholas D created TEIID-3335:
---------------------------------
Summary: Uniqueidentifier values are casted inside INSERT clause field list
Key: TEIID-3335
URL: https://issues.jboss.org/browse/TEIID-3335
Project: Teiid
Issue Type: Bug
Reporter: Nicholas D
Assignee: Steven Hawkins
When inserting into SQL Server table which has uniqueidentifier values - Teiid casts these fields to char(36) inside field list.
Example. When i execute query
bq. INSERT INTO TABLE(record_id, "time", tag_id, "value")
VALUES(UUID(), NOW(), '123', 123);}}
Teiid gives me error
bq. Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ds: 102 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-12 15:40:18.051'}] SQL: INSERT INTO "dbo"."TABLE" (cast("RECORD_ID" as char(36)), "TIME", "TAG_ID", "VALUE") VALUES (uuid(), ?, '123', 123)]
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3334) MongoDB: invalid ip address and port number
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-3334?page=com.atlassian.jira.plugin... ]
Ivan Chan updated TEIID-3334:
-----------------------------
Description:
I got invalid IP address/ port number error when I have ":" in IP address.
Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.valueOf(Integer.java:582)
at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
was:
I got invalid IP address/ port number error when I have special character in IP address.
Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.valueOf(Integer.java:582)
at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
Steps to Reproduce:
try to connect to mongodb://jasper:jasper@ds041671.mongolab.com:41671/domain
Got this exception:
Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.valueOf(Integer.java:582)
at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
was:
try to connect to jasper@ds041671.mongolab.com:41671
Got this exception:
Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.valueOf(Integer.java:582)
at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
> MongoDB: invalid ip address and port number
> --------------------------------------------
>
> Key: TEIID-3334
> URL: https://issues.jboss.org/browse/TEIID-3334
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: MongoDB with Teiid 8.9.1
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
>
> I got invalid IP address/ port number error when I have ":" in IP address.
> Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492)
> at java.lang.Integer.valueOf(Integer.java:582)
> at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3334) MongoDB: invalid ip address and port number
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-3334?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-3334:
----------------------------------
I was trying to connect to "mongodb://jasper:jasper@ds041671.mongolab.com:41671/domain"
> MongoDB: invalid ip address and port number
> --------------------------------------------
>
> Key: TEIID-3334
> URL: https://issues.jboss.org/browse/TEIID-3334
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: MongoDB with Teiid 8.9.1
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
>
> I got invalid IP address/ port number error when I have special character in IP address.
> Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492)
> at java.lang.Integer.valueOf(Integer.java:582)
> at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3334) MongoDB: invalid ip address and port number
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3334?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3334:
---------------------------------------
I don't see how you were able to get that as we are splitting on the colon. The only way I could reproduce that exception is setting the remote server list to ":jasper@ds041671.mongolab.com:41671"
> MongoDB: invalid ip address and port number
> --------------------------------------------
>
> Key: TEIID-3334
> URL: https://issues.jboss.org/browse/TEIID-3334
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: MongoDB with Teiid 8.9.1
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
>
> I got invalid IP address/ port number error when I have special character in IP address.
> Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492)
> at java.lang.Integer.valueOf(Integer.java:582)
> at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months
[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-3333:
-------------------------------------
Fix Version/s: 8.10
Assignee: Steven Hawkins (was: Ramesh Reddy)
The change for TEIID-1478 was not complete. If the referenced key table is not found we are still attempting to create the foreign key and thus the npe.
> Dynamic VDB deployment - JDBCMetadataProcessor NPE
> --------------------------------------------------
>
> Key: TEIID-3333
> URL: https://issues.jboss.org/browse/TEIID-3333
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Fix For: 8.10
>
> Attachments: bad-vdb.xml
>
>
> I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
> The NPE happens with this specific import property
> <property name="importer.TableNamePattern" value="DASHB_A%"/>
> The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
> If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 4 months