Hi, I agree with you. But tell me how to start the derby sever in verbose mode. It help us to find out the insert query.
Thanks for your reply. I hope that you take my problem seriouly and help me to resolve it. Sube On 7/5/05, Satheesh Bandaram <[EMAIL PROTECTED]> wrote: > I have a feeling the stack trace probably wasn't for the query below... The > stack trace shows compiling an INSERT statement, but query below is a > SELECT. Also, there is no timestamp datatype usage in the SELECT query. Is > it possible the error was for another query? > > Satheesh > > > sube singh wrote: > Hi, I Also have a another problem which is given below while running > select Query on derby database in embedded mode,I am facing some > problems. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Query > is::: select c_discount from customer where ( c_id =3D 941 and c_d_id =3D 1 > and c_w_id =3D 1) Exception arise::: ERROR 22007: The syntax of the string > representation of a datetime value is incorrect. at > org.apache.derby.iapi.error.StandardException.newException(Stand= ardException.java) > at > org.apache.derby.iapi.types.DateTimeParser.parseInt(DateTimePars= er.java) > at > org.apache.derby.iapi.types.SQLTimestamp.parseDateOrTimestamp(SQ= LTimestamp.java) > at > org.apache.derby.iapi.types.SQLTimestamp.parseTimestamp(SQLTimes= tamp.java) > at > org.apache.derby.iapi.types.SQLTimestamp.<init>(SQLTimestamp.jav= a) > at > org.apache.derby.iapi.types.SQLChar.getTimestamp(SQLChar.java) > at > org.apache.derby.iapi.types.SQLChar.getTimestamp(SQLChar.java) > at > org.apache.derby.iapi.types.SQLTimestamp.setFrom(SQLTimestamp.ja= va) > at > org.apache.derby.iapi.types.DataType.setValue(DataType.java) > at > org.apache.derby.iapi.types.DataType.normalize(DataType.java) > at > org.apache.derby.iapi.types.DataTypeDescriptor.normalize(DataTyp= eDescriptor.java) > at > org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRo= w(NormalizeResultSet.java) > at > org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowC= ore(NormalizeResultSet.java) > at > org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCo= re(DMLWriteResultSet.java) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertRes= ultSet.java) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(Gener= icPreparedStatement.java) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Embed= Statement.java) > at > org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement= .java) > at > org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement= .java) table > structure is::::: CREATE TABLE CUSTOMER ( C_ID decimal(30) not null, C_D_ID > decimal(30) not null, C_W_ID decimal(30) not null, C_FIRST VARCHAR(16), > C_MIDDLE CHAR(2), C_LAST VARCHAR(16), C_STREET_1 > VARCHAR(20),C_STREET_2 VARCHAR(20), C_CITY VARCHAR(20), C_STATE CHAR(2), > C_ZIP CHAR(9),C_PHONE CHAR(16), C_SINCE TIMESTAMP, C_CREDIT > CHAR(2), C_CREDIT_LIM decimal(30), C_DISCOUNT decimal(30) , > C_BALANCE decimal(30) , C_YTD_PAYMENT decimal(30) , C_PAYMENT_CNT > decimal(30) , C_DELIVERY_CNT decimal(30) , C_DATA VARCHAR(255) , Primary > Key (C_W_ID, C_D_ID, C_ID) , Foreign Key (C_W_ID, C_D_ID) > references DISTRICT (D_W_ID, D_ID) > ) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D i > am running this query in embedded mode. when i run this query though derby > command prompt, it run successfully, but through application program it > through error message as given above. I have checked the connection it > taken successfully. Thanks and Regards, Sube Singh On 7/5/05, > Jeff Levitt <[EMAIL PROTECTED]> wrote: > --- sube singh <[EMAIL PROTECTED]> wrote: > Hi, Please help to start the derby network server. How to get > multiple connection in network mode. Thanks and Regards, Sube Singh > You should take a look at the Version 10.1 Server and Administration guide > on the Manuals Page for > Derby: http://incubator.apache.org/derby/manuals/ Here's > a topic to help you get started: "How to start an embedded server from an > application" http://incubator.apache.org/derby/docs/adminguide/cadminembeddedserver.html In > the future, the derby-user list may be a better list to send questions > concerning the use of Derby. Here are the Derby mailing > lists: http://incubator.apache.org/derby/derby_mail.html Good > luck and thanks for your interest! > >
