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

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

Anonymous — Mon, 20 Jan 2020 15:43:54 GMT

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

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

nivedhitha — Tue, 21 Jan 2020 21:48:46 GMT

@JulienM ,

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

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

Anonymous — Wed, 22 Jan 2020 09:15:55 GMT

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)

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

Anonymous — Wed, 22 Jan 2020 10:23:43 GMT

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