This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
| Summary: | Provide SQL support inside <query> elements in JPA mapping files (orm.xml) | ||
|---|---|---|---|
| Product: | javaee | Reporter: | terje7601 |
| Component: | Persistence | Assignee: | Sergey Petrov <sj-nb> |
| Status: | REOPENED --- | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | 8.0.1 | ||
| Hardware: | PC | ||
| OS: | Windows 7 | ||
| Issue Type: | ENHANCEMENT | Exception Reporter: | |
This old bug may not be relevant anymore. If you can still reproduce it in 8.2 development builds please reopen this issue. Thanks for your cooperation, NetBeans IDE 8.2 Release Boss Still relevant. |
It would be great if NetBeans would provide SQL support inside <query> elements in JPA mapping files (orm.xml), just as if the query was defined in a .sql file (syntax coloring, parsing & validation, ability to run statements, ...). Ideally, there would also be a "Connection" bar to choose the connection, which should also include the connection from the persistence.xml file (if specified, by using the javax.persistence.jdbc.* properties). A simplified fragment of an orm.xml file with an SQL query inside: <entity-mappings> <named-native-query> <query>select id from employee where active = 1</query> </named-native-query> </entity-mappings>