Skip to content
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.

Wrong SQL Statement inside dbContext. dbContext.getWayManager().getEntity(relationId) #4690

Open
openstreetmap-trac opened this issue Jul 23, 2021 · 0 comments

Comments

@openstreetmap-trac
Copy link

Reporter: ysa
[Submitted to the original trac issue database at 12.08pm, Friday, 16th November 2012]

Code


DatabasePreferences preferences = new DatabasePreferences(false,true);
	
PostgreSqlDatasetReader reader = new  PostgreSqlDatasetReader(loginCredentials, preferences);
	
reader.createReader().getWayManager().getEntity(wayId);

produced ERROR: column "entity_id" does not exist

Exception in thread "main" org.openstreetmap.osmosis.core.OsmosisRuntimeException: Query failed for way_nodes 4078548.
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.EntityFeatureDao.getAll(EntityFeatureDao.java:87)
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.EntityFeatureDao.getAllRaw(EntityFeatureDao.java:113)
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.WayDao.loadFeatures(WayDao.java:67)
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.WayDao.loadFeatures(WayDao.java:22)
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.EntityDao.getEntity(EntityDao.java:147)
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.PostgreSqlEntityManager.getEntity(PostgreSqlEntityManager.java:104)
	at org.xxx.tests.osmosis.HelloOSMDbReader.readWays(HelloOSMDbReader.java:73)
	at org.xxx.tests.osmosis.HelloOSMDbReader.main(HelloOSMDbReader.java:27)
Caused by: org.postgresql.util.PSQLException: ERROR: column "entity_id" does not exist
  Line: 73
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
	at org.openstreetmap.osmosis.pgsimple.v0_6.impl.EntityFeatureDao.getAll(EntityFeatureDao.java:74)
	... 7 more

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant