[OSM-dev] Osmosis: Unable to find database driver

[Max Power]

Thanks, now i get this to work and get the next error...

java -cp C:\Downloads\MySQL5.0.45\mysql-connector-java-5.1.5\mysql-connector-java-5.1.5-bin.jar;osmosis.jar com.bretth.osmosis.core.Osmisis --read-xml file="../planet.osm" --write-mysql host="localhost" database="osm" user="osmuser" password="osm"
14.11.2007 13:00:58 com.bretth.osmosis.core.Osmosis main
INFO: Osmosis Version 0.22
14.11.2007 13:00:58 com.bretth.osmosis.core.Osmosis main
INFO: Preparing pipeline.
14.11.2007 13:00:58 com.bretth.osmosis.core.Osmosis main
INFO: Launching pipeline execution.
14.11.2007 13:00:58 com.bretth.osmosis.core.Osmosis main
INFO: Pipeline executing, waiting for completion.
Exception in thread "Thread-1-read-xml" com.bretth.osmosis.core.OsmosisRuntimeException: Unable to create streaming resultset.
        at com.bretth.osmosis.core.mysql.common.DatabaseContext.executeStreaming
Query(DatabaseContext.java:208)
        at com.bretth.osmosis.core.mysql.common.SchemaVersionValidator.validateD
BVersion(SchemaVersionValidator.java:62)
        at com.bretth.osmosis.core.mysql.common.SchemaVersionValidator.validateV
ersion(SchemaVersionValidator.java:44)
        at com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter
.java:316)
        at com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.ja
va:1004)
        at com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeEl
ementProcessor.java:99)
        at com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandle
r.java:108)
        at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endEleme
nt(Unknown Source)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanEndElement(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:101)
        at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'osm
.schema_info' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
        at com.bretth.osmosis.core.mysql.common.DatabaseContext.executeStreaming
Query(DatabaseContext.java:203)
        ... 20 more
14.11.2007 13:00:58 com.bretth.osmosis.core.Osmosis main
INFO: Pipeline complete.


With mysql i did the following:

CREATE DATABASE osm;
use osm
GRANT ALL ON osm .* TO osmuser at localhost IDENTIFIED BY "osm";


 		
---------------------------------
Yahoo! Mail - Sie denken an Ihre Sicherheit?  Das tun wir auch. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20071114/3ead3c22/attachment.html>