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!
>
>
|