RE: cannot make connection

2010-10-04 Thread Daniel A Keefe
I had a simiilar problem Not sure if this is related to your issue but.. I could connect to derby db when I launched my app from Netbeans or when I started it from the command line in the app directory, i.e. java -jar /mydir/myapp. However, when I tried to start it otherwise I would get an

Re: cannot make connection

2010-10-04 Thread Kristian Waagan
On 02.10.10 17:18, laishram rahul wrote: Sir, Im using eclipse Helios wtp latest release, connection with derby embeddeb jdbc driver is working fine but i CANNOT make connection with DERBY CLIENT JDBC DRIVER. please provide me some help if it is possible... Hello, Are you connecting to a serv

'GROUP BY' is failed

2010-10-04 Thread Alex Gusev
Hello, I have created a table: CREATE TABLE TEST (VAL1 VARCHAR(3) NOT NULL, VAL2 VARCHAR(3) NOT NULL); Then I execute statement SELECT * FROM TEST GROUP BY VAL1; and I have an error: ERROR 42Y36: Column reference 'TEST.VAL2' is invalid, or is part of an invalid expression. For a SELECT li

Re: 'GROUP BY' is failed

2010-10-04 Thread Marco Ferretti
you can have, in the select part of the statement, only columns that are in the group by part of the SQL statement or columns that are somehow aggregated . Please check sql reference ( eg. http://www.w3schools.com/sql/sql_groupby.asp ) On Thu, Sep 30, 2010 at 11:43 AM, Alex Gusev wrote: > Hello

cannot make connection

2010-10-04 Thread laishram rahul
Sir, Im using eclipse Helios wtp latest release, connection with derby embeddeb jdbc driver is working fine but i CANNOT make connection with DERBY CLIENT JDBC DRIVER. please provide me some help if it is possible...

derby running with no response

2010-10-04 Thread li luo
hi everyone: I got a problem when I use derby to store my data. This is my situation: I have an application which will insert items into a derby database table , and the derby is running in a standalone mode. below is my derby running 'ps aux' description: mapred 26259 0.4 0.3 339592

Re: Problem inserting a record with derby 10.6.1.0

2010-10-04 Thread Kristian Waagan
On 01.10.10 09:44, Mamatha Kodigehalli Venkatesh wrote: Hello all, I too upgraded derby from 10.5.3.0 to 10.6.1.0, I am getting below exception When I tried to insert a record into the table using a prepared statement. java.sql.SQLException: Java exception: 'org.apache.derby.iapi.sql.exec

Re: derby running with no response

2010-10-04 Thread Bryan Pendleton
ij to connect the derby still fail. The java process still running and derby can not response normally.I didn't do any special configuration for derby. Just start it using: $DERBY_HOME/bin/startNetworkServer -h localhost -p 1527. A good place to start is to look in the derby.log file of the Netw

Re: Problem inserting a record with derby 10.6.1.0

2010-10-04 Thread Kristian Waagan
On 01.10.10 10:11, Bhat, Avinash (NSN - IN/Bangalore) wrote: Hi We /Kristian , our application supports SHA 1 as a default but the default in derby 10.6.1.0 is SHA 256. I Tried changing that to the supporting algorithm by out application. It Fine now. Working fine. Thanks for your kind informa

IJ scipts - stop execution and rollback in case of error

2010-10-04 Thread Thomas
Hi, is there a way to make scripts stop (and the transaction rollbacked) when an error is thrown rather than IJ just continuing the execution with the next statement? Thanks

Re: IJ scipts - stop execution and rollback in case of error

2010-10-04 Thread Mamta Satoor
Hi, I am not 100% but from my recollection, there is no way to stop the script if an error is encountered in the middle of the script. Mamta On Mon, Oct 4, 2010 at 1:50 PM, Thomas wrote: > Hi, > > is there a way to make scripts stop (and the transaction rollbacked) when an > error is thrown rat