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
Code:
<?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
http://www.m-itc.net