Hello,

I am having trouble getting data from views in MS SQL Server. I mapped the view correctly, using a unique field as the key. And all I am trying to do is pull data from it using the find() method. No tricky where clause or anything. Just trying to pull everything out.

It doesnt' work. I tested it using an actual table, and it worked fine, but not when it is a view.

I am using MS SQL Server, and Merlia driver.

Anyone have this problem before? Suggestions?

Here is the error I'm getting:

2003-12-15 15:10:13,871 [Thread-6] WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 7391, SQLState: 01000
2003-12-15 15:10:13,871 [Thread-6] ERROR net.sf.hibernate.util.JDBCExceptionReporter - [SQLSERVER]The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.
2003-12-15 15:10:13,891 [Thread-6] ERROR net.sf.hibernate.util.JDBCExceptionReporter - Could not execute query
com.inet.tds.SQLException: Msg 7391, Level 16, State 1, Procedure CPRO_PROJECTS, Line 3, Sqlstate 01000
[SQLSERVER]The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.b.try(Unknown Source)
at com.inet.tds.b.executeQuery(Unknown Source)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:62)

I am having the same problem. Does anyone have any suggestions?

Have you tried the jTDS driver?

I am using NHibernate. I just thought I'd add a reply to this post in case there was a common solution between NHibernate and Hibernate. I've done some research and it appears as though on Windows 2003 server the Distributed Transaction Coordinator (DTC) service is disabled by default. I'll post a reply once I've had some time to test whether enabling it fixes the problem.

i'm having a similar problem too. i am using SQL Server 2000 on Windows XP. i have a view on the SQL Server accessing tables on another SQL Server on another computer. Funny enough, my other views are working except for one of them. And the logic is almost identical. I am considering deleting the view and recreating it.

meanwhile, any progress with you guys? Thanks in advance.