[jira] Created: (OFBIZ-332) Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (OFBIZ-332) Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect

Nicolas Malin (Jira)
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

       
Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-332) Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect

Nicolas Malin (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

       
Reply | Threaded
Open this post in threaded view
|

[jira] Assigned: (OFBIZ-332) Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect

Nicolas Malin (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

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-332) Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect

Nicolas Malin (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

       
Reply | Threaded
Open this post in threaded view
|

[jira] Closed: (OFBIZ-332) Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect

Nicolas Malin (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