Re: MySQL and MSSQL in same java application

"Franck Routier [email protected] [SimpleORM]" <[email protected]> Fri, 07 Nov 2014 09:08:42 +0100
Newsgroups gmane.comp.java.orm.simpleorm
Message-ID <[email protected]>
--------------010203010106050106000202
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi all,

just a note to say we (at axege.com) are using it on a daily basis in 
our product, and deployed in production on about 30 sites, mainly 
hospitals in France and Switzerland.
SimpleORM is not evolving a lot as it has the features we need now... 
and it is mainly bug less !

You can go ahead using it, you won't be left totally alone :-)

Best regards,
Franck


Le 07/11/2014 04:15, anthony berglas [email protected] [SimpleORM] a 
écrit :
> Ha!  There lies the rub.  It is a Hibernate world, in all its glory. 
> And about 5% of it is actually useful.
>
> If you find something let me know.  All I have seen is rubbish. Lots 
> of mapping to objects using reflection, nothing useful.  What is 
> wanted is something simple.
>
> A project that I am working on now has some very simple code (not 
> written by me) that just wraps SQL, sample below.  You could knock 
> something up yourself like that pretty quick.  If you make it into a 
> clean module please post it to this list.  But that still leaves many 
> issues.
>
> Or just use SimpleOrm.  If you like it pull the current from SVN. But 
> you will need to maintain it yourself, I have no time for it.  But it 
> is simple.
>
> Anthony
>
>     private PreparedStatement executeInner(String sql, String sqlcmd, 
> Object... params) throws SQLException {
>         long start = System.currentTimeMillis();
>         boolean ok = false;
>         count = -1;
>         PreparedStatement stmt = null;
>
>         try {
>             stmt = dbconn.prepareStatement(sql);
>             setParams(stmt, params);
>             if (!stmt.execute()) { // returns false if result is count
>                 count = stmt.getUpdateCount();
>             }
>             ok = true;
>             return stmt;
>         } finally {
>             if (stmt != null) stmt.close
>             long timeTaken = System.currentTimeMillis() - start;
>             log.debug(format("sql: %08x : %s : %s : %d : %05dms : %s : 
> %s\n",
>                     dbconn.hashCode(), sqlcmd, ok ? "ok" : "error", count,
>                     timeTaken, sql, JSON.stringify(params)));
>         }
>     }
>
>
> On Fri, Nov 7, 2014 at 11:41 AM, John Abraham [email protected] 
> <mailto:[email protected]> [SimpleORM] <[email protected] 
> <mailto:[email protected]>> wrote:
>
>>     (But SimpleOrm has minimal support these days.)
>
>     Any recommendations for alternatives?  I refuse to use Hibernate...
>
>     --
>     John Abraham
>
>     Sent from my iPhone, please excuse any typos.
>
>     On Nov 6, 2014, at 5:25 PM, anthony berglas [email protected]
>     <mailto:[email protected]> [SimpleORM]
>     <[email protected] <mailto:[email protected]>> wrote:
>
>>     Should be OK.  There is no global state.
>>
>>     (But SimpleOrm has minimal support these days.)
>>
>>     Anthony
>>
>>     On Thu, Nov 6, 2014 at 10:31 PM, [email protected]
>>     <mailto:[email protected]> [SimpleORM]
>>     <[email protected] <mailto:[email protected]>> wrote:
>>
>>         Hi
>>
>>
>>         Is it a problem for SimpleORM to have one java thread talking
>>         to MySql and MSSQL at the same time?
>>
>>
>>         thanks
>>
>>         GA
>>
>>
>>
>>
>>     -- 
>>
>>     Dr Anthony Berglas, [email protected]
>>     <mailto:[email protected]> Mobile: +61 4 4838 8874
>>     Just because it is possible to push twigs along the ground with
>>     ones nose
>>     does not necessarily mean that that is the best way to collect
>>     firewood.
>>
>
>
>
> -- 
>
> Dr Anthony Berglas, [email protected] <mailto:[email protected]> 
> Mobile: +61 4 4838 8874
> Just because it is possible to push twigs along the ground with ones nose
> does not necessarily mean that that is the best way to collect firewood.
>
> 


--------------010203010106050106000202
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit





<head>

<style type="text/css">
<!--

/* start of attachment style */
       .ygrp-photo-title{
         clear: both;
         font-size: smaller;
         height: 15px;
         overflow: hidden;
         text-align: center;
         width: 75px;
       }
       div.ygrp-photo{
         background-position: center;
         background-repeat: no-repeat;
         background-color: white;
         border: 1px solid black;
         height: 62px;
         width: 62px;
       }

       div.photo-title 
         a,
         div.photo-title a:active,
         div.photo-title a:hover,
         div.photo-title a:visited {
           text-decoration: none; 
       }

       div.attach-table div.attach-row {
         clear: both;
       }

       div.attach-table div.attach-row div {
         float: left;
         /* margin: 2px;*/
       }

       p {
         clear: both;
         padding: 15px 0 3px 0;
	 overflow: hidden;
       }

       div.ygrp-file {
         width: 30px;
         valign: middle;
       }
       div.attach-table div.attach-row div div a {
         text-decoration: none;
       }

       div.attach-table div.attach-row div div span {
         font-weight: normal;
       }

       div.ygrp-file-title {
         font-weight: bold;
       }
 /* end of attachment style */
        -->
        </style>
        </head>
<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">





    Hi all,<br>
    <br>
    just a note to say we (at axege.com) are using it on a daily basis
    in our product, and deployed in production on about 30 sites, mainly
    hospitals in France and Switzerland.<br>
    SimpleORM is not evolving a lot as it has the features we need
    now... and it is mainly bug less !<br>
    <br>
    You can go ahead using it, you won't be left totally alone :-)<br>
    <br>
    Best regards,<br>
    Franck<br>
    <br>
    <br>
    <div class="moz-cite-prefix">Le 07/11/2014 04:15, anthony berglas
      <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> [SimpleORM] a écrit :<br>
    </div>
    <blockquote
cite="mid:CA+_PZMdUyo-gJ-RYUu7TYu47ETF0pMNnhrai-tjwnw0UAh3boQ@mail.gmail.com"
      type="cite"> <span style="display:none"> </span>
      
          <div id="ygrp-text">
            <div dir="ltr">
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;">Ha!  There lies
                the rub.  It is a Hibernate world, in all its glory. 
                And about 5% of it is actually useful.</div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;"><br>
              </div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;">If you find
                something let me know.  All I have seen is rubbish. 
                Lots of mapping to objects using reflection, nothing
                useful.  What is wanted is something simple.</div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;"><br>
              </div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;">A project that I
                am working on now has some very simple code (not written
                by me) that just wraps SQL, sample below.  You could
                knock something up yourself like that pretty quick.  If
                you make it into a clean module please post it to this
                list.  But that still leaves many issues.</div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;"><br>
              </div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;">Or just use
                SimpleOrm.  If you like it pull the current from SVN. 
                But you will need to maintain it yourself, I have no
                time for it.  But it is simple.</div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;"><br>
              </div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;">Anthony</div>
              <div class="gmail_default"
                style="font-family:verdana,sans-serif;"><br>
              </div>
              <div class="gmail_default">
                <div class="gmail_default"><font face="verdana,
                    sans-serif">    private PreparedStatement
                    executeInner(String sql, String sqlcmd, Object...
                    params) throws SQLException {</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        long start =
                    System.currentTimeMillis();</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        boolean ok = false;</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        count = -1;</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        PreparedStatement stmt = null;</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif"><br>
                  </font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        try {</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            stmt =
                    dbconn.prepareStatement(sql);</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            setParams(stmt, params);</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            if (!stmt.execute()) { //
                    returns false if result is count</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">                count =
                    stmt.getUpdateCount();</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            }</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            ok = true;</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            return stmt;</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        } finally {</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            if (stmt != null) stmt.close</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            long timeTaken =
                    System.currentTimeMillis() - start;</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">            log.debug(format("sql: %08x
                    : %s : %s : %d : %05dms : %s : %s\n",</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">                    dbconn.hashCode(),
                    sqlcmd, ok ? "ok" : "error", count,</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">                    timeTaken, sql,
                    JSON.stringify(params)));</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">        }</font></div>
                <div class="gmail_default"><font face="verdana,
                    sans-serif">    }</font></div>
                <div style="font-family:verdana,sans-serif;"><br>
                </div>
              </div>
            </div>
            <div class="gmail_extra"><br>
              <div class="gmail_quote">On Fri, Nov 7, 2014 at 11:41 AM,
                John Abraham <a moz-do-not-send="true"
                  href="mailto:[email protected]">[email protected]</a>
                [SimpleORM] <span dir="ltr">&lt;<a
                    moz-do-not-send="true"
                    href="mailto:[email protected]"
                    target="_blank">[email protected]</a>&gt;</span>
                wrote:<br>
                <blockquote class="gmail_quote" style="border-left:1px
                  #ccc solid;">
                  <div style="background-color:#fff;">
                    <span> </span>
                    <div>
                      <div>
                        <div>
                          <div><span class="">
                              <blockquote type="cite">
                                <div>
                                  <div>
                                    <div>
                                      <div dir="ltr">
                                        <div class="gmail_default"><font
                                            color="#000000"><span>(But
                                              SimpleOrm has minimal
                                              support these days.)</span></font></div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </blockquote>
                              <div><br>
                              </div>
                            </span>Any recommendations for
                            alternatives?  I refuse to use Hibernate...<br>
                            <br>
                            <div>--</div>
                            <div>John Abraham</div>
                            <div><br>
                            </div>
                            Sent from my iPhone, please excuse any
                            typos. </div>
                          <span class="">
                            <div><br>
                              On Nov 6, 2014, at 5:25 PM, anthony
                              berglas <a moz-do-not-send="true"
                                href="mailto:[email protected]"
                                target="_blank">[email protected]</a>
                              [SimpleORM] &lt;<a moz-do-not-send="true"
                                href="mailto:[email protected]"
                                target="_blank">[email protected]</a>&gt;
                              wrote:<br>
                              <br>
                            </div>
                          </span>
                          <blockquote type="cite">
                            <div> <span> </span>
                              <div><span class="">
                                  <div dir="ltr">
                                    <div class="gmail_default"
                                      style="font-family:verdana,sans-serif;">Should
                                      be OK.  There is no global state.</div>
                                    <div class="gmail_default"
                                      style="font-family:verdana,sans-serif;"><br>
                                    </div>
                                    <div class="gmail_default"
                                      style="font-family:verdana,sans-serif;">(But
                                      SimpleOrm has minimal support
                                      these days.)</div>
                                    <div class="gmail_default"
                                      style="font-family:verdana,sans-serif;"><br>
                                    </div>
                                    <div class="gmail_default"
                                      style="font-family:verdana,sans-serif;">Anthony</div>
                                  </div>
                                </span>
                                <div class="gmail_extra"><span class=""><br>
                                    <div class="gmail_quote">On Thu, Nov
                                      6, 2014 at 10:31 PM, <a
                                        moz-do-not-send="true"
                                        href="mailto:[email protected]"
                                        target="_blank">[email protected]</a>
                                      [SimpleORM] <span dir="ltr">&lt;<a
                                          moz-do-not-send="true"
                                          href="mailto:[email protected]"
                                          target="_blank">[email protected]</a>&gt;</span>
                                      wrote:<br>
                                      <blockquote class="gmail_quote"
                                        style="border-left:1px #ccc
                                        solid;">
                                        <div
                                          style="background-color:#fff;">
                                          <span> </span>
                                          <div>
                                            <div>
                                              <div>
                                                <p>Hi</p>
                                                <p><br>
                                                </p>
                                                <p>Is it a problem for
                                                  SimpleORM to have one
                                                  java thread talking to
                                                  MySql and MSSQL at the
                                                  same time?</p>
                                                <p><br>
                                                </p>
                                                <p>thanks</p>
                                                <p>GA</p>
                                              </div>
                                            </div>
                                          </div>
                                        </div>
                                      </blockquote>
                                    </div>
                                    <br>
                                    <br clear="all">
                                    <div><br>
                                    </div>
                                  </span><span class="">-- <br>
                                    <div>
                                      <p>
                                      </p>
                                      <p>Dr Anthony Berglas, <a
                                          moz-do-not-send="true"
                                          href="mailto:[email protected]"
                                          target="_blank">[email protected]</a>      
                                        Mobile: +61 4 4838 8874<br>
                                        Just because it is possible to
                                        push twigs along the ground with
                                        ones nose<br>
                                        does not necessarily mean that
                                        that is the best way to collect
                                        firewood.</p>
                                    </div>
                                  </span></div>
                              </div>
                            </div>
                          </blockquote>
                        </div>
                      </div>
                    </div>
                  </div>
                </blockquote>
              </div>
              <br>
              <br clear="all">
              <div><br>
              </div>
              -- <br>
              <div class="gmail_signature">
                <p>
                </p>
                <p>Dr Anthony Berglas, <a moz-do-not-send="true"
                    href="mailto:[email protected]" target="_blank">[email protected]</a>      
                  Mobile: +61 4 4838 8874<br>
                  Just because it is possible to push twigs along the
                  ground with ones nose<br>
                  does not necessarily mean that that is the best way to
                  collect firewood.</p>
              </div>
            </div>
          </div>
          
      
      <!-- end group email -->
    </blockquote>
    <br>
  



<!-- |**|begin egp html banner|**| -->

<br>


<br>

<!-- |**|end egp html banner|**| -->


<div width="1" style="color: white; clear: both;"/>__._,_.___</div>

      
  

    
    <div id="fromDMARC" style="clear:both; margin-top: 10px;">
         <hr style="height:2px ; border-width:0; color:#E3E3E3; background-color:#E3E3E3;">
         Posted by: Franck Routier &lt;[email protected]&gt;         <hr style="height:2px ; border-width:0; color:#E3E3E3; background-color:#E3E3E3;">
    </div>
<!-- Start Recommendations -->
<!-- End Recommendations -->



<!-- |**|begin egp html banner|**| -->

  <img src="http://geo.yahoo.com/serv?s=97476590/grpId=7360226/grpspId=1705006905/msgId=2099/stime=1415347724" width="1" height="1"> <br>

<!-- |**|end egp html banner|**| -->

    
<!-- |**|begin egp html banner|**| -->

<br>



   
     
 
        <!-- |**|begin egp html banner|**| -->
        <div id="ygrp-vital" style="background-color: #f2f2f2; font-family: Verdana; font-size: 10px; margin-bottom: 10px; padding: 10px;">

        <span id="vithd" style="font-weight: bold; color: #333; text-transform: uppercase; "><a href="https://groups.yahoo.com/neo/groups/SimpleORM/info;_ylc=X3oDMTJlajNpdHBuBF9TAzk3MzU5NzE0BGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQxNTM0NzcyNA--" style="text-decoration: none;">Visit Your Group</a></span>

     <ul style="list-style-type: none; margin: 0; padding: 0; display: inline;">
                                                    </ul>
  </div>


<div id="ft" style="font-family: Arial; font-size: 11px; margin-top: 5px; padding: 0 2px 0 0; clear: both;">
  <a href="https://groups.yahoo.com/neo;_ylc=X3oDMTJkdjFqdGRuBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDE1MzQ3NzI0" style="float: left;"><img src="http://l.yimg.com/ru/static/images/yg/img/email/new_logo/logo-groups-137x15.png" height="15" width="137" alt="Yahoo! Groups" style="border: 0;"/></a>
  <div style="color: #747575; float: right;"> &bull; <a href="https://info.yahoo.com/privacy/us/yahoo/groups/details.html" style="text-decoration: none;">Privacy</a> &bull; <a href="mailto:[email protected]?subject=Unsubscribe" style="text-decoration: none;">Unsubscribe</a> &bull; <a href="https://info.yahoo.com/legal/us/yahoo/utos/terms/" style="text-decoration: none;">Terms of Use</a> </div>
</div>

<!-- |**|end egp html banner|**| -->

  </div> <!-- ygrp-msg -->

   


  <br>

<!-- |**|end egp html banner|**| -->


<div style="color: white; clear: both;"/>__,_._,___</div>
</body>
</html>

--------------010203010106050106000202--