JOSSO

Test Connection and Test Query not working

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: JOSSO 2.0.2
  • Fix Version/s: None
  • Component/s: None
  • Description:
    Hide
    I create a DB Identity source

    Name : DB-ID1
    Driver: JDBC ODBC Bridge
    connection url : jdbc:mysql://localhost:3306/test_db
    username=xyz
    password=xyz

    and clicked Test Connection. I didnt get any response. I'm using MySQL not sure whether I should give a different driver. Drop down is showing only one item though

    Thank You
    Marshal
    Show
    I create a DB Identity source Name : DB-ID1 Driver: JDBC ODBC Bridge connection url : jdbc:mysql://localhost:3306/test_db username=xyz password=xyz and clicked Test Connection. I didnt get any response. I'm using MySQL not sure whether I should give a different driver. Drop down is showing only one item though Thank You Marshal
  • Environment:
    Windows 7

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Marshal Jayason added a comment - 15/Feb/11 2:05 PM
I forgot to mention that I'm facing this issue while using Josso2 visual designer
Show
Marshal Jayason added a comment - 15/Feb/11 2:05 PM I forgot to mention that I'm facing this issue while using Josso2 visual designer
Hide
Permalink
Gianluca Brigandi added a comment - 15/Feb/11 3:05 PM
Make sure that :
* The MySQL ODBC driver is installed in the host running JOSSO2
* A DSN (Data Source Name) for the database holding user and entitlement tables has been setup

The connection URL should have the following format :
jdbc:odbc:DSN[;user=xxx][;password=xxx]
Show
Gianluca Brigandi added a comment - 15/Feb/11 3:05 PM Make sure that : * The MySQL ODBC driver is installed in the host running JOSSO2 * A DSN (Data Source Name) for the database holding user and entitlement tables has been setup The connection URL should have the following format : jdbc:odbc:DSN[;user=xxx][;password=xxx]
Hide
Permalink
Marshal Jayason added a comment - 15/Feb/11 3:40 PM
How to ensure MySQL ODBC driver is installed in the host running JOSSO2 ?
Show
Marshal Jayason added a comment - 15/Feb/11 3:40 PM How to ensure MySQL ODBC driver is installed in the host running JOSSO2 ?
Hide
Permalink
Gianluca Brigandi added a comment - 16/Feb/11 6:50 AM
Go to your control panel then Administrative Tools > Data Sources(ODBC)
Preview

The System DSN tab should show the MySQL entry.

For more information refer to Microsoft official documentation.


Show
Gianluca Brigandi added a comment - 16/Feb/11 6:50 AM Go to your control panel then Administrative Tools > Data Sources(ODBC) Preview The System DSN tab should show the MySQL entry. For more information refer to Microsoft official documentation.
Hide
Permalink
Srdjan added a comment - 27/Oct/12 7:01 AM
Hello,

I have the same problem, when I click test database I don't get any action at all, not any error or response, like program is dead.
I have tried mysql and sql server connection trough ODBC Data Source Administrator and test was successful.
Can you help me please.

Thanks,

Srdjan
Show
Srdjan added a comment - 27/Oct/12 7:01 AM Hello, I have the same problem, when I click test database I don't get any action at all, not any error or response, like program is dead. I have tried mysql and sql server connection trough ODBC Data Source Administrator and test was successful. Can you help me please. Thanks, Srdjan

People

Dates

  • Created:
    14/Feb/11 10:56 AM
    Updated:
    27/Oct/12 7:01 AM
    Resolved:
    15/Feb/11 3:05 PM
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for JOSSO. Try JIRA - bug tracking software for your team.