datavirtualizationbyexample/dvworkshop

dvworkshop's Issues

Documentation issue for workshop on Docker

Section 4.4, page 61 should somehow reference where to get the JDBC driver and where to place in, when using Docker.

Error Creating WS

Hi There,

When try to create web service, I encountered lots of error, please see the attached log file taken from studio. How to resolve this? Thank you in advance.
Error.txt

Error In Preview Data Model

Hi,

I follow the steps and managed to import the metadata into the model but when I tried to preview the data model (step 7.6), there is an error connecting to the database as per the following, what could be wrong?

Thank you in advance.

Error from Studio:

java.sql.SQLException: Cannot perform operations on a closed connection.
at org.teiid.jdbc.ConnectionImpl.checkConnection(ConnectionImpl.java:787)
at org.teiid.jdbc.StatementImpl.checkStatement(StatementImpl.java:351)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:461)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:455)
at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:389)
at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.getExecutionPlan(TeiidAdHocScriptRunnable.java:374)
at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.handleShowExecutionPlan(TeiidAdHocScriptRunnable.java:291)
at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.access$0(TeiidAdHocScriptRunnable.java:290)
at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable$UpdatePlanViewRunnable.run(TeiidAdHocScriptRunnable.java:332)
at org.eclipse.ui.internal.UILockListener.doPendingWork(UILockListener.java:162)
at org.eclipse.ui.internal.UISynchronizer$3.run(UISynchronizer.java:154)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4024)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3700)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)
at org.eclipse.equinox.launcher.Main.run(Main.java:1515)

Error at the EAP Logs:

16:16:40,500 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker1_QueryProcessorQueue1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:351)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:299)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:413)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:457)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:429)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:344)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:367)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:69)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:270) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:68) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:328)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_71]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_71]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_71]
at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_71]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy81.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_71]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71]
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:441)
at org.h2.store.FileLock.lockFile(FileLock.java:337)
at org.h2.store.FileLock.lock(FileLock.java:129)
at org.h2.engine.Database.open(Database.java:542)
at org.h2.engine.Database.openDatabase(Database.java:222)
at org.h2.engine.Database.(Database.java:217)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:159)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:323)
... 31 more

Docker-Image missing datasources

Hi,

to be able to fully follow the workshop with the provided docker image, the datasources for EU_Customers and US_Customers should be predefined in EAP.
Alternatively the instructions should be extended to cover this - or point to an external explanation.

Patrick

DV installer file slightly different to workshop example

As per RHTE workshop chat messages, I have a GA installation file for DV downloaded from RH, it has the name
jboss-dv-installer-6.0.0.GA-redhat.jar
rather than
jboss-dv-installer-6.0.0.GA-redhat-4.jar
Cheers, Simon.

Possible error in lab

This seems to be the problem:

• For US_Customers the ACCOUNT tables look like this:

CREATE TABLE account (
  AccountID decimal(18,0) NOT NULL,
  SSN varchar(12) NOT NULL,
  AccountType char(10) DEFAULT NULL,
  AccountStatus char(10) DEFAULT NULL,
  DATEOPENED timestamp NOT NULL,
  DATECLOSED timestamp DEFAULT NULL,
  PRIMARY KEY (AccountID)
);

• For EU_Customers the ACCOUNT table is:

CREATE TABLE account (
  AccountId decimal(18,0) NOT NULL,
  CustomerID varchar(12) NOT NULL,
  AccountType char(10) DEFAULT NULL,
  AccountStatus char(10) DEFAULT NULL,
  DATEOPENED timestamp NOT NULL,
  DATECLOSED timestamp DEFAULT NULL,
  PRIMARY KEY (AccountId)
);

• Difference is the missing SSN in the EU_Customers.
• The instructions one page 108 and previous states to create the DDC model for US_Customers based on the one created for the EU_Customers. This causes the reconsiliation to raise an error, which is nowhere documented - being that the source SSN needs to be ignored in the target.

XSD files contains absolute paths for Schema location

All_Customers_input.xsd and All_Customers_Output.xsd contain absolute paths. Causes errors when importing and taking defaults for the project. This is a low priority but wanted to put some notes in.

Benefits of Virtual Base Layer

I want to understand a little more detailed about what kind of benefits VBL has.
It seems to be redundant for me. Even though I have VBL as an abstraction layer, I have to modify it anyway if the physical model's layout is changed.
It would be great if you can explain it with any simple use case scenarios.
Best regards,
Ken

warning re. Docker on OSX using brew

This is a general note for OSX users who are setting up Docker for the first time.

I just wasted an hour or so trying to get Docker running on OSX using the homebrew and cask installation (ignore this if you don't know what brew is).

On OSX, Docker relies on a compatibility layer called "Boot2Docker" that runs in VirtualBox. It all seemed to install ok using brew, but I couldn't get the docker client command talking to the background docker daemon in VirtualBox, so I gave up.

tl;dr: follow the instructions here: http://docs.docker.com/installation/mac

Worked perfectly, 2 minute install after download. You only need to download the docker and boot2docker installers from here: https://github.com/boot2docker/osx-installer/releases
The boot2docker installer also installs VirtualBox.

Don't forget to set the environment variable for DOCKER_HOST after starting boot2docker, as per console output when you run it. You'll need to do that in each shell window where you run a docker command. Or set it in a startup script.

Update: I also needed to increase the default memory boot2docker allocates from 1GB to 2GB (got java heap allocation errors using docker build step). You can do this by running "boot2docker -m 2048 start", or create/update the ~/.boot2docker config file as per online help.