Hi all,

I am trying to reverse engineering by business objects from SQLExpress Database found on a remote host.

I have the following configs :

hibernate.cfg.xml



<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="ForecastingSessionFactory">
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.url">jdbc:sqlserver://192.168.2.35\\sqlexpress</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.default_schema">ForecastingAndIventoryV2</property>
<property name="hibernate.connection.password">sa</property>
<property name="hibernate.connection.username">mypassword</property>
</session-factory>
</hibernate-configuration>




I also created a console config where I added the sqljdbc.jar in the classpath


But when i try to look for the tables found in the database using the design view for hibernate.reveng.xml it cannot fetch any !!

I tested my connection to the remote SQLExpress server via a plain JDBC connection and it works.

Can anyone help me out with this


Cheers,
Jankee Yogesh
Software Developer
www.m-itc.net

any errors, logs etc ?

Eclipse does not give any errors ... is there any logs that hibernate tools generate ?

Regards,
Jankee Yogesh
Software Developer
M-ITC LTD

in the error log view should be something if there is an error.

Maybe your db don't allow you to read meatadata without specifying it's catalog/schema first ? do that by setting deault_schema/default_catalog

Already tried that before .... but it did not work .... I completely forgot the error view ... thnx for the tip ... i will try it out when i get back to office .... Have a nice week end ;0)

Regards,
Jankee Yogesh,
Software Developer
M-ITC LTD

Hi, I just successfully reversed engineered from MS SQL Express 2005. The JDBC connection to SQL Express is tricky. By default TCP/IP connections are not enabled and it will select a non-standard port once you do enable TCP/IP. See the SQL Server Configuration Manger for setting up the DB so that you can access it. I also used the sqljdbc_1.2 JDBC driver from Microsoft (type 4). I recommend you do a simple JUnit test to make sure you have the right connection string and then paste that into your hibernate.cfg.xml.

My connection URL looked like something like this

Sometimes geting the JDBC connection correctly working is the biggest hurdle. This should go into the information about target databases so others can benefit [and we can point them to it].

http://www.hibernate.org/383.html