| Author |
Message
|
| prasadzkv |
 Posted: Wed Aug 03, 2016 7:01 am Post subject: Parameter metadata not available for the give statement. |
 |
|
Novice
Joined: 13 Jul 2016
Posts: 21
Location: Chennai
|
Hi Team,
I am doing one POC on Database Retrieve Node.
when i execute the same i am facing the following error.
Text:CHARACTER:Problem encountered setting parameters in prepared statement
Insert
Type:INTEGER:5
Text:CHARACTER:Broker 'IBM'; Execution Group 'default'; Message Flow 'CallableFlow'; Node 'Database Retrieve'; Node Type 'DatabaseRetrieve
Insert
Type:INTEGER:5
Text:CHARACTER:SELECT test.employee.emp_name, test.employee.emp_age, test.employee.emp_city, test.employee.emp_id FROM test.employee WHERE test.employee.emp_id = ? ORDER BY test.employee.emp_name ASC, test.employee.emp_age ASC, test.employee.emp_city ASC, test.employee.emp_id ASC
Insert
Type:INTEGER:5
Text:CHARACTER: error message: Parameter metadata not available for the given statement, SQLState value: S1C00, stack trace: [com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
Could you please help on the same. |
|
| Back to top |
|
 |
| prasadzkv |
| Posted: Wed Aug 03, 2016 11:39 pm Post subject: |
|
|
Novice
Joined: 13 Jul 2016
Posts: 21
Location: Chennai
|
Hi All,
My self find the cause For the above post. if any one also facing the same issue please use the below command.
MY SQL -Jdbc provider configuration Service
in this window ConnectionURLFormat URL should pass the additional parameter like below highlighted in red color.
ConnectionURLFormat - jdbc:mysql://localhost:3306/test?user=root&password=root&generateSimpleParameterMetadata=true
 |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 04, 2016 3:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Your ConnectionURLFormat is entirely broken.
It's a pattern, not a specific example.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 04, 2016 4:47 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| prasadzkv wrote: |
In this window ConnectionURLFormat URL should pass the additional parameter like below highlighted in red color.
ConnectionURLFormat - jdbc:mysql://localhost:3306/test?user=root&password=root&generateSimpleParameterMetadata=true |
No it shouldn't.
You've set the ConnectionURLFormat to a specific URL with hard coded values. This is an insanely bad idea.
| prasadzkv wrote: |
| |
Congratulations indeed. You've fixed that wobbly wheel by welding it to the axle. 
This will cause you more problems long term than a Java error.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| prasadzkv |
| Posted: Thu Aug 04, 2016 6:31 am Post subject: |
|
|
Novice
Joined: 13 Jul 2016
Posts: 21
Location: Chennai
|
Thanks Team For correcting.
Is there any way to handle the problem if yes could you please let me know, its very good help.
Thanks in advance. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 04, 2016 7:11 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| prasadzkv wrote: |
| Is there any way to handle the problem |
Clearly you need to pass this additional parameter.
| prasadzkv wrote: |
| if yes could you please let me know |
You could try reading the InfoCenter on how to set up JDBC connections, starting here. I commend 2 parts in particular to you:
1) The part where it says:
| Quote: |
| If the specified URL format contains non-standard JDBC data source properties, such as a server identifier, specify one of five general-purpose connection attributes to define these additional properties. |
2) The part where it says:
| Quote: |
| Do not use the mqsichangeproperties command to change the pattern itself; changes made to the pattern might cause unpredictable results |
which should have been a clue that the solution you came up with was a bad idea appended to the back of a bad idea.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| prasadzkv |
| Posted: Fri Aug 05, 2016 1:03 am Post subject: |
|
|
Novice
Joined: 13 Jul 2016
Posts: 21
Location: Chennai
|
|
| Back to top |
|
|
|
|
