Maven 2.x SQL Plugin

Replacing question marks in stored procedure scripts by bind variable symbols (e.g :1, :2 etc)

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Not A Bug
  • Affects Version/s: 1.3
  • Fix Version/s: None
  • Labels:
    None
  • Environment:
  • Number of attachments :
    0

Description

When I try to build a project database packeges contain bind variable symbols inside string literals.
Example: '<?xml version="1.0" encoding="utf-8" ?>' replaced by '<:1xml version="1.0" encoding="utf-8" :2>'

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Robert Scholte added a comment -

Nikolay, could you provide a testcase, just to see what you're trying to do?

Show
Robert Scholte added a comment - Nikolay, could you provide a testcase, just to see what you're trying to do?
Hide
Permalink
Robert Scholte added a comment -

It is definitely not a bug of the sql-maven-plugin, because it doesn't translate question marks to binding variables. There's actually only one question mark in the source code right now and this is even javadoc.
So it seems like the Oracle driver does some magic.
I found an article on how to handle XML content in queries:
http://psoug.org/reference/xml_functions.html

Enough reason for me to close this issue.

Show
Robert Scholte added a comment - It is definitely not a bug of the sql-maven-plugin, because it doesn't translate question marks to binding variables. There's actually only one question mark in the source code right now and this is even javadoc. So it seems like the Oracle driver does some magic. I found an article on how to handle XML content in queries: http://psoug.org/reference/xml_functions.html Enough reason for me to close this issue.

People

  • Assignee:
    Robert Scholte
    Reporter:
    Nikolay Kushin
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: