Menu
▾
▴
luciddb-users — Mailing list for users of LucidDB
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(28) |
Jun
(2) |
Jul
(10) |
Aug
(1) |
Sep
(7) |
Oct
|
Nov
(1) |
Dec
(7) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(5) |
Feb
(7) |
Mar
(10) |
Apr
(12) |
May
(30) |
Jun
(21) |
Jul
(19) |
Aug
(17) |
Sep
(25) |
Oct
(46) |
Nov
(14) |
Dec
(11) |
| 2009 |
Jan
(5) |
Feb
(36) |
Mar
(17) |
Apr
(20) |
May
(75) |
Jun
(143) |
Jul
(29) |
Aug
(41) |
Sep
(38) |
Oct
(71) |
Nov
(17) |
Dec
(56) |
| 2010 |
Jan
(48) |
Feb
(31) |
Mar
(56) |
Apr
(24) |
May
(7) |
Jun
(18) |
Jul
(2) |
Aug
(34) |
Sep
(17) |
Oct
(1) |
Nov
|
Dec
(18) |
| 2011 |
Jan
(12) |
Feb
(19) |
Mar
(25) |
Apr
(11) |
May
(26) |
Jun
(16) |
Jul
(2) |
Aug
(10) |
Sep
(8) |
Oct
(1) |
Nov
|
Dec
(5) |
| 2012 |
Jan
(1) |
Feb
(3) |
Mar
(3) |
Apr
|
May
(2) |
Jun
|
Jul
(3) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
(2) |
Dec
|
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
|
1
|
2
|
3
|
4
|
5
(2) |
6
(3) |
7
|
|
8
|
9
(6) |
10
(5) |
11
(2) |
12
(1) |
13
|
14
|
|
15
|
16
|
17
|
18
|
19
(1) |
20
(1) |
21
|
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
|
29
|
30
|
|
|
|
|
|
|
From: John V. S. <js...@gm...> - 2008-06-20 01:27:14
|
David W wrote: > I wonder if there is a similiar function in LucidDB like > "time_to_sec(..)" in SQL. I checked > http://pub.eigenbase.org/wiki/LucidDbAppLib but I did not find this > function. > > > > Anybody knows how to handle "time_to_sec()" in LucidDB? There's no builtin yet, but it's easy to construct your own: create schema your_schema; create or replace function your_schema.time_to_sec(t time) returns integer deterministic contains sql return ( cast(applib.time_to_char('H', t) as integer)*3600 + cast(applib.time_to_char('mm', t) as integer)*60 + cast(applib.time_to_char('ss', t) as integer) ); select your_schema.time_to_sec(time '01:02:03') from (values(0)); +---------+ | EXPR$0 | +---------+ | 3723 | +---------+ Documentation for the underlying function is available here: http://pub.eigenbase.org/wiki/LucidDbAppLib_TIME_TO_CHAR SQL:2003 also supports an EXTRACT expression to do something similar, but it's not fully implemented in LucidDB. JVS |
|
From: David W <dav...@ya...> - 2008-06-19 23:30:54
|
Hi, I wonder if there is a similiar function in LucidDB like "time_to_sec(..)" in SQL. I checked http://pub.eigenbase.org/wiki/LucidDbAppLib but I did not find this function. Anybody knows how to handle "time_to_sec()" in LucidDB? Thanks so much. David |
|
From: John V. S. <js...@gm...> - 2008-06-12 08:01:37
|
Since there have been a number of new-user questions on this list recently, I've collected them together with the answers here: http://pub.eigenbase.org/wiki/LucidDbUserFaq Please feel free to add more (send me mail if you need a wiki account). JVS |
|
From: Oscar G. <og...@kt...> - 2008-06-11 01:57:34
|
Hello David, the "local" driver is local only in the sense "in the same java process", not in the sense "on the same machine", so you'll need to use the RMI driver. I would suggest using the class: com.lucidera.jdbc.LucidDbRmiDriver ...and the URL: jdbc:luciddb:rmi://localhost:5434 / Oscar On 10 jun 2008, at 18.07, David W wrote: > Hi, > > > As my code and LucidDB run on a same machine, I use > "com.lucidera.jdbc.LucidDbLocalDriver" as the name of driver class > following http://pub.eigenbase.org/wiki/ > JdbcUrlConventions#Conventions. After hours of debugging, however, I > found LucidDBClient.jar does not contain such a class file of > "LucidDbLocalDriver". This .jar file only contains > > LucidDbHttpDriver.class and LucidDbRmiDriver.class. > > > I need a jar file containing "LucidDbLocalDriver.class". Can anybody > help me? > > > Thanks a lot. > > > David > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php_______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: David W <dav...@ya...> - 2008-06-11 01:07:52
|
Hi, As my code and LucidDB run on a same machine, I use "com.lucidera.jdbc.LucidDbLocalDriver" as the name of driver class following http://pub.eigenbase.org/wiki/JdbcUrlConventions#Conventions. After hours of debugging, however, I found LucidDBClient.jar does not contain such a class file of "LucidDbLocalDriver". This .jar file only contains LucidDbHttpDriver.class and LucidDbRmiDriver.class. I need a jar file containing "LucidDbLocalDriver.class". Can anybody help me? Thanks a lot. David |
|
From: John V. S. <js...@gm...> - 2008-06-10 20:06:40
|
David W wrote: > Hi Zelaine, > > > > Can you help me again? I have added luciddb/plugin/LucidDbClient.jar is > in my classpath but I got the following errror. > > > > Exception in thread "main" java.lang.NoClassDefFoundError: FetchData. > > I checked Java1.5 Website and found it is "The searched-for class > definition existed when the currently executing class was compiled, but > the definition can no longer be found. ". David, you'll need to get a book on Java and study up on compilers and classpaths. This problem has nothing to do with LucidDB. JVS |
|
From: David W <dav...@ya...> - 2008-06-10 20:00:18
|
Hi Zelaine,
Can you help me again? I have added luciddb/plugin/LucidDbClient.jar is in my classpath but I got the following errror.
Exception in thread "main" java.lang.NoClassDefFoundError: FetchData.
I checked Java1.5 Website and found it is "The searched-for class definition existed when the currently executing class was compiled, but the definition can no longer be found. ".
Following is my code.
String url = "jdbc:luciddb:rmi://host53";
try {
Class.forName("com.lucidera.jdbc.LucidDbRmiDriver");
}catch(Exception ex){
System.out.println("Failed to load JDBC driver.");
ex.printStackTrace();
return;
}
try {
// open Lucid DB
conn = DriverManager.getConnection(url, "sa", "");
stmt = conn.createStatement();
// check if the schema
ps = conn.prepareStatement("select SCHEMA_NAME from SYS_ROOT.DBA_TABLES where SCHEMA_NAME = 'TALOGGER'");
.........
Thanks for your reply!
David
|
|
From: Zelaine F. <zf...@lu...> - 2008-06-10 17:43:36
|
Are you sure luciddb/plugin/LucidDbClient.jar is in your classpath?
-- Zelaine
David W wrote:
> Hi,
>
>
>
> I am using a Java code to access the LucidDB on a same machine.
>
>
>
> Here is the code.
>
>
>
> String url = "jdbc:luciddb:rmi://host56";
>
>
> try {
> Class.forName("com.lucidera.jdbc.LucidDbRmiDriver");
> }catch(Exception ex){
>
> System.out.println("Failed to load JDBC driver.");
>
> ex.printStackTrace();
> return;
> }
>
> When running this code I got
>
> [dwang@host53 bulk_load_test]$ java FetchUdx
> Failed to load JDBC/ODBC driver.
> java.lang.ClassNotFoundException: com.lucidera.jdbc.LucidDbRmiDriver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:164)
> at FetchUdx.main(FetchUdx.java:181)
> [dwang@host53 bulk_load_test]$
>
> Any suggestions!
>
>
>
> Thanks!
>
>
>
> David
>
>
>
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> luciddb-users mailing list
> luc...@li...
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
|
|
From: David W <dav...@ya...> - 2008-06-10 17:36:10
|
Hi,
I am using a Java code to access the LucidDB on a same machine.
Here is the code.
String url = "jdbc:luciddb:rmi://host56";
try {
Class.forName("com.lucidera.jdbc.LucidDbRmiDriver");
}catch(Exception ex){
System.out.println("Failed to load JDBC driver.");
ex.printStackTrace();
return;
}
When running this code I got
[dwang@host53 bulk_load_test]$ java FetchUdx
Failed to load JDBC/ODBC driver.
java.lang.ClassNotFoundException: com.lucidera.jdbc.LucidDbRmiDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at FetchUdx.main(FetchUdx.java:181)
[dwang@host53 bulk_load_test]$
Any suggestions!
Thanks!
David
|
|
From: David W <dav...@ya...> - 2008-06-10 00:11:02
|
Hi JVS,
Thanks so much for your reply. The reason was that there was no JDK on the server from which I invoke Squirrel. LucidDB and Squirrel are installed on another server.
After installing JDK, all became fine.
Thanks again,
David
--- On Mon, 6/9/08, John V. Sichi <js...@gm...> wrote:
From: John V. Sichi <js...@gm...>
Subject: Re: [luciddb-users] LucidDB default listenning port number
To: dav...@ya...
Cc: luc...@li...
Date: Monday, June 9, 2008, 1:41 PM
David W wrote:
> Hi,
>
>
>
> Thanks for your prompt reply. Following the instruction on that Website
> I used URL
>
> "jdbc:luciddb:rmi://108.19.34.33:5434", however I got
>
>
>
>
> Lucid JDBC: java.net.MalformedURLException: no protocol: SQL
> at java.net.URL.<init>(URL.java:567)
> at java.net.URL.<init>(URL.java:464)
> at java.net.URL.<init>(URL.java:413)
> at sun.rmi.server.LoaderHandler.pathToURLs(LoaderHandler.java:747)
What client program are you using?
Did you give it the LucidDbClient.jar path and driver name?
Are you able to connect using the same URL via sqllineClient (from the
same remote client machine)?
Can you include the full exception stack?
JVS
|
|
From: John V. S. <js...@gm...> - 2008-06-09 20:41:47
|
David W wrote: > Hi, > > > > Thanks for your prompt reply. Following the instruction on that Website > I used URL > > "jdbc:luciddb:rmi://108.19.34.33:5434", however I got > > > > > Lucid JDBC: java.net.MalformedURLException: no protocol: SQL > at java.net.URL.<init>(URL.java:567) > at java.net.URL.<init>(URL.java:464) > at java.net.URL.<init>(URL.java:413) > at sun.rmi.server.LoaderHandler.pathToURLs(LoaderHandler.java:747) What client program are you using? Did you give it the LucidDbClient.jar path and driver name? Are you able to connect using the same URL via sqllineClient (from the same remote client machine)? Can you include the full exception stack? JVS |
|
From: David W <dav...@ya...> - 2008-06-09 20:13:34
|
Hi, Thanks for your prompt reply. Following the instruction on that Website I used URL "jdbc:luciddb:rmi://108.19.34.33:5434", however I got Lucid JDBC: java.net.MalformedURLException: no protocol: SQL at java.net.URL.<init>(URL.java:567) at java.net.URL.<init>(URL.java:464) at java.net.URL.<init>(URL.java:413) at sun.rmi.server.LoaderHandler.pathToURLs(LoaderHandler.java:747) .... I have re-started the LucidDB server but I still got the same error. Any more suggestions? Thanks a lot! David --- On Mon, 6/9/08, Sunny Choi <sc...@lu...> wrote: From: Sunny Choi <sc...@lu...> Subject: Re: [luciddb-users] LucidDB default listenning port number To: dav...@ya... Cc: luc...@li... Date: Monday, June 9, 2008, 11:33 AM Hi, http://pub.eigenbase.org/wiki/JdbcUrlConventions#Conventions The default port number is 5434. Sunny David W wrote on 06/09/2008 11:22 AM: > Hello, > &nbsp; > I am creating an alias for LucidDB connection driver. For the URL of the alias I put jdbc:luciddb:rmi://100.123.22.77:80 where 100.123.22.77 is the IP address where the LucidDB is located, but I got > &nbsp; > Lucid JDBC: java.io.EOFException > &nbsp;at java.io.DataInputStream.readByte(DataInputStream.java:243) > &nbsp;at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:215) > ... > &nbsp; > How to fix this URL? What's the default listening port for the LucidDB server? I searched this list alredy but I did not get related information. > &nbsp; > Thanks for all&nbsp;replies! > &nbsp; > David > > > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > > > ------------------------------------------------------------------------ > > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: Sunny C. <sc...@lu...> - 2008-06-09 18:33:21
|
Hi, http://pub.eigenbase.org/wiki/JdbcUrlConventions#Conventions The default port number is 5434. Sunny David W wrote on 06/09/2008 11:22 AM: > Hello, > > I am creating an alias for LucidDB connection driver. For the URL of the alias I put jdbc:luciddb:rmi://100.123.22.77:80 where 100.123.22.77 is the IP address where the LucidDB is located, but I got > > Lucid JDBC: java.io.EOFException > at java.io.DataInputStream.readByte(DataInputStream.java:243) > at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:215) > ... > > How to fix this URL? What's the default listening port for the LucidDB server? I searched this list alredy but I did not get related information. > > Thanks for all replies! > > David > > > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > > > ------------------------------------------------------------------------ > > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: David W <dav...@ya...> - 2008-06-09 18:22:38
|
Hello,
I am creating an alias for LucidDB connection driver. For the URL of the alias I put jdbc:luciddb:rmi://100.123.22.77:80 where 100.123.22.77 is the IP address where the LucidDB is located, but I got
Lucid JDBC: java.io.EOFException
at java.io.DataInputStream.readByte(DataInputStream.java:243)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:215)
...
How to fix this URL? What's the default listening port for the LucidDB server? I searched this list alredy but I did not get related information.
Thanks for all replies!
David
|
|
From: John V. S. <js...@gm...> - 2008-06-09 15:57:31
|
This error occurs if you have two LucidDB processes trying to run from the same installation, like if you run lucidDbServer twice at the same time from two different shells. LucidDB locks the catalog exclusively when it starts up in order to prevent that. Use the ps command to find running Java processes. JVS David W wrote: > Hi, > > > > Trying to start LucidDB server but I met this exception. I searched this > list but did not find related information. > > > > [dwang@host53 bin]$ ./lucidDbServer > Server personality: LucidDB > Loading database... > Exception in thread "main" org.eigenbase.util.EigenbaseException: Failed > to load database > at > net.sf.farrago.resource.FarragoResource$_Def1.ex(FarragoResource.java:1764) > at > net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:264) > at > net.sf.farrago.db.FarragoDbSingleton.pinReference(FarragoDbSingleton.java:88) > at > net.sf.farrago.server.FarragoAbstractServer.start(FarragoAbstractServer.java:183) > at com.lucidera.farrago.LucidDbServer.main(LucidDbServer.java:61) > Caused by: org.eigenbase.util.EigenbaseException: Failed to lock catalog > file > /home/dwang/david/app/WEB-INF/src/java/com/mygeek/luciddb/luciddb-0.7.3/catalog/ReposStorage.properties.lck > at > net.sf.farrago.resource.FarragoResource$_Def0.ex(FarragoResource.java:1741) > at > net.sf.farrago.catalog.FarragoMdrReposImpl.<init>(FarragoMdrReposImpl.java:115) > at > net.sf.farrago.db.FarragoDbSessionFactory.newRepos(FarragoDbSessionFactory.java:123) > at > net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:166) > ... 3 more > [dwang@host53 bin]$ ls > > ================= > > I removed ReposStorage.properties.lck, but now I got the following > exception. > > > > [dwang@host53 luciddb-0.7.3]$ ./bin/lucidDbServer > Server personality: LucidDB > Loading database... > Exception in thread "main" org.eigenbase.util.EigenbaseException: Failed > to load database > at > net.sf.farrago.resource.FarragoResource$_Def1.ex(FarragoResource.java:1764) > at > net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:264) > at > net.sf.farrago.db.FarragoDbSingleton.pinReference(FarragoDbSingleton.java:88) > at > net.sf.farrago.server.FarragoAbstractServer.start(FarragoAbstractServer.java:183) > at com.lucidera.farrago.LucidDbServer.main(LucidDbServer.java:61) > Caused by: org.netbeans.mdr.util.DebugException: Failed accessing > storage factory. > at > org.netbeans.mdr.storagemodel.MdrStorage.<init>(MdrStorage.java:292) > at > org.netbeans.mdr.NBMDRepositoryImpl.initCheck(NBMDRepositoryImpl.java:726) > at > org.netbeans.mdr.NBMDRepositoryImpl.getExtent(NBMDRepositoryImpl.java:298) > at > net.sf.farrago.catalog.FarragoModelLoader.loadModel(FarragoModelLoader.java:101) > at > net.sf.farrago.catalog.FarragoMdrReposImpl.<init>(FarragoMdrReposImpl.java:128) > at > net.sf.farrago.db.FarragoDbSessionFactory.newRepos(FarragoDbSessionFactory.java:123) > at > net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:166) > ... 3 more > [dwang@host53 luciddb-0.7.3]$ > > Can I get any help? > > > > Thank so much! > > > > David > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > > > ------------------------------------------------------------------------ > > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: David W <dav...@ya...> - 2008-06-09 14:45:27
|
Hi,
Trying to start LucidDB server but I met this exception. I searched this list but did not find related information.
[dwang@host53 bin]$ ./lucidDbServer
Server personality: LucidDB
Loading database...
Exception in thread "main" org.eigenbase.util.EigenbaseException: Failed to load database
at net.sf.farrago.resource.FarragoResource$_Def1.ex(FarragoResource.java:1764)
at net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:264)
at net.sf.farrago.db.FarragoDbSingleton.pinReference(FarragoDbSingleton.java:88)
at net.sf.farrago.server.FarragoAbstractServer.start(FarragoAbstractServer.java:183)
at com.lucidera.farrago.LucidDbServer.main(LucidDbServer.java:61)
Caused by: org.eigenbase.util.EigenbaseException: Failed to lock catalog file /home/dwang/david/app/WEB-INF/src/java/com/mygeek/luciddb/luciddb-0.7.3/catalog/ReposStorage.properties.lck
at net.sf.farrago.resource.FarragoResource$_Def0.ex(FarragoResource.java:1741)
at net.sf.farrago.catalog.FarragoMdrReposImpl.<init>(FarragoMdrReposImpl.java:115)
at net.sf.farrago.db.FarragoDbSessionFactory.newRepos(FarragoDbSessionFactory.java:123)
at net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:166)
... 3 more
[dwang@host53 bin]$ ls
=================
I removed ReposStorage.properties.lck, but now I got the following exception.
[dwang@host53 luciddb-0.7.3]$ ./bin/lucidDbServer
Server personality: LucidDB
Loading database...
Exception in thread "main" org.eigenbase.util.EigenbaseException: Failed to load database
at net.sf.farrago.resource.FarragoResource$_Def1.ex(FarragoResource.java:1764)
at net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:264)
at net.sf.farrago.db.FarragoDbSingleton.pinReference(FarragoDbSingleton.java:88)
at net.sf.farrago.server.FarragoAbstractServer.start(FarragoAbstractServer.java:183)
at com.lucidera.farrago.LucidDbServer.main(LucidDbServer.java:61)
Caused by: org.netbeans.mdr.util.DebugException: Failed accessing storage factory.
at org.netbeans.mdr.storagemodel.MdrStorage.<init>(MdrStorage.java:292)
at org.netbeans.mdr.NBMDRepositoryImpl.initCheck(NBMDRepositoryImpl.java:726)
at org.netbeans.mdr.NBMDRepositoryImpl.getExtent(NBMDRepositoryImpl.java:298)
at net.sf.farrago.catalog.FarragoModelLoader.loadModel(FarragoModelLoader.java:101)
at net.sf.farrago.catalog.FarragoMdrReposImpl.<init>(FarragoMdrReposImpl.java:128)
at net.sf.farrago.db.FarragoDbSessionFactory.newRepos(FarragoDbSessionFactory.java:123)
at net.sf.farrago.db.FarragoDatabase.<init>(FarragoDatabase.java:166)
... 3 more
[dwang@host53 luciddb-0.7.3]$
Can I get any help?
Thank so much!
David
|
|
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 |
|
From: David W <dav...@ya...> - 2008-06-06 20:11:00
|
Hello, 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? 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? Thanks so much for all replies! David |
|
From: John V. S. <js...@gm...> - 2008-06-06 04:24:30
|
I'll be giving a presentation on LucidDB next month in Portland, Oregon: http://en.oreilly.com/oscon2008/public/schedule/detail/2781 If you happen to be attending OSCON, see you there! JVS |
|
From: Zelaine F. <zf...@lu...> - 2008-06-05 22:17:58
|
Write a java UDR that takes a parameter that represents the timestamp in some way. Have that UDR dynamically construct the name of the file using the parameter, and then execute the resulting dynamic SQL statement. -- Zelaine David W wrote: > Hello, > > I have researched bulk loading on > > http://pub.eigenbase.org/wiki/LucidDbFlatFileWrapper and > > _http://pub.eigenbase.org/wiki/LucidDbEtlTutorial#Define_Sources_ > <http://pub.eigenbase.org/wiki/LucidDbEtlTutorial/lDefine_Sources>. As > far as I see, they all need to run in lucidClient. Now I have the > following files > > subreport1-2008-06-05_09-10 > > subreport1-2008-06-05_09-20 > > subreport1-2008-06-05_09-30 > > subreport1-2008-06-05_09-40 > > subreport1-2008-06-05_09-50 > > subreport1-2008-06-05_10-00 > > subreport1-temp > > > > subreport2-2008-06-05_09-00 > > subreport2-2008-06-05_09-10 > > subreport2-2008-06-05_09-20 > > subreport2-2008-06-05_09-30 > > subreport2-2008-06-05_09-40 > > subreport2-2008-06-05_09-50 > > subreport2-2008-06-05_10-00 > > subreport2-temp > > > > subreport3-2008-06-05_09-00 > > subreport3-2008-06-05_09-10 > > subreport3-2008-06-05_09-20 > > subreport3-2008-06-05_09-30 > > subreport3-2008-06-05_09-40 > > subreport3-2008-06-05_09-50 > > subreport3-2008-06-05_10-00 > > subreport3-temp > > > > The titles of these data file have this format "subreport#-timestamp". > '#' means a number from 1 to 3 that means different types of data. > "temp" means that the system is just writing data into it. > > Data is writing into these files on a real time basis. As the coming-in > data is really huge, it is cut and saved into seperate files every ten > minutes. The "timestamp" represents "hour-minute". Therefore the title > of these data files always changes according to the time stamp. For > example, during the slot of 11:00am to 12:00pm, subreport1 will be > > > > subreport1-2008-06-05_11-10 > > subreport1-2008-06-05_11-20 > > subreport1-2008-06-05_11-30 > > subreport1-2008-06-05_11-40 > > subreport1-2008-06-05_11-50 > > subreport1-2008-06-05_12-00 > > > > I need to load this data into corresponding tables on a real-time basis > continuously at the back end. It means that no one comes to run SQL > commands anytime. All this bulk loading should be done automatically at > the back end. The challenage here is that the titles of these files > change every hour. > > All data in type '1' goes to table_1. All data in type '2' goes to > table_2 and data in type '3' goes to table_3. > > > Can I get any suggestions? > > Thanks so much. > > David > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > > > ------------------------------------------------------------------------ > > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: David W <dav...@ya...> - 2008-06-05 21:31:28
|
Hello, I have researched bulk loading on http://pub.eigenbase.org/wiki/LucidDbFlatFileWrapper and http://pub.eigenbase.org/wiki/LucidDbEtlTutorial#Define_Sources. As far as I see, they all need to run in lucidClient. Now I have the following files subreport1-2008-06-05_09-10 subreport1-2008-06-05_09-20 subreport1-2008-06-05_09-30 subreport1-2008-06-05_09-40 subreport1-2008-06-05_09-50 subreport1-2008-06-05_10-00 subreport1-temp subreport2-2008-06-05_09-00 subreport2-2008-06-05_09-10 subreport2-2008-06-05_09-20 subreport2-2008-06-05_09-30 subreport2-2008-06-05_09-40 subreport2-2008-06-05_09-50 subreport2-2008-06-05_10-00 subreport2-temp subreport3-2008-06-05_09-00 subreport3-2008-06-05_09-10 subreport3-2008-06-05_09-20 subreport3-2008-06-05_09-30 subreport3-2008-06-05_09-40 subreport3-2008-06-05_09-50 subreport3-2008-06-05_10-00 subreport3-temp The titles of these data file have this format "subreport#-timestamp". '#' means a number from 1 to 3 that means different types of data. "temp" means that the system is just writing data into it. Data is writing into these files on a real time basis. As the coming-in data is really huge, it is cut and saved into seperate files every ten minutes. The "timestamp" represents "hour-minute". Therefore the title of these data files always changes according to the time stamp. For example, during the slot of 11:00am to 12:00pm, subreport1 will be subreport1-2008-06-05_11-10 subreport1-2008-06-05_11-20 subreport1-2008-06-05_11-30 subreport1-2008-06-05_11-40 subreport1-2008-06-05_11-50 subreport1-2008-06-05_12-00 I need to load this data into corresponding tables on a real-time basis continuously at the back end. It means that no one comes to run SQL commands anytime. All this bulk loading should be done automatically at the back end. The challenage here is that the titles of these files change every hour. All data in type '1' goes to table_1. All data in type '2' goes to table_2 and data in type '3' goes to table_3. Can I get any suggestions? Thanks so much. David |
