problem in tDBInput Invalid escape sequence (valid ones are \b

[Anonymous]

Hello everyone,

I'm a new TOS user.

I'm trying to "guess the schema" in a tDBInput component, but I have the following error "Invalid escape sequence (valid ones are \b... "

I saw that there are still many post about this problem and as I understand, the problem comes from the "\" (backslash character).

Indeed, my hostname contains a "\" ( configuration in the attached screenshot ) and so I think the problem comes from this value.

But if I try to change it, the connection doesn't work anymore.

If I let it as it is, the connection is working, but I can't guess the schema.

Does anyone have a solution for this problem?

Thank you

Julien

[nivedhitha]

@JulienM ,

i guess \ should be escaped. Can you try doing "ORDI\\RECETTE"  for the host name?

[Anonymous]

Hello nivedhita, 

Thank you for your answer. 

I still tried this and it doesn't work in my case.

I have found an other way to parameter my connection in order not to have a '\' character:

jdbc:sqlserver://ORDI;DatabaseName=STATS;InstanceName=RECETTE

When I'm testing the connection, it is working, 

But when I'm running the job, I have a new problem: 

Exception in component tDBInput_1 (TEST)
com.microsoft.sqlserver.jdbc.SQLServerException: L'instruction n'a pas renvoyé le jeu de résultat.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:893)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:677)
 at local_project.test_0_1.TEST.tDBInput_1Process(TEST.java:1116)
 at local_project.test_0_1.TEST.runJobInTOS(TEST.java:2510)
 at local_project.test_0_1.TEST.main(TEST.java:2360)

[Anonymous · Accepted solution]

The problem has been solved. 

I think the last error was due to the fact I didin't write a request in the "request" zone of the tDBInput component. 

Thank you