Hello,

i would like to use Hibernate Tools(HibernateTools-3.2.0.beta9a+Eclipse 3.2) for Reverse Code Generation from a MS SQL 2000 DB.
I have allready working the Reverse Code Generation with the DB but must change the schema to connect to. Here is my hibernate.properties file:
hibernate.connection.username=xxx
hibernate.connection.password=xxx
hibernate.connection.url=jdbc:microsoft:sqlserver://192.168.3.xxx:4433
hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.default_schema=db_cra

Code generation works until i do not set the default schema. But i connect to the wrong db_Schema named "master".
When the default_schema is set, the code Generation starts and keeps open, but nothing happens. Is this a bug?

Could somebody help me?

kind regards

martie

As we have lots of examples of success with reveng MS SQL I would suggest to review your configuration rather than conclude to early that its a bug.
Have you setup the ownership and access rights correctly for the user on that schema?

Hello,
and thanks for your reply. It was not my intention to say that i have done everything right and hibernate has a bug.
Making a Connection to the schema with DriverManager.getConnection(...) works fine, so i supose that i do not have a problem with access rights. Maybe only a parameter is missing in my properties file from above. Seems like Hibernate begins to connect to the database and than hangs up.

I am not very experienced in using hibernate. Does anybody have some advice of how to get on with this problem?

kind regards

martie

I am suddenly doing more sqlserver work at the moment so I will see if I have a moment to try it out. I do not expect to have a problem - normally its an issue in the JDBC driver connection or DB permissions. You might consider coding a small JDBC program to do a few database meta data operations to check the connections and data read by the JDBC connection string. Unfortunately, its hard to sort out remotely.

Hello David,

after i got a tip from a colleague i have found my mistake. With this properties file it works:
hibernate.connection.username=xxx
hibernate.connection.password=xxx
hibernate.connection.url=jdbc:microsoft:sqlserver://192.168.3.xxx:4433
hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.default_schema=dbo
hibernate.databaseName=db_cra

Do you perhaps know who to look up for the schema with MSSQL Database Manger? Is there any other way to find out the schema? It would be interisting for me to know this for further projects.

kind regards

Martin

You can find out all aspects from MS SQL Manager - see ownership, and the user, and dbname - its all there. Use this above DB and see the working details you can then see where they all link together.