New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Non-provided columns filled with NULL, conflicts with default UUID #95
Comments
I have the same problem.
I send a lot of messages, for example
Why is the id field replaced with 0? |
Luckily I was able to generate a UUID at the message source, but that may not be possible with incremented ID. Out of curiosity, what database/version is this. Is this oracle? I have not seen these statements for default values before. |
It's Oracle 12.2.0.1 |
It works with |
I have a fluentd configuration that pulls data from the file and pushes to the SQL server however there is a primary key with the auto-incremented column, so, in my fluentd configuration if I don't mention that column it throws an error saying that the field is missing and if I include the column in the configuration it gives identity error, in below configuration "Id" is the primary and auto-incremented column, also let me know if adapter "sqlserver" is the right thing to use. <filter record.**>
|
@theis188 @pikhovkin |
I refused to write directly to Oracle, I write events through the Kafka and the handler, and already in the handler I write to Oracle |
@pikhovkin May I know, why did you go via that path, did you find fluentd configuration difficult/problamatic?? |
I have a field
pkey
which defaults to a generated uuid as follows:pkey UUID NOT NULL DEFAULT uuid_generate_v1(),
I think the plugin is autofilling any missing column with NULL:
The INSERT statement could omit the pkey field and the NULL statement and the database would auto-fill with
uuid_generate_v1()
, so the message would not have to contain uuid.The text was updated successfully, but these errors were encountered: