[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ]
Van Halbert edited comment on TEIID-3862 at 2/18/16 3:34 PM:
-------------------------------------------------------------
Sybase:
{code}
<datasource jndi-name="java:/SYBASE" pool-name="SYBASE" enabled="true">
<connection-url>jdbc:jtds:sybase://${hostname}:5000/${databasename};tds=5.0</connection-url>
<driver>sybase15</driver>
<pool>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>${username}</user-name>
<password${password}</password>
</security>
</datasource>
{code}
{code}
<driver name="sybase15" module="org.sybase15">
<xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
</driver>
{code}
was (Author: van.halbert):
Sybase:
<datasource jndi-name="java:/SYBASE" pool-name="SYBASE" enabled="true">
<connection-url>jdbc:jtds:sybase://${hostname}:5000/${databasename};tds=5.0</connection-url>
<driver>sybase15</driver>
<pool>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>${username}</user-name>
<password${password}</password>
</security>
</datasource>
<driver name="sybase15" module="org.sybase15">
<xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
</driver>
> Documentation in kit for certain datasources missing
> ----------------------------------------------------
>
> Key: TEIID-3862
> URL: https://issues.jboss.org/browse/TEIID-3862
> Project: Teiid
> Issue Type: Quality Risk
> Components: Documentation
> Reporter: Ramesh Reddy
> Assignee: Van Halbert
> Fix For: 8.12.5
>
>
> The following data sources do not have documentation under
> "docs/teiid/datasources"
> where typically a standalone.xml changes and/or CLI scripts are provided.
> access
> hana
> hsql
> informix
> modeshape
> netezza
> sybase
> teradata
> excel
> hbase
> odata
> odata4
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3862:
------------------------------------
Sybase:
<datasource jndi-name="java:/SYBASE" pool-name="SYBASE" enabled="true">
<connection-url>jdbc:jtds:sybase://${hostname}:5000/${databasename};tds=5.0</connection-url>
<driver>sybase15</driver>
<pool>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>${username}</user-name>
<password${password}</password>
</security>
</datasource>
<driver name="sybase15" module="org.sybase15">
<xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
</driver>
> Documentation in kit for certain datasources missing
> ----------------------------------------------------
>
> Key: TEIID-3862
> URL: https://issues.jboss.org/browse/TEIID-3862
> Project: Teiid
> Issue Type: Quality Risk
> Components: Documentation
> Reporter: Ramesh Reddy
> Assignee: Van Halbert
> Fix For: 8.12.5
>
>
> The following data sources do not have documentation under
> "docs/teiid/datasources"
> where typically a standalone.xml changes and/or CLI scripts are provided.
> access
> hana
> hsql
> informix
> modeshape
> netezza
> sybase
> teradata
> excel
> hbase
> odata
> odata4
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3979) Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3979?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3979:
---------------------------------------
9.0 Alpha1 will be out today. 8.13.2 should be out in about 2 weeks.
> Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
> ---------------------------------------------------------------------------------------
>
> Key: TEIID-3979
> URL: https://issues.jboss.org/browse/TEIID-3979
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Gabriel Steinberg
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> When running the following query through Teiid against an HSQL database:
> SELECT CAST(N_NATIONKEY AS VARCHAR(100)) FROM NATION
> Teiid drops the length from the query, sending to HSQL the query
> SELECT CAST(N_NATIONKEY AS VARCHAR) FROM NATION
> which causes an HSQL syntax error. HSQL doesn't support VARCHAR without length.
> Note: this query was generated by Tableau, and there's no easy way to change it to use the LFT function, as suggested by Steven in https://developer.jboss.org/thread/267816
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3599:
---------------------------------------
It seems like from some of the community issues that they may want something more like a procedure, or the ability to use a source hint to drive which file to use - rather than just the aliasing approach from the previous comment.
> Excel translator and dynamic filenames
> --------------------------------------
>
> Key: TEIID-3599
> URL: https://issues.jboss.org/browse/TEIID-3599
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Ralph Martin Black
> Assignee: Ramesh Reddy
> Priority: Minor
> Fix For: Open To Community
>
>
> Hi all,
> All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model:
> ...
> <property name="importer.ExcelFileName" value="names.xls"/>
> ...
> Is there any way to specify filenames dynamically at run-time?
> Best regards
> MB!
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months