Hi Frank,
Can you include the stack trace for this error? The ALTER TABLE
statement does not mention a ROOT schema, so it is hard to see how this
error would come from Derby.
Thanks,
-Rick
On 10/1/13 8:00 AM, Frank Rivera wrote:
Using *Derby 10.10.1.1 Embedded*
*Tomcat 6*
using *tomcat-jdbc connection pool*
The following simple statement fails with the following error "
*Schema 'ROOT' does not exist* " although the schema is clearly stated
*esq.licreq*
*ALTER TABLE esq.licreq ADD COLUMN u_domain GENERATED ALWAYS AS
(UPPER(domain)); *
*
*
Reads and writes are fine. All Alter statements fail.
Without tomcat-jdbc.jar stored in the tomcat/lib folder Alter
statements work. A pooled connection problem with tomcat-jdbc doesn't
seem like the cause since the underlying driver is in fact Derby.
*
*
*
*
/
Sincerely,/
/
/
*Frank Rivera* CEO
-----------------------------------------------------------------------------------------------------------------------------------------
LogicBit Software - Research Triangle Park, North Carolina
919.238.7024408.213.8138*888.366.2280*
***HoudiniEsq ™Legal Practice Management Suite**http://HoudiniEsq.com*
<http://houdiniesq.com/>
Feature Rich web-based Legal Practice Management for today's cutting
edge Law Firms
Any Browser, Any OS, Anytime, Anywhere, Any size firm, SaaS or On-premise
Simple & Simplicity are not the same thing. *"Simple", as it turns
out, simply isn't good enough.*
------------------------------------------------------------------------------------------------------------------------------------------
*NOTICE*: The sender does not accept liability for any errors
or omissions in the contents of this message which arise as
a result of e-mail transmission. This e-mail and any files
transmitted with it are confidential and are intended solely for
the use of the individual or entity to which they are addressed. It is
not an offer or acceptance, and it is not intended to
be all or part of an agreement. This communication may
contain material protected by the attorney-client privilege.
Original material created by the author may be protected by US
Copyright law, 17 U.S.C. § 101 et seq. This communication
constitutes an electronic communication within the meaning of the
Electronic Communications Privacy Act, 18 U.S.C.
§ 2510, and its disclosure is strictly limited to the recipient
intended by the sender of this message. If you are not the
intended recipient or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error and that any review, use, dissemination,
forwarding, printing, or copying of this e-mail is strictly
prohibited. If you have received this e-mail in error, please notify
the sender immediately by return e-mail and delete this
