CMDBuild Forum

Lookup Parents : Connector task manager

Hello, 

 

I have a question, 

 

I am using everyday the connector feature in the task manager menu (mysql).

 

I used to update many informations on my serveurs (String input and lookups), it works well.

 

I needed to add a neew lookup with a "parent", for example :

 

Lookup parent : Operating System

CODE : WIN

DESCRIPTION : Windows

 

Lookup "Child": Version

CODE: WIN-2008

DESCRIPTION : Windows Server 2008

 

_____

 

CODE: WIN-SEVEN

DESCRIPTION : Windows Seven

 

But my problem is, I don't know how my datas in mysql should be, I tried :

Serveur name : My_Server_Name

OS : WIN-2008

 

I also tried 

Serveur name : My_Server_Name

OS : Windows Seven

 

But I always have the same error in my cmdbuild.log : 


org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "3306:3306"'.


Can you tell me how I need to "format" my data in my mysql database to add lookup datas when my lookup has a parent ?

 

Thank you

Fixed