Android Question RDC / SQL Server java.sql.SQLException

[Declan]

I am attempting to query a SQL Server table with RDC.
I get this error:

java.sql.SQLException: Conversion failed when converting date and/or time from character string.
Error: Server Error

My Config file on the server is:

#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://197.xxx.xxx.xxx:1440/sectorstores
User=xxxxxx
Password=xxxxxx
ServerPort=17170
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
sql.get_dates=SELECT DISTINCT [Sale Date] FROM SalesEndUser
sql.sales_end_user=SELECT * FROM SalesEndUser WHERE [Sale Date] BETWEEN ? AND ?

Where the first "?" is the StartDate and the second "?" is the EndDate

My Sub that calls this query is:

Sub GetSales(Name As String)
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = "sales_end_user"
    cmd.Parameters = Array As Object(Name,StartDate,EndDate)
        Msgbox(StartDate,"StartDate")
        Msgbox(EndDate,"EndDate")
        Msgbox(cmd,"CMD")
    reqManager.ExecuteQuery(cmd, 0, "GetSales")
End Sub

Both variables; StartDate and EndDate are Global variables.
The MsgBox(s) are only for "debug" to make sure I have the correct data from the variables.

 

[Anser]

Where the first "?" is the StartDate and the second "?" is the EndDate

sql.sales_end_user=SELECT * FROM SalesEndUser WHERE [Sale Date] BETWEEN ? AND ?

As per your SQL statement, your SQL query expects ONLY 2 parameters , but you are sending 3 parameters.

cmd.Parameters = ArrayAs Object(Name,StartDate,EndDate)

First parameter that you are sending is name, 2nd parameter is StartDate, 3rd parameter is EndDate


Regards
Anser

 

[Declan]

@Anser many thanks
Sorted

 

[erasmusackon]

Please help.

#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://XXX.XXX.X.XX:1433/smart_microfinance
User=*****
Password=******
ServerPort=1433
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

 

[Erel]

1. Always start a new thread for your questions.
2. You should use jRDC2 instead of the older version.

This error means that there is already a server listening on the relevant port. It is most probably another instance of RDC.