Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of jeffgbutler@gmail.com
 designates 64.233.162.232 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=T+/b4Q9New2M/UcTE4o8RAI5cMrDbcmeGpk3kM25Lt5fc4XB05s9RDVahUqcavDyeeZshGizG4VdZUPx1Xiwlt1+0ppQfsz7UCVeZIWVgLGuvxSEmGQ8BINJmd3Xilu0CkuwVKVVvHf8LxlQoPUxfbPhG4pXm1ioCEl3gEyzy0Q=
Message-ID: <c593b8750703300720w4aedfe95qe79c058e7123b192@mail.gmail.com>
Date: Fri, 30 Mar 2007 09:20:40 -0500
From: "Jeff Butler" <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Configurable static parameters in SQL
In-Reply-To: <460D131D.6030703@fh-joanneum.at>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_46699_1667582.1175264440749"
References: <437852.40488.qm@web60416.mail.yahoo.com>
	 <460CF1A4.3070703@fh-joanneum.at>
	 <c593b8750703300623v21d5b161oc5bb105c3daa5a22@mail.gmail.com>
	 <460D131D.6030703@fh-joanneum.at>

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

Ahh SQL Server...you vex me.

Starting with SQL Server 2005, Microsoft has finally started using the
proper terminology here (schema is the proper term, SQL Server called it
"database owner" previously).

Most databases allow you to set a default schema in the connection URL, but
I'm not sure if SQL Server does or not.  This is new territory for SQL
Server.  However, I know that you could create a database user and specify a
default schema that way.

Jeff Butler


On 3/30/07, Ilya Boyandin <Ilya.Boyandin@fh-joanneum.at> wrote:
>
> Really? And how can I set it in the URL?
>
> I think, it's not the schema, but something different. It's "database
> owner", something specific to MS SQL, I think.
>
> Ilya
>
> Jeff Butler wrote:
> > If you are only needing to set the schema, then you could set a
> > default schema on the JDBC connection URL and then avoid the use of
> > schemas completely within your SQL.
> >
> > Jeff Butler
> >
> >
>
>

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

<div>Ahh SQL Server...you vex me.</div>
<div>&nbsp;</div>
<div>Starting with SQL Server 2005, Microsoft has finally started using the proper terminology here (schema is the proper term, SQL Server called it &quot;database owner&quot; previously).</div>
<div>&nbsp;</div>
<div>Most databases allow you to set a default schema in the connection URL, but I&#39;m not sure if SQL Server does or not.&nbsp;&nbsp;This is new territory for&nbsp;SQL Server.&nbsp; However, I know that you could create a database user and specify a default schema that way.
</div>
<div>&nbsp;</div>
<div>Jeff Butler<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 3/30/07, <b class="gmail_sendername">Ilya Boyandin</b> &lt;<a href="mailto:Ilya.Boyandin@fh-joanneum.at">Ilya.Boyandin@fh-joanneum.at</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Really? And how can I set it in the URL?<br><br>I think, it&#39;s not the schema, but something different. It&#39;s &quot;database
<br>owner&quot;, something specific to MS SQL, I think.<br><br>Ilya<br><br>Jeff Butler wrote:<br>&gt; If you are only needing to set the schema, then you could set a<br>&gt; default schema on the JDBC connection URL and then avoid the use of
<br>&gt; schemas completely within your SQL.<br>&gt;<br>&gt; Jeff Butler<br>&gt;<br>&gt;<br><br></blockquote></div><br>

------=_Part_46699_1667582.1175264440749--