[Pontus Amberg]

I think I might have encountered a minor problem in 5.5.0 Milestone 2.

I’m playing around with a JPA enabled project and after enabling database metadata analysis I get an error reported in the problems tab for this line

@Table(name=”[User]”)

and the message is

“The table [User] cannot be found in the database”

The error is correct in a way since the table is named “User”. The problem is that “USER” is a reserved word in MS SQL Server and I need to enclose the table name with “[]” to be able to access the table. I can run the project and everything seems to work fine and its just the database metadata analysis that fails when a table name is enclosed with “[]”.

An easy solution would probably be to rename the table but that’s not a viable option in my case.

Any suggestions for other ways around this problem?

/Pontus

*** Date:
Wednesday, May 2, 2007 5:11:39 PM CEST

** System properties:
OS=Linux
OS version=2.6.20-1.2933.fc6
Java version=1.6.0

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 5.5.0 Milestone 2
Build id: 20070409-5.5.0-Milestone2

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 5.5.0 Milestone 2
Build id: 20070409-5.5.0-Milestone2

Eclipse Project SDK

Version: 3.2.2.r322_v20070104-dCGKm0Ln38lm-8s
Build id: M20070212-1330

Eclipse Platform

Version: 3.2.2.r322_v20070119-RQghndJN8IM0MsK
Build id: M20070212-1330

Eclipse RCP

Version: 3.2.2.r322_v20070104-8pcviKVqd8J7C1U
Build id: M20070212-1330

Eclipse Plug-in Development Environment

Version: 3.2.1.r321_v20060823-6vYLLdQ3Nk8DrFG
Build id: M20070212-1330

Eclipse Java Development Tools

Version: 3.2.2.r322_v20070104-R4CR0Znkvtfjv9-
Build id: M20070212-1330

Eclipse Graphical Editing Framework

Version: 3.2.2.v20070208
Build id: 20070208-1315

Eclipse startup command=-os
linux
-ws
gtk
-arch
x86
-launcher
/usr/java/eclipse-3.2.2/eclipse
-name
Eclipse
-showsplash
600
-exitdata
4100015
-product
com.genuitec.myeclipse.product.ide
-vm
/usr/bin/java

[Riyad Kalla]

It looks like you caught a bug, thank you for reporting it. We’ll take a look ASAP.

[Pontus Amberg]

This minor annoyance is still available in 5.5GA but I am getting a bit uncertain than it really is a bug. It would be nice to know if it still is considered as a bug or if this is the correct behavior of the database metadata analysis.

/PorkLip

[Riyad Kalla]

PorkLip, we do consider it a bug, but it’s a corner-case bug that got discovered late in the 5.5 cycle and we didn’t get a chance to fix it. I’m sorry.

[Pontus Amberg]

Since its no big problem its ok that it wasn’t fixed in this version.

[Author]

Posts