- This topic has 6 replies, 2 voices, and was last updated 13 years, 6 months ago by
.
-
Posts
-
I have created a Scaffold Sprng CRUD application and I need to execute a particular SQL statement when a db connection is made.
Which file would that go in?
Thanks In Advance!
Hello,
I’m not entirely sure I understand the question. Are you trying to create some type of audit statement that logs connections? Or do you have a SQL statement that you would like to use in the application?
If the you are asking the latter, then you can create a named query in the domain object, and then call it in the DAO.
If you are asking the former, I would recommend looking at what atomikos can provide, which is in the [app]-generated-dao-context.xml file, or seeing what the database can do.
Kind regards,
DaveThanks Dave,
I am referring to the latter. I am going to try using the atomikos property “testQuery” and validate it. Ill report back my results. Thanks.the testQuery doesnt work quite like I expected and there is no facility like <new-connection-sql>. Do you know if it is possible to extend AtomikosNonXADataSourceBean so I can use by custom class to do what I need it to do.
In a nutshell, I need to run a few sql statements that change the db session state for what I need to do.
TIA,
ShinanHi Shinan,
The best place to ask this question may be the atomikos forums, which I’ve noticed you already have done – so, I wanted to post the link here in case others are curious about the same question: http://fogbugz.atomikos.com/default.asp?community.6.1772.1.
Kind regards,
Dave
