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