You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by ben short <ja...@gmail.com> on 2007/09/08 15:47:11 UTC
ReverseMappingTool not seeing system varables
Hi,
I have been trying to use the reverse mapping tool with the following command...
java -Dopenjpa.ConnectionURL=jdbc:postgresql://192.168.100.32/eshop-live-backup
-Dopenjpa.ConnectionDriverName=org.postgresql.jdbc3.Jdbc3PoolingDataSource
-Dopenjpa.ConnectionUserName=eshop -Dopenjpa.ConnectionPassword=eshop
-cp openjpa-1.1.0-SNAPSHOT.jar;serp-1.13.1.jar;commons-logging-1.0.4.jar;commons-lang-2.1.jar;commons-pool-1.3.jar;geronimo-jms_1.1_spec-1.0.1.jar;geronimo-jpa_3.0_spec-1.0.jar;geronimo-jta_1.1_spec-1.1.jar;postgresql-8.2-504.jdbc3.jar
org.apache.openjpa.jdbc.meta.ReverseMappingTool
But I get the following error...
0 INFO [main] openjpa.Tool - The reverse mapping tool will run on
the database. The tool is gathering schema information; this process
may take some time. Enable the org.apache.open
a logging category to see messages about schema data.
156 INFO [main] openjpa.jdbc.JDBC - Using dictionary class
"org.apache.openjpa.jdbc.sql.PostgresDictionary".
Exception in thread "main" org.postgresql.util.PSQLException:
Connection refused. Check that the hostname and port are correct and
that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82)
at org.postgresql.ds.jdbc23.AbstractJdbc23PoolingDataSource.getConnection(AbstractJdbc23PoolingDataSource.java:336)
at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:113)
at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:113)
at org.apache.openjpa.jdbc.schema.DataSourceFactory$DefaultsDataSource.getConnection(DataSourceFactory.java:269)
at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:328)
at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:263)
at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:243)
at org.apache.openjpa.jdbc.meta.ReverseMappingTool.run(ReverseMappingTool.java:1970)
at org.apache.openjpa.jdbc.meta.ReverseMappingTool.run(ReverseMappingTool.java:1954)
at org.apache.openjpa.jdbc.meta.ReverseMappingTool.main(ReverseMappingTool.java:1825)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:59)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 20 more
The db URL is defiantly valid as I can connect using pgAdmin and other
java apps.
Does anyone have any ideas?
Regards
Ben Short
Re: ReverseMappingTool not seeing system varables
Posted by ben short <ja...@gmail.com>.
Ok I have it working, by changing ConnectionDriverName to org.postgresql.Driver.
Ben
On 9/8/07, ben short <ja...@gmail.com> wrote:
> Hi,
>
> I have been trying to use the reverse mapping tool with the following command...
>
> java -Dopenjpa.ConnectionURL=jdbc:postgresql://192.168.100.32/eshop-live-backup
> -Dopenjpa.ConnectionDriverName=org.postgresql.jdbc3.Jdbc3PoolingDataSource
> -Dopenjpa.ConnectionUserName=eshop -Dopenjpa.ConnectionPassword=eshop
> -cp openjpa-1.1.0-SNAPSHOT.jar;serp-1.13.1.jar;commons-logging-1.0.4.jar;commons-lang-2.1.jar;commons-pool-1.3.jar;geronimo-jms_1.1_spec-1.0.1.jar;geronimo-jpa_3.0_spec-1.0.jar;geronimo-jta_1.1_spec-1.1.jar;postgresql-8.2-504.jdbc3.jar
> org.apache.openjpa.jdbc.meta.ReverseMappingTool
>
> But I get the following error...
>
> 0 INFO [main] openjpa.Tool - The reverse mapping tool will run on
> the database. The tool is gathering schema information; this process
> may take some time. Enable the org.apache.open
> a logging category to see messages about schema data.
> 156 INFO [main] openjpa.jdbc.JDBC - Using dictionary class
> "org.apache.openjpa.jdbc.sql.PostgresDictionary".
> Exception in thread "main" org.postgresql.util.PSQLException:
> Connection refused. Check that the hostname and port are correct and
> that the postmaster is accepting TCP/IP connections.
> at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
> at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
> at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
> at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
> at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
> at org.postgresql.Driver.makeConnection(Driver.java:382)
> at org.postgresql.Driver.connect(Driver.java:260)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:82)
> at org.postgresql.ds.jdbc23.AbstractJdbc23PoolingDataSource.getConnection(AbstractJdbc23PoolingDataSource.java:336)
> at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:113)
> at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
> at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:113)
> at org.apache.openjpa.jdbc.schema.DataSourceFactory$DefaultsDataSource.getConnection(DataSourceFactory.java:269)
> at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:328)
> at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:263)
> at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:243)
> at org.apache.openjpa.jdbc.meta.ReverseMappingTool.run(ReverseMappingTool.java:1970)
> at org.apache.openjpa.jdbc.meta.ReverseMappingTool.run(ReverseMappingTool.java:1954)
> at org.apache.openjpa.jdbc.meta.ReverseMappingTool.main(ReverseMappingTool.java:1825)
> Caused by: java.net.ConnectException: Connection refused: connect
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.PlainSocketImpl.doConnect(Unknown Source)
> at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
> at java.net.PlainSocketImpl.connect(Unknown Source)
> at java.net.SocksSocketImpl.connect(Unknown Source)
> at java.net.Socket.connect(Unknown Source)
> at java.net.Socket.connect(Unknown Source)
> at java.net.Socket.<init>(Unknown Source)
> at java.net.Socket.<init>(Unknown Source)
> at org.postgresql.core.PGStream.<init>(PGStream.java:59)
> at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
> ... 20 more
>
> The db URL is defiantly valid as I can connect using pgAdmin and other
> java apps.
>
> Does anyone have any ideas?
>
> Regards
>
> Ben Short
>