Create a new Database table

KNIME Analytics Platform
1

Hi,

I need to create a workflow that will create a new table in a SQLite database. The workflow I have is really simple but it works. I need to add some functionality that will allow the user to provide a unique name for the table.

Does anyone have an idea of how I can do this without requiring the user to type the name into SQL script?

tC/.

2

Hi Tiger,

two things: we recently published a Database Table Creator node, with which you can create a table.

For creating the table name I would use a String input quickform and than use the variable to create thetable name.

Best, Iris

PS: Or do you want to deploy this with the KNIME Webportal?

3

Hi @Iris ,

I am currently using the Database Table Creator node ‘dynamic settings’ to create a table in access. It continuously has challenges with the data presented to it and a series of errors due to data types, e.g. double data type to be 28 chars or less, no “*” in the heading, no “_” in the heading, and the latest error is confusing - as the writer was working fine until now.

No # or * allowed:
ERROR Database Table Creator 0:1070:885 Execute failed: UCAExc:::4.0.4 java.sql.SQLSyntaxErrorException: unexpected token: ActiveInd (#1)

ERROR Database Table Creator 0:1070:885 Execute failed: UCAExc:::4.0.4 java.sql.SQLSyntaxErrorException: unexpected token: *Planned_OnDemand

Precision error
ERROR Database Table Creator 0:1070:885 Execute failed: UCAExc:::4.0.4 Precision must be from 1 to 28 inclusive, found 30(Column=Area_SQFT)

Latest Error
ERROR Database Table Creator 0:1070:885 Execute failed: UCAExc:::4.0.4 java.sql.SQLNonTransientConnectionException: connection exception: closed

Do you have suggestions on how to get around these issues - particularly the latest error?

4