-
1. Re: Issue retrieving INET column from PostgreSQL
shawkins Jun 2, 2011 3:12 PM (in response to calebwc)Caleb,
You should be able to use the any value as the object type. This issue was addressed with a fix under the https://issues.jboss.org/browse/TEIID-1011 JIRA. See http://source.jboss.org/browse/Teiid/trunk/common-core/src/main/java/org/teiid/core/types/DataTypeManager.java#3094. That fix is in 7.4 or later.
With that fix, you can use those objects as they are returned from PG. As for adding a native type for InetAddresses, that is something that could be requested through a JIRA. I don't think we've had it come up before now.
Steve
-
2. Re: Issue retrieving INET column from PostgreSQL
calebwc Jun 2, 2011 3:24 PM (in response to shawkins)Steve,
Thanks for your prompt response. I will try to pull down the 7.4 baseline and try again. Thanks again for your assistance. Take care.
Regards,
Caleb
P.S. I'm sure I will have a lot more questions in the not so distant future as we start utilizing Teiid more.
-
3. Re: Issue retrieving INET column from PostgreSQL
calebwc Jun 7, 2011 6:51 AM (in response to calebwc)Steve,
O.k., I've attempted to migrate from Teiid 7.3 to 7.4 to no avail thus far. I've found a lot of the dependent jar files within the JBoss distribution under "deployers/teiid.deployer/" (such as the engine, core api, and runtime) After removing all my 7.3 associations and replacing them with 7.4; creating a brand new JBoss 5.1.0 with a Teiid 7.4 overlay; and redeploying all the VDBs and their dependencies I get a NullPointerException thrown when in org.teiid.query.sql.navigator.DeepPreOrderNavigator's doVisit method. where it tries to call acceptVisitor on a LanguageObject that is passed into the doVisit method. Unfortunately, this object is null for one of the calls. I haven't had a lot of time to fully debug this to see what mapping object is having issues (I will be spending a little time doing that now.) The pertinent portion of the stacktrace is as follows:
Caused by: java.lang.NullPointerException
at org.teiid.query.sql.navigator.DeepPreOrderNavigator.doVisit(DeepPreOrderNavigator.java:44)
at org.teiid.query.optimizer.xml.QueryUtil.markBindingsAsNonExternal(QueryUtil.java:175)
at org.teiid.query.optimizer.xml.SourceNodePlannerVisitor.visit(SourceNodePlannerVisitor.java:175)
... 39 more
The first part of the stacktrace doesn't seem useful: Unexpected exception for request <request id> nullnull
-
4. Re: Issue retrieving INET column from PostgreSQL
calebwc Jun 7, 2011 8:47 AM (in response to calebwc)Update...
Something weird must have been going on behind the scenes (JBoss, Teiid, not really sure.) After deleting the view model and rebuilding it from the XSD, I was able to successfully run against Teiid 7.4 on a PostgreSQL INET column (converting it into a string.) It seemed like the NPE (null pointer exception) was thrown when it encountered it's first convert statement, can't validate this, but, this is what it appeared to be when I debugged the Teiid server instance when the problem was still occurring. Thanks for your assistance.
Caleb