Hi Thomas,
Thanks for the reply. I'll give the table rename a try.
Cheers.
Ashley
On Friday, 22 November 2013 12:32:39 UTC, Thomas Mueller wrote:
>
> Hi,
>
> So as far as I understand, you first create the tables with the wrong
> column name ("_PRICE" instead of "PRICE"), and then change the column names
> using ALTER TABLE?
>
> What I would probably do is create the table with the correct column
> names, as follows:
>
> CREATE TABLE TEST(PRICE INT) AS SELECT * FROM CSVREAD(...)
>
> Or, if you can't do that, first create the table with a temporary name
> (TEMP_TEST), and then rename the columns, and as a last step rename the
> table.
>
> Regards,
> Thomas
>
>
> On Wed, Oct 23, 2013 at 11:22 AM, Ashley Collins
> <[email protected]<javascript:>
> > wrote:
>
>> Hello,
>>
>> I'm creating tables using csvread() and then changing the name and type
>> of some of the columns.
>>
>> Columns starting with "_" have the "_" removed and the type changed from
>> varchar to numeric(18,9). For example, "_PRICE" is renamed to "PRICE" and
>> the column values become numbers.
>>
>> This is all done within a java.sql.Connection.setAutoCommit(false) and
>> java.sql.Connection.commit().
>>
>> Methods which select from this table from another thread occasionally see
>> the unmodified "_PRICE" column.
>>
>> Setting LOCK_MODE=1 (Serializable) seems to fix the problem, but is that
>> just a coincidence? Should it work with LOCK_MODE=3 (Read Committed)?
>>
>> I'm using version 1.3.170 with JDK 1.7.0_40.
>>
>> Thanks.
>> Ashley
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
