Osmosis connection postgresql

Alex_Strunck · 2009-07-17T14:50:02.000Z

Hello

i am pretty new to osm, osmosis und postgresql. i have a windows xp system and i installed osmosis 0.3.0, postgresql 8.3.7.1, postgis 1.3.6.1.
i downloaded some data from geofabrik.de. i used the pgsql_simple_schema_0.5.sql script. i try to convert the osm data into the postgresql database.

C:\Programme\osmosis-0.30\bin>osmosis --read-xml file=berlin.osm --write-pgsql d
atabase=“alex” user=“alex” password=“xxx”
17.07.2009 16:31:23 com.bretth.osmosis.core.Osmosis run
INFO: Osmosis Version 0.30
17.07.2009 16:31:23 com.bretth.osmosis.core.Osmosis run
INFO: Preparing pipeline.
17.07.2009 16:31:23 com.bretth.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
17.07.2009 16:31:23 com.bretth.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
17.07.2009 16:31:23 com.bretth.osmosis.core.xml.v0_5.impl.OsmElementProcessor be
gin
WARNUNG: Expected version 0.5 but received 0.6.
17.07.2009 16:31:23 com.bretth.osmosis.core.pipeline.common.ActiveTaskManager wa
itForCompletion
SCHWERWIEGEND: Thread for task 1-read-xml failed
com.bretth.osmosis.core.OsmosisRuntimeException: Unable to establish a database
connection.
at com.bretth.osmosis.core.pgsql.common.DatabaseContext.getConnection(Da
tabaseContext.java:95)
at com.bretth.osmosis.core.pgsql.common.DatabaseContext.createStatement(
DatabaseContext.java:184)
at com.bretth.osmosis.core.pgsql.common.SchemaVersionValidator.validateD
BVersion(SchemaVersionValidator.java:72)
at com.bretth.osmosis.core.pgsql.common.SchemaVersionValidator.validateV
ersion(SchemaVersionValidator.java:52)
at com.bretth.osmosis.core.pgsql.v0_5.PostgreSqlWriter.initialize(Postgr
eSqlWriter.java:284)
at com.bretth.osmosis.core.pgsql.v0_5.PostgreSqlWriter.process(PostgreSq
lWriter.java:1012)
at com.bretth.osmosis.core.xml.v0_5.impl.BoundElementProcessor.end(Bound
ElementProcessor.java:85)
at com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandle
r.java:109)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endEleme
nt(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.
emptyElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(U
nknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(U
nknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(U
nknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown So
urce)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Un
known Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p
arse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:109)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: FATAL: database “?alex?” does not
exist
at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(Conn
ectionFactoryImpl.java:444)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:99)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
y.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Conn
ection.java:124)
at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Conn
ection.java:30)
at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Conn
ection.java:29)
at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:386)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.bretth.osmosis.core.pgsql.common.DatabaseContext.getConnection(Da
tabaseContext.java:85)
… 22 more
17.07.2009 16:31:23 com.bretth.osmosis.core.Osmosis main
SCHWERWIEGEND: Execution aborted.
com.bretth.osmosis.core.OsmosisRuntimeException: One or more tasks failed.
at com.bretth.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pi
peline.java:146)
at com.bretth.osmosis.core.Osmosis.run(Osmosis.java:85)
at com.bretth.osmosis.core.Osmosis.main(Osmosis.java:30)

what can i do to make it work??

thx in advance.

alex

SK53 · 2009-07-24T10:39:54.000Z

Hi Alex,

Did you make any progress with this. I note that you used a API 0.5 SQL schema not API 0.6, but I’ve got similar problems with missing classes etc.

Can anyone with experience of osmosis on Windows provide a bit of help? There’s a mention somewhere on the wiki of CLASSPATH variable.

SK53

thisisbinod · 2010-05-18T20:36:28.000Z

Were you guys able to figure it out how to do it? I am also having the same problem, please can anybody help?