Your best bet is to change any classpath references from ${database.jar}
to <fileset dir="${mydriver.dir}" includes="*.jar"/> and then change the
setup-tomcat task to copy all 3 jars. That's how I've done it with db2,
which requires 2 jars.
HTH,
Matt
> -----Original Message-----
> From: John Wilson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 15, 2004 2:58 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [Struts-help] AppFuse and SQL Server 2000
>
>
> Hi Matt,
> I'm still trying to get the MS SQL Server JDBC driver to work
> with Appfuse
> and/or Hibernate. I added the necessary jar files to the lib
> folder and
> modified lib.properties. The thing is that the JDBC driver
> consists of 3 jar
> files. lib.properties only allows me to specify 1 jar file
> per section.
>
> I tried jar'ing all the jar files into one jar and then using
> that but it
> doesn't seem happy with that. the db-init ant task does
> pickup the jdbc when
> run but is also needing files from one of the other jar files
> used by the
> JDBC.
>
> Any idea how I can specify all 3 jar files?
>
> Cheers
> John
>
>
> >From: Matt Raible <[EMAIL PROTECTED]>
> >To: "John Wilson" <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: [Struts-help] AppFuse and SQL Server 2000
> >Date: Thu, 12 Feb 2004 05:00:17 -0700
> >
> >I'm assuming you mean that you've tried the following
> tutorial on the
> >wiki:
> >
> >http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseWithSQLServer
> >
> >You might take a look at the writeup I did for using DB2 -
> that might
> >help.
> >
> >http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseOnDB2
> >
> >If you're using AppFuse 1.3 and the SQL Server stuff from
> >database.properties.reference, everything should work. I
> don't know if
> >Hibernate supports the Microsoft JDBC Driver - you'll have
> to check the
> >database.properties.reference file to see.
> >
> >HTH,
> >
> >Matt
> >
> >
> >On Feb 12, 2004, at 4:45 AM, John Wilson wrote:
> >
> >>Hi Matt,
> >>I posted this topic to the mailing list with no luck yet. Do you
> >>perhaps
> >>have any links to some docs that might help me?
> >>
> >>Cheers
> >>John
> >>
> >>
> >>>From: "John Wilson" <[EMAIL PROTECTED]>
> >>>To: [EMAIL PROTECTED]
> >>>Subject: [Struts-help] AppFuse and SQL Server 2000
> >>>Date: Wed, 11 Feb 2004 08:47:10 +0000
> >>>
> >>>
> >>>I have been developing against mySQL but now need to switch my
> >>>application over to SQL Server 2000 for production.
> >>>
> >>>After trying to edit various files and redeploying through Ant
> >>>without
> >>>any luck I would like to know if somebody can perhaps give me a
> >>>step-by-step method for switching databases or just a
> quick run through
> >>>of what I need to do. I did check the Wiki tutorial on SQL
> Server but
> >>>didn�t find anything that can help me.
> >>>
> >>>Please note that I would be using the Microsoft JDBC
> driver. I have
> >>>used
> >>>this driver very successfully with other Struts web
> applications before
> >>>so it should be fairly easy. (I hope).
> >>>
> >>>Any help appreciated.
> >>>
> >>>Kind Regards,
> >>>John
> >>>
> >>>_________________________________________________________________
> >>>G-string or thermal underwear? Find out at MSN Weather!
> >>>http://www.msn.co.za/weather/
> >>>
> >>>
> >>>
> >>>-------------------------------------------------------
> >>>The SF.Net email is sponsored by EclipseCon 2004
> >>>Premiere Conference on Open Tools Development and
> Integration See the
> >>>breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> >>>http://www.eclipsecon.org/osdn
> >>>_______________________________________________
> >>>Struts-help mailing list
> >>>[EMAIL PROTECTED]
> >>>https://lists.sourceforge.net/lists/listinfo/struts-help
> >>
> >>_________________________________________________________________
> >>Food & wine, hobbies, home d�cor tips - get it all with MSN Search!
> >>http://search.msn.co.za/
> >
>
> _________________________________________________________________
> Food & wine, hobbies, home d�cor tips - get it all with MSN Search!
> http://search.msn.co.za/
>
-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id56&alloc_id438&op=click
_______________________________________________
Struts-apps mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/struts-apps
