尝试插入方法时出现多个键错误
这是我正在尝试的:
private int insertMaterial(AddMaterial add) {
final String INSERT =
"insert into material (name, keywords, started, finished, subject, description, c_method, c_time, financer, f_time, g_where, g_when, projectname, project_duration, projectleader, projectresearcher, projectfinancer, publication_details, financed, granted, project, publication) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
Object[] values = new Object[]{
add.getMaterial().getName(),
add.getMaterial().getKeywords(),
add.getMaterial().getStarted(),
add.getMaterial().getFinished(),
add.getMaterial().getSubject(),
add.getMaterial().getDescription(),
add.getMaterial().getcMethod(),
add.getMaterial().getcTime(),
add.getMaterial().getFinancer(),
add.getMaterial().getfTime(),
add.getMaterial().getgWhere(),
add.getMaterial().getgWhen(),
add.getMaterial().getProjectName(),
add.getMaterial().getProjectDuration(),
add.getMaterial().getProjectLeader(),
add.getMaterial().getProjectResearcher(),
add.getMaterial().getProjectFinancer(),
add.getMaterial().getPublicationDetails(),
add.getMaterial().isFinanced(),
add.getMaterial().isGranted(),
add.getMaterial().isProject(),
add.getMaterial().isPublication()
};
PreparedStatementCreatorFactory psc = new PreparedStatementCreatorFactory(INSERT);
psc.addParameter(new SqlParameter("name", Types.VARCHAR));
psc.addParameter(new SqlParameter("keywords", Types.VARCHAR));
psc.addParameter(new SqlParameter("started", Types.VARCHAR));
psc.addParameter(new SqlParameter("finished", Types.VARCHAR));
psc.addParameter(new SqlParameter("subject", Types.VARCHAR));
psc.addParameter(new SqlParameter("description", Types.VARCHAR));
psc.addParameter(new SqlParameter("c_method", Types.VARCHAR));
psc.addParameter(new SqlParameter("c_time", Types.VARCHAR));
psc.addParameter(new SqlParameter("financer", Types.VARCHAR));
psc.addParameter(new SqlParameter("f_time", Types.VARCHAR));
psc.addParameter(new SqlParameter("g_where", Types.VARCHAR));
psc.addParameter(new SqlParameter("g_when", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectname", Types.VARCHAR));
psc.addParameter(new SqlParameter("project_duration", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectleader", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectresearcher", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectfinancer", Types.VARCHAR));
psc.addParameter(new SqlParameter("publication_details", Types.VARCHAR));
psc.addParameter(new SqlParameter("financed", Types.BOOLEAN));
psc.addParameter(new SqlParameter("granted", Types.BOOLEAN));
psc.addParameter(new SqlParameter("project", Types.BOOLEAN));
psc.addParameter(new SqlParameter("publication", Types.BOOLEAN));
psc.setReturnGeneratedKeys(true);
KeyHolder generatedKeyHolder = new GeneratedKeyHolder();
getJdbcTemplate().update(psc.newPreparedStatementCreator(values), generatedKeyHolder);
return generatedKeyHolder.getKey().intValue();
我正在使用 Postgres,因此此方法应该返回串行列 id 的值。但都得到 这是
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: The getKey method should only be used when a single key is returned. The current key entry contains multiple keys: [{name=uu, keywords=, id=null, started=, finished=, subject=, description=, c_method=, c_time=, financer=, f_time=, g_where=, g_when=, projectname=, project_duration=, projectleader=, projectresearcher=, projectfinancer=, publication_details=, financed=false, project=false, publication=true, granted=false}] org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:659) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause org.springframework.dao.InvalidDataAccessApiUsageException: The getKey method should only be used when a single key is returned. The current key entry contains multiple keys: [{name=uu, keywords=, id=null, started=, finished=, subject=, description=, c_method=, c_time=, financer=, f_time=, g_where=, g_when=, projectname=, project_duration=, projectleader=, projectresearcher=, projectfinancer=, publication_details=, financed=false, project=false, publication=true, granted=false}] org.springframework.jdbc.support.GeneratedKeyHolder.getKey(GeneratedKeyHolder.java:65) fi.utu.aineistopankki.database.JdbcDatabaseManager.insertMaterial(JdbcDatabaseManager.java:89) fi.utu.aineistopankki.database.JdbcDatabaseManager.insertAddMaterialValues(JdbcDatabaseManager.java:174) fi.utu.aineistopankki.database.JdbcDatabaseManager$$FastClassByCGLIB$$802c3a1f.invoke() net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:692) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:625) fi.utu.aineistopankki.database.JdbcDatabaseManager$$EnhancerByCGLIB$$cdfed3e.insertAddMaterialValues() net.viralpatel.spring3.controller.MaterialController.onSubmit(MaterialController.java:46) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:710) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:167) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:414) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:402) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
什么?我该如何修复它?
Here is what I'm trying:
private int insertMaterial(AddMaterial add) {
final String INSERT =
"insert into material (name, keywords, started, finished, subject, description, c_method, c_time, financer, f_time, g_where, g_when, projectname, project_duration, projectleader, projectresearcher, projectfinancer, publication_details, financed, granted, project, publication) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
Object[] values = new Object[]{
add.getMaterial().getName(),
add.getMaterial().getKeywords(),
add.getMaterial().getStarted(),
add.getMaterial().getFinished(),
add.getMaterial().getSubject(),
add.getMaterial().getDescription(),
add.getMaterial().getcMethod(),
add.getMaterial().getcTime(),
add.getMaterial().getFinancer(),
add.getMaterial().getfTime(),
add.getMaterial().getgWhere(),
add.getMaterial().getgWhen(),
add.getMaterial().getProjectName(),
add.getMaterial().getProjectDuration(),
add.getMaterial().getProjectLeader(),
add.getMaterial().getProjectResearcher(),
add.getMaterial().getProjectFinancer(),
add.getMaterial().getPublicationDetails(),
add.getMaterial().isFinanced(),
add.getMaterial().isGranted(),
add.getMaterial().isProject(),
add.getMaterial().isPublication()
};
PreparedStatementCreatorFactory psc = new PreparedStatementCreatorFactory(INSERT);
psc.addParameter(new SqlParameter("name", Types.VARCHAR));
psc.addParameter(new SqlParameter("keywords", Types.VARCHAR));
psc.addParameter(new SqlParameter("started", Types.VARCHAR));
psc.addParameter(new SqlParameter("finished", Types.VARCHAR));
psc.addParameter(new SqlParameter("subject", Types.VARCHAR));
psc.addParameter(new SqlParameter("description", Types.VARCHAR));
psc.addParameter(new SqlParameter("c_method", Types.VARCHAR));
psc.addParameter(new SqlParameter("c_time", Types.VARCHAR));
psc.addParameter(new SqlParameter("financer", Types.VARCHAR));
psc.addParameter(new SqlParameter("f_time", Types.VARCHAR));
psc.addParameter(new SqlParameter("g_where", Types.VARCHAR));
psc.addParameter(new SqlParameter("g_when", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectname", Types.VARCHAR));
psc.addParameter(new SqlParameter("project_duration", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectleader", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectresearcher", Types.VARCHAR));
psc.addParameter(new SqlParameter("projectfinancer", Types.VARCHAR));
psc.addParameter(new SqlParameter("publication_details", Types.VARCHAR));
psc.addParameter(new SqlParameter("financed", Types.BOOLEAN));
psc.addParameter(new SqlParameter("granted", Types.BOOLEAN));
psc.addParameter(new SqlParameter("project", Types.BOOLEAN));
psc.addParameter(new SqlParameter("publication", Types.BOOLEAN));
psc.setReturnGeneratedKeys(true);
KeyHolder generatedKeyHolder = new GeneratedKeyHolder();
getJdbcTemplate().update(psc.newPreparedStatementCreator(values), generatedKeyHolder);
return generatedKeyHolder.getKey().intValue();
I'm using Postgres, so this method should return the value of serial column id. But all get
is this
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: The getKey method should only be used when a single key is returned. The current key entry contains multiple keys: [{name=uu, keywords=, id=null, started=, finished=, subject=, description=, c_method=, c_time=, financer=, f_time=, g_where=, g_when=, projectname=, project_duration=, projectleader=, projectresearcher=, projectfinancer=, publication_details=, financed=false, project=false, publication=true, granted=false}] org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:659) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause org.springframework.dao.InvalidDataAccessApiUsageException: The getKey method should only be used when a single key is returned. The current key entry contains multiple keys: [{name=uu, keywords=, id=null, started=, finished=, subject=, description=, c_method=, c_time=, financer=, f_time=, g_where=, g_when=, projectname=, project_duration=, projectleader=, projectresearcher=, projectfinancer=, publication_details=, financed=false, project=false, publication=true, granted=false}] org.springframework.jdbc.support.GeneratedKeyHolder.getKey(GeneratedKeyHolder.java:65) fi.utu.aineistopankki.database.JdbcDatabaseManager.insertMaterial(JdbcDatabaseManager.java:89) fi.utu.aineistopankki.database.JdbcDatabaseManager.insertAddMaterialValues(JdbcDatabaseManager.java:174) fi.utu.aineistopankki.database.JdbcDatabaseManager$FastClassByCGLIB$802c3a1f.invoke() net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:692) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:625) fi.utu.aineistopankki.database.JdbcDatabaseManager$EnhancerByCGLIB$cdfed3e.insertAddMaterialValues() net.viralpatel.spring3.controller.MaterialController.onSubmit(MaterialController.java:46) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:710) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:167) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:414) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:402) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
What is this and how do I fix it?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
我自己就遇到过并解决了这个问题。我建议重构您准备好的声明的方法。这是您需要做的:
创建一个实现 org.springframework.jdbc.core.PreparedStatementCreator 的类。此类将处理如何将数据提供给准备好的语句。这是一个示例
请注意对connection.prepareStatement 的调用。第二个参数指定您希望GenerateKeyHolder 使用哪一列。
使用您的PreparedStatementCreator。例如:
I have encountered and solved this problem myself. I would suggest refactoring your approach to prepared statements. Here is what you need to do:
Create a class that implements org.springframework.jdbc.core.PreparedStatementCreator. This class will handle how data is given to the prepared statement. Here is an example
Notice the call to connection.prepareStatement. The second parameter specifies which column you want to be used by the GeneratedKeyHolder.
Use your PreparedStatementCreator. For example:
使用 getKeys() 方法而不是 getKey() ,显然您指定了多个密钥。
特别是,正如错误告诉您的那样: getKey() 将 从第一个地图中检索第一个项目,假设只有一个项目和一个地图,并且该项目是一个数字。 。
Use the getKeys() method instead of getKey(), apparently you have more than one key specified.
In particular, as the error tells you: getKey() will Retrieve the first item from the first map, assuming that there is just one item and just one map, and that the item is a number..
您应该使用 setGenerateKeysColumnNames 方法在PreparedStatementCreatorFactory 中分配用作表中键的列的名称。
You should use setGeneratedKeysColumnNames method in PreparedStatementCreatorFactory to assign names of the columns used as keys in your table.