You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Richard Qualis (JIRA)" <ju...@ws.apache.org> on 2009/04/20 15:29:51 UTC
[jira] Created: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
ERROR: save_publisher fail. Embedded SQL error.
-----------------------------------------------
Key: JUDDI-222
URL: https://issues.apache.org/jira/browse/JUDDI-222
Project: jUDDI
Issue Type: Bug
Components: core
Affects Versions: 2.0rc6
Environment: Linux
Reporter: Richard Qualis
Assignee: Kurt T Stam
Go to Consol(Beta)
Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
Click on save_publisher
Past the authInfo:#### in SOAP msg and complete other required attribues.
Click submit
RESULT:
Fault response returned.
SERVER LOG:
In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
SOLUTION:
Removed the extra parenthesis found. There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
TEST:
I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
COMMENT:
Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Richard Qualis (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richard Qualis updated JUDDI-222:
---------------------------------
Attachment: screenshot-1.jpg
This is the screen I was working from when I got the error. See my notes on how to recreate the issue. I also upted my comments with the name of the class file the error was found in.
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Kurt T Stam
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Richard Qualis (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richard Qualis updated JUDDI-222:
---------------------------------
Description:
Go to Consol(Beta)
Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
Click on save_publisher
Past the authInfo:#### in SOAP msg and complete other required attribues.
Click submit
RESULT:
Fault response returned.
SERVER LOG:
In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
SOLUTION:
Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
// build insertSQL
sql = new StringBuffer(150);
sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
sql.append("PUBLISHER_ID,");
sql.append("PUBLISHER_NAME,");
sql.append("EMAIL_ADDRESS,");
sql.append("IS_ADMIN, ");
sql.append("IS_ENABLED, ");
sql.append("MAX_BUSINESSES, ");
sql.append("MAX_SERVICES_PER_BUSINESS, ");
sql.append("MAX_BINDINGS_PER_SERVICE, ");
sql.append("MAX_TMODELS) ");
sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
insertSQL = sql.toString();
There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
TEST:
I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
COMMENT:
Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
was:
Go to Consol(Beta)
Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
Click on save_publisher
Past the authInfo:#### in SOAP msg and complete other required attribues.
Click submit
RESULT:
Fault response returned.
SERVER LOG:
In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
SOLUTION:
Removed the extra parenthesis found. There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
TEST:
I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
COMMENT:
Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Kurt T Stam
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Tom Cunningham (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom Cunningham reassigned JUDDI-222:
------------------------------------
Assignee: Tom Cunningham (was: Kurt T Stam)
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Tom Cunningham
> Fix For: 2.0
>
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Richard Qualis (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12700818#action_12700818 ]
Richard Qualis commented on JUDDI-222:
--------------------------------------
I do not have the stack trace anymore because I fixed the issue. I found the java file in this jar file juddi-2-1.0rc6-sources.jar The deployed file was juddi-2-1.0rc6.jar. Hope this helps.
Sorry, next time I will post the complete stack trace.
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Kurt T Stam
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Tom Cunningham (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom Cunningham updated JUDDI-222:
---------------------------------
Fix Version/s: 2.0
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Tom Cunningham
> Fix For: 2.0
>
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (JUDDI-222) ERROR: save_publisher fail. Embedded SQL
error.
Posted by "Kurt T Stam (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kurt T Stam closed JUDDI-222.
-----------------------------
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Tom Cunningham
> Fix For: 2.0rc7
>
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Tom Cunningham (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom Cunningham resolved JUDDI-222.
----------------------------------
Resolution: Fixed
Removed extraneous ")" signs in both trunk and 20rc6 branch.
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Tom Cunningham
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Tom Cunningham (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12700805#action_12700805 ]
Tom Cunningham commented on JUDDI-222:
--------------------------------------
Could you provide a screenshot and any applicable stack trace? Which console (URL would help) are we talking about? What file did you fix by removing the extra parenthesis?
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Kurt T Stam
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found. There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JUDDI-222) ERROR: save_publisher fail. Embedded
SQL error.
Posted by "Kurt T Stam (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kurt T Stam updated JUDDI-222:
------------------------------
Fix Version/s: (was: 2.0)
2.0rc7
> ERROR: save_publisher fail. Embedded SQL error.
> -----------------------------------------------
>
> Key: JUDDI-222
> URL: https://issues.apache.org/jira/browse/JUDDI-222
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0rc6
> Environment: Linux
> Reporter: Richard Qualis
> Assignee: Tom Cunningham
> Fix For: 2.0rc7
>
> Attachments: screenshot-1.jpg
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> Go to Consol(Beta)
> Click on get_authToken. Execute process which will return the authInfo. Copy authInfo returned
> Click on save_publisher
> Past the authInfo:#### in SOAP msg and complete other required attribues.
> Click submit
> RESULT:
> Fault response returned.
> SERVER LOG:
> In the log there is a report of SQL error in the INSERT INTO statement org.apache.juddi.datastore.jdbc.PublisherTable. There were extra Removed the extra parenthesis ) in the SQL
> SOLUTION:
> Removed the extra parenthesis found in the INSERT statement found in class org.apache.juddi.datastore.jdbc.PublisherTable. This to be exact
> // build insertSQL
> sql = new StringBuffer(150);
> sql.append("INSERT INTO ").append(tablePrefix).append("PUBLISHER (");
> sql.append("PUBLISHER_ID,");
> sql.append("PUBLISHER_NAME,");
> sql.append("EMAIL_ADDRESS,");
> sql.append("IS_ADMIN, ");
> sql.append("IS_ENABLED, ");
> sql.append("MAX_BUSINESSES, ");
> sql.append("MAX_SERVICES_PER_BUSINESS, ");
> sql.append("MAX_BINDINGS_PER_SERVICE, ");
> sql.append("MAX_TMODELS) ");
> sql.append("VALUES (?,?,?,?,?,?,?,?,?)");
> insertSQL = sql.toString();
> There were about 4. Rebuilt the juddi-2-1.0rc6.jar and redeployed to server. Restart the AS.
> TEST:
> I tried to save a publisher and no error returned. I checked the PUBLISHER table and the new publisher was entered.
> COMMENT:
> Can this be fixed in the next release. Not sure why I was never able to get 3.0 working on Linux; so maybe this was fixed in 3.0. Thanks
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.