From: "Ramesh Reddy" <rareddy@redhat.com>
To: "Thiago Araki" <taraki@redhat.com>
Cc: "Van Halbert" <vhalbert@redhat.com>, "jbosstools-dev" <jbosstools-dev@lists.jboss.org>, sme-dataservicesplatform@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@redhat.com>
> To: "Thiago Araki" <taraki@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@redhat.com>
> To: "Rob Cernich" <rcernich@redhat.com>
> Cc: "Robert Stryker" <rstryker@redhat.com>, "Max Rydahl Andersen"
> <max.andersen@redhat.com>, sme-dataservicesplatform@redhat.com,
> "jbosstools-dev" <jbosstools-dev@lists.jboss.org>, "Ramesh Reddy"
> <rareddy@redhat.com>, "Van Halbert" <vhalbert@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@redhat.com>
> To: "Ramesh Reddy" <rareddy@redhat.com>
> Cc: "Robert Stryker" <rstryker@redhat.com>, "Max Rydahl Andersen"
> <max.andersen@redhat.com>, sme-dataservicesplatform@redhat.com,
> "jbosstools-dev" <jbosstools-dev@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@redhat.com>
> > > To: "Thiago Araki" <taraki@redhat.com>, "Max Rydahl Andersen"
> > > <max.andersen@redhat.com>, "Robert Stryker"
> <rstryker@redhat.com>,
> > > "jbosstools-dev" <jbosstools-dev@lists.jboss.org>
> > > Cc: sme-dataservicesplatform@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@redhat.com>
> > > > To: "Ted Jones" <tejones@redhat.com>
> > > > Cc: sme-dataservicesplatform@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@redhat.com>
> > > > To: "Thiago Araki" <taraki@redhat.com>
> > > > Cc: sme-dataservicesplatform@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@redhat.com>
> > > >
> > > > > To: sme-dataservicesplatform@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@lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/jbosstools-dev
> >
>
>
>
>
>
>