Hibernate Community • View topic - Named parameter in SQL From clause: impossible?

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

Named parameter in SQL From clause: impossible?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ultranet

Post subject: Named parameter in SQL From clause: impossible?

Posted: Wed May 23, 2007 7:34 pm

Newbie

Joined: Wed May 23, 2007 7:29 pm
Posts: 2

I'm quite certain it's not possible, but would appreciate a confirmation. I'm going for run-time-generated SQL queries.

Code:

[5/23/07 18:17:18:925 CDT] 00000030 DefaultFaultH E   TRAS0014I: The following exception was logged java.lang.IllegalArgumentException: Parameter schema does not exist as a named parameter in [SELECT m.col1 AS {member.col1}, m.col2 AS {member.col2} 
      FROM :schema.mbr m WHERE
      m.id = :ID 
      FOR READ ONLY with UR]

Thanks.

Top

ultranet

Post subject:

Posted: Wed May 23, 2007 8:26 pm

Newbie

Joined: Wed May 23, 2007 7:29 pm
Posts: 2

What are the advantages of using hibernate in comparison to a plain PreparedStatement? I guess one of the advantages is caching. But on the other hand, a PreparedStatement can be used multiple times for efficiency, whereas this efficiency will be foresaken when using a hibernate-based runtime-generated query, won't it?

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum