“ java.lang.IllegalArgumentException：uri.getScheme（）== null！使用JavaFX播放音频时发生错误”

25-02-24 14

本文将为您提供关于“java.lang.IllegalArgumentException：uri.getScheme的详细介绍，我们还将为您解释==null！使用JavaFX播放音频时发生错误”的相关

本文将为您提供关于“ java.lang.IllegalArgumentException：uri.getScheme的详细介绍，我们还将为您解释== null！使用JavaFX播放音频时发生错误”的相关知识，同时，我们还将为您提供关于 java.lang.IllegalArgumentException、Android：java.lang.IllegalArgumentException：未知颜色错误、HTTP错误：java.lang.IllegalArgumentException: Illegal character in scheme at index 0: http://xxxxxx、java – IllegalArgumentException：Type不能为null的实用信息。

本文目录一览：

“ java.lang.IllegalArgumentException：uri.getScheme（）== null！使用JavaFX播放音频时发生错误”
java.lang.IllegalArgumentException
Android：java.lang.IllegalArgumentException：未知颜色错误
HTTP错误：java.lang.IllegalArgumentException: Illegal character in scheme at index 0: http://xxxxxx
java – IllegalArgumentException：Type不能为null

“ java.lang.IllegalArgumentException：uri.getScheme（）== null！使用JavaFX播放音频时发生错误”

我正在尝试在Java和其中一种格式上播放mp3音频。我相信是JavaFX，一切正常，直到尝试播放音频为止。

这是代码：

import javax.sound.sampled.AudioPermission;import javafx.application.Application;import javafx.event.ActionEvent;import javafx.event.EventHandler;import javafx.scene.Scene;import javafx.scene.control.Button;import javafx.scene.layout.StackPane;import javafx.scene.media.Media;import javafx.scene.media.MediaPlayer;import javafx.stage.Stage;public class fx_main extends Application {    @Override    public void start(Stage primaryStage) {        Button btn = new Button();        btn.setText("Say ''Hello World''");        btn.setOnAction(new EventHandler<ActionEvent>() {            @Override            public void handle(ActionEvent event) {                System.out.println("Hello World!");                Media m = new Media("/04.mp3");                MediaPlayer mp = new MediaPlayer(m);                mp.play();            }        });        StackPane root = new StackPane();        root.getChildren().add(btn);         Scene scene = new Scene(root, 300, 250);        primaryStage.setTitle("Hello World!");        primaryStage.setScene(scene);        primaryStage.show();    }  public static void main(String[] args) {        launch(args);    } }

当我按下按钮并尝试加载声音文件时，出现此异常：

   Hello World!    Glass detected outstanding Java exception at -[GlassViewDelegate sendJavaMouseEvent:]:src/com/sun/mat/ui/GlassViewDelegate.m:543    Exception in thread "JavaFX Application Thread" java.lang.IllegalArgumentException: uri.getScheme() == null!        at com.sun.media.jfxmedia.locator.Locator.<init>(Locator.java:217)        at javafx.scene.media.Media.<init>(Media.java:369)        at fx_man$1.handle(fx_man.java:27)        at fx_man$1.handle(fx_man.java:1)        at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:69)        at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:217)        at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:170)        at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:38)        at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:37)        at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)        at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:35)        at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)        at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:53)        at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:28)        at javafx.event.Event.fireEvent(Event.java:171)        at javafx.scene.Node.fireEvent(Node.java:6866)        at javafx.scene.control.Button.fire(Button.java:179)        at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:193)        at com.sun.javafx.scene.control.skin.SkinBase$4.handle(SkinBase.java:336)        at com.sun.javafx.scene.control.skin.SkinBase$4.handle(SkinBase.java:329)        at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:64)        at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:217)        at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:170)        at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:38)        at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:37)        at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)        at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:35)        at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)        at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:35)        at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)        at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:53)        at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:33)        at javafx.event.Event.fireEvent(Event.java:171)        at javafx.scene.Scene$MouseHandler.process(Scene.java:3369)        at javafx.scene.Scene$MouseHandler.process(Scene.java:3209)        at javafx.scene.Scene$MouseHandler.access$1900(Scene.java:3164)        at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1582)        at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2267)        at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:250)        at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:173)        at java.security.AccessController.doPrivileged(Native Method)        at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:292)        at com.sun.glass.ui.View.handleMouseEvent(View.java:530)        at com.sun.glass.ui.View.notifyMouse(View.java:924)

如何解决错误？单击后是否要播放音频文件？

答案1

小编典典

Media的构造函数需要一个URL，因此您需要以http：//或file：//开头的内容

btn.setOnAction(e -> {  Media m = new Media(Paths.get("04.mp3").toUri().toString());  new MediaPlayer(m).play();});`

参见http://docs.oracle.com/javase/8/javafx/media-
tutorial/simpleplayer.htm

它还有助于将Path和File对象都转换为URL。

java.lang.IllegalArgumentException

问题描述：java.lang.IllegalArgumentException: Wrong state class, expecting View State but received class cn.etouch.ecalendar.waterfallview.StaggeredGridView$GridListSavedState instead. This usually happens when two views of different type have the same id in the same hierarchy. This view''s id is id/lv. Make sure other views do not use the same id.

问题出现情况分析：

android 5.0及以下版本如果出现这个问题，不要以为真的是id重复了。

我的项目情况是这样的在一个activity中有四个fagment ,F1,F2,F3,F4,在F2和F3的切换过程中，F4其实也已经初始化了，我在F4的布局中使用了自定义了一个ListView，它的id为lv.

之所以报错说id相同，大约是F4的上一次状态被保留下来了。

问题解决方案：

自定义的Listview的方法重写

   @Override
    protected void onRestoreInstanceState(Parcelable state) {
            super.onRestoreInstanceState(state); }

修改为：

        @Override
    protected void onRestoreInstanceState(Parcelable state) {
        try {
            super.onRestoreInstanceState(state);
        }catch (Exception e) {}
        state=null;
      }

Android：java.lang.IllegalArgumentException：未知颜色错误

从this post我们可以看出你应该写

holder.itemView.cardView
    .setCardBackgroundColor(ContextCompat.getColor(getActivity(),R.color.ColorLightBlack))

您正在尝试使用 parseColor，它以十六进制字符串作为参数。但是调用 toString() 可能不会转换为十六进制。

R.color.ColorLightBlack 是 Android 系统分配的整数值。您正在尝试将此值传递给需要字符串的 parseColor 方法。即使您在 R.color.ColorLightBlack 上使用 toString，该值仍然是 Integer，因此您会收到错误消息。

您可以像这样更新代码：

if (arrList[position].color != null){
holder.itemView.cardView.setCardBackgroundColor(Color.parseColor(arrList[position].color)) }
else { 
holder.itemView.cardView.setCardBackgroundColor(R.color.ColorLightBlack)) 
}

HTTP错误：java.lang.IllegalArgumentException: Illegal character in scheme at index 0: http://xxxxxx

读取T卡文件里的域名，HTTP请求出现如下错误

java.lang.IllegalArgumentException: Illegal character in scheme at index 0: http://xxxxxxxxxxx
at java.net.URI.create(URI.java:727)
at org.apache.http.client.methods.HttpPost.<init>(HttpPost.java:84)

......

出现该错误时，读取域名的代码如下

protected String getFileContent(File file) {
        String content  = "";
        if (file.isDirectory() ) {    //检查此路径名的文件是否是一个目录(文件夹)
            Log.i("zeng", "The File doesn''t not exist "
                +file.getName().toString()+file.getPath().toString());   
        } else {
            if (file.getName().endsWith(".txt")) {//文件格式为txt文件
                try {
                    InputStream instream = new FileInputStream(file); 
                    if (instream != null) {
                        InputStreamReader inputreader
                            =new InputStreamReader(instream, "UTF-8");
                        BufferedReader buffreader = new BufferedReader(inputreader);
                        String line="";
                        //分行读取
                       while (( line = buffreader.readLine()) != null) {
                            content += line + "\n";
                        }                
                        instream.close();        //关闭输入流
                    }
                }
                catch (java.io.FileNotFoundException e) {
                    Log.d("TestFile", "The File doesn''t not exist.");
                } 
                catch (IOException e)  {
                     Log.d("TestFile", e.getMessage());
                }
            }
        }
        return content ;
    }

View Code

修改为如下方法后，HTTP请求正常

private static String getFileContent(File file) {
        String content = "";
        try {
            FileInputStream fin = new FileInputStream(file);
            int length;
            length = fin.available();
            byte [] buffer = new byte[length];   
            fin.read(buffer);       
            content = EncodingUtils.getString(buffer, "UTF-8");   
            fin.close();      
            return content;
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }   
        return content;
    }

View Code

java – IllegalArgumentException：Type不能为null

我遇到了一个问题,似乎很多人遇到了它,可能无法解决它.

我有以下MysqL存储过程.这只是一个示例,看看一切是否正常,然后我会开始添加非活动参数.

CREATE DEFINER=`root`@`localhost` PROCEDURE `get_resource_types`()
BEGIN
    SELECT *
    FROM resource_types
    WHERE inactive = 0;
END

映射resource_types表和命名存储过程查询的实体.

@NamedStoredProcedureQuery(
        name="getResourceTypes",procedureName="get_resource_types",resultClasses = ResourceType.class,parameters = {}
)
@Entity
@Table(name = "resource_types")
public class ResourceType {
    ... fields with annotations used for validation + getters and setters ...
}

这是我的JpaRepository,我从中调用存储过程

@Repository
public interface ResourceTypeRepository extends JpaRepository


驻留在@Service中的getAll()方法

public List

当我尝试运行它时,我得到以下堆栈跟踪：

org.springframework.web.util.nestedservletexception: Request processing Failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Type cannot be null; nested exception is java.lang.IllegalArgumentException: Type cannot be null
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
    at org.springframework.test.web.servlet.TestdispatcherServlet.service(TestdispatcherServlet.java:65)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
    at org.springframework.mock.web.MockFilterChain$ServletFilterProxy.doFilter(MockFilterChain.java:167)
    at org.springframework.mock.web.MockFilterChain.doFilter(MockFilterChain.java:134)
    at org.springframework.test.web.servlet.mockmvc.perform(mockmvc.java:144)
    at com.test.ihbs.controller.ResourceTypeControllerTest.test_getAll(ResourceTypeControllerTest.java:111)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:73)
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:82)
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:73)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runchild(SpringJUnit4ClassRunner.java:224)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runchild(SpringJUnit4ClassRunner.java:83)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runchildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:68)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:163)
    at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecuter.runTestClass(JUnitTestClassExecuter.java:86)
    at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecuter.execute(JUnitTestClassExecuter.java:49)
    at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassprocessor.processtestClass(JUnitTestClassprocessor.java:64)
    at org.gradle.api.internal.tasks.testing.SuiteTestClassprocessor.processtestClass(SuiteTestClassprocessor.java:50)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.gradle.messaging.dispatch.Reflectiondispatch.dispatch(Reflectiondispatch.java:35)
    at org.gradle.messaging.dispatch.Reflectiondispatch.dispatch(Reflectiondispatch.java:24)
    at org.gradle.messaging.dispatch.ContextClassLoaderdispatch.dispatch(ContextClassLoaderdispatch.java:32)
    at org.gradle.messaging.dispatch.ProxydispatchAdapter$dispatchingInvocationHandler.invoke(ProxydispatchAdapter.java:93)
    at com.sun.proxy.$Proxy2.processtestClass(UnkNown Source)
    at org.gradle.api.internal.tasks.testing.worker.TestWorker.processtestClass(TestWorker.java:106)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.gradle.messaging.dispatch.Reflectiondispatch.dispatch(Reflectiondispatch.java:35)
    at org.gradle.messaging.dispatch.Reflectiondispatch.dispatch(Reflectiondispatch.java:24)
    at org.gradle.messaging.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:360)
    at org.gradle.internal.concurrent.DefaultExecutorFactory$StoppableExecutorImpl$1.run(DefaultExecutorFactory.java:64)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Type cannot be null; nested exception is java.lang.IllegalArgumentException: Type cannot be null
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:381)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:223)
    at org.springframework.orm.jpa.AbstractEntityManagerfactorybean.translateExceptionIfPossible(AbstractEntityManagerfactorybean.java:417)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:122)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    at com.sun.proxy.$Proxy87.getResourceTypes(UnkNown Source)
    at com.ihbs.service.ResourceTypeService.getAll(ResourceTypeService.java:34)
    at com.ihbs.controller.ResourceTypeController.getAllResourceTypes(ResourceTypeController.java:44)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.springframework.web.method.support.invocableHandlerMethod.doInvoke(invocableHandlerMethod.java:221)
    at org.springframework.web.method.support.invocableHandlerMethod.invokeForRequest(invocableHandlerMethod.java:137)
    at org.springframework.web.servlet.mvc.method.annotation.ServletinvocableHandlerMethod.invokeAndHandle(ServletinvocableHandlerMethod.java:110)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    at org.springframework.web.servlet.dispatcherServlet.dodispatch(dispatcherServlet.java:959)
    at org.springframework.web.servlet.dispatcherServlet.doService(dispatcherServlet.java:893)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
    ... 58 more
Caused by: java.lang.IllegalArgumentException: Type cannot be null
    at org.hibernate.procedure.internal.AbstractParameterRegistrationImpl.setHibernateType(AbstractParameterRegistrationImpl.java:182)
    at org.hibernate.procedure.internal.AbstractParameterRegistrationImpl.arameterRegistrationImpl.java:131)
    at org.hibernate.procedure.internal.AbstractParameterRegistrationImpl.arameterRegistrationImpl.java:140)
    at org.hibernate.procedure.internal.AbstractParameterRegistrationImpl.arameterRegistrationImpl.java:77)
    at org.hibernate.procedure.internal.PositionalParameterRegistration.arameterRegistration.java:41)
    at org.hibernate.procedure.internal.ProcedureCallImpl.registerParameter(ProcedureCallImpl.java:275)
    at org.hibernate.jpa.internal.StoredProcedureQueryImpl.registerStoredProcedureParameter(StoredProcedureQueryImpl.java:128)
    at org.springframework.data.jpa.repository.query.StoredProcedureJpaQuery.newAdhocStoredProcedureQuery(StoredProcedureJpaQuery.java:147)
    at org.springframework.data.jpa.repository.query.StoredProcedureJpaQuery.createStoredProcedure(StoredProcedureJpaQuery.java:110)
    at org.springframework.data.jpa.repository.query.StoredProcedureJpaQuery.docreatequery(StoredProcedureJpaQuery.java:68)
    at org.springframework.data.jpa.repository.query.StoredProcedureJpaQuery.createquery(StoredProcedureJpaQuery.java:58)
    at org.springframework.data.jpa.repository.query.JpaQueryExecution$ProcedureExecution.doExecute(JpaQueryExecution.java:295)
    at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:74)
    at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:97)
    at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:88)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:395)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:373)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$DefaultMethodInvokingMethodInterceptor.invoke(RepositoryFactorySupport.java:486)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
    ... 80 more

任何想法为什么会发生这种情况以及如何解决它？
InvalidDataAccessApiUsageException的文档说：


Exception thrown on incorrect usage of the API,such as failing to

  “compile” a query object that needed compilation before execution.

  This represents a problem in our Java data access framework,not the

  underlying data access infrastructure.

更新1
如果我将存储库更改为以下代码,它将起作用,这意味着名称过程查询存在问题.我仍然需要使存储过程的方式工作.

@Repository
public interface ResourceTypeRepository extends JpaRepository

更新2
我没有使用EclipseLink(或者至少我不知道他的存在)
更新3
即使我通过代码调试,我也找不到这个问题的原因.但我找到了一些可能有助于找到问题的东西.
我在org / springframework / data / jpa / repository / query / StoredProcedureJpaQuery.java中找到了这段代码,如果您注意到在最后一行有一个函数调用,它会获取参数总数并添加一个额外的一个.这可能是问题,额外的参数.尽管如此,这可能不是问题,因为我认为它可以在不同情况下沿着另一条道路前进.

/**
 * Extracts the output value from the given {@link StoredProcedureQuery}.
 * 
 * @param storedProcedureQuery must not be {@literal null}.
 * @return
 */
Object extractOutputValue(StoredProcedureQuery storedProcedureQuery) {

    Assert.notNull(storedProcedureQuery,"StoredProcedureQuery must not be null!");

    if (!procedureAttributes.hasReturnValue()) {
        return null;
    }

    if (StringUtils.hasText(procedureAttributes.getoutputParameterName())) {
        return storedProcedureQuery.getoutputParameterValue(procedureAttributes.getoutputParameterName());
    }

    return storedProcedureQuery.getoutputParameterValue(getQueryMethod().getParameters().getNumberOfParameters() + 1);
}


最佳答案
从1.11.1开始,Spring Data JPA不支持返回结果集的SP.我用Spring Data提交了a corresponding defect.
解决方案是降低API级别并使用JPA.这是我编写的与MS sql SP一起使用的泛型类.

import com.google.common.base.Strings;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.ParameterMode;
import javax.persistence.Query;
import javax.persistence.StoredProcedureQuery;
import lombok.requiredArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
@requiredArgsConstructor(onConstructor = @__(@Autowired))
public class StoredProcRepository {

  //region Injected beans (via a requiredArgsConstructor)
  private final EntityManager em;
  //endregion 

  /**
   * Calls a stored procedure via JPA and retrieves a single implicit result set (in DBs that
   * support them e.g. MS sql or MysqL). The call is not dependent on a DB dialect. Be
   * aware that large result sets should be paginated and not entirely read to memory. Recreates
   * StoredProcedureQuery instance and its parameters on each call.
   * To execute MS sql SPs performing multiple queries,SET NOCOUNT ON.
   *
   * @param procedureName stored procedure name,optionally qualified per DB Syntax
   * @param resultClass converts (maps) each result set row into instances of resultClass via JPA
   * @param spArgs stored procedure arguments,supplied positionally (optional SP arguments at the
   * end of the list Could be omitted)
   * @param arameterMode.IN);
      spq.setParameter(pos,arg);
    }
    return spq.getResultList();
  }

  /**
   * Calls a stored procedure via JPA and retrieves only the top row of a single implicit result
   * set (in DBs that support them e.g. MS sql or MysqL).
   * Assumes that result set has at least one row.
   * The call is not dependent on a DB dialect.
   * Be aware that large result sets should be paginated and not entirely read to memory.
   * Recreates StoredProcedureQuery instance and its parameters on each call.
   * To execute MS sql SPs performing multiple queries,supplied positionally (optional SP arguments at the
   * end of the list Could be omitted)
   * @param 

对于MS sql SP,附加要求是对执行多个查询的所有SP具有SET NOCOUNT ON.这可以通过以下三种方式之一设置：
>在使用JPA的通用Java包装器中(参见下面的代码).此方法仅适用于jtds JDBC驱动程序. A corresponding issue已经提交了MS JDBC驱动程序项目.
>在每个SP的开头.
> Globally in your database.
她是#1的代码：相同StoredProcRepository类的相应方法.

  /**
   * Calls an MS sql stored procedure via JPA and retrieves a single implicit result set.
   * Protects against lack of SET NOCOUNT in stored procedures.
   * This works with jtds JDBC driver,but not with MS JDBC driver.
   * Be aware that large result sets should be paginated and not entirely read to memory.
   *
   * @param procedureName stored procedure name,supplied positionally (optional SP arguments at the
   * end of the list Could be omitted)
   * @param sqlStoredProc(String procedureName,Object... spArgs) {
    String spBindParams = (spArgs.length == 0) ? "" : "?" + Strings.repeat(",?",spArgs.length - 1);

    // The following works with jtds driver,but not with MS driver
    String spQuery = String.format("EXEC %s %s",procedureName,spBindParams);

    // The following works with jtds driver,but not with MS driver
    /*
    String spQuery = String.format("{call %s(%s)}",spBindParams);
    Query q = em.createNativeQuery("SET NOCOUNT ON; " + spQuery,resultClass)
        .setHint("org.hibernate.readOnly",true);
    */

    Query q = em.createNativeQuery(spQuery,resultClass);
    int pos = 0;
    for (Object arg : spArgs) {
      q.setParameter(++pos,arg);
    }
    return q.getResultList();
  }    

  /**
   * Calls an MS sql stored procedure via JPA and retrieves only the top row of a single implicit
   * result set.
   * Assumes that result set has at least one row.
   * The call sets the "NOCOUNT ON" MS sql batch option.
   * Be aware that large result sets should be paginated and not entirely read to memory.
   *
   * @param procedureName stored procedure name,supplied positionally (optional SP arguments at the
   * end of the list Could be omitted)
   * @param sqlStoredProc(String procedureName,Object... spArgs) {
    return queryViaMssqlStoredProc(procedureName,spArgs).get(0);
  }

关于“ java.lang.IllegalArgumentException：uri.getScheme和== null！使用JavaFX播放音频时发生错误”的介绍已经告一段落，感谢您的耐心阅读，如果想了解更多关于 java.lang.IllegalArgumentException、Android：java.lang.IllegalArgumentException：未知颜色错误、HTTP错误：java.lang.IllegalArgumentException: Illegal character in scheme at index 0: http://xxxxxx、java – IllegalArgumentException：Type不能为null的相关信息，请在本站寻找。

本文标签：