Stephen,
Thanks for the reply. The table is in only one schema.
I have confirmed this by doing a:
SELECT table_name, owner from all_tables where table_name='BLAST_PROG'
as the sysdba user.
Thanks
-
Randall Svancara
Systems Administrator
On Tue, 2008-01-22 at 18:14 -0500, Stephen Boyd wr
I did not use the parameter object because I wanted to ensure that the
parameters in the where clause were valid.
I have confirmed that the database, in this case called maindev has a
table named blast_prog. It also has data in the table.
I actually just got this to work my setting the followi
Do you have the same table in multiple schemas? If so, make sure ibatis is
reading from the correct schema.
On Jan 22, 2008 4:37 PM, Randall Svancara <[EMAIL PROTECTED]> wrote:
> I have used Ibatis for numerous projects and never had a problems with
> returning back a result set. I have other f
Can you turn on logging for java.sql? Then you can see more of what ibatis
is doing with the prepared statement and its parameters.
On Jan 22, 2008 10:45 AM, Krenek, Robert <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
>
> I'm running into an issue that I cannot resolve. If you can provide any
> as
Just a heads up that you are sending a parameter object and not using it :)
Are you positive that you are running the sql in SqlPlus against the same
DB. I can't tell you how many times I get a config messed up and run my
test against an empty DB.
Nathan
On Jan 22, 2008 2:37 PM, Randall Svancar
D'oh! Thanks Chris.
Christopher Lamey wrote:
>
>
>> # User.java #
>> public class User implements java.io.Serializable {
>> private String userName;
>>
>> public String getUserName() { return this.userName; }
>> public void setUserName(String s) { this.userName = userName; }
>> }
I am sure this is not part of the problem but you might want to upgrade your
dtd's to point to the the new apache url.
I would also want to see the api call that you are making to be sure you are
not calling update.
On Jan 22, 2008 2:37 PM, Randall Svancara <[EMAIL PROTECTED]> wrote:
> I have us
Hmm Did you try TRIM(trailing ' ' from sm_issue_symbol)?
On Jan 22, 2008 4:59 PM, novotny <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> That's what I wanted to but for whatever reason maybe because it's CHAR or
> maybe because it's informix, but it doesn't trim the string so I still get
> whitesp
Hi,
That's what I wanted to but for whatever reason maybe because it's CHAR or
maybe because it's informix, but it doesn't trim the string so I still get
whitespace padding... :-(
Jason
Stephen Boyd-3 wrote:
>
> Why don't you change your select clause to this?
>
>select *trim(sm_issue_
> # User.java #
> public class User implements java.io.Serializable {
> private String userName;
>
> public String getUserName() { return this.userName; }
> public void setUserName(String s) { this.userName = userName; }
> }
Should the setter do this?
public void setUserName(String
Why don't you change your select clause to this?
select *trim(sm_issue_symbol) as sm_issue_symbol*,
tm_id
from
sec_master,
category_security,
tier_mast
where sm_secid = cs_secid
and cs_tierid = tm_id
and sm_issue_symbol
I have used Ibatis for numerous projects and never had a problems with
returning back a result set. I have other files configured in a similar
manner and they seem to work just fine.
First of all, i have this sql configuration file:
Contents of Blast_Program.xml
Hi all,
I have a simple problem that I can't seem to get to the root of. I have
searched the archives, the wiki and the SQL map guide with no success. So,
if there is a previous post or other resource that will solve this problem I
would be grateful for a link or other help.
That being said, I
Hi,
I'm not quite sure what you mean-- this is what I have in my sql-ibatis.xml
file:
select
sm_issue_symbol,
tm_id
from
sec_master,
category_security,
tier_mast
where sm_secid = cs_secid
and cs_tier
Thanks Dave for the quick reply. That worked perfectly ..!!
"You should be the change You want to see in the world" -Mahatma Gandhi.
Regards,
Pramodreddy Kampalli
Ph#: (703)-605-2137
[EMAIL PROTECTED]
01/22/2008 12:05 PM
Please respond to
user-java@ibatis.apache.org
To
user-java@ibatis
Try this:
Select DISTINCT
A.Key as java1,
B.Key as java2,
C.Key as java3
From
A,B,C
so that the column aliases match up with the column values.
Dave
We must begin not just to act, but to think, for there is no better slave
than the one who believes hi
Hi there,
I currently use the query (using alias) as:
Select DISTINCT
A.Key as java1,
B.Key as java2,
C.Key as java3
>From
A,B,C
But now for performance issues when i tried to use result map like this:
Select DISTINCT
A.Key
Hi all,
I'm developing a project with eclipse, when running my IBatis DAO inside
eclipse (Run as Java application) I get very fast responses to get my DTOs
filled (a few seconds). The only settings I put in the Run window is inside the
'VM arguments' section and they are:
-Xms256m
-Xmx512m
H
shouldnt you be using something like this :
update digicon.contract set contractStatusCode = #
contractStatusCode:INTEGER# where contractId = #contractId#
regards
ashok
On Jan 22, 2008 3:45 PM, Krenek, Robert <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
>
> I'm running into an issue that I c
Ok to reply to myself then.
I've 'fixed' it by using the shutdown property on my IBATIS Derby JDBC
connection.
I call the dangerous servlet below from my other application to kill IBATIS
database connection (for ever, the application has to be restarted)
public String killMe() {
Thank you Jeff - this solved my question!
Tou could do this:
// query here
SU.userId=#value#
Jeff Butler
--
View this message in context:
http://www.nabble.com/howto-pass-a-Long-argument-to-a-query-%28isNotNull%29-tp14954
Hi All,
I'm running into an issue that I cannot resolve. If you can provide any
assistance, your help would be much appreciated.
The environment consists of Ibatis, along with Apache and Tomcat on Linux
connecting to a DB2 database on an as400.
Insert statements that once worked, are suddenly
Yes, I've checked the source. I get an error when I try to use FishEye to
view JdbcTypeRegistry. Using the Subversion link, JdbcTypeRegistry shows
the method setType as private.
Joe
Larry Meadors-2 wrote:
>
> Have you tried to build iBATIS from the source?
>
> It's probably there, but just
No, you'll need to use JDBC directly for that.
Larry
On Jan 22, 2008 2:29 AM, <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> When using BLOB data it is prefered to use stream mode to save memory usage.
> So instead of using a byte[] for my BLOB data, is there a way to have a
> stream? I've been looking
hi,
is it possible to refer to list items from a parameter class in a call
to a stored proc?
If I have a class as follows that I use as a paramaterClass:
class Foo {
List bar;
String name;
// getters/setters omitted
}
class Bar {
String name;
//getters/setters omitted
}
.. and a SP
Forcing the iBATIS to close the connection doesnt work.we have tried this at
our end.
- Original Message
From: Meindert <[EMAIL PROTECTED]>
To: user-java@ibatis.apache.org
Sent: Tuesday, 22 January, 2008 3:51:22 PM
Subject: RE: how to close connection iin iBATIS
Hi Anika,
I’m having
Hi Anika,
I'm having the same issue, am using Derby with IBATIS on my application.
Derby only one process to access it.
So I'll have to force IBATIS to close all connections before I can access it
from a other process.
My other process would be the database setup application that updates the
Hi,
When using BLOB data it is prefered to use stream mode to save memory
usage. So instead of using a byte[] for my BLOB data, is there a way to
have a stream? I've been looking around in the documentation and on the
Internet. Until now I only found messages that BLOBs can't be processed in
s
28 matches
Mail list logo
