hi,
I'm using tomcat 4.1.24 and hibernate 2.0.3, and I have some problems with the jdbc url connection.
in the hibernate.properties of my application classpath I wrote:

hibernate.connection.url = jdbc:firebirdsql://localhost/%CATALINA_HOME%/webapps/LORS/DB/lors.gdb


where LORS is the root directory of my project and lors.gdb is the interbase db file. if I write:

hibernate.connection.url = jdbc:firebirdsql://localhost/c:/programmi/jakarta-tomcat-4.1.24/webapps/LORS/DB/lors.gdb

all works well, but this will not work on other machine where tomcat is located under another direcotory.

where is my mistake?
Thanks

PS I'm using win xp

I don't think such things as %CATALINA_HOME% get automatically replaced in the hibernate.properties. You will have to figure out how to configure this programmatically.

ps: When using firebird 1.5. there is an alias feature, with it you can avoid hardcoding the file path in the connection URL.

can you tell me more about this feature, please?
but in the hibernate.properties what I should write in this case?

Don't know, read the release notes for Firebird 1.5. I have never used database aliases. You have to hardcode the jdbc url in the properties file, dynamically inserting Environment properties surely does not work.