Actually the CSVWRITE is correct here since I'm trying to execute this
function as a non-admin user. The documentation says that this function as
well as CSVREAD require admin capabilities to execute.
But when I try to execute CSVREAD as a non-admin H2 user, the function
succeeds when per the documentation it should fail.
On Wednesday, January 4, 2017 at 2:08:57 AM UTC-6, Christian MICHON wrote:
>
> Who created the folder c:\temp ?
>
> If it was not created by your standard user account, you may have no
> rights to write into it. Please check the r/w rights access to it, even a
> simple file copy into it will give you a clue.
>
> For me this works as I created the folder c:\temp myself with a standard
> user account. I tried with version 1.3.176
>
> On Tuesday, January 3, 2017 at 9:59:42 PM UTC+1, Chris Sunderland wrote:
>>
>> It doesn't appear that CSVREAD is requiring admin rights per the
>> documentation. However CSVWRITE properly throws an error if I try to
>> execute this as a standard user:
>>
>> Exception in thread "main" org.h2.jdbc.JdbcSQLException: Admin rights are
>> required for this operation; SQL statement:
>> CALL *CSVWRITE*('c:/temp/test.csv', 'SELECT * FROM TableA'); [90040-176]
>> at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
>> at org.h2.message.DbException.get(DbException.java:178)
>>
>> I am using H2 version 1.3.176.
>>
>>
>>
--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
