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:58:30 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/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