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/6/05, sube singh <[EMAIL PROTECTED]> wrote: > 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! > > > > > > > > > >
