I have a list of result objects that were returned by a
queryForPaginatedList. I need to add some information to this
object. But if I loop over the resulting list it only added the date
to the first n, in this case 25, rows.
How can I make sure that the data is loaded to the next set of
-- Forwarded message --
From: Brandon Goodin <[EMAIL PROTECTED]>
Date: Jun 9, 2005 4:26 PM
Subject: Re: creating tables and dynamic configiration
To: [EMAIL PROTECTED]
larry's idea is better. Mine sucks.
Brandon
On 6/9/05, Larry Meadors <[EMAIL PROTECTED]> wrote:
> Ooooh, Ok.
>
Ooooh, Ok.
Use the SqlMapClient's buildSqlMapClient(Reader reader, Properties
props) method.
You can pass in the properties at runtime that way.
Larry
On 6/9/05, Brandon Goodin <[EMAIL PROTECTED]> wrote:
> -- Forwarded message --
> From: Dmitry Skavish <[EMAIL PROTECTED]>
> Date
Dmitry,
you can still use the ThreadLocal strategy without the connection pool
stuff. In a client side app i am assuming you would only need one
connection. So, you could write your own datasource factory that
implements the DataSourceFactory interface and your own DataSource
which implements the
-- Forwarded message --
From: Dmitry Skavish <[EMAIL PROTECTED]>
Date: Jun 9, 2005 3:35 PM
Subject: Re: creating tables and dynamic configiration
To: Brandon Goodin <[EMAIL PROTECTED]>
Let me explain. I am developing a client side app, that is with gui
and such, not a web app.
The
I added it recently. I'm not sure if it exists in the currently
distributed docs. But it is in the svn docs.
http://svn.apache.org/repos/asf/ibatis/trunk/java/docs/iBATIS-SqlMaps-2-Tutorial.sxw
This is an open office document.
Brandon
On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> Right, p
okay, post your final statement. I'll test it this evening with jdk1.5
to see if i get the same results.
Brandon
On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> Oops. I did move it inside the iterate tag where it belongs, but that
> didn't fix my problem, still same exception as before.
>
>
Right, prepend removes the first occurence, that makes sense. Just
hard-coding works fine in this case, since the dynamic tag isn't
really needed. Is there somewhere in the documentation that talks
about the #[]# syntax? Since #value# is how you do it without the
iterate tag, I would assume peop
Oops. I did move it inside the iterate tag where it belongs, but that
didn't fix my problem, still same exception as before.
On 6/9/05, Daniel Henrique Ferreira e Silva <[EMAIL PROTECTED]> wrote:
> Hi Paul,
>
> Did you try putting session_id IN #value[]# inside iterate tag?
>
> Cheers,
> Daniel
This works, thanks.
On 6/9/05, Brandon Goodin <[EMAIL PROTECTED]> wrote:
>
> SELECT
> session_id as id, count(*) count
> FROM
> events
>
>close=")" conjunction=",">
> #[]#
>
>
> GROUP BY
> session_id
>
>
Prepend does work. The tag removes the prepend of the first
content producing tag. So, i gave you a bad example. Sorry.
Yes, i have an example that works just fine.
This should work:
SELECT
session_id as id, count(*) count
FROM
events
#[]#
GROUP BY
session_id
#1 not intentionally
#2 I'm not sure what xml generation has to do with this issue. Maybe i
am misunderstanding you. If you are developing a web application you
will have to do something like what was provided if you want
individuals to use their own username and password for database
access. Cons
Good question. If you place the tags inside the tag, the
first content producing dyanmic tag will have it's prepend removed. If
you have further nested tags you can use the removeFirstPrepend
attribute as well. Both of these are documented in the SQL Maps PDF.
Brandon
On 6/9/05, Michael Zurke <[
Looks like prepend doesn't work, but that's ok, I can just hard code
"session_id IN" before the iterate tag. This works, if I wrap the
List in a map with "sessionIds" as the key:
SELECT
session_id as id, count(*) count
FROM
events
WHERE
session_id IN
SELECT
session_id as id, count(*) count
FROM
events
#[]#
GROUP BY
session_id
On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> That makes sense, that is probably what I want, but I am still getting
> the same exception.
>
> I am calling it this
Well...I have used it for running DDL, it seems to work ok.
Larry
On 6/9/05, Brandon Goodin <[EMAIL PROTECTED]> wrote:
> 1) iBatis does not support DDL script execution.
> 1) iBatis does not support DDL script execution.
Are there any plans to support this?
> 2)
> http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials%3F
It seems to be an overkill for such simple thing. If this is the only
way? I would rather
That makes sense, that is probably what I want, but I am still getting
the same exception.
I am calling it this way (uses SpringFramework 1.1.5 SqlMapClientDaoSupport)
public Map findCountsBySession(List sessionIds) {
return
getSqlMapClientTemplate().queryForMap("event.findCountsBySe
SELECT
session_id as id, count(*) count
FROM
events
#value[]#
GROUP BY
session_id
Brandon
On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> I am using iBatis 2.1.0.565 with JDK 1.5.0. I am trying to pass a
> List to a sqlmap and then
On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> The query I would like to end up with is:
>
> SELECT
> session_id, count(*) count
> FROM
> events
> WHERE
> session_id IN (1,2,3)
> GROUP BY
> session_id
Try this :
SELECT
session_id as id, count(*) count
FROM
events
1) iBatis does not support DDL script execution.
2)
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials%3F
Brandon
On 6/9/05, Dmitry Skavish <[EMAIL PROTECTED]> wrote:
> Hello everybody,
>
> I am pretty new to iBATIS, but already love it!
Hi Paul,
Did you try putting session_id IN #value[]# inside iterate tag?
Cheers,
Daniel Silva.
On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> I am using iBatis 2.1.0.565 with JDK 1.5.0. I am trying to pass a
> List to a sqlmap and then use it to generate a list of comma-separated
> values f
I am using iBatis 2.1.0.565 with JDK 1.5.0. I am trying to pass a
List to a sqlmap and then use it to generate a list of comma-separated
values for the IN clause of a query, like this:
SELECT
session_id as id, count(*) count
FROM
events
did you try it?
On 6/9/05, Michael Zurke <[EMAIL PROTECTED]> wrote:
> ok, but what if name is not available and othername is?
>
> Brandon Goodin wrote:
> >
> > UPDATE public.master
> > SET
> >
> >name= #name#
> >
> >
> >othername
ok, but what if name is not available and othername is?
Brandon Goodin wrote:
UPDATE public.master
SET
name= #name#
othername = #othername#
WHERE id = #id#
On 6/9/05, Michael Zurke <[EMAIL PROTECTED]> wrote:
Hello everybody,
I am pretty new to iBATIS, but already love it! I have couple of questions:
1. I am developing a client app which will be using iBatis. On the
first run I want to create tables in a db if they are not there yet.
Can I use iBatis for that? If yes how? Basically I need to send a
bu
Java with what database?
On 6/9/05, Sanjay Bordia <[EMAIL PROTECTED]> wrote:
>
> I need a solution for Java.
Is there anyone who have a working-code for insert CLOB and LONG data
type in Oracle?
-Henry
P.S.
Check the statement (update failed). - is a missleading error message from
iBatis. I did use INSERT command.
-Henry
Sven Boden wrote:
In your trace it states:
Check the statement (update fai
I have used iBATIS for a cpouple of years now, and have not once seen
this sort of performance issue.
What is the database? what is the connection pooling mechanism? What
type is th Map that is getting returned?
Give us some more context...
Larry
On 6/9/05, Bing Zou <[EMAIL PROTECTED]> wrote:
Hello everybody,
I am pretty new to iBATIS, but already love it! I have couple of questions:
1. I am developing a client app which will be using iBatis. On the
first run I want to create tables in a db if they are not there yet.
Can I use iBatis for that? If yes how? Basically I need to send a
bu
If you change BLOB to CLOB in the example, it DIDn't work!!!
-Henry
Nathan Maves wrote:
Are you sure that your drivers are the most up-to-date available?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I
+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F
Check at the bo
Has anybody else done such test? This can be an important issue.
-Original Message-
From: Dmitry Skavish [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 09, 2005 1:50 PM
To: ibatis-user-java@incubator.apache.org; Bing Zou
Subject: Re: Am I doing anything wrong? iBATIS has very poor performa
1. BLOB works at all.
2. CLOB and LONG don't work for me.
3. I am using the 10G jdbc driver.
-Henry
Nathan Maves wrote:
Are you sure that your drivers are the most up-to-date available?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I
+use+a+Custom+Type+Handler+with+a+B
Are you sure that your drivers are the most up-to-date available?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I
+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F
Check at the bottom of the page.
Nathan
On Jun 9, 2005, at 11:47 AM, Henry Lu wrote:
Could you send me a
May be you have to wrap it into transaction?
On 6/9/05, Bing Zou <[EMAIL PROTECTED]> wrote:
> Am I doing anything wrong? Why iBATIS is so slow compared to JDBC?
> Thanks.
> -
> Using iBATIS to i
Could you send me an example of TypeHandlers in java? I only find some
code in .NET.
-Henry
Brandon Goodin wrote:
I don't have any idea off the top of my head. This may be a good
opportunity for you to do it with straight JDBC to see what works and
then look at our TypeHandlers to see how the
In your trace it states:
Check the statement (update failed).
I would have to check the iBatis code what's actually happening (and
probably would need a few more pieces of information from your setup)
but LOBs/CLOBs can't be updated, only deleted/inserted.
From the Oracle documentation:
http://d
Am I doing anything wrong? Why iBATIS is so slow compared to JDBC?
Thanks.
-
Using iBATIS to insert 1000 records: (38375 ms)
sqlMap.startBatch();
Map args = CollectionUtil
Thanks for your info. I change my sql to be:
insert into x_clob
(name,c)
values
(#name:VARCHAR#,to_lob(#c:VARCHAR#))
and got the following errors:
[java] size=1819572, 1819572
[java] org.springframework.jdbc.BadSqlGrammarException: Bad SQL
grammar [(m
apped s
Hello everybody,
I am pretty new to iBATIS, but already love it! I have couple of questions:
1. I am developing a client app which will be using iBatis. On the
first run I want to create tables in a db if they are not there yet.
Can I use iBatis for that? If yes how? Basically I need to send a
bu
Item 1 is String limitation.
Item 2 I've never hit when using iBatis. I did get it however a few
times in PL-SQL... the problem was then solved by using the Oracle
function to_lob() while inserting the lob.
Regards,
Sven Boden
On Thu, 09 Jun 2005 13:05:50 -0400, you wrote:
>No, I didn't. Howev
I don't have any idea off the top of my head. This may be a good
opportunity for you to do it with straight JDBC to see what works and
then look at our TypeHandlers to see how they are translating.
Brandon
On 6/9/05, Henry Lu <[EMAIL PROTECTED]> wrote:
> No, I didn't. However, I got more details
No, I didn't. However, I got more details on the errors.
1. If I insert into CLOB or LONG as jdbc type with String in java, I got
the 32K limitation error.
[java] size=1551138, 1551138
[java] org.springframework.jdbc.UncategorizedSQLException:
(SqlMapClientTem
plate): encountered SQLE
Additionally, at least for Oracle I'm at least aware of some "issues"
with savepoints/rollbacks as described in
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:18202801725435
Regards,
Sven Boden
On Thu, 9 Jun 2005 06:20:28 -0600, you wrote:
>I put it in JIRA just the other da
I'm not aware of this limitation. We have run into similar things
before with the oracle driver. But, upgrading has always fixed it.
Have you attempted a test using straight JDBC?
Brandon
On 6/9/05, Henry Lu <[EMAIL PROTECTED]> wrote:
> I got the following errors when I insert a large text into a
UPDATE public.master
SET
name= #name#
othername = #othername#
WHERE id = #id#
On 6/9/05, Michael Zurke <[EMAIL PROTECTED]> wrote:
> hi,
>
> i got the following statement:
>
>
>UPDATE public.master
>
Please post to the lists, instead of to me directly so we can help
other people as we fix our own issues. :-)
Is this Oracle, or db2, or what?
Larry
On 6/9/05, Sanjay Bordia <[EMAIL PROTECTED]> wrote:
>
>
>
> Larry,
>
>
>
> Sorry. It's not returning resultset, it is returning refcurs
hi,
i got the following statement:
UPDATE public.master
SET
name= #name#,
othername = #othername#
WHERE id = #id#
Now is there an easy way to get rid of the comma after #name# in case
that the property "othername#
I got the following errors when I insert a large text into a CLOB in
oracle by using iBatis. How do I resulve it? I am using Oracle 10G jdbc
deiver.
org.springframework.jdbc.UncategorizedSQLException:
(SqlMapClientTemplate): encountered SQLException [
--- The error occurred in
edu/umich/med
Larry Meadors wrote:
I am not entirely sure I understand the question, but I will try to
answer it anyway. :-)
iBatis SQLMaps Developers Guide, page 28.
Namespaces help to logically organize the configuration.
For example, if you have a large application (like the one I work on)
with almo
what brandon said. but i suspect that what you're looking for is
somethign like:
where poolName.pool is the name of your pool.
On 6/9/05, Brandon Goodin <[EMAIL PROTECTED]> wrote:
> That is not an option
I put it in JIRA just the other day. :) I'll look at it this weekend.
The real thing we need to discuss is how to provide an intuitive means
for people to configure the jdbc version they are using. We want to be
able to provide clear exceptions when someone who is not using jdbc3
trys to use one of
That is not an option because that is not how JNDI works. Are you
saying that you need to pass a username/password to your datasource
for each individual user or do you simply want to configure it
dynamically for the whole application? If it is the latter then you
are trying to configure your JNDI
I am not entirely sure I understand the question, but I will try to
answer it anyway. :-)
Namespaces help to logically organize the configuration.
For example, if you have a large application (like the one I work on)
with almost 100 sql map files, finding the one that contains a mapped
statement
Hi,
I'm using iBatis sqlMap in a J2ee application to be deployed on WebSphere
AppServer 5.1.
We have to use a JNDI Datasource which needs for username and password.
How can I configure the Transaction Manager?
Is the following an option?
--
transactio
Hi,
I there any chance a solution like savepoint-support gets implemented
soon? And are savepoints not too heavy for some simple reads? From the
spec:
"The representation of a savepoint, which is a point within the current
transaction that can be referenced from the Connection.rollback method.
Wh
56 matches
Mail list logo
