[
http://jira.codehaus.org/browse/MSQL-55?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=226093#action_226093
]
Johan Romme commented on MSQL-55:
---------------------------------
Hi,
With the supplied example I've been able to reproduce and resolve this issue.
In the supplied example one statement creates a stored procedure with inside
the procedure a string spread over 2 lines.
lines 35 and 36 of the sql script are the following:
iierrornumber; :msg = 'Code=' + varchar(:err_code)+' Msg=sp_visit_upda
te_facility_exam: UPDATE EXAM SET foo_f_ekey WHERE bar_v_key = ' +
Note the string that starts with ' Msg=sp_visit_upda' and that continues on the
next line.
The problem can be resolved/worked-around in 2 ways:
- by changing the sql script, concatenating line 35 and 36 to be the following:
iierrornumber; :msg = 'Code=' + varchar(:err_code)+'
Msg=sp_visit_update_facility_exam: UPDATE EXAM SET foo_f_ekey WHERE bar_v_key =
' +
or
- by setting keepFormat=false in the sql-maven-plugin configuration:
<configuration>
<driver>com.ingres.jdbc.IngresDriver</driver>
<url>jdbc:ingres://localhost:21071/mcp0</url>
<username></username>
<password></password>
<autocommit>true</autocommit>
<keepFormat>false</keepFormat>
<delimiterType>row</delimiterType>
<delimiter>go</delimiter>
<encoding>US-ASCII</encoding>
</configuration>
With the original example the sql:execute was about 70 seconds, with both
solutions the sql:execute was about 2 seconds.
grtx,
Johan.
> Very slow performance create stored procedures on Ingres Database
> -----------------------------------------------------------------
>
> Key: MSQL-55
> URL: http://jira.codehaus.org/browse/MSQL-55
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.4
> Environment: Client Machine running Maven SQL Plugin: Window XP SP3,
> Server running Ingres DB, Windows Server 2003, Ingres DB version 3.0, however
> same problem on Ingres 9.3
> Reporter: Christopher E. Correale
> Priority: Minor
> Attachments: codehausExample.zip
>
>
> When running mvn sql:execute, stored procs take an avg 8 mins to build a
> single stored proc. while other database object types can be built in
> fractions of a second.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
