Hi there!
One database per SqlmapConfig - that's the rule.
But if your databases and the data is tightly coupled and if you don't need a
different sqlMapConfig setting setup (don't need ping query, lazyLoadingEnabled
setting etc)
Wouldn't it be more clean to have one sqlMapConfig file ?
Hi there!
Your real problem working with 2 different databases, is that they are of
different versions and as long the driver class is the same in 8i and 9i, your
are stuck to one driver :-)
As far as I know how.
What you could try, is to use a 8i driver to see if the query runs agains
Hi there!
This plugin looks great, but are you also thinking about a feature like this:
Generate CRUD SQL . with default class or alias as input param ?
???
This feature should also have the possibilities to change the default query
names for each CRUD operation from e.g:
Hi again!
To quick respons last time:
We now have intentions for automatically creating result maps and all
CRUD operations (insert, select, update, and delete).
Yes you are planning automatically creating all CRUD operations :-)
That's realy good! ... but remember the option to override
the
Hi there!
In your dao class you can call the sqlMap for example like this:
result = sqlMap.queryForList(searchCompanies, searchBean, ((pageNumber-1) *
pageSize), pageSize);
Use of variables named like this, makes it more easy to read if you ask me :-)
Take care,
Erlend
-Opprinnelig
To make it more clear... then your first page starts on page 1
(pageNumber = 1) .. so you don't have to transform the value you
send in for page 1, to 0 :-)
Clear as ink :-)
-Opprinnelig melding-
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sendt: 2. juli 2007 18:13
Til:
Hi !
Don't fall for
Sun Standards. I did, and iBATIS is worse for it.
Interesting, can you tell us a little more about that ? whats
worse ? J
Thanks,
Erlend
Hi!
Just use AbstractTransactionalDatabaseTestCase or whatever it's
called.
It's not called that, will try to look find it, but do you know the name ?
Sounds more easy to use if it do what I think it does :-)
Thanks!
Erlend
Hi there!
Im trying to set
up some junit tests and want to take automatically a rollback for each test, in
a Spring context.
Any clues how to set this
property transactionManager (see below for the error) correctly in Spring ?
I have tried to use the
Hi there!
I was struggling with this
problem, then I finally realized the problem, ME J
I have been using Hibernate
with Spring (someone else has setup the transactionManager stuff), and when
I realized what I was actually missing then wola J This line here in the spring-dao.xml
Hi Brian!
Are you sure you need to cache?
Pretty sure :-) Have worked pretty well so fare.
What metrics do you have to warrant the additional complexity?
Until now we haven't seen it with extra complexity. When I started to use it, I
liked it a lot :-) The shit hit the fan :-) when we
Hi there!
Gareth wrote:
Most of the hand
written domain objects I have are completely flat POJOs - there is no separate
class for primary key - most of the time, there are no primary keys on the database - so I'd like
all of the Abator generated objects to be the same. Can we turn off
Hi there Jeff!
The primary key class is seperated so that the method signatures for
selectByPrimaryKey and deleteByPrimaryKey can only require the primary key, and
not the class that represents the entire row.
I see, was thinking about
that, but I havent got that problem, I always
Hi therae Christopher!
PrimaryKey
class in the first place the impact would have been greatly reduced and almost
negligible. I learned my lesson and now always create a PrimaryKey class for
every Domain object.
And as
you stated below, it provides a much cleaner interface to the
Hi there!
Yusuf wrote
I think it's better off making the paging logic yourself in the
application, and then querying only the records you want to show, for
example in oracle you can use the rownum to fetch the data like
select * from
(select rownum row, a.* from tabel1 as a)
where row between
Hi there!
When digging for the error in my previous message:
Possible to set timeout on the connection ?
I came over a very strange bug somewhere from SQLMap, the Oracle
driver classes12.jar and to the database Oracle 9.2.
I do a plain SQL without binding variables (I do $complexWhere$ -
Hi there!
Wow, that is a wacky one..it seems most likely that it is a driver issue (i
can promise that there is no
if(sql.length() == 1983) blowChunks(); code in SQL Maps.
:-)
Can you try it with the latest Oracle drivers?
From all reports, the 10g drivers resolved a ton of bugs that were
Title: Melding
Hi
there!
I have a queryForMap
like this:
HashMap codes
= (HashMap) sqlMap.queryForMap("retrieveAdminUserAccessCodes","testUser", "CODE", "VALUE"));
And the query like
this:
select
id="retrieveAdminUserAccessCodes" resultClass="java.util.HashMap"
Hi there!
Have you tried with FK and cascade delete ?
Which means one delete statement, but behind the scene, deletes in several
tables,
the number of deleted rows should then be correct ?
Erlend
---
[Looks like my first post got lost when the list went down :-/]
Hi,
I'm a newbie to
Title: Melding
Hi
there!
One
easy trick is to use the database function, in Oracle:
initcap
select
initcap(name), initcap(contactperson) ...
from
company
--
But
still you have the problem with words that you don't want to initcap
..
words
like:
and,
or ...
--
Let me
know if you
Hi there!
Apparently you have an element type that is not in proper order with the DTD.
You are right, after downloaded the JEdit (thanks for the tip) with the xml
parser plugin, tested with the sqlMap-config file from the sqlMap pdf file ...
I found out it was the order. I had it like this:
Title: Melding
Hi
there!
In my IntelliJ, in
our Resin web applications it all works just fine with SQLMap, but when I
tries to
run a scheduler job
(Quartz) from command prompt using SQLMap from a .bat file (I
run the job
from IntelliJ it
works fine)it seems thatsuddenly the parsingof
22 matches
Mail list logo