8:53 a.m.
Adding Max, Rob and jbosstools-dev for their insights...
----- Original Message -----
From: "Thiago Araki" <taraki(a)redhat.com>
To: "Ted Jones" <tejones(a)redhat.com>
Cc: sme-dataservicesplatform(a)redhat.com
Sent: Thursday, March 13, 2014 8:21:11 AM
Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hello Ted,
I did not, but I tried now with this option and unfortunately the
same thing
happened.
I am stuck with this problem and my time is running out to deliver
this POC.
The reason I am using a Windows environment is because I need to integrate
data from an Excel data source, and the only way I found to do it is with
the Microsoft ODBC driver.
Regards,
Thiago
----- Original Message -----
From: "Ted Jones" <tejones(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Cc: sme-dataservicesplatform(a)redhat.com
Sent: Wednesday, March 12, 2014 6:42:17 PM
Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hi Thiago,
When creating your server connection in JBDS, did you check the
"Server is
externally managed. Assume server is started." radio button? I've attached a
screenshot.
> I know this was the way best way to go at one point, so I always do this now
> out of habit.
----- Original Message -----
> From: "Thiago Araki" <taraki(a)redhat.com>
> To: sme-dataservicesplatform(a)redhat.com
> Sent: Wednesday, March 12, 2014 4:27:34 PM
> Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> Hello all,
> I am having problems with JBoss Dev Studio (with Teiid Designer)
7.1 in a
> Windows environment (Windows XP SP3).
> When I start my Runtime Server via Dev Studio, the server
finishes the
> initialization (I can see it in the Console view and and access it via
> JBoss
> EAP web console) but the progress bar keeps the status "starting JBoss EAP
> 6
> Server..." and never finishes. Because of this situation, every operation
> that needs to sync with my server, for instance, Preview Data, gets queued
> and never executes.
> If I manually start JBoss EAP 6 outside Dev Studio, them try to
connect via
> Server View (acknowledging the server is already started), the problem is
> that the progress bar stays in "Performing pre-launch check..." status
> forever, and I also cannot interact with my server from my project.
> In both cases I am able to enter in "Teiid Instance"
configuration window
> and
> "Test Administration Connection" and "Test JDBC Connection" with
success.
> It seems to me that something is being incorrectly locked in the
plugin
> that
> integrates Dev Studio and JBoss EAP for this situation.
> I tried both Oracle JDK 1.6 and 1.7 with the same results. I
have already
> re-installed both JBoss EAP and Dev Studio (including version 7.0) and
> every
> time this behavior occurs.
> In my Linux machine this problem never happens.
> Can anybody help me?
> Thanks,
> Thiago Araki
8:54 a.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Here' a blog by Ramesh:
http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html
Maybe this is an option for you.
Van
----- Original Message -----
From: "Ted Jones" <tejones(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>, "Max Rydahl Andersen"
<max.andersen(a)redhat.com>, "Robert Stryker" <rstryker(a)redhat.com>,
"jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
Cc: sme-dataservicesplatform(a)redhat.com
Sent: Thursday, March 13, 2014 8:53:04 AM
Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Adding Max, Rob and jbosstools-dev for their insights...
----- Original Message -----
From: "Thiago Araki" <taraki(a)redhat.com>
To: "Ted Jones" <tejones(a)redhat.com>
Cc: sme-dataservicesplatform(a)redhat.com
Sent: Thursday, March 13, 2014 8:21:11 AM
Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hello Ted,
I did not, but I tried now with this option and unfortunately the
same thing
happened.
I am stuck with this problem and my time is running out to deliver
this POC.
The reason I am using a Windows environment is because I need to integrate
data from an Excel data source, and the only way I found to do it is with
the Microsoft ODBC driver.
Regards,
Thiago
----- Original Message -----
From: "Ted Jones" <tejones(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Cc: sme-dataservicesplatform(a)redhat.com
Sent: Wednesday, March 12, 2014 6:42:17 PM
Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hi Thiago,
When creating your server connection in JBDS, did you check the
"Server is
externally managed. Assume server is started." radio button? I've attached a
screenshot.
> I know this was the way best way to go at one point, so I always do this now
> out of habit.
----- Original Message -----
> From: "Thiago Araki" <taraki(a)redhat.com>
> To: sme-dataservicesplatform(a)redhat.com
> Sent: Wednesday, March 12, 2014 4:27:34 PM
> Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> Hello all,
> I am having problems with JBoss Dev Studio (with Teiid Designer)
7.1 in a
> Windows environment (Windows XP SP3).
> When I start my Runtime Server via Dev Studio, the server
finishes the
> initialization (I can see it in the Console view and and access it via
> JBoss
> EAP web console) but the progress bar keeps the status "starting JBoss EAP
> 6
> Server..." and never finishes. Because of this situation, every operation
> that needs to sync with my server, for instance, Preview Data, gets queued
> and never executes.
> If I manually start JBoss EAP 6 outside Dev Studio, them try to
connect via
> Server View (acknowledging the server is already started), the problem is
> that the progress bar stays in "Performing pre-launch check..." status
> forever, and I also cannot interact with my server from my project.
> In both cases I am able to enter in "Teiid Instance"
configuration window
> and
> "Test Administration Connection" and "Test JDBC Connection" with
success.
> It seems to me that something is being incorrectly locked in the
plugin
> that
> integrates Dev Studio and JBoss EAP for this situation.
> I tried both Oracle JDK 1.6 and 1.7 with the same results. I
have already
> re-installed both JBoss EAP and Dev Studio (including version 7.0) and
> every
> time this behavior occurs.
> In my Linux machine this problem never happens.
> Can anybody help me?
> Thanks,
> Thiago Araki
9:01 a.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Even that needs a ODBC DSN created for Excel on Windows platform, if you
already have VDB configured this will work. If you are trying to build
the VDB and preview while doing so then you will still see below issue.
Ramesh..
On Thu, 2014-03-13 at 09:54 -0400, Van Halbert wrote:
Here' a blog by Ramesh:
http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html
Maybe this is an option for you.
Van
----- Original Message -----
From: "Ted Jones" <tejones(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>, "Max Rydahl Andersen"
<max.andersen(a)redhat.com>, "Robert Stryker" <rstryker(a)redhat.com>,
"jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
Cc: sme-dataservicesplatform(a)redhat.com
Sent: Thursday, March 13, 2014 8:53:04 AM
Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Adding Max, Rob and jbosstools-dev for their insights...
----- Original Message -----
> From: "Thiago Araki" <taraki(a)redhat.com>
> To: "Ted Jones" <tejones(a)redhat.com>
> Cc: sme-dataservicesplatform(a)redhat.com
> Sent: Thursday, March 13, 2014 8:21:11 AM
> Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> Hello Ted,
> I did not, but I tried now with this option and unfortunately the same thing
> happened.
> I am stuck with this problem and my time is running out to deliver this POC.
> The reason I am using a Windows environment is because I need to integrate
> data from an Excel data source, and the only way I found to do it is with
> the Microsoft ODBC driver.
> Regards,
> Thiago
> ----- Original Message -----
> From: "Ted Jones" <tejones(a)redhat.com>
> To: "Thiago Araki" <taraki(a)redhat.com>
> Cc: sme-dataservicesplatform(a)redhat.com
> Sent: Wednesday, March 12, 2014 6:42:17 PM
> Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> Hi Thiago,
> When creating your server connection in JBDS, did you check the "Server is
> externally managed. Assume server is started." radio button? I've attached
a
> screenshot.
> I know this was the way best way to go at one point, so I always do this now
> out of habit.
> ----- Original Message -----
> > From: "Thiago Araki" <taraki(a)redhat.com>
>
> > To: sme-dataservicesplatform(a)redhat.com
>
> > Sent: Wednesday, March 12, 2014 4:27:34 PM
>
> > Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hello all,
>
> > I am having problems with JBoss Dev Studio (with Teiid Designer) 7.1 in a
> > Windows environment (Windows XP SP3).
>
> > When I start my Runtime Server via Dev Studio, the server finishes the
> > initialization (I can see it in the Console view and and access it via
> > JBoss
> > EAP web console) but the progress bar keeps the status "starting JBoss
EAP
> > 6
> > Server..." and never finishes. Because of this situation, every operation
> > that needs to sync with my server, for instance, Preview Data, gets queued
> > and never executes.
>
> > If I manually start JBoss EAP 6 outside Dev Studio, them try to connect via
> > Server View (acknowledging the server is already started), the problem is
> > that the progress bar stays in "Performing pre-launch check..."
status
> > forever, and I also cannot interact with my server from my project.
>
> > In both cases I am able to enter in "Teiid Instance" configuration
window
> > and
> > "Test Administration Connection" and "Test JDBC Connection"
with success.
>
> > It seems to me that something is being incorrectly locked in the plugin
> > that
> > integrates Dev Studio and JBoss EAP for this situation.
>
> > I tried both Oracle JDK 1.6 and 1.7 with the same results. I have already
> > re-installed both JBoss EAP and Dev Studio (including version 7.0) and
> > every
> > time this behavior occurs.
>
> > In my Linux machine this problem never happens.
>
> > Can anybody help me?
>
> > Thanks,
>
> > Thiago Araki
>
12:34 p.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
You might make sure the server configuration in the tools is configured to listen to the
management port...and make sure the configured port matches.
----- Original Message -----
Even that needs a ODBC DSN created for Excel on Windows platform, if
you
already have VDB configured this will work. If you are trying to build
the VDB and preview while doing so then you will still see below issue.
Ramesh..
On Thu, 2014-03-13 at 09:54 -0400, Van Halbert wrote:
> Here' a blog by Ramesh:
> http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html
>
> Maybe this is an option for you.
>
> Van
>
> ----- Original Message -----
> From: "Ted Jones" <tejones(a)redhat.com>
> To: "Thiago Araki" <taraki(a)redhat.com>, "Max Rydahl
Andersen"
> <max.andersen(a)redhat.com>, "Robert Stryker"
<rstryker(a)redhat.com>,
> "jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
> Cc: sme-dataservicesplatform(a)redhat.com
> Sent: Thursday, March 13, 2014 8:53:04 AM
> Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> Adding Max, Rob and jbosstools-dev for their insights...
>
> ----- Original Message -----
>
> > From: "Thiago Araki" <taraki(a)redhat.com>
> > To: "Ted Jones" <tejones(a)redhat.com>
> > Cc: sme-dataservicesplatform(a)redhat.com
> > Sent: Thursday, March 13, 2014 8:21:11 AM
> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hello Ted,
>
> > I did not, but I tried now with this option and unfortunately the same
> > thing
> > happened.
>
> > I am stuck with this problem and my time is running out to deliver this
> > POC.
> > The reason I am using a Windows environment is because I need to
> > integrate
> > data from an Excel data source, and the only way I found to do it is with
> > the Microsoft ODBC driver.
>
> > Regards,
>
> > Thiago
>
> > ----- Original Message -----
>
> > From: "Ted Jones" <tejones(a)redhat.com>
> > To: "Thiago Araki" <taraki(a)redhat.com>
> > Cc: sme-dataservicesplatform(a)redhat.com
> > Sent: Wednesday, March 12, 2014 6:42:17 PM
> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hi Thiago,
>
> > When creating your server connection in JBDS, did you check the "Server
> > is
> > externally managed. Assume server is started." radio button? I've
> > attached a
> > screenshot.
>
> > I know this was the way best way to go at one point, so I always do this
> > now
> > out of habit.
> > ----- Original Message -----
>
> > > From: "Thiago Araki" <taraki(a)redhat.com>
> >
> > > To: sme-dataservicesplatform(a)redhat.com
> >
> > > Sent: Wednesday, March 12, 2014 4:27:34 PM
> >
> > > Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> >
>
> > > Hello all,
> >
>
> > > I am having problems with JBoss Dev Studio (with Teiid Designer) 7.1 in
> > > a
> > > Windows environment (Windows XP SP3).
> >
>
> > > When I start my Runtime Server via Dev Studio, the server finishes the
> > > initialization (I can see it in the Console view and and access it via
> > > JBoss
> > > EAP web console) but the progress bar keeps the status "starting
JBoss
> > > EAP
> > > 6
> > > Server..." and never finishes. Because of this situation, every
> > > operation
> > > that needs to sync with my server, for instance, Preview Data, gets
> > > queued
> > > and never executes.
> >
>
> > > If I manually start JBoss EAP 6 outside Dev Studio, them try to connect
> > > via
> > > Server View (acknowledging the server is already started), the problem
> > > is
> > > that the progress bar stays in "Performing pre-launch check..."
status
> > > forever, and I also cannot interact with my server from my project.
> >
>
> > > In both cases I am able to enter in "Teiid Instance"
configuration
> > > window
> > > and
> > > "Test Administration Connection" and "Test JDBC
Connection" with
> > > success.
> >
>
> > > It seems to me that something is being incorrectly locked in the plugin
> > > that
> > > integrates Dev Studio and JBoss EAP for this situation.
> >
>
> > > I tried both Oracle JDK 1.6 and 1.7 with the same results. I have
> > > already
> > > re-installed both JBoss EAP and Dev Studio (including version 7.0) and
> > > every
> > > time this behavior occurs.
> >
>
> > > In my Linux machine this problem never happens.
> >
>
> > > Can anybody help me?
> >
>
> > > Thanks,
> >
>
> > > Thiago Araki
> >
>
_______________________________________________
jbosstools-dev mailing list
jbosstools-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jbosstools-dev
1:33 p.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hello all.
All ports match, and from Dev Studio I am able to enter in "Teiid Instance"
configuration window and "Test Administration Connection" and "Test JDBC
Connection" with success. I am using the same configurations which I am used to with
my linux instances, and they work fine all the time.
I tried Van Halbert approach (described in
http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html ), without
success:
1. Using the VDB below (copied from the blog), I got the following error: Caused by:
org.xml.sax.SAXParseException: cvc-complex-type.2.1: Element 'property' must have
no character or element information item [children], because the type's content type
is empty.
<vdb name= "odbc" version= "1" >
<property name= "UseConnectorMetadata" value= "true" >
<model name= "excel" >
<source connection-jndi-name= "java:/odbcDS" name= "connector"
translator-name= "jdbc-simple" >
</model>
</property></vdb>
2. I changed the VDB to the format shown below, and I got the following error: VDB odbc.1
model "excel" metadata failed to load. Reason:TEIID11010 java.sql.SqlException:
[Microsoft][ODBC Driver Manager] The driver does not offer support for this function.
<vdb name= "odbc" version= "1" >
<property name= "UseConnectorMetadata" value= "true"/ >
<model name= "excel" >
<source connection-jndi-name= "java:/odbcDS" name= "connector"
translator-name= "jdbc-simple"/ >
</model>
</vdb>
I was able to query my Excel data directly using SquirreL SQL client and Microsoft ODBC
driver.
In both cases depicted above, I was not able to access OData via browser
(http://localhost:8080/odata/odbc/excel.Sheet1). After input my credentials I got another
error: HTTP Status 403: Access to the requested resource has been denied .
I attached my excel file. It is very simple (2 columns), and once I get this working I
will have to use the one provided by the customer .
Regards,
Thiago Araki
----- Original Message -----
From: "Rob Cernich" <rcernich(a)redhat.com>
To: "Ramesh Reddy" <rareddy(a)redhat.com>
Cc: "Robert Stryker" <rstryker(a)redhat.com>, "Max Rydahl
Andersen" <max.andersen(a)redhat.com>, sme-dataservicesplatform(a)redhat.com,
"jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
Sent: Thursday, March 13, 2014 2:34:01 PM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
You might make sure the server configuration in the tools is configured to listen to the
management port...and make sure the configured port matches.
----- Original Message -----
Even that needs a ODBC DSN created for Excel on Windows platform, if
you
already have VDB configured this will work. If you are trying to build
the VDB and preview while doing so then you will still see below issue.
Ramesh..
On Thu, 2014-03-13 at 09:54 -0400, Van Halbert wrote:
> Here' a blog by Ramesh:
> http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html
>
> Maybe this is an option for you.
>
> Van
>
> ----- Original Message -----
> From: "Ted Jones" <tejones(a)redhat.com>
> To: "Thiago Araki" <taraki(a)redhat.com>, "Max Rydahl
Andersen"
> <max.andersen(a)redhat.com>, "Robert Stryker"
<rstryker(a)redhat.com>,
> "jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
> Cc: sme-dataservicesplatform(a)redhat.com
> Sent: Thursday, March 13, 2014 8:53:04 AM
> Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> Adding Max, Rob and jbosstools-dev for their insights...
>
> ----- Original Message -----
>
> > From: "Thiago Araki" <taraki(a)redhat.com>
> > To: "Ted Jones" <tejones(a)redhat.com>
> > Cc: sme-dataservicesplatform(a)redhat.com
> > Sent: Thursday, March 13, 2014 8:21:11 AM
> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hello Ted,
>
> > I did not, but I tried now with this option and unfortunately the same
> > thing
> > happened.
>
> > I am stuck with this problem and my time is running out to deliver this
> > POC.
> > The reason I am using a Windows environment is because I need to
> > integrate
> > data from an Excel data source, and the only way I found to do it is with
> > the Microsoft ODBC driver.
>
> > Regards,
>
> > Thiago
>
> > ----- Original Message -----
>
> > From: "Ted Jones" <tejones(a)redhat.com>
> > To: "Thiago Araki" <taraki(a)redhat.com>
> > Cc: sme-dataservicesplatform(a)redhat.com
> > Sent: Wednesday, March 12, 2014 6:42:17 PM
> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hi Thiago,
>
> > When creating your server connection in JBDS, did you check the "Server
> > is
> > externally managed. Assume server is started." radio button? I've
> > attached a
> > screenshot.
>
> > I know this was the way best way to go at one point, so I always do this
> > now
> > out of habit.
> > ----- Original Message -----
>
> > > From: "Thiago Araki" <taraki(a)redhat.com>
> >
> > > To: sme-dataservicesplatform(a)redhat.com
> >
> > > Sent: Wednesday, March 12, 2014 4:27:34 PM
> >
> > > Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> >
>
> > > Hello all,
> >
>
> > > I am having problems with JBoss Dev Studio (with Teiid Designer) 7.1 in
> > > a
> > > Windows environment (Windows XP SP3).
> >
>
> > > When I start my Runtime Server via Dev Studio, the server finishes the
> > > initialization (I can see it in the Console view and and access it via
> > > JBoss
> > > EAP web console) but the progress bar keeps the status "starting
JBoss
> > > EAP
> > > 6
> > > Server..." and never finishes. Because of this situation, every
> > > operation
> > > that needs to sync with my server, for instance, Preview Data, gets
> > > queued
> > > and never executes.
> >
>
> > > If I manually start JBoss EAP 6 outside Dev Studio, them try to connect
> > > via
> > > Server View (acknowledging the server is already started), the problem
> > > is
> > > that the progress bar stays in "Performing pre-launch check..."
status
> > > forever, and I also cannot interact with my server from my project.
> >
>
> > > In both cases I am able to enter in "Teiid Instance"
configuration
> > > window
> > > and
> > > "Test Administration Connection" and "Test JDBC
Connection" with
> > > success.
> >
>
> > > It seems to me that something is being incorrectly locked in the plugin
> > > that
> > > integrates Dev Studio and JBoss EAP for this situation.
> >
>
> > > I tried both Oracle JDK 1.6 and 1.7 with the same results. I have
> > > already
> > > re-installed both JBoss EAP and Dev Studio (including version 7.0) and
> > > every
> > > time this behavior occurs.
> >
>
> > > In my Linux machine this problem never happens.
> >
>
> > > Can anybody help me?
> >
>
> > > Thanks,
> >
>
> > > Thiago Araki
> >
>
_______________________________________________
jbosstools-dev mailing list
jbosstools-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jbosstools-dev
1:43 p.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
I think that vdb xml is in error. close the property tag like this
<vdb name="odbc" version="1">
<property name="UseConnectorMetadata" value="true" />
<model name="excel">
<source connection-jndi-name="java:/odbcDS"
name="connector" translator-name="jdbc-simple">
</model>
</vdb>
----- Original Message -----
From: "Thiago Araki" <taraki(a)redhat.com>
To: "Rob Cernich" <rcernich(a)redhat.com>
Cc: "Max Rydahl Andersen" <max.andersen(a)redhat.com>,
sme-dataservicesplatform(a)redhat.com, "jbosstools-dev"
<jbosstools-dev(a)lists.jboss.org>, "Robert Stryker"
<rstryker(a)redhat.com>
Sent: Thursday, March 13, 2014 1:33:57 PM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hello all.
All ports match, and from Dev Studio I am able to enter in "Teiid Instance"
configuration window and "Test Administration Connection" and "Test JDBC
Connection" with success. I am using the same configurations which I am used to with
my linux instances, and they work fine all the time.
I tried Van Halbert approach (described in
http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html ), without
success:
1. Using the VDB below (copied from the blog), I got the following error: Caused by:
org.xml.sax.SAXParseException: cvc-complex-type.2.1: Element 'property' must have
no character or element information item [children], because the type's content type
is empty.
<vdb name= "odbc" version= "1" >
<property name= "UseConnectorMetadata" value= "true" >
<model name= "excel" >
<source connection-jndi-name= "java:/odbcDS" name= "connector"
translator-name= "jdbc-simple" >
</model>
</property></vdb>
2. I changed the VDB to the format shown below, and I got the following error: VDB odbc.1
model "excel" metadata failed to load. Reason:TEIID11010 java.sql.SqlException:
[Microsoft][ODBC Driver Manager] The driver does not offer support for this function.
<vdb name= "odbc" version= "1" >
<property name= "UseConnectorMetadata" value= "true"/ >
<model name= "excel" >
<source connection-jndi-name= "java:/odbcDS" name= "connector"
translator-name= "jdbc-simple"/ >
</model>
</vdb>
I was able to query my Excel data directly using SquirreL SQL client and Microsoft ODBC
driver.
In both cases depicted above, I was not able to access OData via browser
(http://localhost:8080/odata/odbc/excel.Sheet1). After input my credentials I got another
error: HTTP Status 403: Access to the requested resource has been denied .
I attached my excel file. It is very simple (2 columns), and once I get this working I
will have to use the one provided by the customer .
Regards,
Thiago Araki
----- Original Message -----
From: "Rob Cernich" <rcernich(a)redhat.com>
To: "Ramesh Reddy" <rareddy(a)redhat.com>
Cc: "Robert Stryker" <rstryker(a)redhat.com>, "Max Rydahl
Andersen" <max.andersen(a)redhat.com>, sme-dataservicesplatform(a)redhat.com,
"jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
Sent: Thursday, March 13, 2014 2:34:01 PM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
You might make sure the server configuration in the tools is configured to listen to the
management port...and make sure the configured port matches.
----- Original Message -----
Even that needs a ODBC DSN created for Excel on Windows platform, if
you
already have VDB configured this will work. If you are trying to build
the VDB and preview while doing so then you will still see below issue.
Ramesh..
On Thu, 2014-03-13 at 09:54 -0400, Van Halbert wrote:
> Here' a blog by Ramesh:
> http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html
>
> Maybe this is an option for you.
>
> Van
>
> ----- Original Message -----
> From: "Ted Jones" <tejones(a)redhat.com>
> To: "Thiago Araki" <taraki(a)redhat.com>, "Max Rydahl
Andersen"
> <max.andersen(a)redhat.com>, "Robert Stryker"
<rstryker(a)redhat.com>,
> "jbosstools-dev" <jbosstools-dev(a)lists.jboss.org>
> Cc: sme-dataservicesplatform(a)redhat.com
> Sent: Thursday, March 13, 2014 8:53:04 AM
> Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> Adding Max, Rob and jbosstools-dev for their insights...
>
> ----- Original Message -----
>
> > From: "Thiago Araki" <taraki(a)redhat.com>
> > To: "Ted Jones" <tejones(a)redhat.com>
> > Cc: sme-dataservicesplatform(a)redhat.com
> > Sent: Thursday, March 13, 2014 8:21:11 AM
> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hello Ted,
>
> > I did not, but I tried now with this option and unfortunately the same
> > thing
> > happened.
>
> > I am stuck with this problem and my time is running out to deliver this
> > POC.
> > The reason I am using a Windows environment is because I need to
> > integrate
> > data from an Excel data source, and the only way I found to do it is with
> > the Microsoft ODBC driver.
>
> > Regards,
>
> > Thiago
>
> > ----- Original Message -----
>
> > From: "Ted Jones" <tejones(a)redhat.com>
> > To: "Thiago Araki" <taraki(a)redhat.com>
> > Cc: sme-dataservicesplatform(a)redhat.com
> > Sent: Wednesday, March 12, 2014 6:42:17 PM
> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
>
> > Hi Thiago,
>
> > When creating your server connection in JBDS, did you check the "Server
> > is
> > externally managed. Assume server is started." radio button? I've
> > attached a
> > screenshot.
>
> > I know this was the way best way to go at one point, so I always do this
> > now
> > out of habit.
> > ----- Original Message -----
>
> > > From: "Thiago Araki" <taraki(a)redhat.com>
> >
> > > To: sme-dataservicesplatform(a)redhat.com
> >
> > > Sent: Wednesday, March 12, 2014 4:27:34 PM
> >
> > > Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
> >
>
> > > Hello all,
> >
>
> > > I am having problems with JBoss Dev Studio (with Teiid Designer) 7.1 in
> > > a
> > > Windows environment (Windows XP SP3).
> >
>
> > > When I start my Runtime Server via Dev Studio, the server finishes the
> > > initialization (I can see it in the Console view and and access it via
> > > JBoss
> > > EAP web console) but the progress bar keeps the status "starting
JBoss
> > > EAP
> > > 6
> > > Server..." and never finishes. Because of this situation, every
> > > operation
> > > that needs to sync with my server, for instance, Preview Data, gets
> > > queued
> > > and never executes.
> >
>
> > > If I manually start JBoss EAP 6 outside Dev Studio, them try to connect
> > > via
> > > Server View (acknowledging the server is already started), the problem
> > > is
> > > that the progress bar stays in "Performing pre-launch check..."
status
> > > forever, and I also cannot interact with my server from my project.
> >
>
> > > In both cases I am able to enter in "Teiid Instance"
configuration
> > > window
> > > and
> > > "Test Administration Connection" and "Test JDBC
Connection" with
> > > success.
> >
>
> > > It seems to me that something is being incorrectly locked in the plugin
> > > that
> > > integrates Dev Studio and JBoss EAP for this situation.
> >
>
> > > I tried both Oracle JDK 1.6 and 1.7 with the same results. I have
> > > already
> > > re-installed both JBoss EAP and Dev Studio (including version 7.0) and
> > > every
> > > time this behavior occurs.
> >
>
> > > In my Linux machine this problem never happens.
> >
>
> > > Can anybody help me?
> >
>
> > > Thanks,
> >
>
> > > Thiago Araki
> >
>
_______________________________________________
jbosstools-dev mailing list
jbosstools-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jbosstools-dev
3940
days inactive
3940
days old
jbosstools-dev@lists.jboss.org
5 comments
6 participants
participants (6)
-
Mark Drilling -
Ramesh Reddy -
Rob Cernich -
Ted Jones -
Thiago Araki -
Van Halbert