That's for those .net nerds. ;-)
Larry
On 3/30/07, Ilya Boyandin <[EMAIL PROTECTED]> wrote:
Hi Larry,
Thanks a lot for the hint, now it works!
BTW, I found the description of the properties file format on this page:
http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+should+my
Hi Larry,
Thanks a lot for the hint, now it works!
BTW, I found the description of the properties file format on this page:
http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+should+my+properties.config+file+look+like
Is it about some other kind of a properties file?
Ilya
Larry
What's this?
That should just read like this:
dbOwner=ep63
Larry
On 3/30/07, Ilya Boyandin <[EMAIL PROTECTED]> wrote:
Hello Meindert,
in the log I see the following:
[DEBUG,PreparedStatement,http-8080-2] {pstm-11} Executing
Statement:SELECT LOWER(SUBSTRING(personen.per_
Hello Meindert,
in the log I see the following:
[DEBUG,PreparedStatement,http-8080-2] {pstm-11} Executing
Statement:SELECT LOWER(SUBSTRING(personen.per_edv_user,
PATINDEX('[\\/]', personen.per_edv_user), LEN(personen.per_edv_user)))
as username, personen.oid, per
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 S
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
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
On 3/30/07, Ilya Boyandin <[EMAIL PROTECTED]> wrote:
Hi Seth,
thanks for the quick answer!
Yes, it works this w
Not to sure why it doesn't work in your code, I have the following in my
database.config
#nowfunction=Now()
And
nowfunction=getDate()
Now() to be used if database is MySql and getDate() if database is Sql
Server
And have no issues using ${nowfunction} in my queries
UPDATE Profile SET
Modi
Hi Seth,
thanks for the quick answer!
Yes, it works this way, but it would be much better if I could get rid
of passing the dbOwner parameter and specify it just once in a config
file, because it's static and I need it for every single query.
The need of the extra parameter makes using objec
Hey Ilya,
You can insert dynamic portions into your sql with
iBatis using the $ syntax. To take your example,
below you'd use something like...
SELECT count(*) FROM $dbOwner$.students
WHERE id = #value#
And then supply the String parameter as an object to
the query from your
10 matches
Mail list logo
