Thanks dear, problem resolved actually my db contains too much records and i
was using wireless, after some time of query it gave an error .
then i try with rownum wrote:
> Btw, I think the problem is in the #date:VARCHAR# part. Why don't
> you put the date in as :DATE or :TIMESTAMP ? Did you t
Count is a keyword. it might not be accepted. Try something else.
Did u execute this query directly
On Fri, Jun 12, 2009 at 7:44 AM, DelGurth wrote:
> To me that COUNT seems like an alias for the result of COUNT(CD) as in
> SELECT COUNT(CD) AS COUNT
>
> But, what is the error?
>
> DelGurth
>
>
Btw, I think the problem is in the #date:VARCHAR# part. Why don't
you put the date in as :DATE or :TIMESTAMP ? Did you try to put
com.ibatis and java.sql log to debug, so you see the exact parameter
going into the #date# parameter?
DelGurth
On Fri, Jun 12, 2009 at 4:44 PM, DelGurth wrote:
> To
To me that COUNT seems like an alias for the result of COUNT(CD) as in
SELECT COUNT(CD) AS COUNT
But, what is the error?
DelGurth
On Fri, Jun 12, 2009 at 3:35 PM, Brandon Goodin wrote:
> I didn't look over it thoroughly but i noticed you appear to have a
> misplaced "COUNT":
> SELECT CG , COUNT
I didn't look over it thoroughly but i noticed you appear to have a
misplaced "COUNT":
SELECT CG , COUNT(CD) *COUNT*,
SUM (
TO_DATE(EDATE||' '|| etime ,'DD-MM- HH24:MI:SS' ) -
TO_DATE(ADATE||' '|| atime ,'DD-MM- HH24:MI:SS' )
) total_time
Perh
i am trying to run this but problem occursi have a class
public class CompleteCallsReportBean implements Serializable{
/**
*
*/
private static final long serialVersionUID = 2192836100387342196L;
/**
*
*/
private String cg;
private String COUNT;
private String totalTime;
public void set
... I don't know if it will help, but look the iText library
http://www.lowagie.com/iText/
(but you probably knew about already)
--- On Mon, 9/1/08, Richard Yee <[EMAIL PROTECTED]> wrote:
> From: Richard Yee <[EMAIL PROTECTED]>
> Subject: Re: Help required regarding sho
Ananth,
You aren't storing PDF data into your blob. You are storing a String.
You need to store a PDF in order to retrieve a PDF.
You should use a PDF library to construct a PDF file.
The error you are getting is caused by the fact that you are writing a
String that you retrieved from the data
Hi,
We are using Ibatis with Spring in our project. We have
requirement to store pdf files in the database as blob columns and
retrieve them and show them again as pdf. Currently we are doing the
following.
1. We are converting the pdf file into a byte array and saving
I can only think that it's either that the string is too long, or it's a problem with the JDBC driver. iBATIS doesn't do anything special here, just calls PreparedStatement.setString();PS: Larry is right, you can't use CHAR(10), instead just use CHAR.
Cheers,ClintonOn 6/2/06, Clinton Begin <[EMAIL
n [mailto:[EMAIL PROTECTED]
Sent: Friday, June 02, 2006 1:00 PM
To: user-java@ibatis.apache.org
Subject: Re: IBATIS CHAR FIELD NULL VALUES- Urgent help required
What Java type are you trying to map to the CHAR field?
On 6/2/06, Krishnamoorthi, Sruthi (Raytheon) <
[EMAIL PROTECTED]> wrote:
>
String
type
Thanks, Sruthi Krishnamoorthi 703-562-9732(Work) 537 A -
(Raytheon) Location
-Original Message-From: Clinton Begin
[mailto:[EMAIL PROTECTED]Sent: Friday, June 02, 2006 1:00
PMTo: user-java@ibatis.apache.orgSubject: Re: IBATIS
CHAR FIELD NULL VALUES- Urgent he
What Java type are you trying to map to the CHAR field?On 6/2/06, Krishnamoorthi, Sruthi (Raytheon) <
[EMAIL PROTECTED]> wrote:I have a char field which carries null value.
The samething with varchar field also.when I pass null values it was throwing sql exception as incompatible column types. Then
I have a char field which carries null value.
The samething with varchar field also.
when I pass null values it was throwing sql exception as incompatible column
types. Then for varchar field i add #centerNo:VARCHAR# and same for DAte field
#priorityDt:DATE#.
When I did same for CHAR #parentPat
I don't count myself as often, but for a 1:M or M:M relationship, I will
often insert multiple rows in a statement.
However, I have no need of the updated row count nor retrieving the PK
for each entry (as they are keyed off of the other relationship).
Larry Meadors wrote:
Am I missing somet
Most likely for "muti-insert" you want to use prepared statement (inside
a transaction), and I do so in Groovy (instead of iBatis, I use ibatis
for OLTP, Groovy for batch. Q: I wonder if people know why prepared
statement exists even. A: It's 1,000 times faster).
.V
Sven Boden wrote:
So inse
Am I missing something here...do people frequently insert multiple rows?
Because I would guess that 99.999% of the time I insert one and only one row.
Getting a 0 or 1 back is no more useful than an exception being thrown
(or not being thrown).
This is not going to be changed because of that and
hi, Sruthi (Raytheon)
To: user-java@ibatis.apache.org
Sent: Friday, March 10, 2006 7:41 PM
Subject: Urgent help required
The docs says
int rows = sqlMap.insert ("insertProduct", product);
returns a int value
When I code it ,the return value is object. I am n
Sruthi
(Raytheon)
To: user-java@ibatis.apache.org
Sent: Friday, March 10, 2006 7:41
PM
Subject: Urgent help required
The docs says
int
rows = sqlMap.insert (insertProduct,
product);
returns a int value
When I code it ,the return value is object I a
I will
try this. Thank you
Thanks, Sruthi Krishnamoorthi 703-562-9732(Work) 537 A -
(Raytheon) Location
-Original Message-From: Chen, Tim
[mailto:[EMAIL PROTECTED]Sent: Friday, March 10, 2006 5:07
PMTo: user-java@ibatis.apache.orgSubject: RE: Urgent
help required
ect: RE: Urgent
help required
If
this is the case Y all doc's of Ibatis are statting that it returns a int return
value.
Thanks, Sruthi Krishnamoorthi 703-562-9732(Work) 537 A -
(Raytheon) Location
-Original Message-From: Jeff Butler
[mailto:[EMAIL PROTECTED]Sent: Friday,
In the documents "int" is returned but for iBATIS this is a shortcut for
java.lang.Integer (done in
com.ibatis.sqlmap.engine.type.TypeHandlerFactory). So the documents are
correct, although it may indicate something else for some people upon
first reading.
Regards,
Sven
Larry Meadors wrote:
On 3/10/06, Krishnamoorthi, Sruthi (Raytheon)
<[EMAIL PROTECTED]> wrote:
>
> If this is the case Y all doc's of Ibatis are statting that it returns a int
> return value.
Because in addition to providing you with free support, we all have
day jobs to pay the bills.
Feel free to check out the docs
r [mailto:[EMAIL PROTECTED]
]
Sent: Friday, March 10, 2006 1:13 PMTo:
user-java@ibatis.apache.orgSubject: Re: Urgent help required
Yes - or you could do a select to verify if you don't trust your database or JDBC driver's exception handling.
Jeff Butler
On 3/10/06, Krishnamoorthi, Sruthi (Ra
PMTo: user-java@ibatis.apache.orgSubject: Re: Urgent
help required
Yes - or you could do a select to verify if you don't trust your database
or JDBC driver's exception handling.
Jeff Butler
On 3/10/06, Krishnamoorthi, Sruthi (Raytheon) <[EMAIL PROTECTED]>
wrote:
y way to confirm.
Thanks, Sruthi Krishnamoorthi 703-562-9732(Work)
537 A - (Raytheon) Location
-Original Message-From: Jeff Butler [mailto:
[EMAIL PROTECTED]]Sent: Friday, March 10, 2006 1:08 PMTo: user-java@ibatis.apache.org
Subject: Re: Urgent help required
You woldn't - is u
theon) Location
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
> Of Larry Meadors
> Sent: Friday, March 10, 2006 12:58 PM
> To: user-java@ibatis.apache.org
> Subject: Re: Urgent help required
>
>
> I think you only get a
PMTo: user-java@ibatis.apache.orgSubject: Re: Urgent
help required
You woldn't - is used for automatically generated keys
(like identity fields or sequences). In your case, the insert worked if
no exception is thrown.
Jeff Butler
On 3/10/06, Krishnamoorthi, Sruthi (Ray
) Location
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of Larry Meadors
Sent: Friday, March 10, 2006 12:58 PM
To: user-java@ibatis.apache.org
Subject: Re: Urgent help required
I think you only get a value back if you use selectKey.
Larry
On 3/10/06, Kris
The return value is the result of a element if there is one, or null - NOT the number of rows.
Jeff Butler
On 3/10/06, Krishnamoorthi, Sruthi (Raytheon) <[EMAIL PROTECTED]> wrote:
This is throwing an exception because
Integer test = (Integer)sqlMap.insert(qryId,usr);
System.out.println("Ret
This
is throwing an exception because
Integer test = (Integer)sqlMap.insert(qryId,usr);
System.out.println("Return value from
Insert"+test); id displaying Null
value:
But a record is getting inserted in
Database. //For sure
How to confirm that my record got
inserted.
Thanks, Sruthi Krish
ouch the first line should read...int rows = ((Integer)sqlMap.insert("insertProduct", product)).intValue();On Mar 10, 2006, at 10:51 AM, Nathan Maves wrote:Just useInteger rows = ((Integer)sqlMap.insert("insertProduct", product)).intValue();if you are using Java 1.5int rows = (Integer)sqlMap.insert
Just useInteger rows = ((Integer)sqlMap.insert("insertProduct", product)).intValue();if you are using Java 1.5int rows = (Integer)sqlMap.insert("insertProduct", product);NathanOn Mar 10, 2006, at 10:41 AM, Krishnamoorthi, Sruthi (Raytheon) wrote: The docs says int rows = sqlMap.insert (“in
The docs says
int
rows = sqlMap.insert (“insertProduct”,
product);
returns a int value
When I code it ,the return value is object. I am not
able to get the int return value. Please help me
out.
Thanks, Sruthi Krishnamoorthi 703-562-9732(Work) 537 A -
(Raytheon) Location
Looks like you are totally new to java world. First read a JSP/Servlets book. I would recommend you to read SWCD (search in google) book which gives you exposure to all areas. Then read the iBATIS guides. Trust me, both these take hardly a weekend. Finish that first than start asking questions![EMA
There are 2 things here that jump out as bad ideas:
1) Using M$ Access for *anything* Java-related
2) Hijacking another thread and adding your questions to it
So, I would suggest you get either MySQL or PostregreSQL or...well,
almost ANYTHING would be a better choice than Access (except for may
I am very new to struts and ibatis. I am trying to develop a very small
application. I just have jsp
Page (application is developed using struts) which has textbox, which
gets the id. I want to put the value in the variable id into the
microsoft access database using ibatis. That's all.
I have
AIL PROTECTED]> wrote:
I would think you should add tag in your .Not to sure how this works with a key that isn't a int.-Original Message-From: Karthikeyan Pandurangan [mailto:
[EMAIL PROTECTED]]Sent: 09 September 2005 05:45 AMTo: user-java@ibatis.apache.org; [EMAIL PROTECTED]Subjec
I would think you should add tag in your .
Not to sure how this works with a key that isn't a int.
-Original Message-
From: Karthikeyan Pandurangan [mailto:[EMAIL PROTECTED]
Sent: 09 September 2005 05:45 AM
To: user-java@ibatis.apache.org; [EMAIL PROTECTED]
Subject: Re: help req
number of rows effected.
Throws:
java.sql.SQLException - If an error occurs.
On 9/8/05, Karthikeyan Pandurangan <[EMAIL PROTECTED]> wrote:
-- Forwarded message --From: Karthikeyan Pandurangan <[EMAIL PROTECTED]>Date: Sep 9, 2005 9:01 AMSubject: help required for insert(
-- Forwarded message --
From: Karthikeyan Pandurangan <[EMAIL PROTECTED]>
Date: Sep 9, 2005 9:01 AM
Subject: help required for insert()
To: [EMAIL PROTECTED]
Hi,
I have a problem in using insert() in ibatis 2.1.5 with SQLMap. As
there is no proper sample and doc expl
