Openrefine: can't export the data from database

[mmaithani]

problem during connecting with database

error:Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "18.136.56.185:3365"'.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Create Project'
2. Click on 'Database'
3. Fill the Database field for connection(demo)"confidential data"
   'DB Name: project_sales
   Table Name: data
   Host: http:18.136.56.188
   Username: dm_team2
   Password: NA '
4. See error -popup

Current Results

error- open refine

Screenshots

Desktop:

• OS: [Windows 10]64 bit
• Browser Version: chrome 76
  
  
  
  • java version "1.8.0_221"
    
    Java(TM) SE Runtime Environment (build 1.8.0_221-b11)
    
    Java HotSpot(TM) Client VM (build 25.221-b11, mixed mode)
  
  

**open refine- Version 3.2 [55c921b]

[tcbuzor]

why add the http protocol to the host field?

[wetneb]

The import error is likely to be due to the inclusion of http in the host field, which prevents OpenRefine from connecting to the database.