I am also having great difficulty using the orion-generated finders (findByXXX) with DB2... and I create the tables myself through the DB2 SQL tool on NT. I have not found a solution, hopefully we can discover the problem here!
Josh Motto -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of El Jeffo Sent: Tuesday, October 23, 2001 12:12 PM To: Orion-Interest Subject: Re: orion & DB2 > Does orion really work with DB2 as a datasource? I'm still having I suppose... but I haven't done much ejb/cmp with it, mostly servlets and prepared statements. > trouble with this. The DB won't accept the prepared SQL-statements for > the finder-queries genereated by orion. I had trouble with the create statements it generates. For example create table foo (bar int null) // to say that bar can be null should be create table foo (bar int default null) but of course, if I create the table myself, the cmp for something like the counter works fine. I bet perhaps some other finder stuff it's executing has similar syntax incompatibilities. > Did you have similar probelem? Which JDBC-driver did you use? I'm using the one for solaris in /opt/IBMdb2/V7.1/java12 <?xml version="1.0"?> <!DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/d tds/data-sources.dtd"> <data-sources> <data-source class="com.evermind.sql.DriverManagerDataSource" name="db" location="jdbc/DBCoreDS" xa-location="jdbc/DBXADS" ejb-location="jdbc/DBDS" connection-driver="COM.ibm.db2.jdbc.app.DB2Driver" username="db2inst1" password="foobar" url="jdbc:db2:dbname" inactivity-timeout="30" > <description> This datasource is the main connector to the DB2 backend database </description> </data-source> </data-sources> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com