Hi,
I'm building a gwt app using derby db under eclipse.
I'm looking for simple step-by-step instructions for deploying this
app via tomcat.
So far, I have managed to deploy the gwt app via tomcat excluding derby db.
Amir
ry jars
should live either in Tomcat Shared libs or in your application's
web-inf/lib.
For my dev and prod servers, I have the db living in a similar place.
The location string (the path) is stored as a variable that is
substituted at runtime.
Dan Jue
On 12/27/06, Amir Michail <[EMAIL PROTEC
On 12/27/06, Amir Michail <[EMAIL PROTECTED]> wrote:
Hi,
I can't start the derby server outside of Eclipse properly.
Using the startNetworkServer command, I get this error:
ij> select * from links;
ERROR 42Y07: Schema 'AMICHAIL' does not exist
This turned out to b
On 12/27/06, Amir Michail <[EMAIL PROTECTED]> wrote:
...
I also had a security problem with the connect that I solved like this:
http://forum.java.sun.com/thread.jspa?threadID=653424&messageID=3840697
And yet another security problem (this one unrelated to derby db)
fixed like t
Hi,
I'm getting this exception:
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
SQLERRMC: Failed to start database 'myDB', see the next exception for
details.::SQLSTATE: XJ001Java exception: 'Java heap space:
java.lang.OutOfMemoryError'.
Any ideas on how to debug this and/
On 1/4/07, Amir Michail <[EMAIL PROTECTED]> wrote:
Hi,
I'm getting this exception:
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
SQLERRMC: Failed to start database 'myDB', see the next exception for
details.::SQLSTATE: XJ001Java except
n();
} catch (SQLException e) {
e.printStackTrace();
}
} catch (NamingException e) {
e.printStackTrace();
}
Amir
Amir Michail wrote:
> On 1/4/07, Amir M
On 1/5/07, Per Newgro <[EMAIL PROTECTED]> wrote:
Hey Amir,
> Context envCtx=(Context)initCtx.lookup("java:comp/env");
> DataSource ds =
(DataSource)envCtx.lookup("jdbc/sampleDB"); // fails
Is initCtx.lookup("java:comp/env/jdbc/sampleDB") working? That
Hi,
I found this for tomcat 5.5;
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
However, I still don't know what to do:
* for derby db, do I need to put anything in server.xml and/or web.xml?
* is there a howto like this specifically for derby db?
* what is a rea
Hi,
I was wondering how a servlet should handle derby server problems. For
example, what should happen if the derby server goes down? How should
the servlet handle this situation as to not confuse the derby server
on startup and cause severe errors (e.g., that might result in an
immediate shutdow
Hi,
I was wondering how one should handle race conditions.
My problem has to do with generating ids. I suppose that generating
ids using derby's auto generation does not result in any problems with
respect to race conditions.
However, in my case, I use a pair of items (x, y) where y starts
coun
Hi,
Is there a way to get derby db to give a warning whenever it processes
a query that would benefit significantly from the creation of
additional index(es)?
Also, how do I find out all the (possibly compound field) indexes that
have been created for a table?
Finally, is there a way to dump th
Hi,
I was wondering if it is possible to rename a field in derby and if
so, how it would be done.
Amir
Hi,
Is there an easy way to change a not null column to a null one?
Amir
Hi,
Is there a way to get derby to silently truncate varchar columns?
Amir
Hi,
There are places in my app where I invoke an sql command many times.
I've already gained a significant speedup by using prepared
statements.
Would it be worth moving from client/server to embedded as well? What
sort of speedup should I expect?
If I do make the move to embedded, is there any
On 2/23/07, Jean T. Anderson <[EMAIL PROTECTED]> wrote:
...
> If I do make the move to embedded, is there any way I could use ij
> while the app is running?
Your app could use an embedded server, which means your app would load
the embedded driver for its own use and start the Network Server to
I have no idea what is wrong.
Amir
On 2/23/07, Andrew McIntyre <[EMAIL PROTECTED]> wrote:
On 2/23/07, Amir Michail <[EMAIL PROTECTED]> wrote:
> On 2/23/07, Jean T. Anderson <[EMAIL PROTECTED]> wrote:
> > ...
> > > If I do make the move to embedded, is there
On 2/23/07, Amir Michail <[EMAIL PROTECTED]> wrote:
Hi,
I got embedded working on my laptop under eclipse w/ gwt's hosted
mode, but when deploying to my remote server I get a
NoClassDefFoundError exception on TableScanResultSet.
My tomcat WEB-INF/lib directory in the remote server i
On 2/24/07, Amir Michail <[EMAIL PROTECTED]> wrote:
On 2/23/07, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I got embedded working on my laptop under eclipse w/ gwt's hosted
> mode, but when deploying to my remote server I get a
> NoClassDefFoundError
Hi,
Why is it that prepared statements are created with respect to a connection?
Why can't you share a prepared statement across connections?
Amir
On 2/26/07, Dag H. Wanvik <[EMAIL PROTECTED]> wrote:
"Bernt M. Johnsen" <[EMAIL PROTECTED]> writes:
> Hi,
>
>
> This behaviour is defined in the JDBC specification.
But Derby's statement cache works across connections, which alleviates
redundant statement compilation.
I ran into a connection
Hi,
The column in question has type timestamp yet this doesn't work:
ij> alter table alter column default current_timestamp;
ERROR 22005: An attempt was made to get a data value of type 'long'
from a data value of type 'TIMESTAMP'.
The table does not have any rows.
Amir
Hi,
How do you add a foreign key to an existing table that refers to the
primary key of that table?
Amir
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 t
On 7/21/07, Myrna van Lunteren <[EMAIL PROTECTED]> wrote:
On 7/21/07, Amir Michail <[EMAIL PROTECTED]> 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: XJ0
Hi,
Problem solved. Please ignore.
Amir
On 7/21/07, Amir Michail <[EMAIL PROTECTED]> wrote:
On 7/21/07, Myrna van Lunteren <[EMAIL PROTECTED]> wrote:
> On 7/21/07, Amir Michail <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Not sure what happened, but
Hi,
I tried copying a db as a starting point for a new app, but any
connections I open are read only.
Any suggestions as to what might be wrong?
Amir
Hi,
Is there a way to delete rows while automatically deleting other rows
dependent on those rows?
Amir
Hi,
Is there a tool that will check syntax for all queries in my java
code? I could tell it how to find strings in my program that
correspond to sql queries using a simple search pattern.
Amir
Hi,
I would like to copy rows from one table to another while copying
only the first row from sets of similar rows.
In particular, for rows in which two particular fields are the same, I would
like to copy only the first row in that set. The rows have more than these
two fields.
I know how to c
Hi,
I ended up using JDBC to do this.
Amir
On Nov 16, 2007 8:37 PM, Dag H. Wanvik <[EMAIL PROTECTED]> wrote:
>
> Daniel John Debrunner <[EMAIL PROTECTED]> writes:
>
> > Rick Hillegas wrote:
> >
> >> One way to solve this problem would be to put a filtering function
> >> in the WHERE clause of th
Hi,
Can I copy a db while it is being used or could that lead to a corrupted copy?
Amir
Hi,
Is there a way to speed things up with select distinct?
Amir
Hi,
How do I recover from this error?
ERROR 25503: DDL is not permitted for a read-only connection, user or database.
Amir
On Jan 8, 2008 7:22 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How do I recover from this error?
>
> ERROR 25503: DDL is not permitted for a read-only connection, user or
> database.
>
> Amir
>
It turns out that not only do permissions need to be good, but also ownership.
Amir
On Jan 9, 2008 11:19 AM, Kristian Waagan <[EMAIL PROTECTED]> wrote:
> Amir Michail wrote:
> > On Jan 9, 2008 3:02 AM, Kristian Waagan <[EMAIL PROTECTED]> wrote:
> >> Amir Michail wrote:
> >>> On Jan 8, 2008 7:22 PM, Amir Michail <[EMAIL PROTECTED]>
On Jan 9, 2008 3:02 AM, Kristian Waagan <[EMAIL PROTECTED]> wrote:
>
> Amir Michail wrote:
> > On Jan 8, 2008 7:22 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> >> Hi,
> >>
> >> How do I recover from this error?
> >>
> >>
Hi,
What does this error mean?
ERROR XSCH5: In a base table there was a mismatch between the
requested column number 9 and the maximum number of columns 10.
This happens when I tried to add a reference to a primary key.
Amir
On Feb 13, 2008 3:51 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> What does this error mean?
>
> ERROR XSCH5: In a base table there was a mismatch between the
> requested column number 9 and the maximum number of columns 10.
>
> This happens when I tried t
On Feb 13, 2008 7:13 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
>
> On Feb 13, 2008 3:51 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > What does this error mean?
> >
> > ERROR XSCH5: In a base table there was a mismatch between t
On Thu, Feb 14, 2008 at 4:30 AM, Knut Anders Hatlen <[EMAIL PROTECTED]> wrote:
> Amir Michail <[EMAIL PROTECTED]> writes:
>
> > On Feb 13, 2008 7:13 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> >>
> >> On Feb 13, 2008 3:51 PM, Am
On Thu, Feb 14, 2008 at 10:49 AM, Amir Michail <[EMAIL PROTECTED]> wrote:
> On Thu, Feb 14, 2008 at 4:30 AM, Knut Anders Hatlen <[EMAIL PROTECTED]> wrote:
> > Amir Michail <[EMAIL PROTECTED]> writes:
> >
> > > On Feb 13, 2008 7:13
On Thu, Feb 14, 2008 at 1:19 PM, Kathey Marsden
<[EMAIL PROTECTED]> wrote:
> Amir Michail wrote:
> >
> > ij> alter table levels add column shape_id int references shapes;
> > ERROR XSCH5: In a base table there was a mismatch between the
> > requested colum
Hi,
Is there a way to easily move a column from one table to another (as
easy as a rename say)?
If not, maybe such a command could be added?
Amir
On Feb 19, 2008 1:25 PM, Bryan Pendleton <[EMAIL PROTECTED]> wrote:
> > Is there a way to easily move a column from one table to another (as
> > easy as a rename say)?
>
> alter table newtable add column newcolumn whatever-data-type;
> update newtable set newcolumn = (value that the newcolumn shoul
Hi,
I would like to enter utf-8 characters via the ij tool. How do I set
the encoding to utf-8?
Amir
On Sat, Mar 15, 2008 at 9:09 AM, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I would like to enter utf-8 characters via the ij tool. How do I set
> the encoding to utf-8?
>
> Amir
>
This doesn't work:
java -Dderby.ui.codeset=UTF8 org.apache.derby.tools.ij
Amir
On Sat, Mar 15, 2008 at 9:36 AM, Amir Michail <[EMAIL PROTECTED]> wrote:
>
> On Sat, Mar 15, 2008 at 9:09 AM, Amir Michail <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I would like to enter utf-8 characters via the ij tool. How do I set
> > the encod
Hi,
I would like to reference a column in another table but that column is
not designated as a primary key and unfortunately referring to it
explicitly results in this error:
ERROR XSCH5: In a base table there was a mismatch between the
requested column number 6 and the maximum number of columns
Hi,
Is there an easy way to change a column type from int to double while
automatically converting the data?
Amir
Hi,
Would it be sufficient to shut down tomcat (using
/etc/init.d/tomcat5.5 stop) before copying derby databases?
What would happen to open connections if I do this? Could the copy be corrupt?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
ould someone explain the mechanism(s) for getting a corrupt database
copy? I'm using transactions, so isn't there protection against this
sort of problem anyway? How long does it take to commit a
transaction?
Amir
>
> On Thu, Jul 17, 2008 at 11:45 PM, Amir Michail <[EMAIL PROTECT
Hi,
Is there a way to show the entire field no matter how long in ij output?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
Hi,
Is there an easy way to export derby data to another database say in
the form of a csv file?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
Hi,
I've been using Derby db but will very likely move my development to
the Google app engine to save money and create scalable code.
Unfortunately, the Google app engine does not support schemas because
apparently they would slow things down too much.
Is this a general problem with relational
Hi,
I was wondering what is the most efficient way to get the max
automatically generated row id.
select max(...) is slow.
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška
<[EMAIL PROTECTED]> wrote:
> You want to use identity: Defining an identity column
Yes, but how do you get the max row id efficiently without adding another row?
Amir
>
> On Sun, Oct 19, 2008 at 10:52 PM, Amir Michail <[EMAIL
Hi,
Given some condition, how do you efficiently check whether there is at
least one row that satisfies that condition?
count(*) is slow.
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
On Sun, Oct 19, 2008 at 11:25 PM, Kai Ponte <[EMAIL PROTECTED]> wrote:
> On Sunday 19 October 2008 02:04:29 pm Amir Michail wrote:
>> On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška
>>
>> <[EMAIL PROTECTED]> wrote:
>> > You want to use identity: Definin
On Mon, Oct 20, 2008 at 12:15 AM, Amir Michail <[EMAIL PROTECTED]> wrote:
> On Sun, Oct 19, 2008 at 11:25 PM, Kai Ponte <[EMAIL PROTECTED]> wrote:
>> On Sunday 19 October 2008 02:04:29 pm Amir Michail wrote:
>>> On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška
>
On Tue, Oct 21, 2008 at 2:32 PM, Andrew McIntyre <[EMAIL PROTECTED]> wrote:
> On Sun, Oct 19, 2008 at 1:52 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> I was wondering what is the most efficient way to get the max
>> automatically generated row id
Hi,
What is a good way for efficiently getting the first k rows from a
query that also satisfy some additional condition to be determined
using Java code?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
Hi,
Where can I find information on backwards compatibility? For example,
is version 10.4.2.0 compatible with applications compiled with
10.3.1.4? Can I just use the new libraries without recompiling apps?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
On Mon, Oct 27, 2008 at 1:14 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> What is a good way for efficiently getting the first k rows from a
> query that also satisfy some additional condition to be determined
> using Java code?
BTW, even without this condition, the
On Mon, Oct 27, 2008 at 5:45 PM, Daniel Noll <[EMAIL PROTECTED]> wrote:
> Amir Michail wrote:
>>
>> Hi,
>>
>> What is a good way for efficiently getting the first k rows from a
>> query that also satisfy some additional condition to be determined
>>
>
> On Mon, Oct 27, 2008 at 22:51, Amir Michail <[EMAIL PROTECTED]> wrote:
>>
>> On Mon, Oct 27, 2008 at 5:45 PM, Daniel Noll <[EMAIL PROTECTED]> wrote:
>> > Amir Michail wrote:
>> >>
>> >> Hi,
>> >>
>> >> What
>
> On Mon, Oct 27, 2008 at 23:02, Amir Michail <[EMAIL PROTECTED]> wrote:
>>
>> On Mon, Oct 27, 2008 at 5:59 PM, Peter Ondruška
>> <[EMAIL PROTECTED]> wrote:
>> > Please, post the query you are running.
>> > There are queries where setMaxRows w
Hi,
What is the difference between a hash and table scan?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
Hi,
Is there an easy way to delete data in the presence of circular
foreign key constraints?
That is, how do you delete items from two or more tables at once so
that these constraints are not violated?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
Hi,
Is there any point in calling the close method on ResultSet and the
close method of PreparedStatement?
Amir
--
http://b4utweet.com
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
On Fri, Nov 28, 2008 at 9:11 PM, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there any point in calling the close method on ResultSet and the
> close method of PreparedStatement?
>
> Amir
BTW, I'm using embedded mode. Why won't the garbage
Hi,
jsvc virt size is only 339m even though I specified it to be 1800m:
export CATALINA_OPTS="-Xms1800m -Xmx1800m"
Could this out of memory problem be related to derby somehow?
java.sql.SQLException: The exception 'java.lang.OutOfMemoryError: Java
heap space' was thrown while evaluating an expr
On Sat, Nov 29, 2008 at 2:03 AM, Amir Michail <[EMAIL PROTECTED]> wrote:
> Hi,
>
> jsvc virt size is only 339m even though I specified it to be 1800m:
>
> export CATALINA_OPTS="-Xms1800m -Xmx1800m"
Please ignore. I fixed the memory problem by modifying the
/etc
74 matches
Mail list logo