db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik" <Dag.Wan...@Sun.COM>
Subject Re: How to Start the Derby network server Step by Step process
Date Tue, 05 Jul 2005 14:53:23 GMT

Hi Sube,

>From the stacktrace, it seems to be an error from an INSERT, not a
SELECT? Can you show us the INSERTs you use? 

Dag

>>>>> "ss" == sube singh <sube.singh@gmail.com> wrote:
ss> 
ss> Hi,
ss> I Also have a another problem which is given below 
ss> while running select Query on derby database in embedded mode,I am
ss> facing some problems.
ss> ============================================================
ss> >Query is:::
ss> select c_discount from customer where ( c_id =  941 and c_d_id = 1 and
ss> c_w_id  = 1)
ss> 
ss> Exception arise:::
ss> ERROR 22007: The syntax of the string representation of a datetime
ss> value is incorrect.
ss>        at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
ss>        at org.apache.derby.iapi.types.DateTimeParser.parseInt(DateTimeParser.java)
ss>        at org.apache.derby.iapi.types.SQLTimestamp.parseDateOrTimestamp(SQLTimestamp.java)
ss>        at org.apache.derby.iapi.types.SQLTimestamp.parseTimestamp(SQLTimestamp.java)
ss>        at org.apache.derby.iapi.types.SQLTimestamp.<init>(SQLTimestamp.java)
ss>        at org.apache.derby.iapi.types.SQLChar.getTimestamp(SQLChar.java)
ss>        at org.apache.derby.iapi.types.SQLChar.getTimestamp(SQLChar.java)
ss>        at org.apache.derby.iapi.types.SQLTimestamp.setFrom(SQLTimestamp.java)
ss>        at org.apache.derby.iapi.types.DataType.setValue(DataType.java)
ss>        at org.apache.derby.iapi.types.DataType.normalize(DataType.java)
ss>        at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(DataTypeDescriptor.java)
ss>        at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(NormalizeResultSet.java)
ss>        at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(NormalizeResultSet.java)
ss>        at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(DMLWriteResultSet.java)
ss>        at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java)
ss>        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java)
ss>        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java)
ss>        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
ss>        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
ss> 
ss> table structure is:::::
ss> CREATE TABLE CUSTOMER ( C_ID decimal(30) not null,
ss> 	 C_D_ID decimal(30) not null,
ss> 	 C_W_ID decimal(30) not null,
ss> 	 C_FIRST VARCHAR(16),
ss> 	 C_MIDDLE CHAR(2),
ss> 	 C_LAST VARCHAR(16),
ss> 	 C_STREET_1 VARCHAR(20),
ss> 	 C_STREET_2 VARCHAR(20),
ss> 	 C_CITY VARCHAR(20),
ss> 	 C_STATE CHAR(2),
ss> 	 C_ZIP CHAR(9),
ss>  	 C_PHONE CHAR(16),
ss> 	 C_SINCE TIMESTAMP,
ss> 	 C_CREDIT CHAR(2),
ss> 	 C_CREDIT_LIM decimal(30),
ss> 	 C_DISCOUNT decimal(30) ,
ss> 	 C_BALANCE decimal(30) ,
ss> 	 C_YTD_PAYMENT decimal(30) ,
ss> 	 C_PAYMENT_CNT decimal(30) ,
ss> 	 C_DELIVERY_CNT decimal(30) ,
ss> 	 C_DATA VARCHAR(255) ,
ss> 	 Primary Key (C_W_ID, C_D_ID, C_ID) ,
ss> 	 Foreign Key (C_W_ID, C_D_ID) references DISTRICT (D_W_ID, D_ID) )
ss> 
ss> =============================================================
ss> 
ss> i am running this query in embedded mode.
ss> 
ss> when i run this query though derby command prompt, it run
ss> successfully, but through application program it through error message
ss> as given above.
ss> 
ss> I have checked the connection it taken successfully.
ss> 
ss> Thanks and Regards,
ss> 
ss> Sube Singh
ss> 
ss> 
ss> 
ss> 
ss> 
ss> 
ss> 
ss> 
ss> 
ss> 
ss> On 7/5/05, Jeff Levitt <derby@mylevita.com> wrote:
ss> > --- sube singh <sube.singh@gmail.com> wrote:
ss> > > Hi,
ss> > >
ss> > >
ss> > > Please help to start the derby network server. How
ss> > > to get multiple
ss> > > connection in network mode.
ss> > >
ss> > >
ss> > > Thanks and Regards,
ss> > >
ss> > > Sube Singh
ss> > >
ss> > 
ss> > You should take a look at the Version 10.1 Server and
ss> > Administration guide on the Manuals Page for Derby:
ss> > 
ss> > http://incubator.apache.org/derby/manuals/
ss> > 
ss> > Here's a topic to help you get started:
ss> > 
ss> > "How to start an embedded server from an application"
ss> > http://incubator.apache.org/derby/docs/adminguide/cadminembeddedserver.html
ss> > 
ss> > In the future, the derby-user list may be a better
ss> > list to send questions concerning the use of Derby.
ss> > Here are the Derby mailing lists:
ss> > 
ss> > http://incubator.apache.org/derby/derby_mail.html
ss> > 
ss> > Good luck and thanks for your interest!
ss> > 
ss> >

-- 
Dag H. Wanvik
Sun Microsystems, Web Services, Database Technology Group
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recipient, please contact
the sender by reply email and destroy all copies of the original
message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

Mime
View raw message