Re: Hours/Size for estimation

Read http://xplanner.codehaus.org/Autopatch to understand how the
database management works and is supposed to be extended for other
databases.

Let me know if you any more questions.

Jacques

On 5/1/07, Jeff Morgan <[email protected]> wrote:
> On 5/1/07, Jeff Morgan <[email protected]> wrote:
> > Jacques,
> >
> > 1) Is it possible to use another DBMS like Oracle?
> >
>
> I have started to modify the build to use oracle.  I created a
> xplanner-custom.properties
> with the following values set:
>
> hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerOracleDialect
> hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
> #hibernate.connection.database=xplanner
> xplanner.migration.databasetype=oracle
> hibernate.connection.url=jdbc:oracle:thin:@blah:devl
> hibernate.connection.username=blah
> hibernate.connection.password=blahblah
> xplanner.hibernate.mappingtransform=oracle-mapping-transform.xsl
> hibernate.show_sql=false
>
> I am not sure if the databasetype is set properly.  When I run the
> install.db.schema
> target I get an error when it tries to execute the patch0001_0-6-0.sql file.
>  Clearly
> this file will not execute on oracle.  In the xplanner.properties file it is
> setting the
> xplanner.migration.patchpath to the default value which is:
>
> patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install
>
> Is this correct for Oracle?  If not, what should this be?  What else do I
> need
> to change to use Oracle?
>
> Thanks for your help.
> -Jeff
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Xplanner-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/xplanner-devel
>
>

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/