I apologize for my bad English, that's why I use an online translator I have tried to understand the functioning of the RDC connector but I didn't get any results. I need to access ms sql server database, I downloaded the driver for sql server from
http://jtds.sourceforge.net/, I downloaded the DRC both the server and the client, I configured the config.properties file properties as shown in the tutorial and change the bat RunRLC. At this point start the fix (surely I did not understand well how it works) I use the database and the server on localhost. When I run the bat there's errors in console, but if I run the test as per the tutorial server responds, but I report the following error:
RemoteServer is running (Wed Nov 20 08:39:14 CET 2013) java.sql.SQLException
An attempt by a client to checkout a Connection has timed out.
also I have not clear how does logic level (this is the first time I use a web server) operation of DRC If I have to work with tables in a database of a company and manage such as customer accounts or products like I do?.
I am attaching the file config to see itself is correctly set.
Thank you for the answers that I will be given.
#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
#DriverClass=com.mysql.jdbc.Driver
#JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds://127.0.0.1/test
User=sa
Password=comelavecchia
ServerPort=17178
#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.create_table=CREATE TABLE animals (\
id INT NOT NULL AUTO_INCREMENT,\
name CHAR(30) NOT NULL,\
image BLOB,\
PRIMARY KEY (id))
sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
sql.select_animal=SELECT name, image FROM animals WHERE name = ?
