Hello,
i'm trying to migrate data from Derby to H2 using scriptella.
For some reason, when trying to pass large data from Derby to H2, i
get a strange error with scriptella when inserting values into H2
" JDBC provider exception: Cannot initialize temprorary file
storage "
The script causing this:
<query connection-id="derby_jobs">
SELECT * FROM JOBS;
<script connection-id="h2_jobs">
INSERT INTO JOBS(JOB_ID, BATCH_ID, TYPE, DESCRIPTION,
STATE, FAILURE_REASON, LOCK_NAME, TARGET_WORKER,
WORKER, COMMAND, WORKER_START_TIME, WORKER_END_TIME,
WORKER_RESULT, LOG_FILE_NAME, OUTPUT_FILE_NAME, OUTPUT_FILE_SIZE )
values (?JOB_ID, ?BATCH_ID, ?TYPE, ?DESCRIPTION, ?
STATE, ?FAILURE_REASON, ?LOCK_NAME, ?TARGET_WORKER,
?WORKER, ?COMMAND, ?WORKER_START_TIME, ?WORKER_END_TIME, ?
WORKER_RESULT, ?LOG_FILE_NAME, ?OUTPUT_FILE_NAME, ?OUTPUT_FILE_SIZE);
</script>
Does anyone have an idea how i can fix this? could this be caused by
the H2 driver?
Thank you
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
