Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Eclipse - JBoss (Hibernate) tools not showing any tables
PostPosted: Wed Jul 13, 2011 3:18 am 
Newbie

Joined: Tue Jul 12, 2011 1:04 pm
Posts: 1
Hi,

I want to use JBoss tools in Eclipse to generate java code from DDL.
I am using the following:
Oracle XE
Eclipse Helios (SpringSource version)
JBoss Tools

I've configured the hibernate.cfg.xml (as below) and created a sample application to insert and update records in XE and it works fine.

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>
        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
        <property name="hibernate.connection.username">admin</property>
        <property name="hibernate.connection.password">admin</property>
        <property name="hibernate.default_schema">users</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        <mapping resource="users.hbm.xml"/>
    </session-factory>

</hibernate-configuration>


But when I select (in hibernate perspective) File->New->Hibernate console configuration, I get the following in the "Hibernate Configurations" window:
Code:
-Console
    +Configuration
    +Session Factory
    +Database


Expanding the "Database" above shows "pending" for few seconds and then shows nothing. I expecting it to show the table names. I am struggling to find out the reason. There are no exceptions\errors in any of the log files, nothing on console, all XE services are running, hibernate configuration is correct because my sample app works.

While creating the "console configuration" I created a new database connection and have done the "Test connection" and it shows "Ping successfully" message. I've used the following in the configuration:

Code:
hibernate.connection.url           jdbc:oracle:thin:@localhost:1521:xe
hibernate.dialect                           org.hibernate.dialect.Oracle10gDialect
hibernate.connection.driver_class   oracle.jdbc.OracleDriver


Any help is appreciated. Thanks.


Top
 Profile  
 
 Post subject: Re: Eclipse - JBoss (Hibernate) tools not showing any tables
PostPosted: Tue Jul 19, 2011 9:18 am 
Senior
Senior

Joined: Tue Aug 04, 2009 7:45 am
Posts: 124
Try to remove <property name="hibernate.default_schema">users</property>
If now it shows the database, may be you need to use USERS instead.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.