HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed
↓
root cause

org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed
↓
org.hibernate.TransactionException: unable to rollback against JDBC connection

↓
root cause

java.sql.SQLException: SQL logic error or missing database

SQL語句：select name,phone,idcard,nowlive,ofCompany,stationCode,type,status,certificatecode from(
select p.name,p.phone,p.idcard,p.nowlive,p.ofcompany ,p.stationcode ,p.type,p.status,z.CertificateCode
FROM basicperson p join BasicZhengJ z on p.phone=z.phone)

很簡單的子查詢，可以在查詢分析器正確執(zhí)行，放入dao實現(xiàn)類運行就報以上錯誤
求解決！！！

回復(fù)討論(解決方案)

放五一都沒個人了？？？？？？？？？？？？？？？？？？哎

.... (
select p.name,p.phone,p.idcard,p.nowlive,p.ofcompany ,p.stationcode ,p.type,p.status,z.CertificateCode
FROM basicperson p join BasicZhengJ z on p.phone=z.phone) T
需要指定別名

.... (
select p.name,p.phone,p.idcard,p.nowlive,p.ofcompany ,p.stationcode ,p.type,p.status,z.CertificateCode
FROM basicperson p join BasicZhengJ z on p.phone=z.phone) T
需要指定別名

首先感謝版主的問候，其次，我試了沒用，SQL語句沒有錯

用HQL語法，就可以解決！

解決了！哎，五一都沒人呢？

樓主自己怎么解決的給總結(jié)一下，也好給別的人一個參考嘛 :)

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com