Hey, Is this the link you refer to?:
http://raibledesigns.com/rd/entry/database_profiles_in_appfuse_2 tia... --jack mraible wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/IBM-DB2-tp12898330s2369p20214174.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]
