1. Hibernate: Parse/Translate HQL FROM part to get pairs class alias, class name stackoverflow.comCan anyone point me out, how can I parse/evaluate HQL and get map where key is table alias and value - full qualified class name. E.g. for HQL SELECT a.id from ... |
2. Hibernate, aliases stackoverflow.comI noticed that hibernate generates different aliases for the same columns each time i try to access the same table:
|
3. Hibernate sort by properties of inner bean? stackoverflow.comIn my domain model I have following Classes.A 'UserProfile' has one 'SecurityPrincipal'
|
4. Error in creating alias in formula tag stackoverflow.comI have a sql query in formula tag inside property tag. In that query i am creating alias name but the hibernate appends table name and throwing me error. select sum(e.salary) as sal ... |
5. Is it possible to get the SQL alias of a join table for a Hibernate sqlRestriction? stackoverflow.comI have a Person class which has a String collection of aliases representing additional names that person may go by. For example, Clark Kent may have aliases "Superman" and "Man ... |
6. Hibernate criteria -- alias stackoverflow.com
OrderDetail
|
7. Hibernate criterion Projection alias not being used stackoverflow.comDo Hibernate Projection aliases even work? I could swear it just doesn't. At least, it doesn't do what I would expect it to do. Here is the java:
|
8. Java and Hibernate - HQL aggregate alias stackoverflow.comI am trying to write a simple HQL query with an aggregate function and getting an error. Please help. I have 3 entities Order, OrderItem and Product with the following relationships:
|
9. Configuring OpenJPA 1.3.1 with EhCache: plugin/alias not found stackoverflow.comI'm trying to configure ehcache with openjpa. I get the following error:
|
10. How to tell EclipseLink to use full table names for aliases in SQL stackoverflow.comEclipseLink normally generates SQLs like:
Is it possible to tell EclipseLink, that it should use full table names for aliases to ... |
11. Hibernate Mapping generates Error in Grails for Column with Alias "h002-01" stackoverflow.comIm trying to implement mapping in grails over hibernate for a table which has special characters in columne names. i.e "-" Mapping in Domain Class
|
12. How can I specify a column alias in HQL so I can use AliasToBeanResultTransformer with Count stackoverflow.comUsing NHibernate, I would like to run the following query:
|
13. Hibernate get data from joined table stackoverflow.com
|
14. rownum & aliasing in HQL stackoverflow.comNeed help... how to translate this SQL query to HQL :
|
15. Hibernate HQL is failing on alias ordering stackoverflow.comI have this query in hql:
|
16. jpa criteria query - Duplicate definition of alias error stackoverflow.comI've a war application using hibernate-jpa 2.0, SiteListig is my entity, I want to make a criteria query, my code looks like:
|
17. Hibernate - Use native query and alias to Bean with enum properties? stackoverflow.comI am having trouble using a native query in hibernate to alias a bean that contains enum properties. I am getting an InvocationTargetException when query.list() is called. My ... |
18. Is JPA validation supported for table aliases in Rational Developer 7.5/Eclipse? stackoverflow.comI have a set of database tables that are referenced by JPA entities in RAD 7.5. When I set the JPA schema for validation to the schema where the tables ... |
19. alias for expressions in hql queries stackoverflow.commy Hibernate version is 3.2.6.ga Googling around reveals many people are having the same problems with Hibernate HQL not handling aliases very well. Apparently HQL only lets you alias a column that exists ... |
20. Hibernate HQL Alias Issue stackoverflow.comMainTable.java extends Common.java private Long id ; private Long version ; private String name ; private SubTable sub ; SubTable.java extends Common.java private String subname ; prviate String dualname ; Common.java private Long id ; prviate Date createDate ; HQL v String ... |
21. Query using alias on column give an error stackoverflow.comWhen i use alias for column i get error. Without alias everytinig works good. What is the problem with that ? This is simple example, but need to use more aliases ... |
22. Duplicate definition of alias on query stackoverflow.comI'm having the a problem with a simple jpa criteria query which is producing the following exception
|
23. Hibernate alias - is it normal to still do the n+1 selects? stackoverflow.comI have a very specific 2 part question, which I really really hope hasn't been asked before:) First the context I have some Hibernate beans with lazy associations between them such as: @Entity public class ... |
24. Join an association multiple times with different aliases stackoverflow.comI think, that the problem that i have is a bug in Hibernate (already tracked - https://hibernate.onjira.com/browse/HHH-879 ). My question is - Is there a workaround to join a table ... |
25. NHibernate QueryOver with sub-query and alias stackoverflow.comI'm struggling to convert the following (simplified) HQL to QueryOver:
|
26. Referencing outer criteria query aliases from within an SQLProjection stackoverflow.comI am aware that you can use
What I am trying to do is to ... |
27. HQL alias in delete query stackoverflow.comI want to know hql analog for SQL:
Thanks.
|
28. Adding alias to column name breaks createSQLQuery in Hibernate stackoverflow.comI have a following query that works:
|
29. Hibernate: How To Alias a Column for a Non-Entity Sql Query? stackoverflow.comAll, Does anyone know how I can direct the SqlQuery class to use aliases for columns returned on a Non Managed Entity query? I'm attempting to use the SqlQuery Hibernate class to create ... |
30. table/column alias with hibernate coderanch.comI am hoping that someone can be of help to me as the Hibernate guys are NOT very keen on helping. So here goes: When I generate the property element, I use the column attribute foe the actual valid column name and the name attribute to store the original name that corresponds to my application. Now this work 100% However, when ... |
31. Aliases Support in HQL coderanch.com |
32. how to select c.field as alias in JPA coderanch.comHi Everybody how to write query in JPA-QL. My query is "select c.nameenglish as student, count(m.contact) as messagecount from Message m , Contact c where m.contact=c.id " group by contact order by messagecount desc"; but I am getting error in parsing [as]. Any solution or idea to solve this problem is appreciated |
33. hibernate undefined alias : 1 error coderanch.comHi all, I am new to hibernate . When i run the below HQL i get undefined alias : 1 erorr 1> Error : HQL : "select distinct mct.Col, mct.mctIss ,mct.mctChe, mct.mctCli,mpl.mplAd,mct.mctShp, mct.mctRef, mpl.Par from MPDTO mpl, MADTO maa, MCDTO mct where mct.mctAd = maa.Ad and maa.Ad = mpl.Ad and mpl.mplSpo = 'GREP' and mct.mctCol ='335' and not exists ( select ... |
34. Hibernate-Criteria: Group by column alias coderanch.comHi! I'm tring to perform a query where I need to group by a column alias, but I'm not able to do it. My code is: projL.add(Projections.sqlGroupProjection("month(dataServei) as month, year(dataServei) as year", "month, year", new String[]{"month", "year"}, (org.hibernate.type.Type[]) new Type[]{Hibernate.INTEGER, Hibernate.INTEGER})); The code works perfectly using just a sqlProjection, without doing the grouping, so it has to do with the grouping. ... |
35. hibernate undefined alias : 1 error coderanch.com |
36. Question about Hibernate Aliases coderanch.comHi Mr. Srinivas, Hope that all is well. I have a question regarding Hibernate using aliases. I found a problem when trying to use a hash map to specify an alias that has more than two levels. For example, if I have a composite id in an object as id of that class type. Then definining the alias is ok as: ... |
37. Problem using alias for columns in a query JPA coderanch.comHello, I am having some problems with a query that I am trying to use in my JEE project. This query doesnt return an entity but a group of values. I created a class representing the result and a query with the jpa constructor expression but it is not working. The problem is that in the query I added some alias ... |
38. Hibernate SQL query column alias coderanch.com |
39. JPQL: SELECT queries and field aliases. coderanch.comHi!: I've a very simple question. I've been re-reading "The Java EE 6 Tutorial", specifically the section about the Java Persistence Query Language (JPQL). I've got surprised to see no mention about the use of aliases for entity fields on SELECT queries. It only mentions aliases for entity names. Although I know that field aliases are perfectly valid on several JPQL ... |
40. HSQL Select column AS Alias - java.sql.SQLException forum.hibernate.org |
41. Hibernate generates Alias in Where clause forum.hibernate.orgHi all, I have problem when trying to make a query with HibernateCriteria. Without a projection, everything went fine. However, when I applied a projection on the criteria, the query failed because Hibernate generated a query with alias (same as specified in the projection) in WHERE clause. Has anyone faced this? If yes, could you please point me out how to ... |
42. Can hibernate order queries by the alias? forum.hibernate.org |
43. SQL alias & createNativeQuery forum.hibernate.orgIs there any example how to use SQL alias whit Hibernate, the problem is when retrieving result. I have two columns with same name and Hibernate doesn't right value. Code: String sql = "SELECT uporabniki.id, status.vrednost, host.vrednost " + "FROM uporabniki " + "LEFT JOIN sif_upostat AS status ON status.id=uporabniki.status " + "LEFT JOIN cluster_hosts ... |
44. How to apply and restriction on alias forum.hibernate.org |
45. alias non root entities in SQL Criteria forum.hibernate.org |
46. Criteria eager fetching of collection with alias forum.hibernate.orgDears, I have a 1:n relation between tables A and B, and I added a restriction to B and want to fetch A and B it eagerly, the question would be what happens when I want to navigate from A to B. Should you only see the data in B that matches the restriction, or should you see all Bs that ... |
47. How to alias annotated class forum.hibernate.org |
48. Table name alias not added to column forum.hibernate.orgHi I have recently started using Hibernate 3.5.0-CR-2. I've found a problem that didn't exist when using 3.31.GA Some of our database tables contain Oracle spatial data. One in particular has two columns for longitude and latitude, GEOM.SDO_POINT.X and GEOM.SDO_POINT.Y The problem is that the table alias is not added to the column name due to isIdentifier method in the Template ... |
49. Criteria doesnt work without Alias forum.hibernate.org@Entity @Table(name = "VIEW_MENU_ITEM") public class MenuItem { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") private Long id; @Column(nullable=false,name = "ITEM_LABEL") private String label; @Column(nullable=false,name = "TARGET") ... |
50. Column alias trouble forum.hibernate.org |
51. Using an alias in a formula tag forum.hibernate.orgselect userimpl0_.PERSON_ID as PERSON1_2_0_, userimpl0_.WEB_USERNAME as WEB5_2_0_, userimpl0_2_.USERNAME as USERNAME4_0_, coalesce(lower(userimpl0_.WEB_USERNAME), lower(userimpl0_.USERNAME)) as formula0_0_, from PERSONS userimpl0_ left outer join STUDENTS userimpl0_1_ on userimpl0_.PERSON_ID=userimpl0_1_.PERSON_ID left outer join APPLICATION_USERS userimpl0_2_ on userimpl0_.PERSON_ID=userimpl0_2_.PERSON_ID where userimpl0_.PERSON_ID=? ... |
52. SQL Queries and Column Aliases forum.hibernate.orgSession session = (Session) getJpaTemplate().getEntityManagerFactory().createEntityManager().getDelegate(); SQLQuery sqlQuery = session.createSQLQuery(query); List |
53. Using column alias throws exception in hibernate.SQLQuery forum.hibernate.orgHi, I have recently migrated my application from JCONNECT 5.5 to JCONNECT 6.0. I am using SYBASE ASE 5.5 database. The problem is that I found that the underlying sql's using 'org.hibernate.SQLQuery createSQLQuery(..)' method do not work if the query contains aliasname / label for the column name. For example: Query qryObj = getSession().createSQLQuery("select noe.NoeId, noe.NoeDestinationType, noe.NoeCondition, adapter.AdapterName as Name, noe.RegionBitMask, ... |
54. Unable to pass class parameter in JPQL TYPE(alias) function forum.hibernate.orgCaused by: java.lang.UnsupportedOperationException: At the moment this type is not the one actually used to map the discriminator. at org.hibernate.persister.entity.DiscriminatorType.nullSafeSet(DiscriminatorType.java:111) at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:67) at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:567) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1612) at org.hibernate.loader.Loader.doQuery(Loader.java:717) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2294) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172) ... |
55. Hibernate doesn't seem to support alias in select statement. forum.hibernate.org |
56. HQL: aliases in select cannot contains spaces? forum.hibernate.org |
57. Aliases of generated SQL forum.hibernate.org |
58. getting alias names in hibernate criteria api? forum.hibernate.orgturns out if your columns don't conflict, you can just type in the column names before aliasing. I didn't think that would work since all the columns were aliased to different names from hibernate but it seemed to work this time. I wonder how to do this if you want to get the hibernate alias name so you can specify table1alias.column ... |
59. alias on Criteria forum.hibernate.org |
60. HQL aggregate - alias forum.hibernate.orgNewbie Joined: Mon Jun 21, 2010 1:36 pm Posts: 14 Hi all, I am trying to write a simple HQL query with an aggregate function and getting an error. Please help. I have 3 entities Order, OrderItem and Product with the following relationships: Order --> OrderItem (One to many bi-directional) OrderItem --> Product (Many to one Uni-directional) At a high level, ... |
61. Criteria alias changes Outer join to inner join forum.hibernate.orgNewbie Joined: Tue Jun 29, 2010 1:35 pm Posts: 3 Hi, Iam using Hibernate 3.0.5 and JDk 1.4. What iam tryin gto achieve is to create an alias for unidirectional Many-to-one association. I want it to perform an outer join which it does as long as i dont use createAlias in my Criteria query. Can you please help me out with ... |
62. [HQL] Aliases get lost after query is created forum.hibernate.org |
63. [INVALID ALIAS ON ORDER BY] forum.hibernate.orgNewbie Joined: Sat Sep 08, 2007 10:40 am Posts: 2 Hey Guys, I'm having a problem with order by on hibernate I need to order by a sub-query aliased field but it is not using the proper alias so the sub-query aliased participants is generating a different sql alias for the selection but not for the sort by (which remains as ... |
64. short column name alias forum.hibernate.orgwhwnever i do a select on a table, i see a huge select statement with table name alias and column name alias for each column. this is causing bandwidth issues with database, it just carries unnecessary baggage. i can understand why they are doing, if we join 2 table there could be issue with column names being repetead but is there ... |
65. Dynamically Creating Criteria Join Queries W/o Using Aliases forum.hibernate.orgHi, I am new to Hibernate and currently having a problem with creating search query dynamically using Criteria API. I want to know whether we can write multi-join queries in criteria without using aliases, as its really difficult to dynamically to identify the field and apply alias against it to be able to access it in projections list. Thanks...in advance....... Sumit ... |
66. how to apply "in" condition with two table alias properties. forum.hibernate.orgExpression.in(property, values) : supports for comparing property with collection of values provided. we have the methods Expression.geProperty, leProperty & eqProperty...etc, supports the greater than, less than, equal to comparisions between two alias properties. But i need to compare two alias properties with "in" operation like below given example. example: DetachedCriteria crit = DetachedCriteria.forClass(Prospects.class); crit.createAlias("regDocs.documentType", "docType"); crit.createAlias("docType.docRequirement", "docReq"); "status" is a string ... |
67. Hql table aliases.......... forum.hibernate.orgHi, Here's my code: String sqlQuery = "select CE.* from table CE"; sqlQuery += " where name = :name1"; Query query = sess.createSQLQuery(sqlQuery,"CE",t1.class); query.setParameter("name1", name1); This throws an error : net.sf.hibernate.exception.SQLGrammarException: error performing findBySQL Is this because I am setting alias to table but in where clause I am directly using column name without the alias name. So is it compulsory ... |
68. Avoiding duplicate aliases forum.hibernate.orgHi, I'm using Hibernate 3.2.6. I have a search form in a web app which has lots of fields, they're all optional so you can search for something in many ways. Behind this, I have a method with lots of if statements that say things like "if this field isn't empty then add this criterion". I sometimes need to use Criteria ... |
69. SQL name alias in a clustered environment forum.hibernate.orgHi, We are using hibernate on a application that is running on a clustered environment, and I was wondering if there was a way to get hibernate to always use the same SQL alias in its query. The issue right now is that Hibernate on different member of the cluster will generate different alias, which is according to our database different ... |
70. Problem with table alias in Hibernate 3.6.0Final forum.hibernate.orgHi every one, I have a problem with table alias in subquery. I think that it's a bug in Hibernate 3.6.0 Final. This is my HQL query: Code: insert into Item_Tag(itemId, tagId) select item.id, tag.id from Item item, Tag tag where item.identifier like :identifier0 and tag.id in (:tagIds) and not exists (from Item_Tag where itemId = item.id and tagId = tag.id) ... |
71. Column Alias in hibernate native query forum.hibernate.orghi friends, Can we use column alias in a hibernate native sql query, i found we cannt , if we do we have to use addScalar function and give the type of column we want to return, the problem with this is we have to change the code if we alter the structure of the table, Also i found we cannt ... |
72. Problem with Column Name and Column Alias. forum.hibernate.orgHello, I have a problem when i want to execute a native SQL query with JPA - Hibernate. When some aliases are define for column, i get an error like this : "Caused by: java.sql.SQLException: Invalid column name". After some search, i found that Hibernate was sending the column name ("CODE") when the ResultSet expected to get the column alias ("aliasCode"). ... |
73. Does projections aliases work with Derby? forum.hibernate.orgCaused by: ERROR 42X04: Column 'Y1_' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'Y1_' is not a column ... |
74. Bug in grouping SQLQuery without aliases? forum.hibernate.org public |
75. Problem with query with alias for property forum.hibernate.orgHi, I have a problem with the below query, Caused by: org.hibernate.QueryException: , expected in SELECT [SELECT s.id AS id, s.status AS status, s.firstName AS companyName FROM Student AS s ORDER BY s.firstName asc] What would be the problem with the query ? The same query works fine when I remove the aliases been given for the properties. Meaning: SELECT s.id, ... |
76. ResultTransformer without alias forum.hibernate.org |
77. Unknown HQL return alias "currentTask" forum.hibernate.org |
78. Unknown HQL return alias "currentTask" forum.hibernate.org |
79. get aliases when running sql queries forum.hibernate.orgHi, I'm using hibernate (3.3) to work against a legacy schema. I am running sql queries like this, for example: Code: Query query = getSession().createSQLQuery( "select st.description \"The Description\", st.value \"The Value\" " + "from some_table st"); List list = query.list(); Don't ... |
80. native SQL queries in hibernate don't work when using alias forum.hibernate.org |
81. Query alias in generated SQL forum.hibernate.orgHi, i have a question about using an alias in a query. I use the following simple query: Code: session.createQuery("select this_ from WheelStorage as this_ where this_.customer.id = :customerId") .setParameter("customerId", customer.getId()) .list(); The problem is that in the generated SQL the alias this_ is not used. Here are the logs: Code: 14:30:52,340 INFO ... |
82. Current table alias in Filter ($FILTER_PLACEHOLDER Hack) forum.hibernate.org |
83. need help with alias for expressions in hql queries forum.hibernate.orgmy Hibernate version is 3.2.6.ga Googling around reveals many people are having the same problems with Hibernate HQL not handling aliases very well. Apparently HQL only lets you alias a column that exists in a table. Also, HQL generates its own aliases for all columns in the query and these have the form col_x_y_. I've set my jdbc properties to show_sql=true ... |
84. Result column aliases forum.hibernate.orgI have been using Hibernate 3.3 with success by mapping 1 (one) database table to 1 (one) entity class automatically by using HQL query. In my new project however, I am using a native SQL query that is fetching data from 4 different tables. (I will use stored procedures and functions in the future, that's why I need the native SQL ... |
85. undefined alias error on query field forum.hibernate.orgI have the following query using one field with a 'distinct' keyword: lst = sess.find("select distinct region from us.ut.state.dced.museums.MuseumMain as museumsmain order by region"); It works fine if I start with the word "from", but selecting one field gives me this error: net.sf.hibernate.QueryException: undefined alias: DISCIPLINE [select distinct DISCIPLINE from us.ut.state.dced.museums.MuseumMain as museumsmain order by dicipline] What would be the alias ... |
86. Error: undefined alias: de [.... forum.hibernate.orgHi, I'm using JBoss 3.0.3 with Hibernate 2.1beta3 and Struts 1.1. When I'm running a JSP that executes the Action LoginAction.java, I get the following error: javax.servlet.ServletException: undefined alias: de [FROM de.hibernatemysqltest.User user WHERE (user.userName=? AND user.password=?)] Here is the relvant part of the LoginAction.execute method (I've put some outputs inside. Some notes after the code snippet): Context ctx = new ... |
87. Column names truncated into short aliases by QueryTranslator forum.hibernate.orgWhen I retrieve a "Table" object using session.find(), and it subsequently gets updated back to the database (even though I do not make any change to the table object anywhere). I get a "Attempt to insert NULL value into column 'DESCRIPTION', table 'clientdb.dbo.CDB_TABLE'" error as a result.. I can explain why Hibernate thinks the object is dirty: when I do the ... |
88. hql generated sql additional feature on aliases forum.hibernate.org |
89. undefined alias: decode forum.hibernate.org09:20:59,703 INFO [STDOUT] Hibernate: select nego.stk_no as stk_no0_, equity.stk_name as stk_no1_ from cbotctrad as nego, te.testmb as equity where nego.stk_no = equity.stk_no 09:20:59,781 WARN [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000 09:20:59,781 ERROR [JDBCExceptionReporter] ORA-00933: SQL command not properly ended 09:20:59,797 WARN [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000 09:20:59,797 ERROR [JDBCExceptionReporter] ORA-00933: SQL command not properly ended 09:20:59,797 ERROR [JDBCExceptionReporter] SQLException occurred ... |
90. strange hsql error : undefined alias: from forum.hibernate.orgI have this exception when I do the following query : Code: public IndexEditionValeur read(String numCle,Session session) throws HibernateException { IndexEditionValeur indexEditionValeur = null; IndexEditionPersistent indexEditionPersistent = null; IndexEditionTransform transformer = new IndexEditionTransform(); try { String queryString = "select ... |
91. How to get aliases from the hibernate api forum.hibernate.org |
92. Alias length forum.hibernate.orgIn Hibernate2, the problem of aliases that are too long is supposed to be solved by the Alias class. However, unless a max length is passed in it uses Integer.MAX_VALUE which is huge! What is the best way to implement a max length if your database has a restriction? I could just change that default constructor but it seems like there ... |
93. Aliases for joined tables don't work forum.hibernate.org |
94. "AS" before column aliases in select clause forum.hibernate.orgI'm using Hibernate in a WebLogic - DB2/VSE environment. I noticed that the SQL generated by Hibernate always contains "as" before column aliases in the select clause. This seems not to be supported by our version of DB2/VSE (mainframe): Hibernate: select paritairco0_.TAAL_CODE as TAAL_CODE0_, paritairco0_.CPGM_NAAM as CPGM_NAAM0_ from CB.T170TAAL paritairco0_ where paritairco0_.TAAL_CODE=? The db2 driver returns an error: [WARN] JDBCExceptionReporter - ... |
95. Removing alias forum.hibernate.orgHello, is there a way to remove the using of aliases in SQL Selects? I want it because its is causing some conflicts in two many-to-one mappings in the same hbm that uses the same column names. Example: Code: |
96. How to use {fn ...} and "undefined alias" problem forum.hibernate.orgHello, I am trying to select a list of unique dates from a table, and I want those dates rounded to a day. Example: 2004 2003 .... I am trying to use the following HQL: Code: Query q = ses.createQuery("select " ... |
97. "undefined alias: null" in SELECT clause forum.hibernate.orghi, I've got a class myClass having a constructor public new myClass(Object arg0, Object arg1, Object arg2). I'm trying to select sth from my DB and have a result in the instances of myClass. let's assume I've got my_table in the DB, havin 3 fields If I do SELECT new myClass(t.f1, t.f2, t.f3) FROM myTable AS t then it works, but ... |
98. fetch join with alias forum.hibernate.org |
99. ORA-00911: invalid character, for Hibernate generated alias forum.hibernate.orgHibernate generates the folloging query: select _u.user_group_id as x0_0_ from LTDS.USERGROUP _u where (_u.name='argosys' ) (Oracle version 9i, Hibernate 2.1.2) Oracle reports ORA-00911 error code, Invalid Character. If I remove the underscore on table alias and paste the following query into SQL*Plus it works: (Fails as well with '_' in SQL*Plus) select u.user_group_id as x0_0_ from LTDS.USERGROUP u where (u.name='argosys' ) ... |
100. isNull in select clause: undefined alias? forum.hibernate.org |