db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Banibrata Dutta <banibrata.du...@gmail.com>
Subject Re: Derby newbie - error seen creating 'seconddb' thru ij for network-server Derby
Date Sat, 09 Nov 2019 17:49:14 GMT
Thank you all for the suggestions. However, I decided to downgrade to Java
8 (OpenJDK 8), as I realized that the tutorial I was following was actually
also using OpenJDK 8, and I didn't feel confident to venture out without
help. I am however facing another issue with Derby, after downgrading where
it throws an error. Will make a separate post about it in a moment.

On Sat, Nov 9, 2019 at 7:01 AM Bryan Pendleton <bpendleton.derby@gmail.com>
wrote:

> If you're just learning Derby, you don't need to use the Network
> Server and Network Client.
>
> Try following the "embedded" path in
> http://db.apache.org/derby/docs/10.15/getstart/twwdactivity1_overview.html
>
> It's a lot simpler.
>
> Then when you're more comfortable with Derby you can move up to the
> Network Server and its additional administration issues.
>
> bryan
>
> On Thu, Nov 7, 2019 at 11:29 PM Banibrata Dutta
> <banibrata.dutta@gmail.com> wrote:
> >
> > Hi Folk,
> >
> > Trying to use Derby for the first time. I am not an expert Java
> developer but dabbling for learning me some. I followed the official Derby
> instructions for installing the latest Derby on my freshly minted Lubuntu
> (lighter Ubuntu using LXDE) 64-bit 18.04.3 setup, with OpenJDK11 (default).
> >
> > Have started Derby in network server mode like this:
> > $ java -jar $DERBY_HOME/lib/derbyrun.jar server start
> >
> > And then trying to using ij to create the database like this:
> > $ ij
> > ij version 10.15
> > ij> CONNECT 'jdbc:derby://localhost:1527/seconddb;create=true';
> > ERROR XJ041: DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ041,
> SQLERRMC: Failed to create database 'seconddb', see the next exception for
> details.::SQLSTATE: XBM01::SQLSTATE: XJ001
> > ij>
> >
> > Trying to read around, there are suggestions to look into derby.log
> file, but I found none so far. What gives ? How to proceed ? Didn't find
> any general troubleshooting instructions in the docs. Tried the FAQ, but no
> obvious clues.
> >
> > cheers,
> > B
> >
>


-- 
regards,
Banibrata
http://www.linkedin.com/in/bdutta
http://twitter.com/edgeliving

Mime
View raw message