Hi.
I want a full-text. Here's my steps according to the documentation, as
far as I could understand it:
1. Create a table.
CREATE TABLE KEYWORDS (
ID BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
WORDS VARCHAR,
REF VARCHAR
);
2. Init Lucene search for column "words":
CREATE ALIAS IF NO
On Mar 29, 8:11 pm, Thomas Mueller
wrote:
> No, there is no logging. You would need to modify the source code and
> build it yourself (which is hopefully relatively easy).
It would be easier if the source code included an Eclipse .project
& .classpath files...
Many projects include those as par
Hi,
I've started a h2 database in db2 compatibility mode, but when I try
to execute the following script:
create table DEV.CARTECS_ENQUIRY (
ID decimal(20 , 0) not null,
CREATION_TIME timestampnot null with
default,
primary key
I did not test your sample, but I know that Lucene by default does not
index a bunch of words - "word" is quite surely one of those.
On Wed, Mar 31, 2010 at 11:23, Bogdan Maryniuck wrote:
> Hi.
> I want a full-text. Here's my steps according to the documentation, as
> far as I could understand it
Hi,
The problem is that java.sql.Date.toString() doesn't support years
beyond . You will get the same or a similar result using:
System.out.println(java.sql.Date.valueOf("19676-01-01").toString());
However I will implement a workaround in H2, so that the following
test will work:
Connection
Hi,
> H2 is mapping primitives to their boxed counterparts anyway
Yes, but it doesn't use java.lang.Integer / java.lang.Double internally.
> do the type specific
> getters/setters have any (dis)advantages - apart from compile-time
> type safety - or is it OK to use getObject/setObject everywhere
Hi,
There is a bug in H2, currently you can't use ROWNUM for what you
want. I will fix that. Test case:
drop table test;
create table test(id int);
insert into test values(1);
insert into test values(2);
insert into test values(3);
insert into test values(4);
select * from test where rownum > 2;
Hi Thomas,
see http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6898593
Since Java 6u18 java.sql.Date.valueOf() throws exceptions if not in
-mm-dd format. I just checked in a fix for RandomGen.randomDate().
You should check if everywhere else the handling is correct.
Regards
Christian
On
Compatibility mode doesn't mean that H2 will support all DB2 features.
Currently DB2 compatibility mode means:
- For aliased columns, ResultSetMetaData.getColumnName() returns the
alias name and getTableName() returns null.
- Support for the syntax [OFFSET .. ROW] [FETCH ... ONLY] as an
The documentation says
SCRIPT [SIMPLE] [NODATA] [NOPASSWORDS] [NOSETTINGS] [DROP]
[BLOCKSIZE blockSizeInt] [TO fileNameString
[COMPRESSION {DEFLATE|LZF|ZIP|GZIP}]
[CIPHER cipher PASSWORD string]]
Creates a SQL script with or without the insert statem
I created a new database (the default database created by H2 if i
login into a not existing database). The database had one table with
two columns id (Integer) and name (Array).
Then i did the following using the browser based console:
select * from test;
select cast (test.name as array) from te
One-to-Many relationships are modeled using 2 tables and a foreign key
between them in the relational system.
I advise against using arrays.
Every type (eg. string, array etc.) need type specific operators to
access the value's internals (like SUBSTRING() etc.)
So the relational operators in gen
>So the question is ... why not use the relational toolkit to model the data?
Like MySQL: sometimes it is sufficient enough to hold a small array
of values instead suing tables with foreign keys (for instance for
small set of unique identifiers known as enum in Java or C).
--
You received this
Yes I understand.
But remember that there is no overhead in creating a small table either.
CREATE TABLE X (ID INT PRIMARY KEY REFERENCES Y ON DELETE CASCADE, VAL
VARCHAR):
That's a oneliner.
Then again you may use any type you wish.
But currently creation of custom types and operators that work
Hi all,
I am still getting this using 1.2.128. Should I try with the latest release
build ? Please let me know if you require further details.
2010-mars-31 07:56:55 [JCLLoggerAdapter - WARN] SQL Error: 5, SQLState:
HY000
2010-mars-31 07:56:55 [JCLLoggerAdapter - ERROR] General error:
"jav
On Thu, Apr 1, 2010 at 1:22 AM, Wildam Martin wrote:
> I did not test your sample, but I know that Lucene by default does not
> index a bunch of words - "word" is quite surely one of those.
Well, here "word" is just an example, but usually I want Japanese. I
do all the word split by myself, since
It's my understanding that the TIMESTAMP data type is stored in the H2
database as a long integer that is the number of milliseconds from
unix epoch UTC. So, is the TIMESTAMP data type converted from the
server's local timezone to UTC, or from the client's local timezone?
Cheers,
Matt
--
You rec
Oh, I see.. Thanks.
On Apr 1, 2:55 am, Christian Peter
wrote:
> Hi Thomas,
>
> seehttp://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6898593
>
> Since Java 6u18 java.sql.Date.valueOf() throws exceptions if not in
> -mm-dd format. I just checked in a fix for RandomGen.randomDate().
> You shoul
18 matches
Mail list logo