<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'>Hello Ramesh,<br><br>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.<br><br>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.<br><br>Regards,<br><br>Thiago<br><br><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;"><b>From: </b>"Ramesh Reddy" <rareddy@redhat.com><br><b>To: </b>"Thiago Araki" <taraki@redhat.com><br><b>Cc: </b>"Van Halbert" <vhalbert@redhat.com>, "jbosstools-dev" <jbosstools-dev@lists.jboss.org>, sme-dataservicesplatform@redhat.com<br><b>Sent: </b>Friday, March 14, 2014 10:32:03 AM<br><b>Subject: </b>Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br><br>in the "Select database Metadata" dialog, uncheck the "procedures"<br><br>Ramesh..<br><br>On Fri, 2014-03-14 at 09:13 -0400, Thiago Araki wrote:<br>> Hello Van,<br>> <br>> <br>> <br>> With your suggestion I was finally able to connect to my runtime<br>> server from Dev Studio.<br>> <br>> Continuing with my POC for Petrobras, I was able to crate a JDBC-ODBC<br>> connection to my excel file, and even query data from sql-scrapbook<br>> (see screenshot below):<br>> <br>> <br>> <br>> <br>> <br>> <br>> But in the next step, which is "Create source model for JDBC data<br>> source", I am not able to complete, since there is no table available<br>> to be selected (see screenshot sequence below).<br>> <br>> <br>> <br>> <br>> <br>> <br>> <br>> <br>> <br>> <br>> In the error log that there is the following warning:<br>> <br>> Unexpected exception while calling<br>> sun.jdbc.odbc.JdbcOdbcDatabaseMetadata.getProcedures() and processing<br>> results on DatabaseNew Generic JDBC<br>> <br>> java.sql.SQLException [Microsoft][ODBC Driver Manager] The Driver does<br>> not offer support for this function.<br>> <br>> <br>> <br>> I do not have any preference in the approach to integrate the Excel<br>> data source (via Dev Studio or creating the vdb.xml file and mannually<br>> deploying it). But in both approaches I am facing much more<br>> difficulties than with other data sources (web services, flat files<br>> and databases).<br>> <br>> <br>> <br>> Thanks,<br>> <br>> <br>> <br>> Thiago<br>> <br>> <br>> <br>> <br>> ______________________________________________________________________<br>> From: "Van Halbert" <vhalbert@redhat.com><br>> To: "Thiago Araki" <taraki@redhat.com><br>> Sent: Thursday, March 13, 2014 9:56:26 PM<br>> Subject: Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in<br>> Windows XP SP3<br>> <br>> <br>> If you're still looking at options, can you try this:<br>> <br>> <br>> - 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>> <br>> <br>> Van<br>> <br>> <br>> <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"<br>> <max.andersen@redhat.com>, sme-dataservicesplatform@redhat.com,<br>> "jbosstools-dev" <jbosstools-dev@lists.jboss.org>, "Ramesh Reddy"<br>> <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<br>> Windows XP SP3<br>> <br>> <br>> Hello all. <br>> <br>> <br>> All ports match, and from Dev Studio I am able to enter in "Teiid<br>> Instance" configuration window and "Test Administration Connection"<br>> and "Test JDBC Connection" with success. I am using the same<br>> configurations which I am used to with my linux instances, and they<br>> work fine all the time. <br>> <br>> <br>> I tried Van Halbert approach (described in<br>> http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html ), without success: <br>> <br>> <br>> 1. Using the VDB below (copied from the blog), I got the following<br>> error: Caused by: org.xml.sax.SAXParseException: cvc-complex-type.2.1:<br>> Element 'property' must have no character or element information item<br>> [children], because the type's content type is empty. <br>> <br>> <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"<br>> translator-name= "jdbc-simple" > <br>> </model> <br>> </property></vdb> <br>> 2. I changed the VDB to the format shown below, and I got the<br>> following error: VDB odbc.1 model "excel" metadata failed to load.<br>> Reason:TEIID11010 java.sql.SqlException: [Microsoft][ODBC Driver<br>> Manager] The driver does not offer support for this function. <br>> <br>> <br>> <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"<br>> translator-name= "jdbc-simple"/ > <br>> </model> <br>> </vdb> <br>> <br>> <br>> I was able to query my Excel data directly using SquirreL SQL client<br>> and Microsoft ODBC driver. <br>> <br>> <br>> In both cases depicted above, I was not able to access OData via<br>> browser (http://localhost:8080/odata/odbc/excel.Sheet1). After input<br>> my credentials I got another error: HTTP Status 403: Access to the<br>> requested resource has been denied . <br>> <br>> <br>> I attached my excel file. It is very simple (2 columns), and once I<br>> get this working I will have to use the one provided by the<br>> customer . <br>> <br>> <br>> Regards, <br>> <br>> <br>> Thiago Araki <br>> <br>> <br>> ----- Original Message -----<br>> <br>> <br>> From: "Rob Cernich" <rcernich@redhat.com> <br>> To: "Ramesh Reddy" <rareddy@redhat.com> <br>> Cc: "Robert Stryker" <rstryker@redhat.com>, "Max Rydahl Andersen"<br>> <max.andersen@redhat.com>, sme-dataservicesplatform@redhat.com,<br>> "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<br>> Windows XP SP3 <br>> <br>> <br>> You might make sure the server configuration in the tools is<br>> configured to listen to the management port...and make sure the<br>> configured port matches. <br>> <br>> <br>> ----- Original Message ----- <br>> > Even that needs a ODBC DSN created for Excel on Windows platform, if<br>> you <br>> > already have VDB configured this will work. If you are trying to<br>> build <br>> > the VDB and preview while doing so then you will still see below<br>> 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>> > ><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"<br>> <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<br>> SP3 <br>> > > <br>> > > > Hello Ted, <br>> > > <br>> > > > I did not, but I tried now with this option and unfortunately<br>> the same <br>> > > > thing <br>> > > > happened. <br>> > > <br>> > > > I am stuck with this problem and my time is running out to<br>> deliver this <br>> > > > POC. <br>> > > > The reason I am using a Windows environment is because I need<br>> to <br>> > > > integrate <br>> > > > data from an Excel data source, and the only way I found to do<br>> 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<br>> SP3 <br>> > > <br>> > > > Hi Thiago, <br>> > > <br>> > > > When creating your server connection in JBDS, did you check the<br>> "Server <br>> > > > is <br>> > > > externally managed. Assume server is started." radio button?<br>> 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<br>> 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<br>> 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<br>> finishes the <br>> > > > > initialization (I can see it in the Console view and and<br>> access it via <br>> > > > > JBoss <br>> > > > > EAP web console) but the progress bar keeps the status<br>> "starting JBoss <br>> > > > > EAP <br>> > > > > 6 <br>> > > > > Server..." and never finishes. Because of this situation,<br>> every <br>> > > > > operation <br>> > > > > that needs to sync with my server, for instance, Preview Data,<br>> gets <br>> > > > > queued <br>> > > > > and never executes. <br>> > > > <br>> > > <br>> > > > > If I manually start JBoss EAP 6 outside Dev Studio, them try<br>> to connect <br>> > > > > via <br>> > > > > Server View (acknowledging the server is already started), the<br>> problem <br>> > > > > is <br>> > > > > that the progress bar stays in "Performing pre-launch<br>> check..." status <br>> > > > > forever, and I also cannot interact with my server from my<br>> project. <br>> > > > <br>> > > <br>> > > > > In both cases I am able to enter in "Teiid Instance"<br>> configuration <br>> > > > > window <br>> > > > > and <br>> > > > > "Test Administration Connection" and "Test JDBC Connection"<br>> with <br>> > > > > success. <br>> > > > <br>> > > <br>> > > > > It seems to me that something is being incorrectly locked in<br>> 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<br>> have <br>> > > > > already <br>> > > > > re-installed both JBoss EAP and Dev Studio (including version<br>> 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>> <br>> <br>> <br>> <br>> <br>> <br><br><br></div></div></body></html>