9:13 a.m.
Hello Van,
With your suggestion I was finally able to connect to my runtime server from Dev Studio.
Continuing with my POC for Petrobras, I was able to crate a JDBC-ODBC connection to my
excel file, and even query data from sql-scrapbook (see screenshot below):
But in the next step, which is "Create source model for JDBC data source", I am
not able to complete, since there is no table available to be selected (see screenshot
sequence below).
In the error log that there is the following warning:
Unexpected exception while calling sun.jdbc.odbc.JdbcOdbcDatabaseMetadata.getProcedures()
and processing results on DatabaseNew Generic JDBC
java.sql.SQLException [Microsoft][ODBC Driver Manager] The Driver does not offer support
for this function.
I do not have any preference in the approach to integrate the Excel data source (via Dev
Studio or creating the vdb.xml file and mannually deploying it). But in both approaches I
am facing much more difficulties than with other data sources (web services, flat files
and databases).
Thanks,
Thiago
----- Original Message -----
From: "Van Halbert" <vhalbert(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Sent: Thursday, March 13, 2014 9:56:26 PM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
If you're still looking at options, can you try this:
- at command line, run: hostname (to see what its using)
- when you start DV server (standalone.bat), pass it -b hostname
- in JBDS when configuring server, use hostname
Van
----- Original Message -----
From: "Thiago Araki" <taraki(a)redhat.com>
To: "Rob Cernich" <rcernich(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>, "Ramesh
Reddy" <rareddy(a)redhat.com>, "Van Halbert"
<vhalbert(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
9:32 a.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
in the "Select database Metadata" dialog, uncheck the "procedures"
Ramesh..
On Fri, 2014-03-14 at 09:13 -0400, Thiago Araki wrote:
Hello Van,
With your suggestion I was finally able to connect to my runtime
server from Dev Studio.
Continuing with my POC for Petrobras, I was able to crate a JDBC-ODBC
connection to my excel file, and even query data from sql-scrapbook
(see screenshot below):
But in the next step, which is "Create source model for JDBC data
source", I am not able to complete, since there is no table available
to be selected (see screenshot sequence below).
In the error log that there is the following warning:
Unexpected exception while calling
sun.jdbc.odbc.JdbcOdbcDatabaseMetadata.getProcedures() and processing
results on DatabaseNew Generic JDBC
java.sql.SQLException [Microsoft][ODBC Driver Manager] The Driver does
not offer support for this function.
I do not have any preference in the approach to integrate the Excel
data source (via Dev Studio or creating the vdb.xml file and mannually
deploying it). But in both approaches I am facing much more
difficulties than with other data sources (web services, flat files
and databases).
Thanks,
Thiago
______________________________________________________________________
From: "Van Halbert" <vhalbert(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Sent: Thursday, March 13, 2014 9:56:26 PM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in
Windows XP SP3
If you're still looking at options, can you try this:
- at command line, run: hostname (to see what its using)
- when you start DV server (standalone.bat), pass it -b hostname
- in JBDS when configuring server, use hostname
Van
----- Original Message -----
From: "Thiago Araki" <taraki(a)redhat.com>
To: "Rob Cernich" <rcernich(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>, "Ramesh
Reddy"
<rareddy(a)redhat.com>, "Van Halbert" <vhalbert(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
>
10:38 a.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Hello Ramesh,
Unchecking "procedures" resolved the exception that were raised, but the
behavior is still the same: there is no table to be selected, and I cannot continue with
the "Create source model for JDBC data source" wizard.
I had to restart my windows virtual machine, and when I tried to connect again to my
runtime server from Dev Studio (even though I configured the hostname as suggested by Van
Halbert), I am facing the same problems I had before: Dev Studio keeps forever on
"Performing pre-lauch check" while starting the runtime. I deleted the server
from Dev Studio and created it again, but it did not solve the problem. Restarting the
server also did not take effect.
Regards,
Thiago
----- Original Message -----
From: "Ramesh Reddy" <rareddy(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Cc: "Van Halbert" <vhalbert(a)redhat.com>, "jbosstools-dev"
<jbosstools-dev(a)lists.jboss.org>, sme-dataservicesplatform(a)redhat.com
Sent: Friday, March 14, 2014 10:32:03 AM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
in the "Select database Metadata" dialog, uncheck the "procedures"
Ramesh..
On Fri, 2014-03-14 at 09:13 -0400, Thiago Araki wrote:
Hello Van,
With your suggestion I was finally able to connect to my runtime
server from Dev Studio.
Continuing with my POC for Petrobras, I was able to crate a JDBC-ODBC
connection to my excel file, and even query data from sql-scrapbook
(see screenshot below):
But in the next step, which is "Create source model for JDBC data
source", I am not able to complete, since there is no table available
to be selected (see screenshot sequence below).
In the error log that there is the following warning:
Unexpected exception while calling
sun.jdbc.odbc.JdbcOdbcDatabaseMetadata.getProcedures() and processing
results on DatabaseNew Generic JDBC
java.sql.SQLException [Microsoft][ODBC Driver Manager] The Driver does
not offer support for this function.
I do not have any preference in the approach to integrate the Excel
data source (via Dev Studio or creating the vdb.xml file and mannually
deploying it). But in both approaches I am facing much more
difficulties than with other data sources (web services, flat files
and databases).
Thanks,
Thiago
______________________________________________________________________
From: "Van Halbert" <vhalbert(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Sent: Thursday, March 13, 2014 9:56:26 PM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in
Windows XP SP3
If you're still looking at options, can you try this:
- at command line, run: hostname (to see what its using)
- when you start DV server (standalone.bat), pass it -b hostname
- in JBDS when configuring server, use hostname
Van
----- Original Message -----
From: "Thiago Araki" <taraki(a)redhat.com>
To: "Rob Cernich" <rcernich(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>, "Ramesh
Reddy"
<rareddy(a)redhat.com>, "Van Halbert" <vhalbert(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
>
11:13 a.m.
New subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3
Thiago,
I do not have a solution for it, but a suggestion is, why don't you use
Linux machine for your designer, but run the DV server on windows so
that you can access the Excel file using its DSN.
Ramesh..
On Fri, 2014-03-14 at 10:38 -0400, Thiago Araki wrote:
Hello Ramesh,
Unchecking "procedures" resolved the exception that were raised, but
the behavior is still the same: there is no table to be selected, and
I cannot continue with the "Create source model for JDBC data source"
wizard.
I had to restart my windows virtual machine, and when I tried to
connect again to my runtime server from Dev Studio (even though I
configured the hostname as suggested by Van Halbert), I am facing the
same problems I had before: Dev Studio keeps forever on "Performing
pre-lauch check" while starting the runtime. I deleted the server from
Dev Studio and created it again, but it did not solve the problem.
Restarting the server also did not take effect.
Regards,
Thiago
______________________________________________________________________
From: "Ramesh Reddy" <rareddy(a)redhat.com>
To: "Thiago Araki" <taraki(a)redhat.com>
Cc: "Van Halbert" <vhalbert(a)redhat.com>, "jbosstools-dev"
<jbosstools-dev(a)lists.jboss.org>, sme-dataservicesplatform(a)redhat.com
Sent: Friday, March 14, 2014 10:32:03 AM
Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in
Windows XP SP3
in the "Select database Metadata" dialog, uncheck the "procedures"
Ramesh..
On Fri, 2014-03-14 at 09:13 -0400, Thiago Araki wrote:
> Hello Van,
>
>
>
> With your suggestion I was finally able to connect to my runtime
> server from Dev Studio.
>
> Continuing with my POC for Petrobras, I was able to crate a
JDBC-ODBC
> connection to my excel file, and even query data from sql-scrapbook
> (see screenshot below):
>
>
>
>
>
>
> But in the next step, which is "Create source model for JDBC data
> source", I am not able to complete, since there is no table
available
> to be selected (see screenshot sequence below).
>
>
>
>
>
>
>
>
>
>
> In the error log that there is the following warning:
>
> Unexpected exception while calling
> sun.jdbc.odbc.JdbcOdbcDatabaseMetadata.getProcedures() and
processing
> results on DatabaseNew Generic JDBC
>
> java.sql.SQLException [Microsoft][ODBC Driver Manager] The Driver
does
> not offer support for this function.
>
>
>
> I do not have any preference in the approach to integrate the Excel
> data source (via Dev Studio or creating the vdb.xml file and
mannually
> deploying it). But in both approaches I am facing much more
> difficulties than with other data sources (web services, flat files
> and databases).
>
>
>
> Thanks,
>
>
>
> Thiago
>
>
>
>
>
______________________________________________________________________
> From: "Van Halbert" <vhalbert(a)redhat.com>
> To: "Thiago Araki" <taraki(a)redhat.com>
> Sent: Thursday, March 13, 2014 9:56:26 PM
> Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in
> Windows XP SP3
>
>
> If you're still looking at options, can you try this:
>
>
> - at command line, run: hostname (to see what its using)
> - when you start DV server (standalone.bat), pass it -b hostname
> - in JBDS when configuring server, use hostname
>
>
> Van
>
>
>
> ----- Original Message -----
> From: "Thiago Araki" <taraki(a)redhat.com>
> To: "Rob Cernich" <rcernich(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>, "Ramesh
Reddy"
> <rareddy(a)redhat.com>, "Van Halbert" <vhalbert(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
> >
>
>
>
>
>
>
3693
days inactive
3693
days old
jbosstools-dev@lists.jboss.org
3 comments
2 participants
participants (2)
-
Ramesh Reddy -
Thiago Araki