7.1 Alpha1 posted
by Steven Hawkins
Hello all,
7.1 Alpha1 is available. There are already quite a few features in there too -- http://teiid.blogspot.com/2010/07/71-pre-release.html
A couple of things to highlight, the Teiid rar files no longer have version numbers so that -ds.xml don't have to change between releases. Also you can get query plan information from any client tool with the show statement:
set showplan on
select ... from ...
show plan
The show plan statement will return a result set containing the plan text/xml/debug log.
See the release notes and updated docs in the kit for all the details.
Steve
14 years
additional URL parms
by Charles Simon
I am trying to use the additional properties. The "key=value" pairs
after the semi-colon in the URL or set as
TeiidDataSource.setAdditionalProperties(...).
I cannot figure out where/how these additional properties get passed to
my translator. When are they available so I can capture them for use in
my ResultSetExecution object? I thought they would get passed into my
subclasses for ExecutionFactory or BasicConnetionFactory. Or possibly
they need to parameters of my BasicConnction subclass?
What am I missing?
--
Charles Simon
Principal Software Engineer
Select Business Solutions, Inc.
35 Nutmeg Drive
Trumbull, CT 06611
http://www.selectbs.com
mailto:charles.simon@selectbs.com
14 years
Dyn VDB always INACTIVE
by Charles Simon
I am having trouble getting past the VDBDeployer.validateServices() tests.
If I add the <vdb> property "preview" as true it skips the
validateSources test but I don't know if that is the correct thing to do.
My VDB XML file looks like this (line numbers on the left are not int
the file):
1) <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
2) <vdb name="UQDynamicFilms" version="1">
3) <property name="UseConnectorMetadata" value="true" />
4) <property name="preview" value="true" />
5)
6) <model name="Films">
7) <property name="importer.useFullSchemaName" value="false"/>
8) <property name="uqDBName" value="FILMS"></property>
9) <source name="Films" translator-name="uquest"/>
10) </model>
11) </vdb>
When I remove line 4 the VDB fails the validateSources() test and is set
inactive.
--
Charles Simon
Principal Software Engineer
Select Business Solutions, Inc.
35 Nutmeg Drive
Trumbull, CT 06611
http://www.selectbs.com
mailto:charles.simon@selectbs.com
14 years
Translator not found
by Charles Simon
I am using the 7.0 final release and having problems getting to use my
translator. I believe I have followed the directions in the developer's
guide and it appears to have been deployed into JBoss but not quite the
same way as the packaged translators. It does get activated by JBoss
(not Teiid) and my ExecutionFactory sub-class is loaded and an object
created but it is not started by the Dynamic VDB which gets an error
about not being able to find the parent translator.
There is probably something rather small that I am doing wrong but I
can't figure it out. Let me know if you need the jboss-beans.xml file or
the vdb file.
I get the following in the JBoss log: (P.S., The RUNTIME log lines with
"UQ exec" are coming from my ExecutionFactory sub-class.)
===========================================================
2010-07-06 15:46:03,212 INFO
[org.jboss.ejb3.session.SessionSpecContainer] (main) Starting
jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
2010-07-06 15:46:03,212 INFO [org.jboss.ejb3.EJBContainer] (main)
STARTED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean
ejbName: SecureProfileService
2010-07-06 15:46:03,243 INFO
[org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase]
(main) Binding the following Entries in Global JNDI:
SecureProfileService/remote - EJB3.x Default Remote Business Interface
SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService
- EJB3.x Remote Business Interface
2010-07-06 15:46:03,962 INFO [org.teiid.RUNTIME] (main) Teiid
translator "file" has been added.
2010-07-06 15:46:05,384 INFO [org.teiid.RUNTIME] (main) Teiid
translator "jdbc-simple" has been added.
2010-07-06 15:46:05,399 INFO [org.teiid.RUNTIME] (main) Teiid
translator "informix" has been added.
2010-07-06 15:46:05,399 INFO [org.teiid.RUNTIME] (main) Teiid
translator "db2" has been added.
2010-07-06 15:46:05,399 INFO [org.teiid.RUNTIME] (main) Teiid
translator "access" has been added.
2010-07-06 15:46:05,415 INFO [org.teiid.RUNTIME] (main) Teiid
translator "postgresql" has been added.
2010-07-06 15:46:05,415 INFO [org.teiid.RUNTIME] (main) Teiid
translator "mysql5" has been added.
2010-07-06 15:46:05,446 INFO [org.teiid.RUNTIME] (main) Teiid
translator "jdbc-ansi" has been added.
2010-07-06 15:46:05,462 INFO [org.teiid.RUNTIME] (main) Teiid
translator "mysql" has been added.
2010-07-06 15:46:05,462 INFO [org.teiid.RUNTIME] (main) Teiid
translator "derby" has been added.
2010-07-06 15:46:05,462 INFO [org.teiid.RUNTIME] (main) Teiid
translator "modeshape" has been added.
2010-07-06 15:46:05,477 INFO [org.teiid.RUNTIME] (main) Teiid
translator "sybase" has been added.
2010-07-06 15:46:05,477 INFO [org.teiid.RUNTIME] (main) Teiid
translator "h2" has been added.
2010-07-06 15:46:05,477 INFO [org.teiid.RUNTIME] (main) Teiid
translator "sqlserver" has been added.
2010-07-06 15:46:05,493 INFO [org.teiid.RUNTIME] (main) Teiid
translator "teiid" has been added.
2010-07-06 15:46:05,493 INFO [org.teiid.RUNTIME] (main) Teiid
translator "teradata" has been added.
2010-07-06 15:46:05,493 INFO [org.teiid.RUNTIME] (main) Teiid
translator "hsql" has been added.
2010-07-06 15:46:05,493 INFO [org.teiid.RUNTIME] (main) Teiid
translator "metamatrix" has been added.
2010-07-06 15:46:05,509 INFO [org.teiid.RUNTIME] (main) Teiid
translator "oracle" has been added.
2010-07-06 15:46:05,556 INFO [org.teiid.RUNTIME] (main) Teiid
translator "ldap" has been added.
2010-07-06 15:46:07,180 INFO [org.teiid.RUNTIME] (main) Teiid
translator "loopback" has been added.
2010-07-06 15:46:07,243 INFO [org.teiid.RUNTIME] (main) Teiid
translator "salesforce" has been added.
2010-07-06 15:46:07,321 INFO [org.jboss.ejb3.deployers.JBossASKernel]
(main) installing bean:
jboss.j2ee:jar=translator-uquest.jar,name=translator-uquest,service=EJB3
2010-07-06 15:46:07,321 INFO [org.jboss.ejb3.deployers.JBossASKernel]
(main) with dependencies:
2010-07-06 15:46:07,321 INFO [org.jboss.ejb3.deployers.JBossASKernel]
(main) and demands:
2010-07-06 15:46:07,321 INFO [org.jboss.ejb3.deployers.JBossASKernel]
(main) and supplies:
2010-07-06 15:46:07,321 INFO [org.jboss.ejb3.deployers.JBossASKernel]
(main) Added
bean(jboss.j2ee:jar=translator-uquest.jar,name=translator-uquest,service=EJB3)
to KernelDeployment of: translator-uquest.jar
2010-07-06 15:46:07,368 INFO [RUNTIME] (main) UQ exec factory loaded.
2010-07-06 15:46:07,368 INFO [RUNTIME] (main) UQ exec factory obj created.
2010-07-06 15:46:07,415 INFO
[org.jboss.ejb3.clientmodule.ClientENCInjectionContainer] (main) STARTED
CLIENT ENC CONTAINER: translator-uquest
2010-07-06 15:46:07,477 INFO [org.teiid.RUNTIME] (main) Teiid
translator "ws" has been added.
2010-07-06 15:46:07,634 INFO
[org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy,
ctxPath=/admin-console
2010-07-06 15:46:07,805 INFO
[javax.enterprise.resource.webcontainer.jsf.config] (main) Initializing
Mojarra (1.2_12-b01-FCS) for context '/admin-console'
2010-07-06 15:46:14,868 INFO
[org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy,
ctxPath=/
2010-07-06 15:46:15,040 INFO
[org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy,
ctxPath=/jmx-console
2010-07-06 15:46:15,165 ERROR
[org.jboss.kernel.plugins.dependency.AbstractKernelController] (main)
Error installing to Real:
name=vfsfile:/C:/jboss-5.1.0.GA/server/default/deploy/uq-films-vdb.xml
state=PreReal mode=Manual requiredState=Real
org.jboss.deployers.spi.DeploymentException: The parent translator
defined not found in configuration
"vfsfile:/C:/jboss-5.1.0.GA/server/default/deploy/uq-films-vdb.xml"
at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:100)
at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:59)
at
org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at
org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at
org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at
org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at
org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at
org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at
org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at
org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at
org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at
org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at
org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
...
===========================================================
--
Charles Simon
Principal Software Engineer
Select Business Solutions, Inc.
35 Nutmeg Drive
Trumbull, CT 06611
http://www.selectbs.com
mailto:charles.simon@selectbs.com
14 years
New changes for the eclipse cdk plugin
by Sanjay Chaudhuri
I have uploaded fresh changes for the cdk plugin. The plugin now supports an
editor for the config-properties section of ra.xml. Changes made either on
config-properties editor or the raw xml view tab will be synchronized.
The ManagedConnectionFactory.java doesn't yet get updated. I shall be
working on that next.
Thanks
Sanjay
14 years
