Cannot map java type [class java.lang.Object] to a valid database type.

Question

Hi,

I created the aggregate database from the detail database using QBE (grouping the attribute and sum the measure) by checking the persist in the Advance tab.

From that aggregate database, I created the dataset and then the cockpit.

• If the dataset and the cockpit document created WITHOUT parameters, the cockpit WILL show the graph.
• If the dataset and the cockpit document created WITH parameters, the cockpit WILL NOT show and graph and found in the logs knowage this error: [http-bio-8080-exec-1] 31 Des 2018 09:33:11,262 ERROR it.eng.spagobi.utilities.database.PostgreSQLDataBase.getDataBaseType:88 - Cannot map java type [class java.lang.Object] to a valid database type. Set TEXT by default.

In the analytical driver, I use type as String

Thanks for the help.

Comments

Dear.
Could be a problem about type mapping on driver jdbc.

Wich PostgresQL version are you using ?

Best Regards

A.

---

Hi Abernabel,

Thanks for your reply.

The PostgreSQL version is postgresql-11.1-1-windows-x64,  the jar jdbc file is postgresql-42.2.5.jar and  the java version is 1.8.0_161 build 1.8.0_161-b12.

Best Regards,

Panggeulisna

SOLVED: In order to manage the cache table, I created the different data schema for business data and cache.  And I had this error.  

Now I set the cache and business data in the same data schema, the error is gone.

It's better to able create the dedicated data schema for the cache because it will nice if only the business data table listed in the table list during creating the business model, not including cache files.