Error nullpointer when query in database with parameter

Asked

Viewed 74 times

0

When I run the query below I have a nullPointer error.

@Query(value = "SELECT * FROM x WHERE USER_NAME = :name", nativeQuery = true)
DataBaseCobilling findByCdIdent(@Param("name") String name);

But when I run this one it works :

@Query(value = "SELECT * FROM x WHERE USER_NAME = 'WESLEY BANDEIRA LIMA'", nativeQuery = true)
 * DataBaseCobilling getByUserName();

I am passing the same name as parameter, when I do by error parameter when running the direct query works.

What could be the mistake ? 

java.lang.NullPointerException
at br.com.oiinternet.oitestautomation.sga.page.PaymentCobillingPage.fillDddAndCollectionPhone(PaymentCobillingPage.java:66)
at br.com.oiinternet.oitestautomation.sga.test.PurchaseCobillingTest.purchasePlanCobilling(PurchaseCobillingTest.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
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:70)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
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.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
java sql oracle spring

  • Are you using any framework? in which part of the error code? can you report the cause of the error?

  • What is the "*" in the return of the second method?

  • @Murillogoulart the * was the most can ignore,

  • @Elyelrubensdarosa I’m using Spring,

  • You wouldn’t have to concatenate single quotes before inserting the name variable? '<minha_variavel>'

  • This part of the code appears to be correct, make sure the import is correct import org.springframework.data.repository.query.Param;

Show 1 more comment

1 answer

0

This is a bug from Spring Data JPA and was corrected in version 1.3.4.

Update the version via Maven and check that the error will be corrected.

Browser other questions tagged java sql oracle spring

You are not signed in. Login or sign up in order to post.