Last night on the Internet to find didn't find out the solution to a night, depressed. It is very simple, I use a PB9.0 JDBC driver (mysql connector - Java - 3.1.12 - bin. Jar) connect the mysql, performed directly in the database can be normal select COUNT (SYMBOL) from sms_main;
But by the program select COUNT (1) into: zxy from sms_main; Just make a mistake.
The FUNCTION RAIN. The COUNT does not exist.
Seems PB is not supported. The first time to use PB even MYSQL. Experienced friends don't know is how to solve this problem?

CodePudding user response:

The count () the function, the database is support,
The FUNCTION RAIN. The COUNT does not exist. Here the RAIN is what ah,

CodePudding user response:

RAIN seems to be the user name, write back to COUNT (SYMBOL)?

CodePudding user response:

Rain here is my library name. Should have nothing to do,
See the previous post, some say, is the PB do not compatible with MYSQL, I sweat, so long, there should be a patch or what's the solution

CodePudding user response:

: hey! : hey! Should be a user name, anyway I user name and the library is the same, write back to COUNT (SYMBOL) is the same error message.
If it is the count (*) is more outrageous wrong. (you hav the an error in your SQL syntax: check the manual that corresponds to your mysql server version for the right syntax to use near '*) from sms_main where symbol=' aaaa "at line 1

CodePudding user response:

A little difficulty oh

CodePudding user response:

This simple ah, online search will get the answer.

CodePudding user response:

What ah