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]
