Stopping Events for Repeats

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

Stopping Events for Repeats

Ryan Puddephatt

Hi all,   

            Just a query about whether there is a way to stop events and formatting for the <xforms:repeat> in my application I’m using the repeat to display data, nothing will change with the data and I don’t need to monitor the users movement around repeat, nor do I need the yellow bar for selection. I have used CSS to stop the formatting, but notice that OPS is going back and forth when I click on the repeat. Is it possible to disable this?

 

Thanks

 

Ryan Puddephatt

Web Developer

TFX Group

1 Michaelson Square

Livingston

West Lothian

Scotand

EH54 7DP

 

* [hidden email]

( 01506 407 110

7  01506 407 108

 

 



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

sql type date vs. xs type datetime

Sebastian Kraus/INPLUS/DE

Hi,


I have some problems getting date typed data from a oracle DB (version 8 - 10) with ops3.0beta.
In my opinion the oracle sql type "date" corresponds with the xs type "datetime".
Ops3.0beta throws an error and expects xs:date type.
But in this case, hours, minutes and seconds are cutted of.
I remember that the mapping from sql type "date" to xs type xs:datetime was no problem.

Is there a special reason of this behaviour, cause Oracle does not have a type datetime, only timestamp which is a variable datatype, as far as I know.

Regards

Sebastian



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Stopping Events for Repeats

Erik Bruchez
Administrator
In reply to this post by Ryan Puddephatt
Ryan,

There is currently no way to disable this.

-Erik

Ryan Puddephatt wrote:

> Hi all,  
>
>             Just a query about whether there is a way to stop events and
> formatting for the <xforms:repeat> in my application I’m using the
> repeat to display data, nothing will change with the data and I don’t
> need to monitor the users movement around repeat, nor do I need the
> yellow bar for selection. I have used CSS to stop the formatting, but
> notice that OPS is going back and forth when I click on the repeat. Is
> it possible to disable this?
>
>  
>
> Thanks
>
>  
>
> *Ryan Puddephatt*
>
> Web Developer
>
> TFX Group
>
> 1 Michaelson Square
>
> Livingston
>
> West Lothian
>
> Scotand
>
> EH54 7DP
>
>  
>
> * [hidden email]
>
> ( 01506 407 110
>
> 7  01506 407 108


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Alessandro  Vernet
Administrator
In reply to this post by Sebastian Kraus/INPLUS/DE
Hi Sebastian,

What is the exception you are getting? Also, can you send the section
of the XPL file where you call the SQL processor?

Alex

On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:

>
> Hi,
>
>
> I have some problems getting date typed data from a oracle DB (version 8 -
> 10) with ops3.0beta.
> In my opinion the oracle sql type "date" corresponds with the xs type
> "datetime".
> Ops3.0beta throws an error and expects xs:date type.
> But in this case, hours, minutes and seconds are cutted of.
> I remember that the mapping from sql type "date" to xs type xs:datetime was
> no problem.
>
> Is there a special reason of this behaviour, cause Oracle does not have a
> type datetime, only timestamp which is a variable datatype, as far as I
> know.
>
> Regards
>
> Sebastian
>
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>

--
Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Sebastian Kraus/INPLUS/DE

Hi Alex,

I get following exeption:
Illegal XML type for SQL type: {http://www.w3.org/2001/XMLSchema}dateTime, DATE

the sql Prozessore call looks like this:

  <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql">
        <p:input name="data" href="#data"/>
        <p:input name="config">
            <sql:config>
                <sql:connection>
                    <sql:datasource>mySource</sql:datasource>                
                    <sql:execute>                        
                        <sql:query>                
                            select
                                *
                            from
                                OBJECTS
                            where
                                O_ID = <sql:param type="xs:string"  select="test/RequestParams/ID" />
                       </sql:query>
                           
                       <sql:result-set>                          
                                <Objects>
                                    <sql:row-iterator>  
                                      <Object>                                                                                      
                                            <ID><sql:get-column-value type="xs:decimal" column="O_ID"/></ID>                                            
                                            <Name><sql:get-column type="xs:string" column="O_NAME"/></Name>
                                              <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate>                                              
                                        </Object>
                                        </sql:row-iterator>                                            
                                </Objects>
                            </Response>
                        </sql:result-set>
                        <sql:no-results>
                            <Response>some response</Response>
                        </sql:no-results>
                    </sql:execute>
                </sql:connection>
            </sql:config>
        </p:input>
        <p:output name="data" ref="data"/>
    </p:processor>


The line <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate>                        

is the important one. If type is set to xs:date, i get data, but without houres, minutes and seconds.

Sebastian




Alessandro Vernet <[hidden email]>
Sent by: [hidden email]

14.12.2005 05:07

Please respond to
[hidden email]

To
[hidden email]
cc
Subject
Re: [ops-users] sql type date vs. xs type datetime





Hi Sebastian,

What is the exception you are getting? Also, can you send the section
of the XPL file where you call the SQL processor?

Alex

On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:
>
> Hi,
>
>
> I have some problems getting date typed data from a oracle DB (version 8 -
> 10) with ops3.0beta.
> In my opinion the oracle sql type "date" corresponds with the xs type
> "datetime".
> Ops3.0beta throws an error and expects xs:date type.
> But in this case, hours, minutes and seconds are cutted of.
> I remember that the mapping from sql type "date" to xs type xs:datetime was
> no problem.
>
> Is there a special reason of this behaviour, cause Oracle does not have a
> type datetime, only timestamp which is a variable datatype, as far as I
> know.
>
> Regards
>
> Sebastian
>
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>


--
Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Sebastian Kraus/INPLUS/DE

Hi,

ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We implemented it within an own SQL-Prozessor.
So here is the Problem in a new light.
"The oracle datatype "date" supports hours,minutes and seconds. The Xml Schema Type date only supports year,month and day. So the time part is cutted of.
The sql processor should be able to provide both xml types, date and datetime, if getting some date data from oracle."

Regards

Sebastian Kraus



"Sebastian Kraus/INPLUS/DE" <[hidden email]>

14.12.2005 11:38

Please respond to
[hidden email]

To
[hidden email]
cc
Subject
Re: [ops-users] sql type date vs. xs type datetime






Hi Alex,


I get following exeption:

Illegal XML type for SQL type: {http://www.w3.org/2001/XMLSchema}dateTime, DATE


the sql Prozessore call looks like this:


 <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql">

       <p:input name="data" href="#data"/>

       <p:input name="config">

           <sql:config>

               <sql:connection>

                   <sql:datasource>mySource</sql:datasource>                
                   <sql:execute>                        

                       <sql:query>                

                           select
                               *

                           from

                               OBJECTS

                           where
                               O_ID = <sql:param type="xs:string"  select="test/RequestParams/ID" />

                      </sql:query>

                         
 
                      <sql:result-set>                          
                               <Objects>

                                   <sql:row-iterator>  
                                     <Object>                                                                                      
                                           <ID><sql:get-column-value type="xs:decimal" column="O_ID"/></ID>                                            

                                           <Name><sql:get-column type="xs:string" column="O_NAME"/></Name>

                                             <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate>                                              
                                       </Object>

                                       </sql:row-iterator>                                            

                               </Objects>

                           </Response>

                       </sql:result-set>

                       <sql:no-results>

                           <Response>some response</Response>

                       </sql:no-results>

                   </sql:execute>

               </sql:connection>

           </sql:config>

       </p:input>

       <p:output name="data" ref="data"/>

   </p:processor>



The line <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate>                        


is the important one. If type is set to xs:date, i get data, but without houres, minutes and seconds.


Sebastian




Alessandro Vernet <[hidden email]>
Sent by: [hidden email]

14.12.2005 05:07

Please respond to
[hidden email]

To
[hidden email]
cc
Subject
Re: [ops-users] sql type date vs. xs type datetime







Hi Sebastian,

What is the exception you are getting? Also, can you send the section
of the XPL file where you call the SQL processor?

Alex

On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:
>
> Hi,
>
>
> I have some problems getting date typed data from a oracle DB (version 8 -
> 10) with ops3.0beta.
> In my opinion the oracle sql type "date" corresponds with the xs type
> "datetime".
> Ops3.0beta throws an error and expects xs:date type.
> But in this case, hours, minutes and seconds are cutted of.
> I remember that the mapping from sql type "date" to xs type xs:datetime was
> no problem.
>
> Is there a special reason of this behaviour, cause Oracle does not have a
> type datetime, only timestamp which is a variable datatype, as far as I
> know.
>
> Regards
>
> Sebastian
>
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>


--
Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Erik Bruchez
Administrator
Sebastian,

I entered a bug to track this:

http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207

Can you please read the description and confirm that it describes your
issue?

-Erik

Sebastian Kraus/INPLUS/DE wrote:

>
> Hi,
>
> ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We
> implemented it within an own SQL-Prozessor.
> So here is the Problem in a new light.
> "The oracle datatype "date" supports hours,minutes and seconds. The Xml
> Schema Type date only supports year,month and day. So the time part is
> cutted of.
> The sql processor should be able to provide both xml types, date and
> datetime, if getting some date data from oracle."
>
> Regards
>
> Sebastian Kraus
>
>
>
> *"Sebastian Kraus/INPLUS/DE" <[hidden email]>*
>
> 14.12.2005 11:38
> Please respond to
> [hidden email]
>
>
>
> To
> [hidden email]
> cc
>
> Subject
> Re: [ops-users] sql type date vs. xs type datetime
>
>
>
>
>
>
>
>
>
> Hi Alex,
>
> I get following exeption:
> Illegal XML type for SQL type:
> {http://www.w3.org/2001/XMLSchema}dateTime, DATE
>
> the sql Prozessore call looks like this:
>
>  <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql">
>        <p:input name="data" href="#data"/>
>        <p:input name="config">
>            <sql:config>
>                <sql:connection>
>                    <sql:datasource>mySource</sql:datasource>            
>    
>                    <sql:execute>                        
>                        <sql:query>                
>                            select
>                                *
>                            from
>                                OBJECTS
>                            where
>                                O_ID = <sql:param type="xs:string"
>  select="test/RequestParams/ID" />
>                       </sql:query>
>                            
>                       <sql:result-set>                          
>                                <Objects>
>                                    <sql:row-iterator>  
>                                      <Object>                          
>                                                            
>                                            <ID><sql:get-column-value
> type="xs:decimal" column="O_ID"/></ID>                                  
>          
>                                            <Name><sql:get-column
> type="xs:string" column="O_NAME"/></Name>
>                                            
>  <LastChangeDate><sql:get-column type="xs:dateTime"
> column="O_LCDATE"/></LastChangeDate>                                    
>          
>                                        </Object>
>                                        </sql:row-iterator>              
>                              
>                                </Objects>
>                            </Response>
>                        </sql:result-set>
>                        <sql:no-results>
>                            <Response>some response</Response>
>                        </sql:no-results>
>                    </sql:execute>
>                </sql:connection>
>            </sql:config>
>        </p:input>
>        <p:output name="data" ref="data"/>
>    </p:processor>
>
>
> The line <LastChangeDate><sql:get-column type="xs:dateTime"
> column="O_LCDATE"/></LastChangeDate>                        
>
> is the important one. If type is set to xs:date, i get data, but without
> houres, minutes and seconds.
>
> Sebastian
>
>
>
> *Alessandro Vernet <[hidden email]>*
> Sent by: [hidden email]
>
> 14.12.2005 05:07
> Please respond to
> [hidden email]
>
>
> To
> [hidden email]
> cc
>
> Subject
> Re: [ops-users] sql type date vs. xs type datetime
>
>
>
>
>
>
>
>
>
>
> Hi Sebastian,
>
> What is the exception you are getting? Also, can you send the section
> of the XPL file where you call the SQL processor?
>
> Alex
>
> On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:
>  >
>  > Hi,
>  >
>  >
>  > I have some problems getting date typed data from a oracle DB
> (version 8 -
>  > 10) with ops3.0beta.
>  > In my opinion the oracle sql type "date" corresponds with the xs type
>  > "datetime".
>  > Ops3.0beta throws an error and expects xs:date type.
>  > But in this case, hours, minutes and seconds are cutted of.
>  > I remember that the mapping from sql type "date" to xs type
> xs:datetime was
>  > no problem.
>  >
>  > Is there a special reason of this behaviour, cause Oracle does not have a
>  > type datetime, only timestamp which is a variable datatype, as far as I
>  > know.
>  >
>  > Regards
>  >
>  > Sebastian
>  >
>  >
>  >
>  > --
>  > You receive this message as a subscriber of the [hidden email]
>  > mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  >
>  >
>  >
>
>
> --
> Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Sebastian Kraus/INPLUS/DE

Hi Erik,

your bug post is a little bit old but I did not see your answer. Now I'm facing this problem again.
So here is my confirmation :-)
Did something change until now?

Regards

Sebastian


Erik Bruchez <[hidden email]>
Sent by: Erik Bruchez <[hidden email]>

16.12.2005 22:47

Please respond to
[hidden email]

To
[hidden email]
cc
Subject
Re: [ops-users] sql type date vs. xs type datetime





Sebastian,

I entered a bug to track this:

http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207

Can you please read the description and confirm that it describes your
issue?

-Erik

Sebastian Kraus/INPLUS/DE wrote:
>
> Hi,
>
> ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We
> implemented it within an own SQL-Prozessor.
> So here is the Problem in a new light.
> "The oracle datatype "date" supports hours,minutes and seconds. The Xml
> Schema Type date only supports year,month and day. So the time part is
> cutted of.
> The sql processor should be able to provide both xml types, date and
> datetime, if getting some date data from oracle."
>
> Regards
>
> Sebastian Kraus
>
>
>
> *"Sebastian Kraus/INPLUS/DE" <[hidden email]>*
>
> 14.12.2005 11:38
> Please respond to
> [hidden email]
>
>
>                  
> To
>                  [hidden email]
> cc
>                  
> Subject
>                  Re: [ops-users] sql type date vs. xs type datetime
>
>
>                  
>
>
>
>
>
>
> Hi Alex,
>
> I get following exeption:
> Illegal XML type for SQL type:
> {http://www.w3.org/2001/XMLSchema}dateTime, DATE
>
> the sql Prozessore call looks like this:
>
>  <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql">
>        <p:input name="data" href="#data"/>
>        <p:input name="config">
>            <sql:config>
>                <sql:connection>
>                    <sql:datasource>mySource</sql:datasource>            
>    
>                    <sql:execute>                        
>                        <sql:query>                
>                            select
>                                *
>                            from
>                                OBJECTS
>                            where
>                                O_ID = <sql:param type="xs:string"
>  select="test/RequestParams/ID" />
>                       </sql:query>
>                            
>                       <sql:result-set>                          
>                                <Objects>
>                                    <sql:row-iterator>  
>                                      <Object>                          
>                                                            
>                                            <ID><sql:get-column-value
> type="xs:decimal" column="O_ID"/></ID>                                  
>          
>                                            <Name><sql:get-column
> type="xs:string" column="O_NAME"/></Name>
>                                            
>  <LastChangeDate><sql:get-column type="xs:dateTime"
> column="O_LCDATE"/></LastChangeDate>                                    
>          
>                                        </Object>
>                                        </sql:row-iterator>              
>                              
>                                </Objects>
>                            </Response>
>                        </sql:result-set>
>                        <sql:no-results>
>                            <Response>some response</Response>
>                        </sql:no-results>
>                    </sql:execute>
>                </sql:connection>
>            </sql:config>
>        </p:input>
>        <p:output name="data" ref="data"/>
>    </p:processor>
>
>
> The line <LastChangeDate><sql:get-column type="xs:dateTime"
> column="O_LCDATE"/></LastChangeDate>                        
>
> is the important one. If type is set to xs:date, i get data, but without
> houres, minutes and seconds.
>
> Sebastian
>
>
>
> *Alessandro Vernet <[hidden email]>*
> Sent by: [hidden email]
>
> 14.12.2005 05:07
> Please respond to
> [hidden email]
>
>                  
> To
>                  [hidden email]
> cc
>                  
> Subject
>                  Re: [ops-users] sql type date vs. xs type datetime
>
>
>
>                  
>
>
>
>
>
>
> Hi Sebastian,
>
> What is the exception you are getting? Also, can you send the section
> of the XPL file where you call the SQL processor?
>
> Alex
>
> On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:
>  >
>  > Hi,
>  >
>  >
>  > I have some problems getting date typed data from a oracle DB
> (version 8 -
>  > 10) with ops3.0beta.
>  > In my opinion the oracle sql type "date" corresponds with the xs type
>  > "datetime".
>  > Ops3.0beta throws an error and expects xs:date type.
>  > But in this case, hours, minutes and seconds are cutted of.
>  > I remember that the mapping from sql type "date" to xs type
> xs:datetime was
>  > no problem.
>  >
>  > Is there a special reason of this behaviour, cause Oracle does not have a
>  > type datetime, only timestamp which is a variable datatype, as far as I
>  > know.
>  >
>  > Regards
>  >
>  > Sebastian
>  >
>  >
>  >
>  > --
>  > You receive this message as a subscriber of the [hidden email]
>  > mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  >
>  >
>  >
>
>
> --
> Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Erik Bruchez
Administrator
Sebastian,

The bug is still open so I don't think it has been fixed.

-Erik

Sebastian Kraus/INPLUS/DE wrote:

>
> Hi Erik,
>
> your bug post is a little bit old but I did not see your answer. Now I'm
> facing this problem again.
> So here is my confirmation :-)
> Did something change until now?
>
> Regards
>
> Sebastian
>
>
> *Erik Bruchez <[hidden email]>*
> Sent by: Erik Bruchez <[hidden email]>
>
> 16.12.2005 22:47
> Please respond to
> [hidden email]
>
>
>
> To
> [hidden email]
> cc
>
> Subject
> Re: [ops-users] sql type date vs. xs type datetime
>
>
>
>
>
>
>
>
> Sebastian,
>
> I entered a bug to track this:
>
> http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207
>
> Can you please read the description and confirm that it describes your
> issue?
>
> -Erik
>
> Sebastian Kraus/INPLUS/DE wrote:
>  >
>  > Hi,
>  >
>  > ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We
>  > implemented it within an own SQL-Prozessor.
>  > So here is the Problem in a new light.
>  > "The oracle datatype "date" supports hours,minutes and seconds. The Xml
>  > Schema Type date only supports year,month and day. So the time part is
>  > cutted of.
>  > The sql processor should be able to provide both xml types, date and
>  > datetime, if getting some date data from oracle."
>  >
>  > Regards
>  >
>  > Sebastian Kraus
>  >
>  >
>  >
>  > *"Sebastian Kraus/INPLUS/DE" <[hidden email]>*
>  >
>  > 14.12.2005 11:38
>  > Please respond to
>  > [hidden email]
>  >
>  >
>  >                  
>  > To
>  >                  [hidden email]
>  > cc
>  >                  
>  > Subject
>  >                  Re: [ops-users] sql type date vs. xs type datetime
>  >
>  >
>  >                  
>  >
>  >
>  >
>  >
>  >
>  >
>  > Hi Alex,
>  >
>  > I get following exeption:
>  > Illegal XML type for SQL type:
>  > {http://www.w3.org/2001/XMLSchema}dateTime, DATE
>  >
>  > the sql Prozessore call looks like this:
>  >
>  >  <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql">
>  >        <p:input name="data" href="#data"/>
>  >        <p:input name="config">
>  >            <sql:config>
>  >                <sql:connection>
>  >                    <sql:datasource>mySource</sql:datasource>            
>  >    
>  >                    <sql:execute>                        
>  >                        <sql:query>                
>  >                            select
>  >                                *
>  >                            from
>  >                                OBJECTS
>  >                            where
>  >                                O_ID = <sql:param type="xs:string"
>  >  select="test/RequestParams/ID" />
>  >                       </sql:query>
>  >                            
>  >                       <sql:result-set>                          
>  >                                <Objects>
>  >                                    <sql:row-iterator>  
>  >                                      <Object>                          
>  >                                                            
>  >                                            <ID><sql:get-column-value
>  > type="xs:decimal" column="O_ID"/></ID>                                  
>  >          
>  >                                            <Name><sql:get-column
>  > type="xs:string" column="O_NAME"/></Name>
>  >                                            
>  >  <LastChangeDate><sql:get-column type="xs:dateTime"
>  > column="O_LCDATE"/></LastChangeDate>                                    
>  >          
>  >                                        </Object>
>  >                                        </sql:row-iterator>              
>  >                              
>  >                                </Objects>
>  >                            </Response>
>  >                        </sql:result-set>
>  >                        <sql:no-results>
>  >                            <Response>some response</Response>
>  >                        </sql:no-results>
>  >                    </sql:execute>
>  >                </sql:connection>
>  >            </sql:config>
>  >        </p:input>
>  >        <p:output name="data" ref="data"/>
>  >    </p:processor>
>  >
>  >
>  > The line <LastChangeDate><sql:get-column type="xs:dateTime"
>  > column="O_LCDATE"/></LastChangeDate>                        
>  >
>  > is the important one. If type is set to xs:date, i get data, but without
>  > houres, minutes and seconds.
>  >
>  > Sebastian
>  >
>  >
>  >
>  > *Alessandro Vernet <[hidden email]>*
>  > Sent by: [hidden email]
>  >
>  > 14.12.2005 05:07
>  > Please respond to
>  > [hidden email]
>  >
>  >                  
>  > To
>  >                  [hidden email]
>  > cc
>  >                  
>  > Subject
>  >                  Re: [ops-users] sql type date vs. xs type datetime
>  >
>  >
>  >
>  >                  
>  >
>  >
>  >
>  >
>  >
>  >
>  > Hi Sebastian,
>  >
>  > What is the exception you are getting? Also, can you send the section
>  > of the XPL file where you call the SQL processor?
>  >
>  > Alex
>  >
>  > On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:
>  >  >
>  >  > Hi,
>  >  >
>  >  >
>  >  > I have some problems getting date typed data from a oracle DB
>  > (version 8 -
>  >  > 10) with ops3.0beta.
>  >  > In my opinion the oracle sql type "date" corresponds with the xs type
>  >  > "datetime".
>  >  > Ops3.0beta throws an error and expects xs:date type.
>  >  > But in this case, hours, minutes and seconds are cutted of.
>  >  > I remember that the mapping from sql type "date" to xs type
>  > xs:datetime was
>  >  > no problem.
>  >  >
>  >  > Is there a special reason of this behaviour, cause Oracle does not
> have a
>  >  > type datetime, only timestamp which is a variable datatype, as far
> as I
>  >  > know.
>  >  >
>  >  > Regards
>  >  >
>  >  > Sebastian
>  >  >
>  >  >
>  >  >
>  >  > --
>  >  > You receive this message as a subscriber of the
> [hidden email]
>  >  > mailing list.
>  >  > To unsubscribe: mailto:[hidden email]
>  >  > For general help: mailto:[hidden email]?subject=help
>  >  > ObjectWeb mailing lists service home page:
> http://www.objectweb.org/wws
>  >  >
>  >  >
>  >  >
>  >
>  >
>  > --
>  > Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/
>  >
>  >
>  > --
>  > You receive this message as a subscriber of the [hidden email]
>  > mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  >
>  > --
>  > You receive this message as a subscriber of the [hidden email]
>  > mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  >
>  >
>  > ------------------------------------------------------------------------
>  >
>  >
>  > --
>  > You receive this message as a subscriber of the
> [hidden email] mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: sql type date vs. xs type datetime

Sebastian Kraus/INPLUS/DE

Ok,

so I will try to write a workaround or I even touch the source. I will post the results.

Sebastian


Erik Bruchez <[hidden email]>
Sent by: Erik Bruchez <[hidden email]>

14.06.2006 02:00

Please respond to
[hidden email]

To
[hidden email]
cc
Subject
Re: [ops-users] sql type date vs. xs type datetime





Sebastian,

The bug is still open so I don't think it has been fixed.

-Erik

Sebastian Kraus/INPLUS/DE wrote:
>
> Hi Erik,
>
> your bug post is a little bit old but I did not see your answer. Now I'm
> facing this problem again.
> So here is my confirmation :-)
> Did something change until now?
>
> Regards
>
> Sebastian
>
>
> *Erik Bruchez <[hidden email]>*
> Sent by: Erik Bruchez <[hidden email]>
>
> 16.12.2005 22:47
> Please respond to
> [hidden email]
>
>
>                  
> To
>                  [hidden email]
> cc
>                  
> Subject
>                  Re: [ops-users] sql type date vs. xs type datetime
>
>
>                  
>
>
>
>
>
> Sebastian,
>
> I entered a bug to track this:
>
> http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207
>
> Can you please read the description and confirm that it describes your
> issue?
>
> -Erik
>
> Sebastian Kraus/INPLUS/DE wrote:
>  >
>  > Hi,
>  >
>  > ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We
>  > implemented it within an own SQL-Prozessor.
>  > So here is the Problem in a new light.
>  > "The oracle datatype "date" supports hours,minutes and seconds. The Xml
>  > Schema Type date only supports year,month and day. So the time part is
>  > cutted of.
>  > The sql processor should be able to provide both xml types, date and
>  > datetime, if getting some date data from oracle."
>  >
>  > Regards
>  >
>  > Sebastian Kraus
>  >
>  >
>  >
>  > *"Sebastian Kraus/INPLUS/DE" <[hidden email]>*
>  >
>  > 14.12.2005 11:38
>  > Please respond to
>  > [hidden email]
>  >
>  >
>  >                  
>  > To
>  >                  [hidden email]
>  > cc
>  >                  
>  > Subject
>  >                  Re: [ops-users] sql type date vs. xs type datetime
>  >
>  >
>  >                  
>  >
>  >
>  >
>  >
>  >
>  >
>  > Hi Alex,
>  >
>  > I get following exeption:
>  > Illegal XML type for SQL type:
>  > {http://www.w3.org/2001/XMLSchema}dateTime, DATE
>  >
>  > the sql Prozessore call looks like this:
>  >
>  >  <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql">
>  >        <p:input name="data" href="#data"/>
>  >        <p:input name="config">
>  >            <sql:config>
>  >                <sql:connection>
>  >                    <sql:datasource>mySource</sql:datasource>            
>  >    
>  >                    <sql:execute>                        
>  >                        <sql:query>                
>  >                            select
>  >                                *
>  >                            from
>  >                                OBJECTS
>  >                            where
>  >                                O_ID = <sql:param type="xs:string"
>  >  select="test/RequestParams/ID" />
>  >                       </sql:query>
>  >                            
>  >                       <sql:result-set>                          
>  >                                <Objects>
>  >                                    <sql:row-iterator>  
>  >                                      <Object>                          
>  >                                                            
>  >                                            <ID><sql:get-column-value
>  > type="xs:decimal" column="O_ID"/></ID>                                  
>  >          
>  >                                            <Name><sql:get-column
>  > type="xs:string" column="O_NAME"/></Name>
>  >                                            
>  >  <LastChangeDate><sql:get-column type="xs:dateTime"
>  > column="O_LCDATE"/></LastChangeDate>                                    
>  >          
>  >                                        </Object>
>  >                                        </sql:row-iterator>              
>  >                              
>  >                                </Objects>
>  >                            </Response>
>  >                        </sql:result-set>
>  >                        <sql:no-results>
>  >                            <Response>some response</Response>
>  >                        </sql:no-results>
>  >                    </sql:execute>
>  >                </sql:connection>
>  >            </sql:config>
>  >        </p:input>
>  >        <p:output name="data" ref="data"/>
>  >    </p:processor>
>  >
>  >
>  > The line <LastChangeDate><sql:get-column type="xs:dateTime"
>  > column="O_LCDATE"/></LastChangeDate>                        
>  >
>  > is the important one. If type is set to xs:date, i get data, but without
>  > houres, minutes and seconds.
>  >
>  > Sebastian
>  >
>  >
>  >
>  > *Alessandro Vernet <[hidden email]>*
>  > Sent by: [hidden email]
>  >
>  > 14.12.2005 05:07
>  > Please respond to
>  > [hidden email]
>  >
>  >                  
>  > To
>  >                  [hidden email]
>  > cc
>  >                  
>  > Subject
>  >                  Re: [ops-users] sql type date vs. xs type datetime
>  >
>  >
>  >
>  >                  
>  >
>  >
>  >
>  >
>  >
>  >
>  > Hi Sebastian,
>  >
>  > What is the exception you are getting? Also, can you send the section
>  > of the XPL file where you call the SQL processor?
>  >
>  > Alex
>  >
>  > On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote:
>  >  >
>  >  > Hi,
>  >  >
>  >  >
>  >  > I have some problems getting date typed data from a oracle DB
>  > (version 8 -
>  >  > 10) with ops3.0beta.
>  >  > In my opinion the oracle sql type "date" corresponds with the xs type
>  >  > "datetime".
>  >  > Ops3.0beta throws an error and expects xs:date type.
>  >  > But in this case, hours, minutes and seconds are cutted of.
>  >  > I remember that the mapping from sql type "date" to xs type
>  > xs:datetime was
>  >  > no problem.
>  >  >
>  >  > Is there a special reason of this behaviour, cause Oracle does not
> have a
>  >  > type datetime, only timestamp which is a variable datatype, as far
> as I
>  >  > know.
>  >  >
>  >  > Regards
>  >  >
>  >  > Sebastian
>  >  >
>  >  >
>  >  >
>  >  > --
>  >  > You receive this message as a subscriber of the
> [hidden email]
>  >  > mailing list.
>  >  > To unsubscribe: mailto:[hidden email]
>  >  > For general help: mailto:[hidden email]?subject=help
>  >  > ObjectWeb mailing lists service home page:
> http://www.objectweb.org/wws
>  >  >
>  >  >
>  >  >
>  >
>  >
>  > --
>  > Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/
>  >
>  >
>  > --
>  > You receive this message as a subscriber of the [hidden email]
>  > mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  >
>  > --
>  > You receive this message as a subscriber of the [hidden email]
>  > mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  >
>  >
>  > ------------------------------------------------------------------------
>  >
>  >
>  > --
>  > You receive this message as a subscriber of the
> [hidden email] mailing list.
>  > To unsubscribe: mailto:[hidden email]
>  > For general help: mailto:[hidden email]?subject=help
>  > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws


--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws