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 Tue, 05 Jul 2005 08:24:39 GMT
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