jpa - unable to get result from MySql Stored Procedure/Function to JPQL -


this code of stored function:

create definer=`root`@`localhost` function `func`()     returns int(11)     language sql     not deterministic     contains sql     sql security definer     comment '' begin declare total int default 0; select count(*) total students; return total; end

java code:

query=em.createnativequery("{ select func() }");           string s=(string) query.getsingleresult();         system.out.println(s);

but ir gives exception:

internal exception: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax use near '{ select func() }' @ line 1 error code: 1064 call: { select func() } query: datareadquery(sql="{ select func() }") javax.persistence.persistenceexception: exception [eclipselink-4002] (eclipse persistence services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.databaseexception internal exception: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax use near '{ select func() }' @ line 1 error code: 1064 call: { select func() } query: datareadquery(sql="{ select func() }")     @ org.eclipse.persistence.internal.jpa.queryimpl.getdetailedexception(queryimpl.java:377)     @ org.eclipse.persistence.internal.jpa.queryimpl.executereadquery(queryimpl.java:260)     @ org.eclipse.persistence.internal.jpa.queryimpl.getsingleresult(queryimpl.java:516)     @ org.eclipse.persistence.internal.jpa.ejbqueryimpl.getsingleresult(ejbqueryimpl.java:400)     @ org.ceynamon.oregano.datamigration.test.main(test.java:26) caused by: exception [eclipselink-4002] (eclipse persistence services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.databaseexception internal exception: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax;

the braces around select funct() not needed


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more