You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Amir Michail <am...@gmail.com> on 2007/07/21 22:02:00 UTC
can't access or create a db
Hi,
Not sure what happened, but now I can't access or create a db on my server:
ERROR XJ041: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC:
Failed to create database 'testDB', see the next exception for
details.::SQLSTATE: XBM0HDirectory /home/.../testDB cannot be created.
If I copy the db to my laptop, then it works.
Any ideas on how I could track down this problem?
Amir
Re: can't access or create a db
Posted by Amir Michail <am...@gmail.com>.
Hi,
Problem solved. Please ignore.
Amir
On 7/21/07, Amir Michail <am...@gmail.com> wrote:
> On 7/21/07, Myrna van Lunteren <m....@gmail.com> wrote:
> > On 7/21/07, Amir Michail <am...@gmail.com> wrote:
> > > Hi,
> > >
> > > Not sure what happened, but now I can't access or create a db on my server:
> > >
> > > ERROR XJ041: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC:
> > > Failed to create database 'testDB', see the next exception for
> > > details.::SQLSTATE: XBM0HDirectory /home/.../testDB cannot be created.
> > >
> > > If I copy the db to my laptop, then it works.
> > >
> > > Any ideas on how I could track down this problem?
> > >
> > > Amir
> > >
> > You probably already thought of it, but the only thing I can think of
> > off hand is write permissions on the server. Maybe the umask for the
> > server process' user has been changed? Or the write permission for /
> > ? Or maybe the server has been started from a different directory from
> > before (if /home/../testDB would not be where your database used to
> > be)?
> >
> > HTH
> > Myrna
> >
> The process accessing the db is tomcat55. How does umask apply in this case?
>
> This used to work fine. I have no idea what happened to mess up the
> permissions.
>
> Amir
>
Re: can't access or create a db
Posted by Amir Michail <am...@gmail.com>.
On 7/21/07, Myrna van Lunteren <m....@gmail.com> wrote:
> On 7/21/07, Amir Michail <am...@gmail.com> wrote:
> > Hi,
> >
> > Not sure what happened, but now I can't access or create a db on my server:
> >
> > ERROR XJ041: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC:
> > Failed to create database 'testDB', see the next exception for
> > details.::SQLSTATE: XBM0HDirectory /home/.../testDB cannot be created.
> >
> > If I copy the db to my laptop, then it works.
> >
> > Any ideas on how I could track down this problem?
> >
> > Amir
> >
> You probably already thought of it, but the only thing I can think of
> off hand is write permissions on the server. Maybe the umask for the
> server process' user has been changed? Or the write permission for /
> ? Or maybe the server has been started from a different directory from
> before (if /home/../testDB would not be where your database used to
> be)?
>
> HTH
> Myrna
>
The process accessing the db is tomcat55. How does umask apply in this case?
This used to work fine. I have no idea what happened to mess up the
permissions.
Amir
Re: can't access or create a db
Posted by Myrna van Lunteren <m....@gmail.com>.
On 7/21/07, Amir Michail <am...@gmail.com> wrote:
> Hi,
>
> Not sure what happened, but now I can't access or create a db on my server:
>
> ERROR XJ041: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC:
> Failed to create database 'testDB', see the next exception for
> details.::SQLSTATE: XBM0HDirectory /home/.../testDB cannot be created.
>
> If I copy the db to my laptop, then it works.
>
> Any ideas on how I could track down this problem?
>
> Amir
>
You probably already thought of it, but the only thing I can think of
off hand is write permissions on the server. Maybe the umask for the
server process' user has been changed? Or the write permission for /
? Or maybe the server has been started from a different directory from
before (if /home/../testDB would not be where your database used to
be)?
HTH
Myrna