Hi
Is there any place where it has updated information about calling stored
procedure from ibatis 3.0, i checked google and could not find any,
I was reading user guide and it says parameterMap is not used,
I tried the code below and seems it is working, but i would like to do this
using some meth
What database are you using?
>
>
> On Fri, Jul 24, 2009 at 12:22 PM, Ashish Kulkarni <
> ashish.kulkarn...@gmail.com> wrote:
>
>> HiHas anyone noticed issue with inserting japanese characters in database
>> using ibatis, i am having some issues here, i have debugged
HiHas anyone noticed issue with inserting japanese characters in database
using ibatis, i am having some issues here, i have debugged my program and
found that the class which is passed to ibatis as input parameter has
correct japanese characters, but in database they are not,
Is there any special
HiI have to write a query like below
Select col1, col2 from table1 where col3='ABC' or col3='XYZ'
so i wrote a query like below, will this work, *what do i have to specify
for property, *i have specified it as list, will this work, any suggestions
SELECT col1, col2 FROM table1
col3=*#list[]
Hi Any ideas on this mail, how to test if Pool.PingQuery is working as
expected
On Mon, May 4, 2009 at 10:03 AM, Ashish Kulkarni <
ashish.kulkarn...@gmail.com> wrote:
> HiI have configured my data Source as below
>
>
> />
> value="jdbc:as400:MYAS400/MYDB;namin
HiI have configured my data Source as below
In my Log4j.xml i have following lines to debug all queries, but i do not
see any PingQuery log in my log files, what am i missing, what is the way to
make sure that Pool.PingQuery is working as expected, i am going to
change Pool.PingConnect
are reminded that these connections are active and shouldn't be closed.
>
>
> On Mon, Apr 27, 2009 at 2:39 PM, Ashish Kulkarni <
> ashish.kulkarn...@gmail.com> wrote:
>
>> HiHow does the performance get affected if i add a ping query, or what is
>> the best way to do it
HiHow does the performance get affected if i add a ping query, or what is
the best way to do it
On Fri, Apr 24, 2009 at 1:10 PM, Chema wrote:
> Logs show that he's using a SimpleDataSource , so I guess, the
> connection pool is implemented by iBatis
>
> I bet for a "firewall issue". Some is rese
configure. It would do something like select the current system
> time or something. This would just let the database know not to kill the
> connection in the first place.
>
> Good luck.
>
>
> On Fri, Apr 24, 2009 at 10:41 AM, Ashish Kulkarni <
> ashish.kulkarn...@gmail.
wrote:
> What's SQL ERROR CODE in the exception. You want to look it up the DB2 on
> AS400 docs
>
>
>
>
> Ashish Kulkarni
> 3...@gmail.com> To
>
HiI am having some issue with connection dropping, i am using
ibatis ibatis-2.3.4.726.jar and creating connection to AS400 using JDBC,
but i am seeing these errors in log file, for some reason connection is
getting dropped, what may be the reason, the issue is this a high
availability system and we
HiI am having issue with ibatis, the error i am getting is
Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error
parsing XML. Cause: java.net.ProtocolException: Server redirected too many
times (20)
java.net.ProtocolException: Server redirected too many times (20)
How can i reso
Hican you please explain what do you there are no parameter markers
SELECT TYPE, AS400NAME, ENVNAME, ENVDESC, DISABLED, INIPROG,
INIPGMLIB, USERID, PASS_WRD, MAPSLOGINR FROM EnvNames WHERE TYPE =tYPE and
AS400NAME =aS400Name and ENVNAME=eNVNAME
i have TYPE=tYPE, which i expect to work as marker
HiI have a query as below where resultClass is same as parameterClass, for
some reason the response i get when i run this query is parameterClass, for
example if i input as
EnvNames envNames = new EnvNames();
envNames.setTYPE("APPROVALS");
envNames.setAS400NAME("PGMAPSD1");
envNames.setENVNAME("MA
HiAny ideas on the mail below
On Fri, Nov 7, 2008 at 10:17 AM, Ashish Kulkarni <
[EMAIL PROTECTED]> wrote:
> HiIs there any standard way or best practice for of using Ibatis in web
> application,
> This is how i use it
> In my InitServlet which is loaded when the applicatio
HiIs there any standard way or best practice for of using Ibatis in web
application,
This is how i use it
In my InitServlet which is loaded when the application starts, i create
instance SqlMapClient and save it in ServletContext.
And in other servlets where i need to get data from database, i get
HiI am trying to create SqlMapClient using Properties object
I am getting following error, please see my code below
Exception in thread "main" java.lang.NullPointerException
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:782)
at
com.ibatis.sqlmap
Hi
This is my code
// Create SQlMapClient
Properties prop = new Properties();
prop.setProperty("url", url.trim());
prop.setProperty("driver", driver);
prop.setProperty("username", userid);
prop.setProperty("password", password);
String resource = "SQLMapConfigWeb.xml";
Reader reader = R
Hi
I am gettig following error when trying to sqlSession.queryForList()
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:776)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:141)
at
com.ibatis.sqlmap.engin
Hi
I changed Hashtable to HashMap and now it works,
On 5/19/08, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
>
> Hi
> I am running following query
> parameterClass="java.lang.String">
> Select * from Document_Version where UIC_Identity =#value# and PD
Hi
I am running following query
Select * from Document_Version where UIC_Identity =#value# and PDF_Current =
1
order by Version, Minor_Version
There is column in this database
called Reprocessing_Scan_Date_Time, which has null values,
when i do
sqlMapClient.queryForList("getPDFInfo","item");
I g
Hi
I have a class like below with get and set method
public ColorClass
{
private String name, desc;
public void setName(String _name)
{
this.name = _name;
}
public String getName()
{
return name;
}
}
How can i define this ColorClass in parameterMap and use it in SQL statement
for varaible substi
Hi
How can i use java logging API to control logging of ibatis, for example if
i have log4j, i put all the logging information in log4j.xml and from there
i can control what logs i want from ibatis, for example i have added
following lines in log4j.xml
So waht would i do if i am using java.
t, setting the name/value pairs on that,
> and
> passing that into:
>
> public static SqlMapClient buildSqlMapClient(java.io.Reader reader,
> java.util.Properties props)
>
> Cheers,
> Chris
>
> On 11/21/07 2:15 PM, "Ashish Kulkarni" <[EMAIL PROTECTED]>
> wrot
Hi
I am working on a swing application where the user enters his user id and
password, then this user id and password is required to create SqlMapClient,
this is what i am tried but did not work
in my sqlconfig.xml file i have
And in my java program
I do
System.setProperty("driver", JDBCdriv
Hi
Sorry i send it to wrong forum, send the question to log4j forum
Ashish
On 10/4/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
>
> Hi
> Can you please let me know where do i look into for this information, any
> hints please
>
> Ashish
>
> On 10/4/07, Larry Mead
Hi
Can you please let me know where do i look into for this information, any
hints please
Ashish
On 10/4/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
>
> http://logging.apache.org/
>
> Larry
>
>
> On 10/4/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
>
Hi
How do we set the log file location dyanamically in web application,
Currently i am using log4j.xml file with following definiation, this file is
under WEB-INF file
...
and in load the this xml file in Servlet using
String fileName = config.getInitParameter(log4j.xml);
ServletContext oCtx = c
ds the
> "java:/comp/env/"
> bit to declared JNDI resources.
>
> Cheers,
> Chris
>
> On 9/27/07 9:32 AM, "Ashish Kulkarni" <[EMAIL PROTECTED]> wrote:
>
> > Hi
> > This is what i have done,
> > in my server.xml file i have ad
owto.html
>
> PS: I think you can add a resource-env-ref to your webapp's web.xml to
> link
> to the global JNDI resource too, but I usually go with the ResourceLink in
> the context files to avoid mucking with web.xml.
>
> Cheers,
> Chris
>
> On 9/27/07 7:58 AM,
ation server
> configuration. What AppServer are you using?
>
> -Richard
>
> Ashish Kulkarni wrote:
> > Hi
> > I did modify this to look like below
> >
> >
> >
> >
> >
> >
> > But i get following err
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java
:1105)
On 9/26/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
>
> Hi
> Is there any example of setting up ibatis to use JNDI as data source,
> I have the following, how do i cha
Hi
Is there any example of setting up ibatis to use JNDI as data source,
I have the following, how do i change it to use JNDI
And i have SqlMapConfigAS400.properties where i have
driver=com.ibm.as400.access.AS400JDBCDriver
url=jdbc:as400:AS400B/RPTSTEXTDB;naming=system;date format=is
ation,
Ashish
On 9/26/07, Kenny Pearce < [EMAIL PROTECTED]> wrote:
>
> What you are doing should work fine. However, depending on where you
> initialize your ibatis client in your servlet code, you may have to
> restart your web application after modifying the file.
>
> Ashish
a
> DataSource in JNDI. Then your webapp just references the JNDI name
> (something like java:/comp/env/jdbc/OrderDS) and you can change it as you
> like outside the webapp.
>
> Lookup JNDI DataSource in your weblogic docs to see more.
>
> Cheers,
> Chris
>
> On 9/26/
Hi
I need some information about using ibatis in web application, i am using
sql maps for java. i have SqlMapConfig.xml and SqlMapConfig.properties file
under src folder,
SqlMapConfig.properties has database connection information,
Now the question is when i create the war file, i do not know what
Hi
I got it working
this is how i defined
select * from table
code=#notes[]#
and view =#view#
On 9/16/07, Richard Yee <[EMAIL PROTECTED]> wrote:
>
> Ashish,
> Did you read the documentation? What have you tried so far?
>
>
Hi
I have a question about using Dynamic Mapped Statements and Iterate tag
I have a table with columns,
view
code
color
I have an sql statement like below which i have to convert to dynamic mapped
statement
select color from table where view=? and code in (?,?,?)
But the code in must be dynamic
Hi
I have a sql statment like
select * from mytable where line in ('ABC', 'XYZ')
where this SQL
statement is going to extact all rows where line is ABC and XYZ,
but now the problem is i do not know if there are going to be only one line
or 2 or 10, so i thought i would define the sql as
select
depending on your operating environment, you may need to do some other
> work. For example, WebSphere supplies it's own implementation of JCL that
> must be configured from the administrative console.
>
> Jeff Butler
>
>
> On 8/24/07, Ashish Kulkarni <[EMAIL PROTECTED]>
on page 62 of the developer's guide.
>
> Jeff Butler
>
>
> On 8/23/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> >
> > Hi
> > I am using log4j for logging and added the following XML elements in my
> > configuration file, but i still get the log file
Hi
I am using log4j for logging and added the following XML elements in my
configuration file, but i still get the log file as below, how do i supress
these logs from coming in stdout file
2007-08-23 16:50:12,935 DEBUG [http-4080-Processor25]
jakarta.JakartaCommonsLoggingImpl (JakartaCommonsLoggin
, Larry Meadors <[EMAIL PROTECTED]> wrote:
I'd look for a way to make the database do this - any solution on the
Java side will be inherently out-of-date.
Can you do this in a stored procedure?
Larry
On 6/10/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> Hi
> I have a s
Hi
I have a situation where i have a table of about 16,000. rows, which i need
to use for mathematical calculation.
i want to cache the data and this data should update as soon as the database
is updated.
Database is updated by external process, so Java program does not know if
there is update
e more background on the problem
statement I am not sure how much help we can give.
Nathan
On 6/1/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
>
> Hi
> I have a requirement where i have to constantly monitor a database for
> changes, for example if thers is an row added, or row ch
Hi
I have a requirement where i have to constantly monitor a database for
changes, for example if thers is an row added, or row changed the java
program will process those records.
is there any good way of doing it, currently i am thinking of writing a
TimerTask which will sleep for 5-10 seconds t
Hi
I have following definition in my sql-map file
SELECT M009D as INCOTERMDESCGR FROM pu1012 , cf1009 WHERE PCPORD =
#value# and M009KY = '3T1'concat PCINCO
I run the query as below
List list = sqlMapClient.queryForList("getINCOTERMSGR", new
BigDecimal("20"));
I was expecting that list wi
Hi
I would be interested in the solution you provided where i can create XML
file from HashMap.
I was using ibtaits and type=XML , but hit an issue when there are some
German characters like umlaut in the database,
here is a email i had send, but did not got any reply for it
http://www.nabble.com/
On 3/19/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
>
> Hi
> I have posted another thread with detail explaination
> this is the thread
> http://www.nabble.com/forum/ViewPost.jtp?post=9499524&framed=y
>
> if you can take a look and tell me if you have any so
. Bulk loaders can fill varchars with
badly encoded text that give trouble.
Just a theory.
-J
On 3/12/07, Yuvraj Shinde <[EMAIL PROTECTED]> wrote:
>
>
>
>
> You can use CDATA tag.
>
>
>
>
>
>
> From: Ashish Kulkarni [mailt
Hi
I am using ibatis to create XML file from database, i have the following
sqlMap
SELECT P704SPEC, P704LINE, P704DETL, P704USER, P704DATE, P704TIME
FROM PU27041 WHERE P704SPEC = #value#
This works fine, but some times P704DETL has german characters like Ö
(umlout) in this case
ection, or < > etc...
It's just XML. ;-)
On 3/11/07, Ashish Kulkarni < [EMAIL PROTECTED]> wrote:
>
> Hi
> I am using ibatis to run a SQL statement which returns a XML as output
> as shown below,
>
>
> SELECT P706DETL as SPECIALNOTE , PDLINE as PDL
Hi
I am using ibatis to run a SQL statement which returns a XML as output as
shown below,
SELECT P706DETL as SPECIALNOTE , PDLINE as PDLINENOTES FROM PU1706,
PU1013 WHERE P706ORD = PDPORD and PDSPEC = P706SPEC and PDPORD = #value#
order by P706LINE
I am having issues when the data r
Hi
I have a application running on AS400 using ibatis, i am using Log4J for
logging, i am getting a lot of log in my spool file.
for preparedStatement created, resultset etc,
How do i suppress these logs from my Log4j.properties file which i use to
set logging in my application.
Ashish
Hi
Is there any source code for using properties when creating sql map client
Ashish
On 2/13/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
Use a properties object when you create the sql map client.
Larry
On 2/13/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> Hi
> I have
Hi
I have a web application where i am using ibatis, i have a situation where i
want to select the database from where i want to get data.
In this application user will login and select he wants to use development
1, or development 2 or test 1 from a drop down
So if the user selects development1
ile
> > Try this one.
> > **
> > * >
> > PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
> >
> > "http://ibatis.apache.org/dtd/sql-map-2.dtd";>
> >
> > Which version of iBATIS are you using. This DOCTYPE is for versions
> &
.1
-Richard
-Original Message-
*From:* Ashish Kulkarni [mailto:[EMAIL PROTECTED]
*Sent:* Tuesday, February 06, 2007 9:25 AM
*To:* user-java@ibatis.apache.org; [EMAIL PROTECTED]
*Subject:* Re: issue with unknown host exception
Hi
I tried changing it to
http://ibatis.apache.org/dtd/sql-map
der
version of iBATIS, or the current release?
Also, it could be the XML parser on the 400..if that is the case, you
could use a system DTD instead of the default.
Larry
On 2/6/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> Hi
> I have a java program which uses ibatis to run SQL qu
Hi
I have a java program which uses ibatis to run SQL queries, this program
runs on AS400, and on of the AS400 boxes i am getting following error
Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error
parsing XML.
Caused by: java.net.UnknownHostException: ibatis.apache.org
The he
ItemFormat","myname");
> } finally {
> session.close ();
> }
>
> Jeff Butler
>
>
>
> On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED] > wrote:
> >
> > Hi
> >
> > How do i replace my existing code with
> > sqlMapClient.
gt; This is very similar to this issue:
>
> http://issues.apache.org/jira/browse/IBATIS-66
>
> Make sure you're calling client.setUserConnection(null) after processing
> each query.
>
> Jeff Butler
>
>
>
> On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED] &
Hi
I have attached the sqlmap and xml file with all the sql statements along
this mail.
On 12/18/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
Can you post your configuration (database and sqlmap)?
Larry
On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> Hi
&
Hi
We have a web application running in websphere, and for a while we are
seeing some hung threads in websphere,
do we did some java dump as insturcted by IBM and we are seeing some of the
following messages in the dump.
In our java program before calling SQL statemenet we do the following
SqlMap
Hi
This is what i am doing in my code and want to confirm that it is the right way to use commitment control
// start commitment control
sqlMapClient.startTransaction();
sqlMapClient.insert("insertCOHeader", coDataBean);
sqlMapClient.insert("insertCOCOmment", coComment);
sqlMapClient.insert("insert
Hi
Has anyone worked with SQLJ, suppose if i have 10 SQLJ
files, how do i use them from java.
How do i compile them?
and call them from java class?
Ashish
A$HI$H
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
htt
Hi
I am using ibatis for sql mapping in my web
application, i am also using log4j for logging,
I have a XML file which i load at startup where I
setup logging parameters and logging levels,
Can i use this XML file to setup ibatis logging
parameters?
Suppose i have to add following line
log4j.logg
Hi
Recently i had asked question about designing java
classes for resultset,
So if i have desgined my java classes as per my
requirement, and using java.util.HashMap to get result
using ibatis, and then in my java program loading
values from HashMap in my java class,
am i not making the process sl
Hi
What is the best way to design java class for mapping,
for example suppose i have a SQL querry which join 2-3
tables and returns the data,
should i design java class to match this SQL querry,
or should i design java class to match tables, and
then create a Map in xml file and then populate data
Boden <[EMAIL PROTECTED]> wrote:
> Hi Ashish,
>
> Have a look at
> http://issues.apache.org/jira/browse/IBATIS-53 for
> some
> examples of what you can probably use. It's not
> really the primary use
> of iBATIS, but it works ;-)
>
> Regards,
> Sven
&
Hi
Is it possible to get Resultset as resultClass after
running a query
Suppose i have a query like below
select * from mytable
how do i define in xml file so i can get a
resultset as output from it
I will parse this resultset into objects i need
Ashish
__
= 123
> and date = (select
> min(date) from mytable where number = 123)
>
> nathan
>
>
> On Feb 24, 2006, at 9:25 AM, Nathan Maves wrote:
>
> > You almost had it :)
> >
> > select min(date), min(time), name from mytable
> where number = 123
> &g
Hi
I have a table with 4 columns number, name, date,
time, it is not unique so can have multiple entries
for one name at different date and time.
I need to find out the first instance of name for that
number in this table, or get the name with minimum
date and time
i can do
select min(date), min(t
Hi
Is there any open source utility which i can use to
create DDL from an existing database, so i can use it
to run to create tables on other database.
This utility should be smart enough to create DDL
statements for tables with primary key, before tables
with foreign key.
That way when i run the D
Hi
I have defined a query as
SELECT L083LINE FROM PL1083 WHERE L083CODE = #value#
ORDER BY L083SQNO
and in my java code i do
List list = client.queryForList("selectLinesFromView",
"ABC");
Suppose if i want a Vector as output, i just cannot
parse it as it gives me classcastexception,
so what i
Hi
I did configure Aator and ran to create sql mapping
for 1 table (PODATA),
it worked but then created on more java class called
(PodataExample) and also in
CXASHTEST_PODATA_SqlMap.xml (CXASHTEST is schema name)
there is a xml tags for
then
PDBLRF like #pdblrf#
Hi
is there any tutorial on manual about using abator?
I am working on webapplication, i haev a database and
need to write SQL statements for CRUD type of
operations? can i use abator for it
ashish
__
Yahoo! DSL Something to write home
ion - if you wanted to, you could store the
> SMC in application
> scope based on the key (test1 or test2), and get it
> from there.
>
> Larry
>
>
> On 12/22/05, Ashish Kulkarni
> <[EMAIL PROTECTED]> wrote:
> > Hi
> > I have a situation, in which
Hi
I have a situation, in which i have 2 database on
suppose DB2, first database is Test1, and second is
Test2.
There is table called names in both databases.
I have created JNDI connection in tomcat.
Now in my website i want to give user a option to
select one of the 2 JNDI connection, and then
Hi
I have a SQL statement as below, how do i define it in
xml
select * from mytable where mytest <> ' '
When i define it in xml file i get following error
The content beginning "<>" is not legal markup.
Perhaps the ">" (e;) character should be a letter.
Ashish
___
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
you
> using iBATIS? :)
> Jeff Butler
>
> On 11/18/05, Ashish Kulkarni
> <[EMAIL PROTECTED]> wrote:
> >
> > Hello
> > Why do i get following error
> > Caused by:
> > org.xml.sax.SAXParseException: Element "sqlMap"
> > requires additional
Hello
Why do i get following error
Caused by:
org.xml.sax.SAXParseException: Element "sqlMap"
requires additional elements.
at java/lang/Throwable.(Throwable.java:195)
at java/lang/Exception.(Exception.java:41)
at
org/x
Hi
Suppose if i want to get any data using ibatis, this
is what i do
1, Create a javabean to store this data
public class MyBean
{
private String a;
//get and set methods
}
2, define in xml file SQL statement
Select name from nametable
Now if i have to change the SQL statement i have to go
an
Alan
What you are doing is singleton pattern, it makes sure
that there is only one instance of SqlMapClient
through out your application.
Ashish
--- Alan Chandler <[EMAIL PROTECTED]> wrote:
> On Monday 24 Oct 2005 16:50, Ashish Kulkarni wrote:
> > Hello
> > What i
(SqlMapClient)
> context.getAttribute(SqlMapClient.class.getName());
> }
> You also need to configure the listener in web.xml.
> Pretty simple...
> Jeff Butler
>
> On 10/24/05, Ashish Kulkarni
> <[EMAIL PROTECTED]> wrote:
> >
> > Jeff
> > Can you p
qlMapClient
> into the servlet context with a listener. I think
> this is essentially what
> Spring does too.
> Jeff Butler
>
> On 10/24/05, Ashish Kulkarni
> <[EMAIL PROTECTED]> wrote:
> >
> > Hello
> > What is the best way to get SqlMapClient in a web
>
Hello
What is the best way to get SqlMapClient in a web
application
1 , Define a singleton pattern class, and create a
instance of SqlMapClient to use by all classes which
need to access data.
2, Define a AbstractClass and put method to get
SqlMapClient in constructor of this class, and then
each
the Document
> object.
>
> The work of the DAO layer is to only execute queries
> and return the data. You can externalize such
> transformations into the RowHandler.
>
> Rgds
> Prashanth Sukumaran.
>
> Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> Hi
> thi
t; wrote:
> Wit apologies to Clinton, my official opinion on
> iBATIS XML results is
> that they suck.
>
> If you want to do what you are describing, do it in
> your DAO class. If
> you want multiple records, do it with a RowHandler.
>
> Larry
>
>
> On 9/12/
Hi
Is it possible to get XML document from ibatis
I am trying to get a XML document as a resultClass
from ibatis, here is what i am doing
SELECT A.PCPORD AS PCPORD
from Pu1012
WHERE A.Pcpord = #value#
String str =
(String)client.queryForObject("getPOData", poNum);
I cannot define resultClas
Hello
Is there a way to use existing database connection
with ibatis?
I have a java program in which i create a connection
and want to include ibatis to do some data extraction,
do i have to specify connection in properties file, or
is there a way i can use the same connection created
in this appli
7;
> and type1 not like '%2%'
> and type1 not like '%3%'
> and type1 not like '%4%'
> and type1 not like '%5%'
> and type1 not like '%6%'
> and type1 not like '%7%'
> and type1 not like '%8%'
Hello
I have a table called test1 in DB2 database, in this
table there is column name type1 which is 2 char in
lenght,
I want to write a SQL statement where i want to select
all the records where "type1 does not have any numeric
data"
for example
if following is data in type1 column
AB
CA
AA
12
23
as far as I can see, just
> passing in a Map of
> Integer and String objects should work fine and you
> don't really need to use
> a parameter map.
>
>
> - Original Message -
> From: "Ashish Kulkarni" <[EMAIL PROTECTED]>
> To:
> Sent: Tu
Hello
I am getting the following error
Check the DELETE FROM POCOMMENT WHERE SYSTEM=#system#
and USER=#user# and ENVNAME=#envname# and P204PORD =
#ponum# and P204ROUT=#routing# .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: [SQL0206] Column
#SYSTEM# not
Hello
If my sql statement is "select * from abc where a = ?"
then i define in my xml file as below
SELECT * from abc where a = #value#>
In my java program i do
List list = sqlMap.queryForList("getPOData",
bigDecimal);
Q1 If i have multiple parameters in select statement
how do i define,
for
> ..and...
>
>WHERE A.Pcpord = "VALUE#
>
> - should be -
>
>WHERE A.Pcpord = #VALUE#
>
> What db is this? That is a freaky looking join with
> all the
> (((( in there.
>
> Larry
>
>
> On 7/5/05, Ashish Kulkarni
>
Hi
I am not sure why i am getting the above error, is
there a way to debug it.
I am going to paste my xml file definiation here,
I am sure this SQL statement works
the error i am getting is as below
Caused by: com.ibatis.sqlmap.client.SqlMapException:
Unrecognized parameter mapping field: ' F.P81
--- Ashish Kulkarni <[EMAIL PROTECTED]>
wrote:
> Hi
> I am trying to use SQL Map to insert data into
> database,
> this table has 124 columns, and i have defined a
> java
> bean to map with this database,
> I am sure that the database bean and insert statment
>
1 - 100 of 102 matches
Mail list logo
