<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><div>Hello Van,<br></div><div><br></div><div>With your suggestion I was finally able to connect to my runtime server from Dev Studio.<br></div><div>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):<br></div><div><br></div><div><img src="cid:846fed3f01c9d8698c8d5c7a19a51a45d2e7d673@zimbra" alt="" height="199" width="527"></div><div><br></div><div>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).<br></div><div><img src="cid:350ce0a156842e4fb22588742635f8a268235a62@zimbra" alt="" height="265" width="559"></div><div><br></div><div><img src="cid:f4320bc61d5c5f326c807f07328a5be13bf9ccc0@zimbra" alt="" height="468" width="558"></div><div><br></div><div><img src="cid:61b5291c8617cca369dd8df08d1f7de5ac3f6122@zimbra" alt="" height="477" width="565"></div><div><br></div><div>In the error log that there is the following warning:<br></div><div><strong><em>Unexpected exception while calling sun.jdbc.odbc.JdbcOdbcDatabaseMetadata.getProcedures() and processing results on DatabaseNew Generic JDBC</em></strong><br></div><div><strong><em>java.sql.SQLException [Microsoft][ODBC Driver Manager] The Driver does not offer support for this function.</em></strong><br></div><div><br></div><div>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).<br></div><div><br></div><div>Thanks,<br></div><div><br></div><div>Thiago<br></div><div><span></span><br></div><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="color: #000000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Van Halbert" <vhalbert@redhat.com><br><b>To: </b>"Thiago Araki" <taraki@redhat.com><br><b>Sent: </b>Thursday, March 13, 2014 9:56:26 PM<br><b>Subject: </b>Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br><div><br></div>If you're still looking at options, can you try this:<br><div><br></div>- at command line, run: hostname (to see what its using)<br>- when you start DV server (standalone.bat), pass it -b hostname<br>- in JBDS when configuring server, use hostname<br><div><br></div>Van<br><div><br></div><br>----- Original Message -----<br>From: "Thiago Araki" <taraki@redhat.com><br>To: "Rob Cernich" <rcernich@redhat.com><br>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><br>Sent: Thursday, March 13, 2014 1:33:57 PM<br>Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br><div><br></div>Hello all. <br><div><br></div>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. <br><div><br></div>I tried Van Halbert approach (described in http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html ), without success: <br><div><br></div>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. <br><div><br></div><vdb name= "odbc" version= "1" > <br><property name= "UseConnectorMetadata" value= "true" > <br><model name= "excel" > <br><source connection-jndi-name= "java:/odbcDS" name= "connector" translator-name= "jdbc-simple" > <br></model> <br></property></vdb> <br>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. <br><div><br></div><br><vdb name= "odbc" version= "1" > <br><property name= "UseConnectorMetadata" value= "true"/ > <br><model name= "excel" > <br><source connection-jndi-name= "java:/odbcDS" name= "connector" translator-name= "jdbc-simple"/ > <br></model> <br></vdb> <br><div><br></div>I was able to query my Excel data directly using SquirreL SQL client and Microsoft ODBC driver. <br><div><br></div>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 . <br><div><br></div>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 . <br><div><br></div>Regards, <br><div><br></div>Thiago Araki <br><div><br></div>----- Original Message -----<br><div><br></div>From: "Rob Cernich" <rcernich@redhat.com> <br>To: "Ramesh Reddy" <rareddy@redhat.com> <br>Cc: "Robert Stryker" <rstryker@redhat.com>, "Max Rydahl Andersen" <max.andersen@redhat.com>, sme-dataservicesplatform@redhat.com, "jbosstools-dev" <jbosstools-dev@lists.jboss.org> <br>Sent: Thursday, March 13, 2014 2:34:01 PM <br>Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3 <br><div><br></div>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. <br><div><br></div>----- Original Message ----- <br>> Even that needs a ODBC DSN created for Excel on Windows platform, if you <br>> already have VDB configured this will work. If you are trying to build <br>> the VDB and preview while doing so then you will still see below issue. <br>> <br>> Ramesh.. <br>> <br>> On Thu, 2014-03-13 at 09:54 -0400, Van Halbert wrote: <br>> > Here' a blog by Ramesh: <br>> > http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html <br>> > <br>> > Maybe this is an option for you. <br>> > <br>> > Van <br>> > <br>> > ----- Original Message ----- <br>> > From: "Ted Jones" <tejones@redhat.com> <br>> > To: "Thiago Araki" <taraki@redhat.com>, "Max Rydahl Andersen" <br>> > <max.andersen@redhat.com>, "Robert Stryker" <rstryker@redhat.com>, <br>> > "jbosstools-dev" <jbosstools-dev@lists.jboss.org> <br>> > Cc: sme-dataservicesplatform@redhat.com <br>> > Sent: Thursday, March 13, 2014 8:53:04 AM <br>> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3 <br>> > <br>> > Adding Max, Rob and jbosstools-dev for their insights... <br>> > <br>> > ----- Original Message ----- <br>> > <br>> > > From: "Thiago Araki" <taraki@redhat.com> <br>> > > To: "Ted Jones" <tejones@redhat.com> <br>> > > Cc: sme-dataservicesplatform@redhat.com <br>> > > Sent: Thursday, March 13, 2014 8:21:11 AM <br>> > > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3 <br>> > <br>> > > Hello Ted, <br>> > <br>> > > I did not, but I tried now with this option and unfortunately the same <br>> > > thing <br>> > > happened. <br>> > <br>> > > I am stuck with this problem and my time is running out to deliver this <br>> > > POC. <br>> > > The reason I am using a Windows environment is because I need to <br>> > > integrate <br>> > > data from an Excel data source, and the only way I found to do it is with <br>> > > the Microsoft ODBC driver. <br>> > <br>> > > Regards, <br>> > <br>> > > Thiago <br>> > <br>> > > ----- Original Message ----- <br>> > <br>> > > From: "Ted Jones" <tejones@redhat.com> <br>> > > To: "Thiago Araki" <taraki@redhat.com> <br>> > > Cc: sme-dataservicesplatform@redhat.com <br>> > > Sent: Wednesday, March 12, 2014 6:42:17 PM <br>> > > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3 <br>> > <br>> > > Hi Thiago, <br>> > <br>> > > When creating your server connection in JBDS, did you check the "Server <br>> > > is <br>> > > externally managed. Assume server is started." radio button? I've <br>> > > attached a <br>> > > screenshot. <br>> > <br>> > > I know this was the way best way to go at one point, so I always do this <br>> > > now <br>> > > out of habit. <br>> > > ----- Original Message ----- <br>> > <br>> > > > From: "Thiago Araki" <taraki@redhat.com> <br>> > > <br>> > > > To: sme-dataservicesplatform@redhat.com <br>> > > <br>> > > > Sent: Wednesday, March 12, 2014 4:27:34 PM <br>> > > <br>> > > > Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3 <br>> > > <br>> > <br>> > > > Hello all, <br>> > > <br>> > <br>> > > > I am having problems with JBoss Dev Studio (with Teiid Designer) 7.1 in <br>> > > > a <br>> > > > Windows environment (Windows XP SP3). <br>> > > <br>> > <br>> > > > When I start my Runtime Server via Dev Studio, the server finishes the <br>> > > > initialization (I can see it in the Console view and and access it via <br>> > > > JBoss <br>> > > > EAP web console) but the progress bar keeps the status "starting JBoss <br>> > > > EAP <br>> > > > 6 <br>> > > > Server..." and never finishes. Because of this situation, every <br>> > > > operation <br>> > > > that needs to sync with my server, for instance, Preview Data, gets <br>> > > > queued <br>> > > > and never executes. <br>> > > <br>> > <br>> > > > If I manually start JBoss EAP 6 outside Dev Studio, them try to connect <br>> > > > via <br>> > > > Server View (acknowledging the server is already started), the problem <br>> > > > is <br>> > > > that the progress bar stays in "Performing pre-launch check..." status <br>> > > > forever, and I also cannot interact with my server from my project. <br>> > > <br>> > <br>> > > > In both cases I am able to enter in "Teiid Instance" configuration <br>> > > > window <br>> > > > and <br>> > > > "Test Administration Connection" and "Test JDBC Connection" with <br>> > > > success. <br>> > > <br>> > <br>> > > > It seems to me that something is being incorrectly locked in the plugin <br>> > > > that <br>> > > > integrates Dev Studio and JBoss EAP for this situation. <br>> > > <br>> > <br>> > > > I tried both Oracle JDK 1.6 and 1.7 with the same results. I have <br>> > > > already <br>> > > > re-installed both JBoss EAP and Dev Studio (including version 7.0) and <br>> > > > every <br>> > > > time this behavior occurs. <br>> > > <br>> > <br>> > > > In my Linux machine this problem never happens. <br>> > > <br>> > <br>> > > > Can anybody help me? <br>> > > <br>> > <br>> > > > Thanks, <br>> > > <br>> > <br>> > > > Thiago Araki <br>> > > <br>> > <br>> <br>> <br>> _______________________________________________ <br>> jbosstools-dev mailing list <br>> jbosstools-dev@lists.jboss.org <br>> https://lists.jboss.org/mailman/listinfo/jbosstools-dev <br>> <br><div><br></div><br></div><div><br></div></div></body></html>