[JBoss JIRA] (TEIIDDES-1744) Cannot preview data from HSQL database
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1744?page=com.atlassian.jira.plu... ]
Paul Richardson commented on TEIIDDES-1744:
-------------------------------------------
The eclipse hsqldb profile template is only version 1.8 but it is possible to hack the template or add another one by editing the following file:
{code}
${YOUR_ECLIPSE_WORKSPACE}/.metadata/.plugins/org.eclipse.datatools.connectivity/driverStorage.xml
{code}
Either edit the 1.8 hsqldb entry in this file or it is possible to insert something like the following into the file and therefore create an additional hsqldb profile. Bear in mind this is a hack and still uses the 1.8 template descriptor due to it being necessary for validating the properties (template descriptor is defined by extension point).
{code}
<propertySet
iD="DriverDefn.org.eclipse.datatools.enablement.hsqldb.2_2_9.driver.HSQLDB JDBC Driver"
keys="org.eclipse.datatools.connectivity.db.version org.eclipse.datatools.connectivity.db.vendor org.eclipse.datatools.connectivity.db.driverClass org.eclipse.datatools.connectivity.db.username jarList org.eclipse.datatools.connectivity.drivers.defnType org.eclipse.datatools.connectivity.db.URL org.eclipse.datatools.connectivity.db.databaseName "
name="HSQLDB JDBC Driver"
prop_org.eclipse.datatools.connectivity.db.URL="jdbc:hsqldb:MyDB"
prop_org.eclipse.datatools.connectivity.db.databaseName="SAMPLE"
prop_org.eclipse.datatools.connectivity.db.driverClass="org.hsqldb.jdbc.JDBCDriver"
prop_org.eclipse.datatools.connectivity.db.username="sa"
prop_org.eclipse.datatools.connectivity.db.vendor="HSQLDB"
prop_org.eclipse.datatools.connectivity.db.version="2.2.9"
prop_org.eclipse.datatools.connectivity.drivers.defnType="org.eclipse.datatools.enablement.hsqldb.1_8.driver" />
{code}
Either way the modified driverClass should be used instead.
> 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
10 years, 11 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:
---------------------------------------------
So, from the discussion on #teiiddesigner we know that the problem is in eclipse hsqldb profile template. The template set a driver as org.hsqldb.jdbcDriver but the jar lib for hsqldb 2.2.9 defines the driver as org.hsqldb.jdbc.JDBCDriver, that why the teiid is complaining about "JDBC Source for Driver class org.hsqldb.jdbcDriver was not found".
> 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
10 years, 11 months
[JBoss JIRA] (TEIIDDES-1744) Cannot preview data from HSQL database
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1744?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1744:
----------------------------------------
This is not a bug, you set your port wrong to 9999. This should have been 31000 by default. Also, only create a JIRA when you know for sure it is a bug. when in question, ask in the forums first then follow with JIRA
> 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
10 years, 11 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 updated TEIIDDES-1744:
--------------------------------------
Steps to Reproduce:
0. run JBoss AS 7.1 with Teiid 8.3
1. create HSQLDB profile:
database: emp, database location: <path-to-attached-emp.script>, user name: admin, password: admin
2. create source model for JDBC data source:
- connection profile: previously created HSQLDB profile
- import tables customer, order
3. Preview data from any table (e.g. customer).
was:
1. create HSQLDB profile:
database: emp, database location: <path-to-attached-emp.script>, user name: admin, password: admin
2. create source model for JDBC data source:
- connection profile: previously created HSQLDB profile
- import tables customer, order
3. Preview data from any table (e.g. customer).
> 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
10 years, 11 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 updated TEIIDDES-1744:
--------------------------------------
Attachment: emp.script
> 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
10 years, 11 months
[JBoss JIRA] (TEIIDDES-1744) Cannot preview data from HSQL database
by Lucie Fabrikova (JIRA)
Lucie Fabrikova created TEIIDDES-1744:
-----------------------------------------
Summary: 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
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
10 years, 11 months