CMDBuild Forum

Task manager / Connector problem

Old Versions
#1

Hi, I'm relatively new to CMDBuild and we're trying it out to see if it can do what we need.

So far things are looking good, but we came across problem with the Connector Wizard.

 

The logs say:

 

INFO  2015-03-11 14:18:59 [jsonrpc ] Calling url /schema/taskmanager/connector/availablesqlsources

ERROR 2015-03-11 14:18:59 [org.cmdbuild.common.logging] error invoking method 'public abstract void org.cmdbuild.common.java.sql.DataSourceTypes$DataSourceTypeVisitor.visit(org.cmdbuild.common.java.sql.DataSourceTypes$SqlServer)'

ERROR 2015-03-11 14:18:59 [org.cmdbuild.common.logging] error invoking method 'public abstract void org.cmdbuild.common.java.sql.DataSourceTypes$DataSourceTypeVisitor.visit(org.cmdbuild.common.java.sql.DataSourceTypes$MySql)'

 

This happens when we try to add a new connector task.

 

System speccs:

 

# cat /etc/*-release

LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Red Hat Enterprise Linux Server release 6.6 (Santiago)

 

 

# tomcat6 version

Server version: Apache Tomcat/6.0.24

Server built:   September 16 2014 1842

Server number:  6.0.24.0

OS Name:        Linux

OS Version:     2.6.32-504.8.1.el6.x86_64

Architecture:   amd64

JVM Version:    1.6.0_34-b34

JVM Vendor:     Sun Microsystems Inc.

 

# java -version

java version "1.6.0_34"

OpenJDK Runtime Environment (IcedTea6 1.13.6) (rhel-1.13.6.1.el6_6-x86_64)

OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)

 

CMDBuild Version 2.3.0 (03/02/2015) from http://sourceforge.net/projects/cmdbuild/

and is also present when compiling from source: http://sourceforge.net/p/cmdbuild/main/ci/default/tree/

 

#2

We configured without problems several Wizard Connectors.
Probably your error depends on how you have configured the various steps of the wizard (not described in your post).
CMDBuild Team

#3

Th

ank you for the reply.

 

In our case it happens with a fresh install and an empty database.

 

As soon as I get to the Datasource wizard step and click on the "Type" dropdown menu, the error is logged and only PostgresSQL is displayed on the list.

(I think there's a flicker of a larger selection of DB Types, but it disapears immediately)

Here's a screenshot.

http://postimg.org/image/xzwbr5box/

 

If you're unable to reproduce the problem, I can only assume there's an issue with our tomcat and or java setup, but i have no idea where to start looking.

 

Previously Tecnoteca wrote:
We configured without problems several Wizard Connectors.
Probably your error depends on how you have configured the various steps of the wizard (not described in your post).
CMDBuild Team

 

#4

With your screenshot perhaps we understand the problem.
To show in the list the names of the enabled databases, CMDBuild checks for JDBC drivers of PostgreSQL, MySQL, SQLServer and Oracle (the four supported databases).
The search for the driver of MySQL, SQLServer and Oracle produces the error in the log (a “controlled” error) and in the list appears correctly only PostgreSQL.
CMDBuild Team

#5

It seems you were right!

 

I added the needed drivers to tomcat6/lib and the error is no longer there.

 

Thank you for your help!

:D

 

Previously Tecnoteca wrote:
With your screenshot perhaps we understand the problem.
To show in the list the names of the enabled databases, CMDBuild checks for JDBC drivers of PostgreSQL, MySQL, SQLServer and Oracle (the four supported databases).
The search for the driver of MySQL, SQLServer and Oracle produces the error in the log (a "controlled" error) and in the list appears correctly only PostgreSQL.
CMDBuild Team

 

#6
Hi Kristjan,
 
We are facing the same exact issue, and for some reason the drivers we've been trying to add do not solve the issue.
Would you care to tell us which drivers were used ?
Also, did you have to configure Tomcat/CMDBuild files for the application to recognize the freshly installed drivers ?
 
Thanks a lot,
 
Philippe
 
Previously Kristjan wrote:

It seems you were right!

 

I added the needed drivers to tomcat6/lib and the error is no longer there.

 

Thank you for your help!

:D

 

Previously Tecnoteca wrote:
With your screenshot perhaps we understand the problem.
To show in the list the names of the enabled databases, CMDBuild checks for JDBC drivers of PostgreSQL, MySQL, SQLServer and Oracle (the four supported databases).
The search for the driver of MySQL, SQLServer and Oracle produces the error in the log (a "controlled" error) and in the list appears correctly only PostgreSQL.
CMDBuild Team