Ron Lindhoudt wrote > Did you try to add " around the column names?What database do you > use?Maybe you can turn on GeoTools logging to see what SQL statement is > executed.You can turn on JDBC logging in logging.properties : > org.geotools.jdbc.level=FINESTorg.geotools.jdbc.SQLDialect.level=FINEST
Yes i did, but then the it doesn't find the columns. The same happens with ' instead of \". I have to use Orale 12c. I've set the loglevel to finest and the SQL-Statement is fine. The manual execution of the statement returns the expected result. So the problem doesn't seem to be the Query, it looks like the application tries to access a column that doesn't exist in the result while adding it to a layer. At the beginning i thought that the join would only return one id-column, but both id-columns are in the result. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Join-on-Primary-Keys-in-a-Query-tp5172471p5172719.html Sent from the geotools-gt2-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk _______________________________________________ GeoTools-GT2-Users mailing list GeoTools-GT2-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
