db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sube singh <sube.si...@gmail.com>
Subject Re: How to Start the Derby network server Step by Step process
Date Wed, 06 Jul 2005 03:59:25 GMT
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 <sube.singh@gmail.com> 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 <satheesh@sourcery.org> 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 <derby@mylevita.com> wrote:
> 
> > --- sube singh <sube.singh@gmail.com> 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!
> 
> 
> 
> >
> 
> 
> >
>

Mime
View raw message