PDA

View Full Version : Error when spoon writting in the repository



kettle_anonymous
04-06-2006, 12:05 AM
- I've created the repository in a Oracle 9i database.


- When I want to save a transformation, I receive the error message below. It seems to be a column definition issue.



- Is repository management reliable enough or should i better use local files ?
- has repository been tested with Oracle ?
- do you know if a fix exists to solve this problem?



Thierry

<hr />


Error saving transformation to repository!



Unable to commit connection after having inserted rows.
ORA-01461: can bind a LONG value only for insert into a LONG column



java.lang.reflect.InvocationTargetException: Error saving transformation: be.ibridge.kettle.core.exception.KettleException:
Error saving transformation to repository!



Unable to commit connection after having inserted rows.
ORA-01461: can bind a LONG value only for insert into a LONG column

kettle_anonymous
04-06-2006, 06:17 AM
I have encountered this same issue in Oracle 9i, we elected to store our repositories in postgre. I believe I know the issue, R_TRANSFORMATION stores a number of values as -1 for some transformations, in Oracle the repository creates with definition NUMBER(9,0). The fields won't take a signed value.

kettle_anonymous
04-06-2006, 06:55 AM
Thank you for your reply


Thierry

MattCasters
04-06-2006, 11:46 AM
Except that this is not the correct answer of-course.
Kettle repositories work perfectly fine on Oracle.
I have knowledge of several sites running perfectly fine on Oracle.

I suspect there are AGAIN some issues with JDBC drivers and database version mixups. Unfortunately, we will have sweat this one out as the Oracle JDBC drivers are not backward compatible and the old ones not forward compatible.
In a few months time we will have database connection plugins and this will eliminate this problem.

BUT, I would be very gratefull if you could send me something more besides this single ORA- line.
What is the complete stack trace? Perhaps we can find a workaround by simplifying things?
What&#39;s the version of Kettle used?

Thanks,
Matt

MattCasters
04-06-2006, 11:47 AM
Just for the record, Oracles data type NUMBER(9,0) takes a -1 just fine!
Don&#39;t want you to get the wrong idea about Oracle ;-)

Hey, the database is not THAT bad...

Matt