Hi Sube, >From the stacktrace, it seems to be an error from an INSERT, not a SELECT? Can you show us the INSERTs you use?
Dag >>>>> "ss" == sube singh <[EMAIL PROTECTED]> wrote: ss> ss> Hi, ss> I Also have a another problem which is given below ss> while running select Query on derby database in embedded mode,I am ss> facing some problems. ss> ============================================================ ss> >Query is::: ss> select c_discount from customer where ( c_id = 941 and c_d_id = 1 and ss> c_w_id = 1) ss> ss> Exception arise::: ss> ERROR 22007: The syntax of the string representation of a datetime ss> value is incorrect. ss> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java) ss> at org.apache.derby.iapi.types.DateTimeParser.parseInt(DateTimeParser.java) ss> at org.apache.derby.iapi.types.SQLTimestamp.parseDateOrTimestamp(SQLTimestamp.java) ss> at org.apache.derby.iapi.types.SQLTimestamp.parseTimestamp(SQLTimestamp.java) ss> at org.apache.derby.iapi.types.SQLTimestamp.<init>(SQLTimestamp.java) ss> at org.apache.derby.iapi.types.SQLChar.getTimestamp(SQLChar.java) ss> at org.apache.derby.iapi.types.SQLChar.getTimestamp(SQLChar.java) ss> at org.apache.derby.iapi.types.SQLTimestamp.setFrom(SQLTimestamp.java) ss> at org.apache.derby.iapi.types.DataType.setValue(DataType.java) ss> at org.apache.derby.iapi.types.DataType.normalize(DataType.java) ss> at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(DataTypeDescriptor.java) ss> at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(NormalizeResultSet.java) ss> at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(NormalizeResultSet.java) ss> at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(DMLWriteResultSet.java) ss> at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java) ss> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java) ss> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java) ss> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java) ss> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java) ss> ss> table structure is::::: ss> CREATE TABLE CUSTOMER ( C_ID decimal(30) not null, ss> C_D_ID decimal(30) not null, ss> C_W_ID decimal(30) not null, ss> C_FIRST VARCHAR(16), ss> C_MIDDLE CHAR(2), ss> C_LAST VARCHAR(16), ss> C_STREET_1 VARCHAR(20), ss> C_STREET_2 VARCHAR(20), ss> C_CITY VARCHAR(20), ss> C_STATE CHAR(2), ss> C_ZIP CHAR(9), ss> C_PHONE CHAR(16), ss> C_SINCE TIMESTAMP, ss> C_CREDIT CHAR(2), ss> C_CREDIT_LIM decimal(30), ss> C_DISCOUNT decimal(30) , ss> C_BALANCE decimal(30) , ss> C_YTD_PAYMENT decimal(30) , ss> C_PAYMENT_CNT decimal(30) , ss> C_DELIVERY_CNT decimal(30) , ss> C_DATA VARCHAR(255) , ss> Primary Key (C_W_ID, C_D_ID, C_ID) , ss> Foreign Key (C_W_ID, C_D_ID) references DISTRICT (D_W_ID, D_ID) ) ss> ss> ============================================================= ss> ss> i am running this query in embedded mode. ss> ss> when i run this query though derby command prompt, it run ss> successfully, but through application program it through error message ss> as given above. ss> ss> I have checked the connection it taken successfully. ss> ss> Thanks and Regards, ss> ss> Sube Singh ss> ss> ss> ss> ss> ss> ss> ss> ss> ss> ss> On 7/5/05, Jeff Levitt <[EMAIL PROTECTED]> wrote: ss> > --- sube singh <[EMAIL PROTECTED]> wrote: ss> > > Hi, ss> > > ss> > > ss> > > Please help to start the derby network server. How ss> > > to get multiple ss> > > connection in network mode. ss> > > ss> > > ss> > > Thanks and Regards, ss> > > ss> > > Sube Singh ss> > > ss> > ss> > You should take a look at the Version 10.1 Server and ss> > Administration guide on the Manuals Page for Derby: ss> > ss> > http://incubator.apache.org/derby/manuals/ ss> > ss> > Here's a topic to help you get started: ss> > ss> > "How to start an embedded server from an application" ss> > http://incubator.apache.org/derby/docs/adminguide/cadminembeddedserver.html ss> > ss> > In the future, the derby-user list may be a better ss> > list to send questions concerning the use of Derby. ss> > Here are the Derby mailing lists: ss> > ss> > http://incubator.apache.org/derby/derby_mail.html ss> > ss> > Good luck and thanks for your interest! ss> > ss> > -- Dag H. Wanvik Sun Microsystems, Web Services, Database Technology Group Haakon VII gt. 7b, N-7485 Trondheim, Norway Tel: x43496/+47 73842196, Fax: +47 73842101 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
