On Thu, Mar 6, 2008 at 12:36 PM, Lambertus <[EMAIL PROTECTED]> wrote:
> As the title says, I'm trying to import a planet file into a mysql > database > on my debian machine. I've done the following steps to accomplish this: > - Install mysql-server-5.0 (using no password for root) > - Create a database > - Create the tables according to the Osmosis mysql schema as said in the > wiki > - Iinstall sun-java6-bin > - Install libmysql-java > - Download Osmosis (version 0.24) > > This seems all ok to me, so I run the command to fill the database: > > bzcat planet/planet-latest.osm.bz2 | java -Xmx1048m -jar > utils/osmosis/osmosis.jar --rx /dev/stdin enableDateParsing=no > outPipe.0="planet" --wm inPipe.0="planet" host="localhost" database="osm" > user="root" > > Now Osmosis returns with the error "Unable to find database driver" (see > below for the full error message). Can someone give me a pointer to where > I've gone wrong? > > Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main > INFO: Osmosis Version 0.24 > Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main > INFO: Preparing pipeline. > Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main > INFO: Launching pipeline execution. > Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main > INFO: Pipeline executing, waiting for completion. > Exception in thread "Thread-1-rx" > com.bretth.osmosis.core.OsmosisRuntimeException: Unable to find database > driver. > at > com.bretth.osmosis.core.mysql.common.DatabaseContext.loadDatabaseDriver( > DatabaseContext.java:58) > at > com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection( > DatabaseContext.java:77) > at > com.bretth.osmosis.core.mysql.common.DatabaseContext.executeStreamingQuery > (DatabaseContext.java:197) > at > > com.bretth.osmosis.core.mysql.common.SchemaVersionValidator.validateDBVersion > (SchemaVersionValidator.java:62) > at > > com.bretth.osmosis.core.mysql.common.SchemaVersionValidator.validateVersion > (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.java > :1004) > at > com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end( > NodeElementProcessor.java:99) > at > com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement( > OsmHandler.java:108) > at > com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement( > AbstractSAXParser.java:601) > at > > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement > (XMLDocumentFragmentScannerImpl.java:1772) > at > > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next > (XMLDocumentFragmentScannerImpl.java:2923) > at > com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next( > XMLDocumentScannerImpl.java:647) > at > > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument > (XMLDocumentFragmentScannerImpl.java:508) > at > com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse( > XML11Configuration.java:807) > at > com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse( > XML11Configuration.java:737) > at > com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java > :107) > at > com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse( > AbstractSAXParser.java:1205) > at > com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse( > SAXParserImpl.java:522) > at javax.xml.parsers.SAXParser.parse(SAXParser.java:395) > at javax.xml.parsers.SAXParser.parse(SAXParser.java:198) > at > com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:101) > at java.lang.Thread.run(Thread.java:619) > Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver > at java.net.URLClassLoader$1.run(URLClassLoader.java:200) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:188) > at java.lang.ClassLoader.loadClass(ClassLoader.java:306) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276) > at java.lang.ClassLoader.loadClass(ClassLoader.java:251) > at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:169) > at > com.bretth.osmosis.core.mysql.common.DatabaseContext.loadDatabaseDriver( > DatabaseContext.java:55) > ... 22 more > Mar 6, 2008 8:16:56 PM com.bretth.osmosis.core.Osmosis main > INFO: Pipeline complete. > The database driver is not on your classpath. You could (should?) use the shell script in the osmosis/bin directory, or copy the classpath arguments from it (specifically the mysql-connector-java bit). Karl
_______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk