[
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