Here is the output of the test (Java 1.6.0_06, Ubuntu 8.04, 2.6.24-19-
generic):

 1.0.78 (2008-08-28)
Exception in thread "main" org.h2.jdbc.JdbcSQLException: IO Exception:
java.io.IOException: Permission denied; mem:appDB [90031-78]
        at org.h2.message.Message.getSQLException(Message.java:103)
        at org.h2.message.Message.convertIOException(Message.java:271)
        at org.h2.engine.SessionRemote.createTempFile(SessionRemote.java:459)
        at org.h2.value.ValueLob.initLarge(ValueLob.java:375)
        at org.h2.value.ValueLob.createFromReader(ValueLob.java:201)
        at org.h2.value.ValueLob.createClob(ValueLob.java:169)
        at org.h2.jdbc.JdbcConnection.createClob(JdbcConnection.java:1500)
        at
org.h2.jdbc.JdbcPreparedStatement.setCharacterStream(JdbcPreparedStatement.java:
945)
        at
org.h2.jdbc.JdbcPreparedStatement.setCharacterStream(JdbcPreparedStatement.java:
917)
        at
org.h2.jdbc.JdbcPreparedStatement.setCharacterStream(JdbcPreparedStatement.java:
928)
        at H2Test.main(H2Test.java:17)
Caused by: java.io.IOException: Permission denied
        at java.io.UnixFileSystem.createFileExclusively(Native Method)
        at java.io.File.checkAndCreate(File.java:1704)
        at java.io.File.createTempFile(File.java:1793)
        at org.h2.store.fs.FileSystemDisk.createTempFile(FileSystemDisk.java:
157)
        at org.h2.util.FileUtils.createTempFile(FileUtils.java:158)
        at org.h2.engine.SessionRemote.createTempFile(SessionRemote.java:457)
        ... 8 more


On Oct 1, 9:34 pm, "Thomas Mueller" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> I can reproduce this problem with previous versions, but so far I
> couldn't reproduce it with version 1.0.78. Could you post a simple
> test case similar to the one below? Or maybe this test doesn't work
> for you?
>
>     public static void main(String[] args) throws Exception {
>         org.h2.Driver.load();
>         Server server = Server.createTcpServer(new String[0]).start();
>         Connection conn =
> DriverManager.getConnection("jdbc:h2:tcp://localhost/mem:appDB");
>         System.out.println(conn.getMetaData().getDatabaseProductVersion());
>         PreparedStatement prep = conn.prepareStatement("CALL ?");
>         prep.setCharacterStream(1, new StringReader(new String(new
> char[100000])));
>         prep.executeQuery();
>         conn.close();
>         server.stop();
>     }
>
> Regards,
> Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to