You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "danjreyes (via GitHub)" <gi...@apache.org> on 2024/05/31 22:23:24 UTC
[I] [Bug]: Table output insert statement does not quote field names in INSERT statement (hop)
danjreyes opened a new issue, #4002:
URL: https://github.com/apache/hop/issues/4002
### Apache Hop version?
2.9.0
### Java version?
11.0.22
### Operating system
Windows
### What happened?
I am trying to use the Table output action to insert data into a SQL Server table. Some of the fields in the table have spaces in them. In the driver settings, I have the "Quote all identifiers in database" option checked.
However, it appears that the INSERT statement is being generated without the quote symbols around the field names which cause a failure.
### Issue Priority
Priority: 2
### Issue Component
Component: Actions
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Table output insert statement does not quote field names in INSERT statement (hop)
Posted by "sramazzina (via GitHub)" <gi...@apache.org>.
sramazzina commented on issue #4002:
URL: https://github.com/apache/hop/issues/4002#issuecomment-2143318894
Hi @danjreyes, which database type are you using?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Table output insert statement does not quote field names in INSERT statement (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #4002: [Bug]: Table output insert statement does not quote field names in INSERT statement
URL: https://github.com/apache/hop/issues/4002
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Table output insert statement does not quote field names in INSERT statement (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4002:
URL: https://github.com/apache/hop/issues/4002#issuecomment-2690792948
the quotes in the conneciton type are blanks, replacing them with "[" and "]"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Table output insert statement does not quote field names in INSERT statement (hop)
Posted by "danjreyes (via GitHub)" <gi...@apache.org>.
danjreyes commented on issue #4002:
URL: https://github.com/apache/hop/issues/4002#issuecomment-2143433555
@sramazzina, I'm using MS SQL Server database. I'm using the MS SQLSERVER (not the native) driver.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Table output insert statement does not quote field names in INSERT statement (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4002:
URL: https://github.com/apache/hop/issues/4002#issuecomment-2143584618
Unless it's an older MS SQL that still requires the jtds drivers I would highly recommend using the newer version.
Other than that this should indeed not be happening so we will take a look.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org