Brandon Goodin wrote:
"com.mafoi.bats.Image" is not a javaType.
Yes, but I got that idea from declaration from the wiki in
"how to write custom handlers" section.
Please read the developers guide. You may consider using a
CustomTypeHandler for what you are trying to do.
Actually, I was att
Well, iBATIS will support it if the driver does...
However, I would recommend not mapping such a thing to an object
anyway...it's kind of silly no?
Data that large should be directly streamed to the client, or to disk.
It shouldn't be left resident in memory.
Cheers,
Clinton
On Thu, 17 Feb 2
Use ibatis's typeHandler.
On Wed, 16 Feb 2005 16:56:59 +0100, BOUSSEBHA Djamel
<[EMAIL PROTECTED]> wrote:
> Hi;
>
> I use into my j2ee application, the Ibatis tool for database access. Another
> external application stores into this database of the documents (pdf) in
> using of the fields BLOB
Version 2.0.9 of iBATIS supports BLOB field to byte[], as long as the
JDBC driver you're using "does the right thing".
So, just define a byte[] field in your javabean and have a go, post
back if it doesn't work!
On Wed, 16 Feb 2005 16:56:59 +0100, BOUSSEBHA Djamel
<[EMAIL PROTECTED]> wrote:
>
My understanding is that streaming data to a BLOB-type field (which
you would likely need to do with a 20MB+ dataset, is still a "coming
soon" feature - and I believe it requires the latest version of JDBC
(3.0), which may or may not be supported by the SQL Server driver
you're using (are you using
It doesn't appear you are using a CustomTypeHandler ... this is
necessary as iBATIS does not support Postgres' ARRAY type.
On Mon, 14 Feb 2005 06:52:17 -0500, William Harding
<[EMAIL PROTECTED]> wrote:
> Greetings all,
>
> I have spent the last 2 days researching how to handle the Postgres data
A RowHandler is the best way to process a large data set one record at
a time. But if you actually want to limit the number of rows, you can
use a paginated list, or queryForList with an offset and max rows.
Also consider the following attributes for optimization, althought
their depdendent on yo
>> 1) How the implementation of PaginatedList handles large result sets?
>> Does it use cursors?
Depends on your database, your driver, your configuration and
attributes such as
>> 2) Why the unusual use of the ThreadLocal class in SqlMapClientImpl?
>> Why localSqlMapSession isn't declared as s
What db ending?
I use limit/ofset in the select to process.
.V
Carl Brodeur wrote:
Hi:
Is there a way to limit the size of the List returned by a find query
in IBatis ?
We have a query returning 3000 rows. iBatis creates an instance of the
object corresponding object for each row returned. Cac
Using a RowHandler would work best. You would have to implement the
resulset size. But, it will give you the control you want regarding
row by row processing.
Brandon
On Wed, 16 Feb 2005 11:56:06 -0500, Carl Brodeur
<[EMAIL PROTECTED]> wrote:
>
> Hi:
>
> Is there a way to limit the size of the
I think our mailing list is a bit friedwhat's the deal with the reposts?
(I'm pretty sure it's not the users)
Clinton
On Thu, 17 Feb 2005 10:06:32 -0700, Baker, Russ <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am having issues with creating a sql map. I have set up the application
> accord
[EMAIL PROTECTED]
you can load your sqlmapconfig.xml as from the classpath or from the
file system. Take a closer look at the
com.ibatis.common.resources.Resources class. I think
getUrlAsReader(String urlString) and getUrlAsReader(String urlString)
may meet your needs.
Brandon
On Wed, 16 Feb 2005 14:36:54 +0200,
Also be sure to set remapResults="true" in your select element.
On Thu, 17 Feb 2005 20:30:14 -0700, Brandon Goodin
<[EMAIL PROTECTED]> wrote:
> you would want to use the literal $tabPrefix$ notation.
>
> Brandon
>
> On Tue, 15 Feb 2005 17:06:53 +0100, Vincenzo Graziadei
> <[EMAIL PROTECTED]> wr
you would want to use the literal $tabPrefix$ notation.
Brandon
On Tue, 15 Feb 2005 17:06:53 +0100, Vincenzo Graziadei
<[EMAIL PROTECTED]> wrote:
> > It's possible , with iBatis for Java, to have a dynamic table name, like
> > this :
> >
> >> resultMap="resultRighe"
It would be a good idea to be more specific. Many others have been
able to develop stored procedure usage with ibatis just fine with the
existing examples. We'd be happy to help you. But, you have to give us
an idea as to what is not being adressed in what you have read.
Brandon
On Tue, 15 Feb 2
http://wiki.apache.org/ibatis/How_20do_20I_20get_20SqlMapClient_20to_20log_20SQL_20statements_3f
On Mon, 14 Feb 2005 11:19:51 -0500, Matt Givney <[EMAIL PROTECTED]> wrote:
> Hi folks,
>
> Great product, thanks for all your hard work!
>
> Question about logging what the framework is doing when r
Hello,
I am having issues with creating a sql map. I have set up the application
according to the developer's guide, and for some reason, it isn't loading the
sql maps. I have enclosed the configuration files and the Java file that gets
the sqlMap. I have isolated the handing out of the SqlMap
Hi:
Is there a way to limit the size of the List returned by a find query
in IBatis ?
We have a query returning 3000 rows. iBatis creates an instance of the
object corresponding object for each row returned. Caching is not
possible in that particular case.
Hi;
I use into
my j2ee application, the
Ibatis tool for database
access. Another external
application stores into this database of the documents (pdf) in using
of the fields BLOB. My web application must load and get these documents to
publish them on line.
questions :
- How get
Hi all,
I'm thinking of using iBatis in my application and I've two questions
about iBatis:
1) How the implementation of PaginatedList handles large result sets?
Does it use cursors?
2) Why the unusual use of the ThreadLocal class in SqlMapClientImpl? Why
localSqlMapSession isn't declared as sta
Title: SOAP attachement (pdf) stored into a db field
I have a SOAP service that I would like to receive and store both XML based messages and their corresponding MIME attachments, in particular large, 20+ MB file sizes directly into a database "image" type field in MS-SQL. I can easily direc
Hi;
I know that this maybe a simple newbie question, but I never really
needed this, and now I face a problem with it.
Simply, I have a executable Jar file with my code in it, currently I
pack the sqlMapConfig.xml inside the jar with the code, this way my
code works fine, but I want the sqlMapCon
> It's possible , with iBatis for Java, to have a dynamic table name, like
> this :
>
> resultMap="resultRighe"
> parameterClass="java.util.Map">
>
>
> Thank You
>
> Vincenzo Graziadei
>
>
<>
Hi,
I'm currently looking for a way to implement stored
procedures/functions (from Oracle DB) via Ibatis. Unfortunately, the
simple example given in User Guide is insufficient, so are sources on
the Internet. Could someone please provide me with a full example of an
xml SQL map amd its associa
Hi folks,
Great product, thanks for all your hard work!
Question about logging what the framework is doing when running an app on
WebSphere. I have written and tested code using a simple datasource and
running from my main method and I get the War & Peace style logging (love
it!)
Though when I
Greetings all,
I have spent the last 2 days researching how to handle the Postgres data
type: VARCHAR[] and how to map it to a String[] with little to no luck.
I am fairly new to iBATIS and I could have easily missed something very
simple.
Here is what I have.
My Current mapping is as follows:
Yes, Strings are immutable, but Map entries are not. Remember, it's
the parameter class that matters. If you passed a String as the
parameter class, it wouldn't be able to receive an output value.
Cheers,
Clinton
On Thu, 17 Feb 2005 23:28:26 -, Yee, Richard K, CTR,, DMDCWEST
<[EMAIL PROTEC
I'm a little confused about INOUT parameters for stored procedures. The
iBATIS-SqlMaps.pdf documentation says the following:
Stored Procedures
Stored procedures are supported via the statement element. The
following example shows
how a stored procedure would be used with output parameters.
{
It's not possible to perform a queryForMap from the complex property.
Also, do you realize that the complex property query will not reduce
the number of hits on your database. So, I would suggest that you
query your accounts first and then iterate through the list using the
queryForMap. It's a lit
yep this worked.
thx.
-Original Message-
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 1:17 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Getting error with Bean Object property not writtable at
sqlmap config initial load
Yep, there is still
How to queryForMap using the resultMap complex properties functionality.
I need to know how do I use queryForMap using resultMap complex properties
functionality but for this map, I should be able to define which column to use
as key and which to use as value.
Amad
Brandon Goodin wrote:
I am not
That is a private member of your class. Ibatis is looking for a public setter
method setNetPrefixID2.
--- Jason Hall <[EMAIL PROTECTED]> wrote:
> This is what i have defined in my bean
>
> private int netPrefixID2;
>
> How is this not the property of the bean?
>
>
>
> -Original Message--
Ah yes, getting the latest version helped immensely! Thanks for your help!
-Russ
-Original Message-
From: Clinton Begin [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 11:01 AM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Cannot get sqlMaq
Yeah, the XML files are q
You need to read the "One Page JavaBeans Course" in the SQL Maps
developer guide
http://www.ibatis.com/common/download.html
Page 47.
Cheers,
clinton
On Thu, 17 Feb 2005 13:21:02 -0500, Jason Hall <[EMAIL PROTECTED]> wrote:
> This is what i have defined in my bean
>
> private int netPrefix
This is what i have defined in my bean
private int netPrefixID2;
How is this not the property of the bean?
-Original Message-
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 1:17 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Getting error wit
Yep, there is still no netPrefixID2 property in the bean:
Larry
On Thu, 17 Feb 2005 13:08:27 -0500, Jason Hall <[EMAIL PROTECTED]> wrote:
> Sorry here is the correct to xml file. The original xml file had the wrong
> database field of "O1" it should have been NetPrefixID.
>
> Now.
iBATIS 2.0 is backward compatible with 1.0 -- but 2.0 is highly
recommended. You had a spelling error when you requested your
statement, for which it did complain loudly with "There is no
statement named..."
Cheers,
Clinton
On Thu, 17 Feb 2005 11:09:03 -0700, Baker, Russ <[EMAIL PROTECTED]> wro
Thanks Clinton,
This kinda raises an interesting issue though. I had no problem parsing the
sql-map-config.xml file, and when I buggered that up, the app complained.
However, if the sql map xml files are buggered up, then it doesn't complain but
just says it cannot find the statement. So if it
Sorry here is the correct to xml file. The original xml file had the wrong
database field of "O1" it should have been NetPrefixID.
Now. With the correct xml file netPrefixID2 is the property of Network.java and
NetPrefixID is the column of the database.
Here is the correct xml file. Still gett
setNetPrefixID == netPrefixID, not netPrefixID2
On Thu, 17 Feb 2005 12:59:14 -0500, Jason Hall <[EMAIL PROTECTED]> wrote:
>
>
>
> I'm get this error below. What's the problem.
>
> Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE
> property named 'netPrefixID2' in class
Yeah, the XML files are quite messed up. You're using a combination
of 1.0 and 2.0 perhaps the problem you're having all around.
I'd suggest you re-download everything all over again. Start over
with the 2.0 tutorial and JPetStore 4 as an example.
Also check out the articles posted on the h
Title: Getting error with Bean Object property not writtable at sqlmap config initial load
I'm get this error below. What's the problem.
Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE property named 'netPrefixID2' in class 'Network'
Network.java:
import java.io.
Kris,
Thanks for the info. I looked at the "statement" spelling and corrected that.
What exactly do you mean by v2, the xml version?
Thanks,
Russ
-Original Message-
From: Kris Jenkins [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 10:46 AM
To: ibatis-user-java@incubator.ap
In addition, it looks like you're using v1. I'd strongly advise you to
upgrade to v2 if you're just getting started.
Kris
roberto wrote:
is misspelled in EnergencyContact.xml.
Roberto
-Original Message-
From: Baker, Russ [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 12:
"com.mafoi.bats.Image" is not a javaType.
Please read the developers guide. You may consider using a
CustomTypeHandler for what you are trying to do.
Brandon
On Thu, 17 Feb 2005 21:14:31 +0530, Vamsee Kanakala <[EMAIL PROTECTED]> wrote:
> Hello,
>
>I'm encountering a persistent error.
is misspelled in EnergencyContact.xml.
Roberto
> -Original Message-
> From: Baker, Russ [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 17, 2005 12:28 PM
> To: ibatis-user-java@incubator.apache.org
> Subject: Cannot get sqlMaq
>
> Hello,
>
> I am having issues with creating a sq
Hello,
I am having issues with creating a sql map. I have set up the application
according to the developer's guide, and for some reason, it isn't loading the
sql maps. I have enclosed the configuration files and the Java file that gets
the sqlMap. I have isolated the handing out of the SqlMap
Roger,
You'll need to dig a little harder to find the root cause of the exception.
Unless I see a com.ibatis.* exception, I can't help you.
Cheers,
Clinton
On Thu, 17 Feb 2005 08:14:40 -0800 (PST), Roger Baeza
<[EMAIL PROTECTED]> wrote:
> java.lang.ExceptionInInitializerError
>
> sep.fmat.s
java.lang.ExceptionInInitializerError
sep.fmat.sipre.service.PreinscripcionService.(PreinscripcionService.java:53)
sep.fmat.sipre.service.PreinscripcionService.(PreinscripcionService.java:37)
sep.fmat.sipre.action.BusqAlumnoAction.execute(BusqAlumnoAction.java:66)
is raised when, i get instance f
My problem is when daoManager load configuration...not
sql executing else...
--- Fabrizio Gianneschi
<[EMAIL PROTECTED]> wrote:
> The limit is imposed by the database or the JDBC
> driver, on the length of
> the entire query string.
>
> I remember an old query on SQLServer that didn't
> work d
The limit is imposed by the database or the JDBC driver, on the length of
the entire query string.
I remember an old query on SQLServer that didn't work due a big dynamic SQL
IN clause.
F
-Messaggio originale-
Da: Larry Meadors [mailto:[EMAIL PROTECTED]
Inviato: giovedi 17 febbraio 2005 1
my xml have this specification
Select (max(Id_direccion) + 1) as direccionId
from direcciones
Insert Into Direcciones
(id_direccion, calle, entrecalle, ycalle,
nombrecol, num_int,
num_ext, codpost, cve_mpio)
values
(#direccionId#, #calle#, #cal
Hello,
I'm encountering a persistent error. I'm trying to use a
parameter map inside my application. Here goes:
insert into students (id, name, dob, doe, stream_id, batch_id,
photo)
values (#id#, #name#, to_d
I have used iBATIS to insert dozens of fields. AFAIK, there is no limit.
Larry
> On Thu, 17 Feb 2005 05:04:17 -0800 (PST), Roger Baeza
> <[EMAIL PROTECTED]> wrote:
> > Hello all
> >
> > Any one can help me...
> >
> > I'm usign sqlMap, when I put more than 9 field to
> > insert statement like this
what is the specific exception it is giving you?
Brandon
On Thu, 17 Feb 2005 05:04:17 -0800 (PST), Roger Baeza
<[EMAIL PROTECTED]> wrote:
> Hello all
>
> Any one can help me...
>
> I'm usign sqlMap, when I put more than 9 field to
> insert statement like this
>
> 9 exactly
> Insert Into spIng
I am not sure which issue your asking for help on...
How to reduce the number of queries.
-- or --
How to queryForMap using the resultMap complex properties functionality.
Could you please clarify what you are asking.
Brandon
On Thu, 17 Feb 2005 03:05:56 -0800, Anad Fida <[EMAIL PROTECTED]> w
Here is a gratuitous ego booster for Clinton, but I must say that I love the
extra struts package in in the JPetStore that allows mapping to bean
methods. The use of thread local context is so nice not having to pass the
servlet objects around.
I read about a lot of people complaining about strut
Hello all
Any one can help me...
I'm usign sqlMap, when I put more than 9 field to
insert statement like this
9 exactly
Insert Into spIngresoSecundaria
(IdPreinscripcion, IdAlumno, IdPrimaria,
IdSecundaria, TieneHermanos,
PrimariaInf, EsMenorA12, FechaPreIns, FechaIns)
values
(0,
I have a Domain Object as following,
public class Account {
private long accountKey;
private String accountName;
private String userName;
private Date lastUpdateDate;
// Holds account attribute name - values
private Map accountAttributes;
// Setters/Getters
}
I have accounts, att
I have a Domain Object as following,
public class Account {
private long accountKey;
private String accountName;
private String userName;
private Date lastUpdateDate;
// Holds account attribute name - values
private Map accountAttributes;
// Setters/Getters
}
I have a
test successfull &.*
On Thu, 17 Feb 2005 03:01:15 + (UTC), NetSQL <[EMAIL PROTECTED]> wrote:
> testing (please ignore)
>
--
äåå
[EMAIL PROTECTED]
[EMAIL PROTECTED]
62 matches
Mail list logo
