Hi,
Thanks! You are right, the missing slash is the problem. Unfortunately
I did not test the last release with Linux, otherwise I would have
found out. The fix is:
SessionRemote.getFilePrefix(String dir) {
StringBuffer buff = new StringBuffer();
buff.append(dir);
buff.append('/'); // << NEW
This will be fixed in the next release.
Regards,
Thomas
On Thu, Oct 2, 2008 at 12:11 PM, pepez <[EMAIL PROTECTED]> wrote:
>
> Hi Thomas,
>
> Under linux the System.getProperty("java.io.tmpdir") returns /tmp
> without trailing path separator '/' character which is different from
> Windows (....\LOCALS~1\Temp\). This most likely causes the problem in
> getFilePrefix method in SessionRemote class as the database name is
> appended after the directory string.
>
> On 2 loka, 10:25, pepez <[EMAIL PROTECTED]> wrote:
>> And same with the latest:
>>
>> 1.0.79 (2008-09-26)
>> Exception in thread "main" org.h2.jdbc.JdbcSQLException: IO Exception:
>> java.io.IOException: Permission denied; mem:appDB [90031-79]
>> 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:1521)
>> 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 2, 10:21 am, pepez <[EMAIL PROTECTED]> wrote:
>>
>> > 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
-~----------~----~----~----~------~----~------~--~---
