Hi All, ver 3.2 GA on Linux
I have a H2 db created by PDI in a dir that is wide open for permissions and space etc. I have a job that checks to see if the H2 db file exists and if it does it uses the Check if Table Exists entry to see if the table "FOO" exists and if it doesn't it uses the SQL JOb entry to run a CREAT TABLE FOO ... I even added a "commit;" within the SQL Job Entry ... not sure if the commit is implicit or not at this point. Regardless I then have another Check if Table Exists and if it does I run a Trans that reads from a CSV file and uses a Table Output step to push the rows into my FOO table within the H2 db. I have verified that the H2 DB connection is Shared and that both the job and the trans are referencing the same db connection. They are! My Issue is the Trans fails saying that it can't find Table FOO and throws an H2 error within the log. So to recap: The Job knew the Table didn't exist and created it using the SQL entry. The Job then checked if the Table existed and it did so it calls the Trans. The Trans fails saying it can't find the Table. (The very same table that the Preceding Job found) UGH! :-) Anyone made it over this hump? Any thoughts MUCH appreciated. Thanks Kent -- 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.
