Hi,
A short question. I get an Error while sending a Select statement with
multiple where conditions in iBatis. I've seen me blind on the problem so I
thought I’ll try you. So I would be pleased if you used a minute or two.
Below it’s clips form the files I use and it’s works with other
On Mon, 11 Dec 2006, Tommy Kristiansen wrote:
snip/
PinOrder pinorder = (PinOrder)
sqlMap.queryForObject(getLastPinOrder,fnr,partnerCode);
The signature for this is
queryForObject(String id,Object parameterObject, Object resultObject)
You appear to be passing 2 parameters. You
Thanks for a fast replay, but now I get this error...
2006-12-11 11:55:40,578 DEBUG
[com.commfides.servlets.RequestCertficateServlet] Cert wizard 1::: IDENTIFY
fnr=03127634725 partnerCode=1
2006-12-11 11:55:41,079 ERROR
On Mon, 11 Dec 2006, Tommy Kristiansen wrote:
Caused by: java.lang.ClassNotFoundException: Bean
You have to *create* the class Bean.
select id=getLastPinOrder resultClass=com.commfides.dao.PinOrder
parameterClass=Bean
Call it anything you like e.g. com.commfides.beans.PinOrderQueryBean
I agree with Larry. Leave ibatis out.
I have done it two ways in the past. The first is to export the table as a
csv and then use Oracle's Sqlldr to load the values into the new table.
The second is as Larry stated.
select 'insert into TableA (col1,col2,col3) values
But if you REALLY want to use iBATIS, you could use a RowHandler w/baching
(commit after every 1000 records or so).
Using this approach I was inserting the NetFlix Prize data at 15,000 records
per second from a flat file to SQL Server.
Clinton
On 12/11/06, Nathan Maves [EMAIL PROTECTED]
hi all,
In one of my xml mapping files, I need to reference a resultmap defined
in an other ibatis mapping file. can anyone comment on how to do this?
The two resultmaps have difference namespaces right now but I could make
them the same. thanks.
Stan
Hello all,
I have a question regarding the valid values for the attribute class
in the parameterMap. So far, the docs make it clear that I can use
pkg-qualified names there, but don't say much else.
If I have:
parameterMap id=orderByStatusAndType class=map
parameter
I am getting the following error whenever I try to insert a null or update a
null value in a table.
[IBM][SQLServer JDBC Driver]The specified SQL type is not supported by this
driver
The ibatis version that I am using is 2.1.7.
The database is sql server 2000
The driver is websphere embedded
Several things...
1. map is OK - it is a predefined type alias
2. java.util.HashMap is OK also
3. When using parameter maps, you must specify question marks in the SQL
instead of property names. This is likely the cause of your problem. For
this reason, I recommend that you forego the use of
You'll need to specify the JDBC type for the nullable column like this:
insert id=myInsert
insert into mytable (id, name) values (#id#, #name:VARCHAR#)
/insert
Jeff Butler
On 12/11/06, Niharika Mateti [EMAIL PROTECTED] wrote:
I am getting the following error whenever I try to insert a null
you would need to make sure the resultmap containing the resultmap being
referenced is loaded prior to being referenced. Then you would simply use a
namespace.resultMapId notation in the resultMap attribute of your mapped
statement.
Brandon
On 12/11/06, Ou, Stan (Mission Systems) [EMAIL
12 matches
Mail list logo