Re: Hours/Size for estimation

--===============1619147376==
Content-Type: multipart/alternative; 
	boundary="----=_Part_65237_19329207.1178029492824"

------=_Part_65237_19329207.1178029492824
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.sqlfile.  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

------=_Part_65237_19329207.1178029492824
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 5/1/07, <b class="gmail_sendername">Jeff Morgan</b> &lt;<a href="mailto:[email protected]">[email protected]</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Jacques,<br><br>1) Is it possible to use another DBMS like Oracle?&nbsp; <br></blockquote></div><br>I have started to modify the build to use oracle.&nbsp; I created a xplanner-custom.properties<br>with the following values set:<br>
<br>hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerOracleDialect<br>hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver<br>#hibernate.connection.database=xplanner<br>xplanner.migration.databasetype=oracle
<br>hibernate.connection.url=jdbc:oracle:thin:@blah:devl<br>hibernate.connection.username=blah<br>hibernate.connection.password=blahblah<br>xplanner.hibernate.mappingtransform=oracle-mapping-transform.xsl<br>hibernate.show_sql=false
<br><br>I am not sure if the databasetype is set properly.&nbsp; When I run the install.db.schema<br>target I get an error when it tries to execute the patch0001_0-6-0.sql file.&nbsp; Clearly<br>this file will not execute on oracle.&nbsp; In the 
xplanner.properties file it is setting the<br>xplanner.migration.patchpath to the default value which is:<br><br>patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install<br><br>Is this correct for Oracle?&nbsp; If not, what should this be?&nbsp; What else do I need
<br>to change to use Oracle?<br><br>Thanks for your help.<br>-Jeff<br><br><br>

------=_Part_65237_19329207.1178029492824--


--===============1619147376==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-------------------------------------------------------------------------
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/
--===============1619147376==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel

--===============1619147376==--