[Vishal kumar Singh]

i created tables in oracle and all have related sequence to their ID(primry key).

But the problem is when ever i do the reverse engineering with hibernate it creates same name tables (but all names in capital letters like i have Contact table then it creates table with CONTACT in caps).

is it a bug or m i doing something wrong?????

please help.

[support-shalini]

Vishal,
I could not replicate this at my end. Can you give some more information?
1. Can you copy paste your installation details from MyEclipse > Installation Summary > Installation Details?
2. What is the version of Oracle that you are using and what are the jar files you are using?
3. Can you list out the steps in detail, the reverse engineering process you followed.

[Vishal kumar Singh]

hi,

oracle 10g
myeclipse 7, 8( persists for both)

basically the problem is occuring when ever i am trying to do something on the database.

check the snap shot

@support-shalini wrote:

Vishal,
I could not replicate this at my end. Can you give some more information?
1. Can you copy paste your installation details from MyEclipse > Installation Summary > Installation Details?
2. What is the version of Oracle that you are using and what are the jar files you are using?
3. Can you list out the steps in detail, the reverse engineering process you followed.

[support-shalini]

Vishal,
Your issue is not clear. Can you list out the steps in detail to replicate the issue? This will help me replicate the issue internally.
Also, please give us your installation details from MyEclipse > Installation Summary > Installation Details.

[Vishal kumar Singh]

see, the thing is like… i installed the oracle and myeclipse then i went to “MyEclipse Database Explorer”prespective with oracle thin driver made the connection with my database…. now i did the Reverse engineerring (till here i have tables with Title case only – verify in above pic ) by selecting the tables. now as soon as i try to insert the data through hibernate i get these extra tables( with table names all cappital letter). (in the pic u can seee 2 tables one with all letter caps and other with title case. the title casse tables are correct and the other cpital case letter table names are incorrect)

*** Date:
Tuesday, March 2, 2010 3:02:25 PM IST

** System properties:
OS=WindowsVista
OS version=6.1.0
Java version=1.5.0_11

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 7.0 Milestone-2
Build id: 7.0-M2-20080915

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 7.0 Milestone-2
Build id: 7.0-M2-20080915

Eclipse Project SDK

Version: 3.4.0.v20080522-7O7S-CHEp2gcoGjmFFomLz-d5M8NdvuPgDrH17jw0Mvhe
Build id: I20080617-2000

Eclipse Platform

Version: 3.4.0.v20080610-9I96EhtEm-T_5LxIsybz-3MdGZmOA3uwv7Ka_M
Build id: I20080617-2000

Eclipse Java Development Tools

Version: 3.4.0.v20080603-2000-7o7tEAXEFpPqqoXxgaBhhhq
Build id: I20080617-2000

Eclipse Graphical Editing Framework GEF

Version: 3.4.0.v20080115-677-8082A5696H274A
Build id: 200806091334

Eclipse RCP

Version: 3.4.0.v20080324a-989JERhEk-jWnd5IY8K5tjxB
Build id: I20080617-2000

Eclipse Plug-in Development Environment

Version: 3.4.0.v20080603-7T7U-E_EkMNrNKb39WcMC
Build id: I20080617-2000

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
D:\Genuitec\MyEclipse 7.0 M2\eclipse\eclipse.exe
-name
Eclipse
–launcher.library
D:\Genuitec\MyEclipse 7.0 M2\eclipse\plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.100.v20080509-1800\eclipse_1114.dll
-startup
D:\Genuitec\MyEclipse 7.0 M2\eclipse\plugins/org.eclipse.equinox.launcher_1.0.100.v20080509-1800.jar
-exitdata
1148_5f0
-clean
-vm
D:\Genuitec\MyEclipse 7.0 M2\jre\bin\javaw.exe

[support-shalini]

Vishal,
Can you share your project? Please send your project to support@genuitec.com. Please add ATTN:Shalini in the subject and refer to this post.
Also, can you clarify if you have checked “Enable dynamic DB table creation” when adding hibernate capabilities?
Please send us the script of the table you are using along with the project.
This will help me replicate the issue internally.

[Vishal kumar Singh]

yes that i did that time.

[Vishal kumar Singh]

yes that i did that time. now if that is an issue how to uncheck that.

[support-shalini]

vishal,
Can you try removing <property name=”hbm2ddl.auto”>update</property> from hibernate.cfg.xml
and check if that works for you?

[Vishal kumar Singh]

but i guesss…….. myeclipse is not made for handling oracle as it is not been able to parse the given below query. Plz clarify???

select * from “COMSSADMIN”.”Role”;
insert into “COMSSADMIN”.”Role” (RoleID, RoleName, RoleDescription) values(default,’HR’,’Human Resource’);

where i have a sequence attach to this first coloumn RoleID.

the problem comes here i guess “COMSSADMIN”.”Role” as it is not been able to consider the double quotes.
hope u can understand my probs.

[support-shalini]

Vishal,
Can you please share your project? You can send a mail to support@genuitec.com. Please add ATTN:Shalini in the subject and refer to this post.
This will help me replicate the issue internally.
Also, attach the required scripts.
Thank you

[Author]

Posts