Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
ojdbc14_10.2.0.4.jar
Exlipse Version: 3.4.0
org.hibernate.eclipse.* 3.2.2.200808070657-nightly (and previous versions)
it is impossible to tell the hibernate
reverse engineer system only to take the user_objects of one user/schema.
with this hibernate.cfg.xml (with Oracle10gDialect,Oracle9Dialect,OracleDialect) it shows nothing:
<?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>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST=xxx ) (PORT = 1521)) (LOAD_BALANCE = no) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))</property>
<property name="hibernate.connection.username">myuser</property>
<property name="hibernate.connection.password">mypass</property>
<property name="hibernate.default_schema">myuser</property>
<property name="hibernate.use_sql_comments">false</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">50</property>
</session-factory>
</hibernate-configuration>
with this config it reads the schema-info of the 10g for ever, because
the 10g has some big XML schemas (XDB) ...
<?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>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST=xxx ) (PORT = 1521)) (LOAD_BALANCE = no) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))</property>
<property name="hibernate.connection.username">myuser</property>
<property name="hibernate.connection.password">mypass</property>
<property name="hibernate.use_sql_comments">false</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">50</property>
</session-factory>
</hibernate-configuration>
if i break the network-connection, i get a JDBC exception and in the hibernate configuration Database, i see some schemas (and the schema i want), but in the reverse engineering editor this trick does not help.
how can i reduce the schemas to that one i want, so that only the
user_objects and not the dba_objects are taken from the db?
thanks for info.
regards.
|