You should really take a look at the docs,
it’s all there…
Niels
From: Zsolt
[mailto:[EMAIL PROTECTED]
Sent: donderdag 30 maart 2006 8:14
To: user-java@ibatis.apache.org
Subject: RE: How to convert
BLOB/CLOB to String.
I don’t want to
convert all BLOBs to String only
I don’t want to
convert all BLOBs to String only for one table.
Zsolt
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006
5:51 AM
To: user-java@ibatis.apache.org;
Balaji
Subject: Re: How to convert
BLOB/CLOB to String.
iBATIS comes with a B
iBATIS comes with a BLOB and CLOB type handlerit has for some time now.ClintonOn 3/27/06, Balaji <
[EMAIL PROTECTED]> wrote:Does anyone have a custom type handler for Clob - String written that you
can share.Thanks,Balaji- Original Message -From: "Nathan Maves" <[EMAIL PROTECTED]>To: <
Hmm...unfortunately at this time your two choices are to extend it or duplicate it. As you've discovered, the resultMap attribute of the result element is strictly for collections only. Cheers,Clinton
On 3/27/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
I can't seem to find any documentation
Nope. And I suggest not using the XML output anyway. Instead, consider mapping it to a real domain model, then use something like XStream to serialize it to XML.Cheers,Clinton
On 3/26/06, sadasiva lingala <[EMAIL PROTECTED]> wrote:
Hi Is there a way to customize xml output by extending the i
Greetings, I am trying to deploy an iBATIS app on JBoss 4.0.2 which has been running fine on Tomcat 4.1, but am getting this error: org.jboss.deployment.DeploymentException: Error during deploy; - nested throwable: (javax.naming.NamingException: resource-ref: jdbc/testapp1 has no valid JNDI
Tony,
Try aliasing the duplicate columns. For example:
Select a.column1 as a_column1, b.column1 as b_column1 from table1 a, table2 b
where b.some_id = a.idOn 3/29/06, Tony Qian <[EMAIL PROTECTED]> wrote:
All,
Got two questions on iBATIS DAO.
1) I have two tables. Those two tables happ
All,
Got two questions on iBATIS DAO.
1) I have two tables. Those two tables happen to have a column with
same name. I try to join those two table first and then use groupBy to
construct two lists, one for each table. The problem is that I cannot
use table qualifier to specify the data from
Short answer - no.
Only the column name is returned in the result set. This is JDBC, not just iBATIS. Run the query in something like the Squirrel SQL client to verify.
A better solution would be to use a real domain object instead of a map, and use iBATIS' group by and descriminator support.
I want to perform a query like:
Select * FROM data AS `root:data` JOIN other AS `root:other` JOIN
something as `root:other:something` WHERE $where$
The tables "data", "other", and "something" may or may not have
similarly named columns. The aliases correspond to bean's in a map.
---CODE---
Map
This is probably a syntax error in your sql. That error message from
oracle often indicates a comma in the wrong place or parenthesis that is
unmatched. I would use your logs to see exactly what sql you're sending
to your database. Or else run your statements using sqlplus to see a
nice cara
Not, it isn'tThe name is VIEW_JOB ( but the table name is FUTURE_JOB and works fine )2006/3/29, Larry Meadors <[EMAIL PROTECTED]
>:Does the view name have a # or $ character in it?LarryOn 3/29/06, Chema <
[EMAIL PROTECTED]> wrote:> Hello:>> I've got this query in sqlmap config file>> > parameterC
Does the view name have a # or $ character in it?
Larry
On 3/29/06, Chema <[EMAIL PROTECTED]> wrote:
> Hello:
>
> I've got this query in sqlmap config file
>
> parameterClass="QueryClass">
> SELECT $c$
> FROM $table$
> WHERE $where$
>
>
>
>
> If $table$ is the n
A clever use of and where the is in the ${dialect} file will
give some pretty reasonable flexability without the need to exploit any
bugs. I have recently posted a JIRA feature request precisely to help
address key generation aspect of the cross-DB compatability issue more
easily using propertie
Hello:I've got this query in sqlmap config file SELECT $c$
FROM $table$ WHERE $where$ If $table$ is the name of a view , this error happens:ORA-00921: unexpected end of SQL command If
$table$ is the name of a table, all works fine why ?Thanks in advanceBest regards
You don't want to know"Lingala, Sadasiva" <[EMAIL PROTECTED]> wrote: Thanks Larry.1. I still think there is a benefit using ibatis (if I can) in this caseas I can use all the parameter mapping and externalizing the SQL etc..2. Solution for not just accessing DAOs but also for developers writingDAO
16 matches
Mail list logo
