Have you seen the database profiles page? It's just a matter of creating a DB2 profile in your pom.xml and then having a single JAR for your JDBC driver.
On Tue, Oct 21, 2008 at 3:22 PM, jackalista <[EMAIL PROTECTED]> wrote: > > Hey Matt, > > Well, to put it more succinctly, what are the steps to configure appfuse for > *any* DB? I can abstract that for DB2 myself but I don't know what the > general approach is for appfuse 2. > > Thanks dude... > > --j > > > > mraible wrote: >> >> On Tue, Oct 21, 2008 at 8:53 AM, jackalista <[EMAIL PROTECTED]> wrote: >>> >>> Hey Matt, >>> >>> There's only 1 zip file, so there's no need to combine anything, so no. >>> Are you saying that the zip format might be the problem? >>> >>> Can you tell me the list of steps that need to be performed to allow >>> appfuse >>> to use DB2? As I'm kind of new to both appfuse 2.x and maven I'm not >>> sure >>> what all needs to be done. >> >> I've never used AppFuse 2 with DB2, so I don't have an answer for you. >> >> Matt >> >>> >>> Thanks man, >>> >>> --jack >>> >>> >>> mraible wrote: >>>> >>>> Have you tried combining the zips into a single JAR and installing that? >>>> >>>> On Mon, Oct 20, 2008 at 4:18 PM, jackalista <[EMAIL PROTECTED]> wrote: >>>>> >>>>> One more clue: I just checked my repository in ~/.m2/repository and >>>>> since I >>>>> tried running the mvn install:install-file cmd using both "db2java" and >>>>> "db2jcc" as the jdbc.artifactId I have the zip file for the driver in >>>>> the >>>>> repository under both db2java and db2jcc (in com/ibm). For some reason >>>>> it's >>>>> not becoming available to the app though; if anyone can see what I'm >>>>> doing >>>>> wrong I'd love to hear from you. >>>>> >>>>> --jack >>>>> >>>>> PS: I tried to do the mvn install:install-file using -Dpackaging=zip, >>>>> since >>>>> the driver is actually in a zip file rather than a jar but I got a >>>>> different >>>>> error, it seems pretty clear that the problem is that I'm not correctly >>>>> getting the dependency set up with maven (tho I could be wrong...). >>>>> Here's >>>>> the trace from that: >>>>> >>>>> [EMAIL PROTECTED]:~/java/ccas/proto/af2.02/src/ccas/web$ mvn >>>>> install:install-file >>>>> -Dfile=/home/jack/dnlds/java/db2/jdbc.driver/db2java.zip >>>>> -DgroupId=com.ibm >>>>> -DartifactId=db2jcc -Dversion=3.50.152 -Dpackaging=zip >>>>> -DgeneratePom=true >>>>> [INFO] Scanning for projects... >>>>> [INFO] Searching repository for plugin with prefix: 'install'. >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Building AppFuse Modular Application - Web (Struts 2) >>>>> [INFO] task-segment: [install:install-file] (aggregator-style) >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] [install:install-file] >>>>> [INFO] Installing /home/jack/dnlds/java/db2/jdbc.driver/db2java.zip to >>>>> /home/jack/.m2/repository/com/ibm/db2jcc/3.50.152/db2jcc-3.50.152.zip >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] BUILD SUCCESSFUL >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Total time: 3 seconds >>>>> [INFO] Finished at: Mon Oct 20 17:08:11 GMT-05:00 2008 >>>>> [INFO] Final Memory: 10M/94M >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> >>>>> >>>>> >>>>> >>>>> [EMAIL PROTECTED]:~/java/ccas/proto/af2.02/src/ccas/web$ mvn jetty:run-war >>>>> [INFO] Scanning for projects... >>>>> [INFO] Searching repository for plugin with prefix: 'jetty'. >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Building AppFuse Modular Application - Web (Struts 2) >>>>> [INFO] task-segment: [jetty:run-war] >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Preparing jetty:run-war >>>>> Downloading: >>>>> http://repo1.maven.org/maven2/com/ibm/db2java/3.50.152/db2java-3.50.152.jar >>>>> Downloading: >>>>> http://static.appfuse.org/repository/com/ibm/db2java/3.50.152/db2java-3.50.152.jar >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [ERROR] BUILD ERROR >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Failed to resolve artifact. >>>>> >>>>> Missing: >>>>> ---------- >>>>> 1) com.ibm:db2java:jar:3.50.152 >>>>> >>>>> Try downloading the file manually from the project website. >>>>> >>>>> Then, install it using the command: >>>>> mvn install:install-file -DgroupId=com.ibm -DartifactId=db2java >>>>> -Dversion=3.50.152 -Dpackaging=jar -Dfile=/path/to/file >>>>> >>>>> Alternatively, if you host your own repository you can deploy the file >>>>> there: >>>>> mvn deploy:deploy-file -DgroupId=com.ibm -DartifactId=db2java >>>>> -Dversion=3.50.152 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] >>>>> -DrepositoryId=[id] >>>>> >>>>> Path to dependency: >>>>> 1) com.hbc.ccas:ccas-webapp:war:1.0-SNAPSHOT >>>>> 2) com.ibm:db2java:jar:3.50.152 >>>>> >>>>> ---------- >>>>> 1 required artifact is missing. >>>>> >>>>> for artifact: >>>>> com.hbc.ccas:ccas-webapp:war:1.0-SNAPSHOT >>>>> >>>>> from the specified remote repositories: >>>>> central (http://repo1.maven.org/maven2), >>>>> appfuse (http://static.appfuse.org/repository) >>>>> >>>>> >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] For more information, run Maven with the -e switch >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Total time: 5 seconds >>>>> [INFO] Finished at: Mon Oct 20 17:08:52 GMT-05:00 2008 >>>>> [INFO] Final Memory: 16M/118M >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> jackalista wrote: >>>>>> >>>>>> I tried running mvn jetty:run-war after adding the profile below to my >>>>>> top >>>>>> level pom.xml and also changing the settings at the bottom of the >>>>>> pom.xml >>>>>> in the section titled "<!-- Database settings -->". I got an >>>>>> UnsatisfiedLinkError that makes it look like even though the mvn >>>>>> install:install-file command succeeded the zip file for the driver >>>>>> doesn't >>>>>> appear to be available to the app. If anyone knows what's wrong with >>>>>> this >>>>>> picture I'd appreciate hearing from you. Here's the error I got >>>>>> running >>>>>> mvn jetty:run-war: >>>>>> >>>>>> [EMAIL PROTECTED]:~/java/fooapp/web$ mvn jetty:run-war >>>>>> [INFO] Scanning for projects... >>>>>> [INFO] Searching repository for plugin with prefix: 'jetty'. >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> [INFO] Building AppFuse Modular Application - Web (Struts 2) >>>>>> [INFO] task-segment: [jetty:run-war] >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> [INFO] Preparing jetty:run-war >>>>>> [INFO] [warpath:add-classes {execution: default}] >>>>>> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}] >>>>>> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}] >>>>>> [INFO] [resources:resources] >>>>>> [INFO] Using default encoding to copy filtered resources. >>>>>> [INFO] [compiler:compile] >>>>>> [INFO] Compiling 1 source file to >>>>>> /home/jack/java/fooapp/web/target/classes >>>>>> [INFO] [resources:testResources] >>>>>> [INFO] Using default encoding to copy filtered resources. >>>>>> [INFO] [compiler:testCompile] >>>>>> [INFO] Compiling 1 source file to >>>>>> /home/jack/java/fooapp/web/target/test-classes >>>>>> [INFO] [dbunit:operation {execution: test-compile}] >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> [ERROR] BUILD ERROR >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> [INFO] Error executing database operation: CLEAN_INSERT >>>>>> >>>>>> Embedded error: java.lang.UnsatisfiedLinkError: no db2jdbc in >>>>>> java.library.path >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> [INFO] For more information, run Maven with the -e switch >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> [INFO] Total time: 10 seconds >>>>>> [INFO] Finished at: Mon Oct 20 16:47:09 GMT-05:00 2008 >>>>>> [INFO] Final Memory: 19M/121M >>>>>> [INFO] >>>>>> ------------------------------------------------------------------------ >>>>>> >>>>>> >>>>>> I have a feeling this is merely maven cluelessness, does anyone see >>>>>> what >>>>>> I'm doing wrong? >>>>>> >>>>>> Thanks... >>>>>> >>>>>> --jack >>>>>> >>>>>> >>>>>> >>>>>> jackalista wrote: >>>>>>> >>>>>>> I'm piecing together the profile for DB2, if someone would comment >>>>>>> and >>>>>>> help me tweak this I'd appreciate it. I'm trying to put together >>>>>>> some >>>>>>> code in a hurry to do some performance testing and need to do it >>>>>>> against >>>>>>> DB2. I'm hoping to use appfuse on this project so I need to figure >>>>>>> out >>>>>>> how to set appfuse up to use DB2. We're using DB2 version 9.5, the >>>>>>> driver is in a zip file called db2java.zip. >>>>>>> >>>>>>> Here's the profile I've got so far, can anyone take a look at this >>>>>>> and >>>>>>> tell me if it's correct?: >>>>>>> >>>>>>> <profile> >>>>>>> <id>db2</id> >>>>>>> <properties> >>>>>>> >>>>>>> <hibernate.dialect>org.hibernate.dialect.DB2Dialect</hibernate.dialect> >>>>>>> <jdbc.groupId>com.ibm</jdbc.groupId> >>>>>>> <jdbc.artifactId>db2jcc</jdbc.artifactId> >>>>>>> <jdbc.version>3.50.152</jdbc.version> >>>>>>> >>>>>>> <jdbc.driverClassName>COM.ibm.db2.jdbc.app.DB2Driver</jdbc.driverClassName> >>>>>>> >>>>>>> <jdbc.url><![CDATA[jdbc:db2://myhost:50000/mydb]]></jdbc.url> >>>>>>> <jdbc.username>foo</jdbc.username> >>>>>>> <jdbc.password>bar</jdbc.password> >>>>>>> </properties> >>>>>>> </profile> >>>>>>> >>>>>>> The part I'm not sure about are the artifactId. I seems like it >>>>>>> should >>>>>>> either be db2jcc or db2java, I'm not sure which is right. I tried >>>>>>> running the following command and it succeeded, so thta may confirm >>>>>>> that >>>>>>> db2jcc is correct, but as I'm pretty new to maven I'm not too sure. >>>>>>> Here's the command: >>>>>>> >>>>>>> mvn install:install-file >>>>>>> -Dfile=/home/jack/dnlds/java/db2/jdbc.driver/db2java.zip >>>>>>> -DgroupId=com.ibm -DartifactId=db2jcc -Dversion=3.50.152 >>>>>>> -Dpackaging=jar >>>>>>> -DgeneratePom=true >>>>>>> >>>>>>> If anyone would help me figure out if this is the right approach, I'd >>>>>>> be >>>>>>> very grateful, tia... >>>>>>> >>>>>>> --jack >>>>>>> >>>>>>> >>>>>>> >>>>>>> jackalista wrote: >>>>>>>> >>>>>>>> I'm trying to run down how to configure appfuse to use DB2 so am >>>>>>>> finding >>>>>>>> a;ll these threads. DB2 *does* have a single zip file for version >>>>>>>> 9.5 >>>>>>>> of the DB. >>>>>>>> >>>>>>>> What I'm not so clear on is how to set this up. Do I need to create >>>>>>>> a >>>>>>>> profile in the top pom.xml? What other steps are involved? I'm >>>>>>>> seeing >>>>>>>> info but some of it appears irrelevant (like the comments about >>>>>>>> multiple >>>>>>>> jars for the jdbc driver, for ex.). Is there a list that explains >>>>>>>> how >>>>>>>> to integrate a DB? >>>>>>>> >>>>>>>> Here's what appears to be the necessary steps: >>>>>>>> >>>>>>>> 1. create a profile for DB2 >>>>>>>> 2. somehow import the jar (actally a zip file in this case) into my >>>>>>>> project >>>>>>>> 3. set up hibernate to use the DB2 dialect (and where is this now? >>>>>>>> I'm >>>>>>>> also semi new to appfuse 2.x) >>>>>>>> >>>>>>>> Is that the correct set of steps? Is the complete process spelled >>>>>>>> out >>>>>>>> anywhere? >>>>>>>> >>>>>>>> thanks... >>>>>>>> >>>>>>>> --j >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> mraible wrote: >>>>>>>>> >>>>>>>>> You should be able to. I've tried to use the Derby Driver with DB2, >>>>>>>>> but it didn't work. The main issue we've had in adding DB2 support >>>>>>>>> is >>>>>>>>> the fact that it requires multiple JARs for its JDBC Driver. If you >>>>>>>>> can find a single JAR/artifact we can use, we'd be happy to add >>>>>>>>> support. In the meantime, there's two things you can do: >>>>>>>>> >>>>>>>>> 1. Replace all references to jdbc.* dependencies with the two >>>>>>>>> depdendencies that DB2 requires in pom.xml. >>>>>>>>> >>>>>>>>> 2. Create a pom that has a dependency on the two DB2 artifacts and >>>>>>>>> install it in your local repository. >>>>>>>>> >>>>>>>>> See the following entry (and comments) on my blog for more >>>>>>>>> solutions: >>>>>>>>> >>>>>>>>> http://raibledesigns.com/rd/entry/database_profiles_in_appfuse_2 >>>>>>>>> >>>>>>>>> Matt >>>>>>>>> >>>>>>>>> On 9/26/07, meisam4910 <[EMAIL PROTECTED]> wrote: >>>>>>>>>> >>>>>>>>>> does Appfuse work with IBM DB2 ? in its database list i could not >>>>>>>>>> found the >>>>>>>>>> DB2 name :(( is there any way to use DB2 with appfuse ? >>>>>>>>>> -- >>>>>>>>>> View this message in context: >>>>>>>>>> http://www.nabble.com/IBM-DB2-tf4521471s2369.html#a12898330 >>>>>>>>>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>>>>>>>>> >>>>>>>>>> --------------------------------------------------------------------- >>>>>>>>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>>>>>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> http://raibledesigns.com >>>>>>>>> >>>>>>>>> --------------------------------------------------------------------- >>>>>>>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>>>>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/IBM-DB2-tp12898330s2369p20079950.html >>>>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>>>> >>>>> >>>>> --------------------------------------------------------------------- >>>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>>> >>>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/IBM-DB2-tp12898330s2369p20092017.html >>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> > > -- > View this message in context: > http://www.nabble.com/IBM-DB2-tp12898330s2369p20099668.html > Sent from the AppFuse - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
