在我的weblogic中有这样的错误信息: javax.ejb.FinderException: Problem in findByPrimaryKey while preparing or executing statement: 'weblogic.jdbc.rmi.SerialPreparedStatement@7723ab': java.sql.SQLException: No data foundjava.sql.SQLException: No data found at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6207) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3261) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5393) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:321) at weblogic.jdbc.jts.ResultSet.getString(ResultSet.java:84) at weblogic.jdbc.rmi.internal.ResultSetImpl.getString(ResultSetImpl.java:178) at weblogic.jdbc.rmi.internal.ResultSetStraightReader.getString(ResultSetStraightReader.java:37) at weblogic.jdbc.rmi.SerialResultSet.getString(SerialResultSet.java:128) at lastcmp.TTableBean_txd1ye__WebLogic_CMP_RDBMS.__WL_loadGroup0FromRS(TTableBean_txd1ye__WebLogic_CMP_RDBMS.java:599) at lastcmp.TTableBean_txd1ye__WebLogic_CMP_RDBMS.ejbFindByPrimaryKey(TTableBean_txd1ye__WebLogic_CMP_RDBMS.java:419) at java.lang.reflect.Method.invoke(Native Method) at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.findByPrimaryKey(RDBMSPersistenceManager.java:203) at weblogic.ejb20.manager.BaseEntityManager.findByPrimaryKey(BaseEntityManager.java:500) at weblogic.ejb20.manager.BaseEntityManager.localFindByPrimaryKey(BaseEntityManager.java:457) at weblogic.ejb20.internal.EntityEJBLocalHome.findByPrimaryKey(EntityEJBLocalHome.java:275) at lastcmp.TTableBean_txd1ye_LocalHomeImpl.findByPrimaryKey(TTableBean_txd1ye_LocalHomeImpl.java:101) at lastcmp.testSessionBean.getname(testSessionBean.java:52) at lastcmp.testSessionBean_qc2f8k_EOImpl.getname(testSessionBean_qc2f8k_EOImpl.java:46) at lastcmp.testSessionBean_qc2f8k_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:362) at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:114) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:313) at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:785) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:308) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134) at lastcmp.TTableBean_txd1ye__WebLogic_CMP_RDBMS.ejbFindByPrimaryKey(TTableBean_txd1ye__WebLogic_CMP_RDBMS.java:443) at java.lang.reflect.Method.invoke(Native Method) at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.findByPrimaryKey(RDBMSPersistenceManager.java:203) at weblogic.ejb20.manager.BaseEntityManager.findByPrimaryKey(BaseEntityManager.java:500) at weblogic.ejb20.manager.BaseEntityManager.localFindByPrimaryKey(BaseEntityManager.java:457) at weblogic.ejb20.internal.EntityEJBLocalHome.findByPrimaryKey(EntityEJBLocalHome.java:275) at lastcmp.TTableBean_txd1ye_LocalHomeImpl.findByPrimaryKey(TTableBean_txd1ye_LocalHomeImpl.java:101) at lastcmp.testSessionBean.getname(testSessionBean.java:52) at lastcmp.testSessionBean_qc2f8k_EOImpl.getname(testSessionBean_qc2f8k_EOImpl.java:46) at lastcmp.testSessionBean_qc2f8k_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:362) at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:114) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:313) at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:785) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:308) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
还是这个错啊!!!!!!!!!!!!!!! javax.ejb.FinderException: Problem in findByPrimaryKey while preparing or executing statement: 'weblogic.jdbc.rmi.SerialPreparedStatement@7fe5ac': java.sql.SQLException: No data found java.sql.SQLException: No data found
你加了<ejb-ref>了吗
我通过session bean调用entity bean(cmp)的findByPrimaryKey(String id) throws FinderException方法。
代码如下:
public String getname(String id) {
String name="";
try{
ttable=ttablehome.findByPrimaryKey(id);
name=ttable.getName();
System.out.println("ttable.getname() is"+name);
}catch(Exception ex)
{ex.printStackTrace();}
return name;
}
返回的是个空值,为什么?大虾们,这可困扰我好几天了,只要解决了就结贴!
再次谢谢!!!!
javax.ejb.FinderException: Problem in findByPrimaryKey while preparing or executing statement: 'weblogic.jdbc.rmi.SerialPreparedStatement@7723ab': java.sql.SQLException: No data foundjava.sql.SQLException: No data found at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6207) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3261) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5393) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:321) at weblogic.jdbc.jts.ResultSet.getString(ResultSet.java:84) at weblogic.jdbc.rmi.internal.ResultSetImpl.getString(ResultSetImpl.java:178) at weblogic.jdbc.rmi.internal.ResultSetStraightReader.getString(ResultSetStraightReader.java:37) at weblogic.jdbc.rmi.SerialResultSet.getString(SerialResultSet.java:128) at lastcmp.TTableBean_txd1ye__WebLogic_CMP_RDBMS.__WL_loadGroup0FromRS(TTableBean_txd1ye__WebLogic_CMP_RDBMS.java:599) at lastcmp.TTableBean_txd1ye__WebLogic_CMP_RDBMS.ejbFindByPrimaryKey(TTableBean_txd1ye__WebLogic_CMP_RDBMS.java:419) at java.lang.reflect.Method.invoke(Native Method) at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.findByPrimaryKey(RDBMSPersistenceManager.java:203) at weblogic.ejb20.manager.BaseEntityManager.findByPrimaryKey(BaseEntityManager.java:500) at weblogic.ejb20.manager.BaseEntityManager.localFindByPrimaryKey(BaseEntityManager.java:457) at weblogic.ejb20.internal.EntityEJBLocalHome.findByPrimaryKey(EntityEJBLocalHome.java:275) at lastcmp.TTableBean_txd1ye_LocalHomeImpl.findByPrimaryKey(TTableBean_txd1ye_LocalHomeImpl.java:101) at lastcmp.testSessionBean.getname(testSessionBean.java:52) at lastcmp.testSessionBean_qc2f8k_EOImpl.getname(testSessionBean_qc2f8k_EOImpl.java:46) at lastcmp.testSessionBean_qc2f8k_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:362) at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:114) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:313) at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:785) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:308) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134) at lastcmp.TTableBean_txd1ye__WebLogic_CMP_RDBMS.ejbFindByPrimaryKey(TTableBean_txd1ye__WebLogic_CMP_RDBMS.java:443) at java.lang.reflect.Method.invoke(Native Method) at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.findByPrimaryKey(RDBMSPersistenceManager.java:203) at weblogic.ejb20.manager.BaseEntityManager.findByPrimaryKey(BaseEntityManager.java:500) at weblogic.ejb20.manager.BaseEntityManager.localFindByPrimaryKey(BaseEntityManager.java:457) at weblogic.ejb20.internal.EntityEJBLocalHome.findByPrimaryKey(EntityEJBLocalHome.java:275) at lastcmp.TTableBean_txd1ye_LocalHomeImpl.findByPrimaryKey(TTableBean_txd1ye_LocalHomeImpl.java:101) at lastcmp.testSessionBean.getname(testSessionBean.java:52) at lastcmp.testSessionBean_qc2f8k_EOImpl.getname(testSessionBean_qc2f8k_EOImpl.java:46) at lastcmp.testSessionBean_qc2f8k_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:362) at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:114) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:313) at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:785) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:308) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
程序很简单,就一个添加和查询函数!用的是JBULIDER7+WBLOGIC7+ACCESS!
我自己添加一个finder查询函数,可是在添加查询语句时总出错!
请大厦门指点!
id用的是:String 类型
我也用过oracle,还是一样的错误提示!
如果数据库用的是SQL Server,类型改成varchar
如果数据库用的是ORACLE,类型改成varchar2
而且我用access也是一样的错啊?
那位大哥能帮我看看我的程序。告诉我你的邮件地址好吗?
我发给你帮我看看!
这个问题都快困扰我一周时间了,郁闷啊!!!!!!!呜呜~~~~~~~~~
javax.ejb.FinderException: Problem in findByPrimaryKey while preparing or executing statement: 'weblogic.jdbc.rmi.SerialPreparedStatement@7fe5ac':
java.sql.SQLException: No data found
java.sql.SQLException: No data found