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