hi,
I appreciate your advice, Larry.
Your guess is right to the point!
> Odds are good that your driver is choking on it.
>
> Try this:
>
>
> INSERT INTO testtable (seqNo, name)
> VALUES (#seqNo:INTEGER#, #name:VARCHAR#)
>
>
> This will tell iBATIS what the types are, and it can then
Odds are good that your driver is choking on it.
Try this:
INSERT INTO testtable (seqNo, name)
VALUES (#seqNo:INTEGER#, #name:VARCHAR#)
This will tell iBATIS what the types are, and it can then tell your driver.
I think that will fix it.
Larry
On 12/7/05, Toshiaki Takashima <[EMAIL PRO
hi,
> Larry
thank for your response.
> Are you getting a SQLException?
I get Exception when executing insert statement
with setting "name" parameter to null such as :
com.ibatis.common.jdbc.exception.NestedSQLException
--- The error occurred in Map.xml.
--- The error occurred while applyi
My application makes heavy use of the ibatis DAO framework. I primarily use sqlmaps for my implementation. The problem is, my app has some front end caching that needs to be flushed when underlying data is changed. It seems like the best place to do this is in the DAOs however I have no way of pass
On 11/10/05, Paul Benedict <[EMAIL PROTECTED]> wrote:
...While you're at it, I don't think caching
> works unless you pass in parameters; I have MANY parameterless queries and I
> haven't been able to
> see them get cached yet (stay tuned).
Is this true? Parameterless queries like SELECT * FROM
I am unaware of any planned native support of PL/SQL tables.
Your best bet for handling PL/SQL tables or object types is to create a
implement a custom TypeHandlerCallback.
Regards,
Mike Fagan
Juan Cañadas wrote:
It works fine!!!
Thanks!!! :-)
Another question... Oracle PL/SQL tables aren'
Hello
If i have to use DAO and SQLMap to get data from my
database, but i want to supply the connection, is it
possible?
for example if i have to just SQLMap i do the
following
SqlMapClient client =
GetSQLConfig.getSqlMapInstance();
client.setUserConnection(conn);
How can i do it when using DAO a
I discovered this by accident, during unit tests. I needed an expected
value and then I was inserting into it with specific values.
In fact, I was wondering if a little bit of reflection like
public Object insert(Object o) throws SQLException{
return this.dbclient.insert("insert"+o.ge
Why are you inserting into an auto_increment field?
Larry
On 12/7/05, Leonardo Kenji Shikida <[EMAIL PROTECTED]> wrote:
> if I try to insert an object with id=0 into a mysql table that have an
> autoincrement id column, strange things happens
>
> mysql silently inserts that object with messy val
if I try to insert an object with id=0 into a mysql table that have an
autoincrement id column, strange things happens
mysql silently inserts that object with messy values. very dangerous.
is there any workaround for this in mysql or ibatis? or will I have to
check explictly for zeroed ids and th
Are you getting a SQLException?
Larry
On 12/7/05, Toshiaki Takashima <[EMAIL PROTECTED]> wrote:
> Hi there
>
> I defined sql Map definition for select statement
> as follows :
>
>
>
> SELECT
> SEQNO as seqNo,
> NAME as name
> FROM testtable
> WHERE
> NME like #
Yeah, that is a known issue - it is fixed in SVN, but not in the
release...either get 2.1.5, or check it out and build it.
Larry
-- Forwarded message --
From: Juan Cañadas <[EMAIL PROTECTED]>
Date: Dec 7, 2005 9:15 AM
Subject: oracle/toplink/sessions/UnitOfWork
To: user-java@ibat
Hi there
I defined sql Map definition for select statement
as follows :
SELECT
SEQNO as seqNo,
NAME as name
FROM testtable
WHERE
NME like #paraName#
This Statement works, but following insert statement
fails when null(java) value is specified to any paramet
you need a 'toplink.jar' from your classpath.
TopLink can download from oracle.com
2005/12/8, Juan Cañadas <[EMAIL PROTECTED]>:
Hello...I'm trying to implement DAO with ibatis and Oracle...i'm using ibatis-dao-2.jar, release
2.1.6 - Nov 5, 2005, downloaded fromhttp://opensource2.atlassian.com/con
Hello...
I'm trying to implement DAO with ibatis and Oracle...
i'm using ibatis-dao-2.jar, release 2.1.6 - Nov 5, 2005, downloaded from
http://opensource2.atlassian.com/confluence/oss/pages/viewpageattachments.action?pageId=561
but it raises the error:
Exception in thread "main" java.lang.NoClas
Hi there
I have configured iBatis to use JTA like this:
It worked with JBoss 4.0.3RC2. With JBoss 4.0.3SP1 it doesn't work anymore.
I receive a NameNotFoundException.
Has somebody an idea about this?
I want to process the items once if they DO NOT come from the cache.
Zsolt
>-Original Message-
>From: Zarar Siddiqi [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, December 07, 2005 4:47 PM
>To: user-java@ibatis.apache.org
>Subject: Re: How to figure out whether the results are coming from th
Well, for development purposes you would just check the IBatis logs when
your query executes. I'm not too sure why you would need to know this in a
production scenario?
- Original Message -
From: "Zsolt" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 07, 2005 7:55 AM
Subject: Ho
I have the problem also with ibatis-2.1.6.589 and that is pretty new.
Zsolt
>-Original Message-
>From: Voorhoeve, Niels {PBG} [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, December 07, 2005 4:26 PM
>To: user-java@ibatis.apache.org
>Subject: RE: Does Read/Write cache work?
>
>There is a prob
There is a problem with the cache in the 2.1.5 release. It does not
properly cache null objects. Maybe that is the reason for your problem.
The version in SVN works for me, so maybe it will solve this issue for
you.
-Original Message-
From: Zsolt [mailto:[EMAIL PROTECTED] On Behalf Of
[E
Hi,
If I use an LRU cache readOnly="true" I see in the log that ibatis doesn't
access the database if the data is already available but id I use
readOnly="false" I do see prepared statements.
Do I miss something?
I'm using ibatis-2.1.5.582.
Zsolt
Hi,
How to figure out whether the results are coming from the cache or newly
fetched from the database?
Zsolt
It works fine!!!
Thanks!!! :-)
Another question... Oracle PL/SQL tables aren't supported? is there
expected to support them in future versions?
Mike Fagan wrote:
Juan,
Sorry I missed the change for namespaces. If you download the source
from the wiki it should work fine for you.
(I even t
I seam to be getting a null return on sqlmap getConnection but if i use
getDataSource getConnection that works ok is there any reason for this?
And if i use the latter do i need to close the connection myself?
Steve.
This e-mail and any attachment is for authorised use by the intended
reci
24 matches
Mail list logo
