db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: How to Start the Derby network server Step by Step process
Date Tue, 05 Jul 2005 16:26:04 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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?<br>
<br>
Satheesh<br>
<br>
sube singh wrote:<br>
<blockquote cite="mid74130ca10507050124367c31f9@mail.gmail.com"
 type="cite">
  <pre wrap="">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.&lt;init&gt;(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 <a class="moz-txt-link-rfc2396E" href="mailto:derby@mylevita.com">&lt;derby@mylevita.com&gt;</a>
wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">--- sube singh <a class="moz-txt-link-rfc2396E" href="mailto:sube.singh@gmail.com">&lt;sube.singh@gmail.com&gt;</a>
wrote:
    </pre>
    <blockquote type="cite">
      <pre wrap="">Hi,


Please help to start the derby network server. How
to get multiple
connection in network mode.


Thanks and Regards,

Sube Singh

      </pre>
    </blockquote>
    <pre wrap="">You should take a look at the Version 10.1 Server and
Administration guide on the Manuals Page for Derby:

<a class="moz-txt-link-freetext" href="http://incubator.apache.org/derby/manuals/">http://incubator.apache.org/derby/manuals/</a>

Here's a topic to help you get started:

"How to start an embedded server from an application"
<a class="moz-txt-link-freetext" href="http://incubator.apache.org/derby/docs/adminguide/cadminembeddedserver.html">http://incubator.apache.org/derby/docs/adminguide/cadminembeddedserver.html</a>

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:

<a class="moz-txt-link-freetext" href="http://incubator.apache.org/derby/derby_mail.html">http://incubator.apache.org/derby/derby_mail.html</a>

Good luck and thanks for your interest!


    </pre>
  </blockquote>
  <pre wrap=""><!---->


  </pre>
</blockquote>
</body>
</html>


Mime
View raw message