I can connect to my database explicitly, i think there is some problem with
jdbc connection
Apr 20, 2010 3:10:51 PM org.openstreetmap.osmosis.
core.Osmosis run
INFO: Osmosis Version 0.34
Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Apr 20, 2010 3:10:53 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-read-apidb failed
org.springframework.transaction.CannotCreateTransactionException:* Could not
open JDBC Connection for transaction;* nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: database "openstreetmap" does not exist)
at
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:238)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:125)
at
org.openstreetmap.osmosis.core.apidb.common.DatabaseContext2.executeWithinTransaction(DatabaseContext2.java:100)
at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbReader.run(ApidbReader.java:102)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: database "openstreetmap" does not exist)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
... 5 more
On Wed, Apr 21, 2010 at 6:28 AM, Brett Henderson <[email protected]> wrote:
> It seems odd that it's not finding the database.
>
> Can you try this please to verify that you can connect to the openstreetmap
> database explicitly?
> mysql -h 127.0.0.1 -u root -p rose *openstreetmap*
>
>
> On Tue, Apr 20, 2010 at 9:29 PM, M Naveed Akram <[email protected]> wrote:
>
>> Yes database is present, also accessible.. i can check it via mysql -h
>> 127.0.0.1 -u root -p rose
>>
>>
>> On Tue, Apr 20, 2010 at 4:17 PM, Peter Körner <[email protected]>wrote:
>>
>>> M Naveed Akram schrieb:
>>>
>>> Hi i get following when exporting osm from db, please help
>>>>
>>>>
>>>>
>>>> $ ./osmosis --read-apidb host="127.0.0.1" database="openstreetmap"
>>>> user="root" password="rose" dbType="mysql" --write-xml file="output.osm"
>>>>
>>>>
>>> ...
>>>
>>> (FATAL: database "openstreetmap" does not exist)
>>> ...
>>>
>>> Q: Does the database "openstreetmap" exist and does the user root have
>>> access to it?
>>>
>>> Peter
>>>
>>
>>
>
--
Regards
M Naveed Akram
http://www.google.com/profiles/cmnajs
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
