"stream database operator - not working - JTDS - MS SQL Server 2008"

Hello,

I get error messages about "incorrect syntax near the keyword AS"

1) I'm using the JTDS driver to SQL Server
2) The table has a primary key and is indexed
3) When I specify the label, id and weight columns this does't seem to be recognized.

Find more posts tagged with

AI Studio

Server

Databases

SQL

Accepted answers

All comments

steffen

Hey bcourtney

It seems that the syntax of your sql - statement is broken. Did you try it (the statement) out on a console/gui which is directly linked with your database (like e.g. SQuirrel SQL) ?

greetings,

steffen

bcourtney

The SQL is valid.

steffen

Seems like you are a minimalist ... I'll copy your style for this thread

We do not have enough information for "remote debugging". Please post...
- the process xml
- the sql statement
- the log output after running the process

bcourtney

1) I am not using any operators that perform database writes at all.
2) The label column is also specified but later in the operation chain, operators can't "see" it.

Feb 23, 2011 3:28:27 PM CONFIG: Connecting to jdbc:jtds:sqlserver://localhost:xxxxx/Training;instance=SQLSERVER2008R2 as .
Feb 23, 2011 3:28:28 PM SEVERE: Process failed: operator cannot be executed (The 'set' operation (writing data) is not supported for this type of underlying example tables, e.g. it is not supported for a data table backed up by a database. Please transform into a memory based data table first, for example with the batch processing operator, or materialize the data table in memory.). Check the log messages...
Feb 23, 2011 3:28:28 PM SEVERE: Here: Root[1] (Process)

haddock

Are we meant to guess the log message? Get a grip!

bcourtney

That was the end of the log. There is no need to be so aggressive.

haddock

There is no need to be so aggressive.

:-*

bcourtney

I think I figured out the problem.

I used Rapidminer 4.6 some time ago. In that interface there was a "wizard" which let you specify what columns were, datatypes and roles.
That wizard is gone now. Now you can only specify the 3 basic roles when using a stream database operator, and I cannot connect a
role to the output of the database stream. It thinks I want to "write" data, when in fact I want to designate the roles inside rapidminer, not
be forced to "carefully craft" my input table. I think this is very limiting, mostly because this is a read only operation.

The stream database operator should have a "read-only" checkbox, so that role assignment and field designations can be made inside
Rapidminer I think.

Thanks

bcourtney

Still having a problem. I can read all my data in. When I highlight over the output from the Stream Database operator it shows the column count and Meta data infomation including a "label" column which I designated in the Stream Database Operator, however the learning methods receiving the example set input complain that a label has not been specified. additionally I cannot use set role because it thinks I might want to write to the database.

I'm stuck, any help appreciated.

land

Hi,
in contrast to the "Set" operator, the "set role" operator won't write to any database. What happens if you use it?

Greetings,
Sebastian