If you look in the pom file for your project you will see that there are several database profiles. Unfortunately DB2 is not one of them, but you will simply need to add a suitable profile for db2 to get things working.
In the same pom file you will find a configuration for the hibernate3-maven-plugin, which is the plugin that generates the scripts used to create the database. In normal mode this works directly on the database ( i.e. does not generate the scripts), but you can change this behaviour by changing the configuration of the plugin: In the section <componentProperties> add the following: <outputfileaname>myproject-schema.sql</outputfilename> Once you run mvn hibernate3:hbm2ddl, you will find the sql script you want under target/hibernate3/sql/myproject-schema.sql. Please see http://mojo.codehaus.org/maven-hibernate3/hibernate3-maven-plugin/ for further configuration options for the hibernate3 maven plugin. Mike. On 4/30/07, Bajaj, Deepak <[EMAIL PROTECTED]> wrote:
That's ok. How do I create the appropriate and correct tables in DB/2 to suppor the user and role in DB2. Presently MYSQL is using bitmap columns for permissions, DB2 does not have this as a datatype. I wonder, how do I get or generate the right and appropriate script for table creation for DB2. Table creation needs to be done by a different deptt, and we need to provide a DDL script for same. Rgds, Deepak -----Original Message----- From: Christopher Love [mailto:[EMAIL PROTECTED] Sent: Monday, April 30, 2007 1:59 PM To: [email protected] Subject: Re: [appfuse-user] Switch database from mySQL to Db/2 using JNDI datasources You need too change your dataSource bean in the applicationContext-resources.xml file. Have this point too a jndi context factory. Example: <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" value="jdbc/YOURDS"/> </bean> On 4/30/07, Bajju <[EMAIL PROTECTED]> wrote: > > Any idea how I wuld accompalish above? > > basically, we wish to do following. > > (1) Use JNDI datasources (on websphere 6.1.x), instead of spring managed. > > (2) Use DB/2 instead of MySQL > > Rgds, > Deepak BAJAJ > -- > View this message in context: > http://www.nabble.com/Switch-database-from-mySQL-to-Db-2-using-JNDI-da > tasources-tf3670931s2369.html#a10257492 > Sent from the AppFuse - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Chris Love ph. 303 929.8509 --------------------------------------------------------------------- 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]
