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. 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]
