|
From: John V. S. <js...@gm...> - 2008-06-06 20:21:41
|
David W wrote: > I have researched UDX on > http://pub.eigenbase.org/wiki/LucidDbUdxJavaHowto. It seemed to me that > the Java code load all data into one table. For me, I need to load data > into different tables accordingly. So how can I tell the system which > table to use when loading? If you do what Zelaine suggested, you would want to write a user-defined procedure rather than a UDX. An example of a UDP which invokes dynamic SQL is here: http://pub.eigenbase.org/wiki/LucidDbAppLib_DO_FOR_ENTIRE_SCHEMA Code: http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/util/DoForEntireSchemaUdp.java > Another question is that I wonder if I have to build .Jar file and > install it in SQL. As I need my code to run continuously at the back > end, are there any other ways to invoke this code? Instead of a UDP, you can also just write a JDBC client program which automates your logic, and either run it as a separate process, or run it in the same app server if you are deploying LucidDB as an mbean: http://pub.eigenbase.org/wiki/LucidDbAsManagedBean For complex scheduling/automation logic, people typically use a workflow system of some kind. JVS |