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]
