Hi,
I am getting random errors from jRDC. It is directly related with the config.properties file and the format character "\" used to split the sql command lines ie to make the sql commands more readable. If I bring the sql commands to one single line then it is working as expected. Please note that, I already have many sql commands in the same config.properties file that are formatted using the "\" character and all those are working fine. Only the recently/last added commands are behaving erratically and throwing random errors OR the giving output.
I am getting the following error. From the error, I understand that it is something related to the parameter. But actually nothing wrong with the parameter.
Whenever I add new sql commands at the bottom in the config.properties file , I am getting these kinds of errors. That's what I understand.
Screen Snapshot of the config.properties file that throws error. (Highlighted in Yellow Color).
When I modified the same sql command line, removing the line split ie "\" it started working.
But I am using similar character ie "\" to split the lines and to make the sql commands in the config.properties file readable. All those are working fine in the same file.
What could be wrong ?. Is it because the length (no of lines) of the config.properties increased beyond a point ?. The total no of lines reached a count of 197 as of now.
Prior to the error, my SQL query result set was not sorted even though I had given the ORDER BY clause in it.
After I removed the "\" character and removed all the ENTER KEY characters and brought everything to one single line, then it started working as expected.
Any idea what could be wrong ?
I use notepad to modify the config.properties file.
Thanks & Regards
Anser
I am getting random errors from jRDC. It is directly related with the config.properties file and the format character "\" used to split the sql command lines ie to make the sql commands more readable. If I bring the sql commands to one single line then it is working as expected. Please note that, I already have many sql commands in the same config.properties file that are formatted using the "\" character and all those are working fine. Only the recently/last added commands are behaving erratically and throwing random errors OR the giving output.
I am getting the following error. From the error, I understand that it is something related to the parameter. But actually nothing wrong with the parameter.
B4X:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body>
<h2>HTTP ERROR: 500</h2>
<p>Problem accessing /rdc. Reason:
<pre> java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).</pre></p>
<hr /><i><small>Powered by Jetty://</small></i>
</body>
</html>
Reached JobDone
Error: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).Whenever I add new sql commands at the bottom in the config.properties file , I am getting these kinds of errors. That's what I understand.
Screen Snapshot of the config.properties file that throws error. (Highlighted in Yellow Color).
When I modified the same sql command line, removing the line split ie "\" it started working.
But I am using similar character ie "\" to split the lines and to make the sql commands in the config.properties file readable. All those are working fine in the same file.
What could be wrong ?. Is it because the length (no of lines) of the config.properties increased beyond a point ?. The total no of lines reached a count of 197 as of now.
Prior to the error, my SQL query result set was not sorted even though I had given the ORDER BY clause in it.
B4X:
SELECT Full_Name, User_ID FROM cmn_users WHERE User_Types_ID = 7 AND App_Type_Mobile = 1 AND ACTIVE = 1 AND Comp_ID = ? ORDER BY Full_NameAfter I removed the "\" character and removed all the ENTER KEY characters and brought everything to one single line, then it started working as expected.
Any idea what could be wrong ?
I use notepad to modify the config.properties file.
Thanks & Regards
Anser
