1. MS SQL Server generated SQL failure forum.hibernate.orgI am running Roller ( http://www.rollerweblogger.org ) on WebSphere Application Server 5.1.1 using MS SQL Server as the roller datasource. One of the roller tables is named rolleruser, but the Java object related to this table is just called user. SQL Server is complaining about the use of the name "user" as a table identifier in the Hibernate-generated SQL (see below); ... |
2. Use user defined SQL functions (MS SQL Server 2000) forum.hibernate.orgHibernate version: 3.0.5 I want to use a Microsoft SQL server user defined user function from Hibernate, in HQL statement in a report query. Code between sessionFactory.openSession() and session.close(): Query theQuery9 = session.createQuery("select dbo.funDecrypt(df.ccriteria3Dfr,'ABCDEFGH') from DataformIrmdfr df"); Full stack trace of any exception that occurs: java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.MethodNode +-[METHOD_CALL] MethodNode: '(' | \-[METHOD_NAME] SqlNode: 'exprList' | +-[DOT] ... |
3. MS SQL Server and SQL Profiler cant see sql statements forum.hibernate.orgI am getting complaints from our DBAs that they cannot turn on the sql profiler like they normally do and view the sql statements coming across from our app which is using hibernate. Everything just shows as a sp_prepare. Has anyone figured out a workaround for this?? What I am doing now is turning on tracing in our app and shipping ... |