Well, after few days of trying I think I have finally got the answer; trouble was that in my Torque.properties I set these:

torque.database.default=default
                        ^^^^^^^^
torque.database.default.adapter=postgresql
                ^^^^^^^^

etc., but in my project-schema.xml I had <database name="jetspeed" ...>
When I changed Torque.props to:

torque.database.default=jetspeed
                        ^^^^^^^^
torque.database.jetspeed.adapter=postgresql
                ^^^^^^^^

it started to work (so your idea 2 was correct, as when you don't specify the name for database, it probably uses default (??)). Anyway, I'm happy that it works now and I'm very thankfull for your help.

Regards,
Martin


Dne 09.11.2003 23:32:29 napsal Yong Bing Khoo:
Hi Martin,

I compared your schema with mine. There are only three major differences:

1. I used the default hypersonic SQL dbms that came with Jetspeed instead of Postgresql, so I am think people out there who have used Postgresql may be able to help you more in terms of the torque properties.
2. My database tag is empty, i.e. <database> ... You might want to try that to see if that would resolve the error.
3. My idMethods for all tables are "idbroker" except primary keys which are non-integer and those which are really foreign keys in other tables.


Hope that helps.

Regards,
Yong Bing


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to