Hi Nathan,
Nathan Anderson wrote:
I have not used Oracle in a while, but if you need to set some parameter at the
time the connection is made there is a good chance the driver is set up to
accept parameters in the jdbc url. I've recently needed to do the same for a
DB2 database, an old MSSQL, and an old MySQL database.
Thanks, that's a good thought. Have done a bit of Googling - one
opinion on this page:
http://forum.java.sun.com/thread.jspa?threadID=656554&tstart=0
suggests that I can set a NLS_DATE_FORMAT environment variable and that
will be picked up by the JDBC driver. I'll test that later on when I'm
next connecting to the Oracle box and see if it works.
----- "Rob Hills" <[EMAIL PROTECTED]> wrote:
I am trying to deploy my AppFuse 2 app to a test environment that uses
Oracle 10g as the database.
I'm running into problems with DBUnit and my test data. One of my
POJOs
stores time data and my sample-data.xml file which has worked fine so
far for HSQLDB and PostgreSQL is now causing DBUnit to barf when
trying
to feed it to Oracle.
The format I'm using in my sample-data.xml file is "hh:mm:ss". I know
Oracle is funny about date data and there's a command one can issue at
the start of a DB session to tell it what date format you want to use,
but is there any way of doing that in an AppFuse app? I'm guessing I
can pull something out of the DBUnit API to do it, but that adds
another
level of complexity to the app that I was hoping to avoid. Anyway,
I'd
naively thought that Hibernate/DBUnit would handle all that for me.
Has anyone else come across this problem before?
Cheers,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
