Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect
---------------------------------------------------------------------- Key: OFBIZ-332 URL: http://issues.apache.org/jira/browse/OFBIZ-332 Project: OFBiz (The Open for Business Project) Issue Type: Bug Components: framework Environment: Windows XP SQL Server Express 2005 SQL Server JDBC Driver 1.1 Reporter: Cameron Smith Priority: Minor [This is a followon to a thread on OpenTAPS General Users Discussion: http://sourceforge.net/forum/forum.php?thread_id=1572185&forum_id=487771] The default settings for driver name and URL in the localmssql section of entityengine.xml are wrong for my platform, and given their nature I suspect they are wrong for earlier versions of SQL Server and MS JDBC driver as well. After some experimentation, I can contributed the corrected settings. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
[ http://issues.apache.org/jira/browse/OFBIZ-332?page=all ]
Cameron Smith updated OFBIZ-332: -------------------------------- Attachment: 1572185.patch The attached patch fixes the two relevant parameters, assuming a typical setup of username, password, dbname all = to 'ofbiz', as is the norm with other DBs. I also included a comment section which gives tips to avoid major time wasting issues specific to JDBC connection to SQL Server. Please feel free to move these comments to somewhere else if you feel it would be more appropriate. > Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect > ---------------------------------------------------------------------- > > Key: OFBIZ-332 > URL: http://issues.apache.org/jira/browse/OFBIZ-332 > Project: OFBiz (The Open for Business Project) > Issue Type: Bug > Components: framework > Environment: Windows XP > SQL Server Express 2005 > SQL Server JDBC Driver 1.1 > Reporter: Cameron Smith > Priority: Minor > Attachments: 1572185.patch > > > [This is a followon to a thread on OpenTAPS General Users Discussion: http://sourceforge.net/forum/forum.php?thread_id=1572185&forum_id=487771] > The default settings for driver name and URL in the localmssql section of entityengine.xml are wrong for my platform, and given their nature I suspect they are wrong for earlier versions of SQL Server and MS JDBC driver as well. After some experimentation, I can contributed the corrected settings. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-332?page=all ]
Jacques Le Roux reassigned OFBIZ-332: ------------------------------------- Assignee: Jacques Le Roux > Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect > ---------------------------------------------------------------------- > > Key: OFBIZ-332 > URL: http://issues.apache.org/jira/browse/OFBIZ-332 > Project: OFBiz (The Open for Business Project) > Issue Type: Bug > Components: framework > Environment: Windows XP > SQL Server Express 2005 > SQL Server JDBC Driver 1.1 > Reporter: Cameron Smith > Assigned To: Jacques Le Roux > Priority: Minor > Attachments: 1572185.patch > > > [This is a followon to a thread on OpenTAPS General Users Discussion: http://sourceforge.net/forum/forum.php?thread_id=1572185&forum_id=487771] > The default settings for driver name and URL in the localmssql section of entityengine.xml are wrong for my platform, and given their nature I suspect they are wrong for earlier versions of SQL Server and MS JDBC driver as well. After some experimentation, I can contributed the corrected settings. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-332?page=comments#action_12438063 ]
Jacques Le Roux commented on OFBIZ-332: --------------------------------------- This sounds good, if nobody complains I will commit this patch in some days... > Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect > ---------------------------------------------------------------------- > > Key: OFBIZ-332 > URL: http://issues.apache.org/jira/browse/OFBIZ-332 > Project: OFBiz (The Open for Business Project) > Issue Type: Bug > Components: framework > Environment: Windows XP > SQL Server Express 2005 > SQL Server JDBC Driver 1.1 > Reporter: Cameron Smith > Assigned To: Jacques Le Roux > Priority: Minor > Attachments: 1572185.patch > > > [This is a followon to a thread on OpenTAPS General Users Discussion: http://sourceforge.net/forum/forum.php?thread_id=1572185&forum_id=487771] > The default settings for driver name and URL in the localmssql section of entityengine.xml are wrong for my platform, and given their nature I suspect they are wrong for earlier versions of SQL Server and MS JDBC driver as well. After some experimentation, I can contributed the corrected settings. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-332?page=all ]
Jacques Le Roux closed OFBIZ-332. --------------------------------- Fix Version/s: SVN trunk Resolution: Fixed Completed: At revision: 451294 Thanks Cameron > Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect > ---------------------------------------------------------------------- > > Key: OFBIZ-332 > URL: http://issues.apache.org/jira/browse/OFBIZ-332 > Project: OFBiz (The Open for Business Project) > Issue Type: Bug > Components: framework > Environment: Windows XP > SQL Server Express 2005 > SQL Server JDBC Driver 1.1 > Reporter: Cameron Smith > Assigned To: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: 1572185.patch > > > [This is a followon to a thread on OpenTAPS General Users Discussion: http://sourceforge.net/forum/forum.php?thread_id=1572185&forum_id=487771] > The default settings for driver name and URL in the localmssql section of entityengine.xml are wrong for my platform, and given their nature I suspect they are wrong for earlier versions of SQL Server and MS JDBC driver as well. After some experimentation, I can contributed the corrected settings. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
Free forum by Nabble | Edit this page |