Re: [luciddb-users] UDX: how to load data into different tables

[John V. S. <js...@gm...>]

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