On Thu, 19 Mar 2009, Paweł Gutowski wrote:
mysql-connector-java-5.1.7
What could be wrong?
Are you using 'useUnicode=yes&characterEncoding=UTF8' in the connection
URL?
--
Graeme -
On Tue, 11 Nov 2008, [EMAIL PROTECTED] wrote:
XML does not support < and > operator as it is. You have to use
OR
<
>
?
--
Graeme -
On Mon, 18 Aug 2008, Warren Bell wrote:
Has anyone else had this problem after upgrading to Postgres 8.3? I have
tried the Postgres users list and the Postgres JDBC users list and have
gotten no where.
Have you tried the 8.1 driver with 'compatible=8.1' in the connection
string?
IIRC I ran
On Fri, 25 Jul 2008, Chris Marshall wrote:
According to a previous post[1] you have
WEB-INF/context.xml
but this should be
/META-INF/context.xml
according to
http://tomcat.apache.org/tomcat-6.0-doc/config/context.html
[1] http://www.mail-archive.com/user-java@ibatis.apache.org/msg11892.html
On Wed, 30 Apr 2008, supriya .pelluru wrote:
i am getting this error
Delete statements cannot be executed as a query.
at
com.ibatis.sqlmap.engine.mapping.statement.DeleteStatement.executeQueryForObject(DeleteStatement.java:33)
You're using queryForObject instead of delete.
--
Graeme -
On Wed, 12 Mar 2008, slaughter wrote:
I found the double / by trying a lot of stuff.
Something is wrong with your setup, single / works fine.
Are these files derived from a Win32 box?
--
Graeme -
On Thu, 21 Feb 2008, Ryan Shelley wrote:
Is there a way to
either 1) get the namespace to be recognized, or 2) remove the namespace
--
Graeme -
On Fri, 15 Feb 2008, erosik wrote:
i am using ibatis in my jsp application, i have created db with a
unique field (e.g. id) so when i insert a record with same id again i m
getting error like this, can any one help to sort out this exception
com.mysql.jdbc.exceptions.MySQLIntegrityConstrai
On Mon, 10 Dec 2007, Thomas Rene Vervik wrote:
So my question would be - how do you manage to make < and > comparisons in
queries using ibatis ?
You're dealing with XML, so use CDATA sections or entities < and >
< <
>
--
Graeme -
On Wed, 21 Nov 2007, smelly wrote:
I am using ibatis and oracle 10. The jdbc driver is
oracle.jdbc.driver.OracleDriver. When I retrieve data from table, I found a
space ' ' is appended. Let's say column ACTIVE_IND CHAR(1), the data
retrieved is 'A '. is it weird? Does anybody have idea?
CHAR
On Wed, 14 Nov 2007, [EMAIL PROTECTED] wrote:
Thanks Graeme. It appears to be a problem with the Strings. On hardcoding
#family#, #group# and #type# with the actual Strings but using
#firstContractId# and #secondContractId# as params it works. However
setting the Strings as params and hardcod
On Wed, 14 Nov 2007, [EMAIL PROTECTED] wrote:
Thanks for the suggestion but that is exactly what I did - not too clear
I'm afraid in the last part of my email:
I thought Niels meant that you should keep 'between 12377813 and
12378073' hardcoded and test the remaining fields as parameters?
On Fri, 9 Nov 2007, Jeremy Jardin wrote:
uhu;. I did not change anything on my log4j.properties file...
The project is in developpement part, so, the appender is the console...
I'm losing all my time with that pb !! :-(
Sounds more like an eclipse issue and not being an eclipse user .
On Tue, 30 Oct 2007, Rich Midwinter wrote:
This has worked previously, I wouldn't have changed the jar since but MySQL
could have been updated. My code's definitely changed since - I haven't
committed it to version control yet though. :-s
It could be a bug introduced in 5.0.45
Usual advi
On Tue, 30 Oct 2007, Rich Midwinter wrote:
It's completely repeatable. I'm using a MySQL database and when I
manually enter the query it works fine.
Can anyone suggest where I might be going wrong? Thanks
Which version of MySQL and jdbc connector?
--
Graeme -
On Tue, 18 Sep 2007, maomaode wrote:
JDK6 + Mysql-Conn-3.0.10 + Mysql 5.0.45 + GBK (or GB2312, not the utf8)
AIUI all your Unicode will be converted to GBK, yet your inserts now
seem to work (server-side conversion?).
My Chinese characters is in UTF-8 (load from xml file, and encoded with
On Mon, 17 Sep 2007, maomaode wrote:
But if I insert the Chinese char into the table, i still got the junk
characters.
Anyone have solutions to this?
jdbc:mysql://localhost/mydb?characterEncoding=utf8
Your Chinese characters must be utf-8 and your viewing platform must be
utf-8 enabled too
On Sun, 16 Sep 2007, startxxx wrote:
my database tables are set utf8
netbeans debugger shows me the hebrew value of the string fine
one line before i insert it using iBatis.
anything else?
Set characterEncoding=utf8 on the connection URL but it's not an iBatis issue.
--
Graeme -
On Sun, 16 Sep 2007, startxxx wrote:
The database seem to hold hebrew text if I add it using the mysql query
browser and the hebrew
values show fine when selected from my application using iBatis - so I have
all reasons
to believe it's not a mysql setup issue (unless I'm missing something in
bet
Hi,
I'm trying to use statementCachingEnabled to see if I can speed up an
insert task and the inserts are executed within a batch.
The log gives the following sequence:
Connection
Preparing Statement
Executing Statement
Connection
Preparing Statement
Executing Statement
Should I get:
Connec
On Thu, 14 Jun 2007, vinays84 wrote:
Hi, I'm trying to learn iBatis SQL Maps. I've gone through the basic tutorial
provided on the iBatis site. The tutorial only deals with one table and
doesn't explain how to handle several tables with links. Is there a simple
tutorial out there that handles t
On Thu, 31 May 2007, Giovanni D'Addabbo wrote:
Ok it work very well but i've read in the book that i can use dot
notation, for example Account.gettAllUsers ok now is the problem...how
can i use this dot notation? :D
IIUC, you need to enable namespaces:
...
...
...
sele
On Tue, 27 Mar 2007, [EMAIL PROTECTED] wrote:
The issue was actually to do
with there being two setter methods on my object - both with the same
name but taking parameters of different types - one 'Date' and one
'String'. My local environment was using the correct setter method. The
service prov
On Wed, 21 Mar 2007, Niels Beekman wrote:
We use jTDS (http://jtds.sf.net) for several years now, it has excellent
performance and any bugs (which are very rare) are dealt with promptly.
+1
--
Graeme -
On Wed, 21 Mar 2007, [EMAIL PROTECTED] wrote:
I think the two errors are unconnected. The unparseable 'date' shown is
from the dob column not the lastLogin column. I think that is a red
herring. I have no idea why 'lastLogin' is causing an issue as well.
The value is from the dob column but iB
On Tue, 20 Mar 2007, [EMAIL PROTECTED] wrote:
--- Check the result mapping for the 'lastLogin' property.
--- Cause: com.ibatis.common.exception.NestedRuntimeException: Error
setting properties of 'BaseObject [107, null, null, null]'. Cause:
java.text.ParseException: Unparseable date: "1975-01-1
On Tue, 20 Mar 2007, [EMAIL PROTECTED] wrote:
The database is MySQL - sorry for not mentioning that!
I have manually inserted a record into the database and tried the same
code. It fails in exactly the same way.
From your earlier posts:
1. Local server, local DB works
2. Local server, remo
On Tue, 20 Mar 2007, Mark Volkmann wrote:
Perhaps I'm doing something wrong in my AbatorConfig.xml. Here's the part
that pertains to the address table.
Is the value for the sqlStatement attribute wrong?
Something like .
--
Graeme -
On Tue, 20 Mar 2007, [EMAIL PROTECTED] wrote:
The only difference to take into account though is that all the datetime
columns are system generated where as the date field that is throwing
read errors has orginated from a form field. This field is correctly
inserted into the database but then ha
On Tue, 20 Mar 2007, [EMAIL PROTECTED] wrote:
Thanks for the response. I'll have a look at the example you have
suggested. I am using a date jdbc type for the date field as I only
need dates in the form -MM-dd rather than the extended datetime
format.
Is the column type DATE or DATETIME ?
On Thu, 8 Mar 2007, Gordon Ross wrote:
Now this wasn't totally surprised as I wasn't sure about the basic CWD
of a tomcat app. In this case (when running under Eclipse) it appears to
be my home directory. So I put the sqlmap.xml file there, and IBATIS
still complains that it can't find the file.
On Thu, 1 Mar 2007, Mark Volkmann wrote:
If you're interested in learning more about Abator, I have some notes on it
at http://www.ociweb.com/mark/Abator.html that might be helpful.
Doesn't appear to work, I just get a blank page.
--
Graeme -
On Mon, 29 Jan 2007, Andr? Rodrigues Pena wrote:
I'm new to iBatis, this is my first project. I'm trying to use it with a
JDBC driver provided by Microsoft to access MS SQL 2005. Every time I try to
FYI http://jtds.sourceforge.net/
run it on Eclipse I get the same error message: "Could not f
On Mon, 11 Dec 2006, Tommy Kristiansen wrote:
Caused by: java.lang.ClassNotFoundException: Bean
You have to *create* the class Bean.
Call it anything you like e.g. com.commfides.beans.PinOrderQueryBean
--
Graeme -
On Mon, 11 Dec 2006, Tommy Kristiansen wrote:
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 need
On Fri, 8 Dec 2006, puneet arya wrote:
you can use directly JDBC to insert data from access to database
without using IBATIS
For one table you're probably right.
I use abator, if I have to do this type of a task.
--
Graeme -
On Wed, 8 Nov 2006, Hari... wrote:
what exactly cache model is ?
The cacheModel wraps/represents a cache implementation.
i had gone through the dev guide ,i fell that infornmation is not
sufficient. can anyone explain me what exactly happens when we use the cache
model .
The cache will be
On Fri, 3 Nov 2006, Larry Meadors wrote:
What is returned by to_char(max(position_as_at))?
additionally, what Java type is positionAsAt? I'm guessing it should be a
String.
columnIndex="4" jdbcType="VARCHAR"/>
?
--
Graeme -
On Fri, 3 Nov 2006, Rutherford, Matthew [CIB-IT] wrote:
The java property is of type int. ie. setFii(2) sets it to an int value 2. In
the db it is an oracle number(12).
If I do a getItems (select *) type query The list is populated fine.
Any ideas?
what happens if you hardcode the value o
On Fri, 20 Oct 2006, Javier Leyba wrote:
I've the following code defined:
--
Log show me that parameters arrives to query without problems. If I
put those querys in a MySQL it works ok, so. I' ve no idea about
the origin of th
On Tue, 10 Oct 2006, trevor paterson (RI) wrote:
we are developing a webapp on netbeans/tomcat and using ibatis to
connect to a remote postgres database
during development we are deploying the web app through netbeans - and
when we stop the webapp we seem to leave dangling connections which the
On Mon, 9 Oct 2006, Hariharan, Vadivelu (IE10) wrote:
I don't see anything called
useStatementNamespaces="true" element in the DTD.
Could you be more specific
See your sqlMapConfig, http://ibatis.apache.org/dtd/sql-map-config-2.dtd.
--
Graeme -
On Mon, 9 Oct 2006, Hariharan, Vadivelu (IE10) wrote:
If I prefix each if the "id" elments with the namespace type, the problem is
fixed
Can't abator generated the id elements with the namespace prefix, or is
there any setting I'm missing in my properties file
Are namespaces enabled in yo
On Wed, 2 Aug 2006, [EMAIL PROTECTED] wrote:
java.sql.BatchUpdateException: ORA-01000: maximum open cursors exceeded
But this is working fine with FireBird and MS-SQL
So it's not an iBatis problem then.
after exactly 150 records i am getting the error.
http://www.cryer.co.uk/brian/oracle
On Tue, 1 Aug 2006, jeb001 wrote:
No it's not a war.. I've my webapps in the context path.. I'm developping.
As per Tim Chen, make sure WEB-INF/lib is the only place the jar is
present.
Restart your servlet container.
--
Graeme -
On Tue, 1 Aug 2006, jeb001 wrote:
no one ?
Are you deploying your application as a WAR?
If you've manually copied it to WEB-INF/lib, did you restart your
servlet container?
If you've transferred the oracle jar say by ftp then do an md5dum on it
and compare with the original.
--
Graeme -
On Fri, 28 Jul 2006, Stefan Podkowinski wrote:
Can anyone give advise how to seperate object mappings from statements
in ibatis? We would like to create a file containing a few complex
reporting queries with the intention to use it as a common query
definition base for several applications. The
On Tue, 18 Jul 2006, CIJOML wrote:
newKontakt.setId_lokace('4');
Detail: Key (lokace_id_lokace)=(52) is not present in table "lokace".
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on
table "kontakt" violates foreign key
constraint "kontakt_lokace_id_lokace_fkey"
On Mon, 17 Jul 2006, al pivonka wrote:
HELP
I'm getting a ClassCastException on SqlMapDaoTemplate.getSqlMapExecutor
Never used it, can you post your code and the exception trace.
--
Graeme -
On Mon, 17 Jul 2006, hicham abassi wrote:
What's the actually best ibatis plugin ? Abator, ?
Plugin for what?
--
Graeme -
On Thu, 13 Jul 2006, jeremy jardin wrote:
So I want to launch a request with a where clause on "MOBILE" property.
When I look on the XML file, I just can't see that :
Sould I had the property ??
Pour votre Anglais: add not had
From your abator generated classes you should have a
UTILISA
On Tue, 11 Jul 2006, chaithanya ibatis wrote:
currently i'm using this which is not supporting typeHandler tag
http://www.ibatis.com/dtd/sql-map-config-2.dtd";>
It does. Post your sqlMapConfig.xml
--
Graeme -
On Mon, 10 Jul 2006, Paul Benedict wrote:
I get that annoying "cannot find WRITABLE property id in Person" message
because it is looks at Article.getPerson() which returns the interface not
implementation.
Doesn't that mean that Person is not a JavaBean i.e. missing a setId
method?
--
Gr
On Tue, 4 Jul 2006, Thomas Karl Schwaerzler wrote:
You don't have to do this
link.setId(id);
as this call
linkDao.insert(link);
will return you the id. Check the javadoc of your DAO (or
LinkDAOImpl.java).
--
Graeme -
On Mon, 3 Jul 2006, Thomas Karl Schwaerzler wrote:
com.ibatis.common.exception.NestedRuntimeException: Could not find SQL
statement to include with refid
'user_ODM_LINK.abatorgenerated_Example_Where_Clause'
Is it a namespace issue?
here my SqlMapConfigAbator.xml
http://www.ibatis.com/d
On Mon, 3 Jul 2006, Anthony Hong wrote:
Is this impossible to achieve?
If there is no inherent iBatis solution then an alternative is to change
your build configuration to pull in the correct config file at run time.
--
Graeme -
On Thu, 29 Jun 2006, Rob van der Leek wrote:
However, this does not solves my "namespace problem".
Have you set your config to use namespaces?
--
Graeme -
On Wed, 21 Jun 2006, jeremy jardin wrote:
targetProject="authentification.components.SqlDatas.src"
targetProject="authentification/components/SqlDatas/src"
--
Graeme -
On Sun, 11 Jun 2006, Tarek Nabil wrote:
log4j.appender.RollingFile.File=c:/customs.log
c:\customs.log ?
--
Graeme -
On Mon, 5 Jun 2006, Mayeul MARGUET wrote:
Is there an official way to do it, which would save me the hassle of
modifying my default timezone or storing my dates and timestamps as
text?
Create a TimeZone for GMT and use that to create a Calendar instance.
That should help with the insertions.
On Thu, 4 May 2006, radha rukmani wrote:
Is there a way to turn of the result set logging I use log 4j and havent
written any logging statement for ibatis queries, it comes by itself
What about this in your log4j configuration ?
log4j.logger.java.sql.ResultSet=OFF
--
Graeme -
[Looks like my first post got lost when the list went down :-/]
Hi,
I'm a newbie to iBatis and as part of some unit-testing I need to confirm
that the correct number of rows are deleted when removing some records.
If do
delete from X where id=#value#;
delete from Y where id=#value#;
I get
62 matches
Mail list logo
