[JBoss JIRA] (TEIIDDES-1744) Cannot preview data from HSQL database
by Andrej Podhradsky (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1744?page=com.atlassian.jira.plu... ]
Andrej Podhradsky closed TEIIDDES-1744.
---------------------------------------
Resolution: Rejected
Not a bug
> Cannot preview data from HSQL database
> ---------------------------------------
>
> Key: TEIIDDES-1744
> URL: https://issues.jboss.org/browse/TEIIDDES-1744
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.1
> Environment: JBDS 6.0.1.GA, Teiid designer 8.1.0.Final, hsqldb.jar version 2.2.9, java.version=1.6.0_45, OS=linux, ARCH=x86_64
> Reporter: Lucie Fabrikova
> Attachments: emp.script
>
>
> I cannot preview data from HSQL database; however, I can access them via SQL scrapbook.
> If I select Preview data, I get following exception:
> java.lang.Exception: JDBC Source for Driver class org.hsqldb.jdbcDriver was not found on server mm://localhost:9999::admin
> at org.teiid83.runtime.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:318)
> at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:555)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIIDDES-1744) Cannot preview data from HSQL database
by Andrej Podhradsky (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1744?page=com.atlassian.jira.plu... ]
Andrej Podhradsky commented on TEIIDDES-1744:
---------------------------------------------
Or better solution, you can use Generic JDBC template instead of HSQLDB template.
> Cannot preview data from HSQL database
> ---------------------------------------
>
> Key: TEIIDDES-1744
> URL: https://issues.jboss.org/browse/TEIIDDES-1744
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.1
> Environment: JBDS 6.0.1.GA, Teiid designer 8.1.0.Final, hsqldb.jar version 2.2.9, java.version=1.6.0_45, OS=linux, ARCH=x86_64
> Reporter: Lucie Fabrikova
> Attachments: emp.script
>
>
> I cannot preview data from HSQL database; however, I can access them via SQL scrapbook.
> If I select Preview data, I get following exception:
> java.lang.Exception: JDBC Source for Driver class org.hsqldb.jdbcDriver was not found on server mm://localhost:9999::admin
> at org.teiid83.runtime.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:318)
> at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:555)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIIDDES-1744) Cannot preview data from HSQL database
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1744?page=com.atlassian.jira.plu... ]
Lucie Fabrikova commented on TEIIDDES-1744:
-------------------------------------------
As Andrej said, I updated the hsqldb.jar/META-INF/services/java.sql.Driver to "org.hsqldb.jdbcDriver" and it seems to solve my problem.
> Cannot preview data from HSQL database
> ---------------------------------------
>
> Key: TEIIDDES-1744
> URL: https://issues.jboss.org/browse/TEIIDDES-1744
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.1
> Environment: JBDS 6.0.1.GA, Teiid designer 8.1.0.Final, hsqldb.jar version 2.2.9, java.version=1.6.0_45, OS=linux, ARCH=x86_64
> Reporter: Lucie Fabrikova
> Attachments: emp.script
>
>
> I cannot preview data from HSQL database; however, I can access them via SQL scrapbook.
> If I select Preview data, I get following exception:
> java.lang.Exception: JDBC Source for Driver class org.hsqldb.jdbcDriver was not found on server mm://localhost:9999::admin
> at org.teiid83.runtime.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:318)
> at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:555)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months