Hi,
Only the most popular features of other database can be implemented in a
compatibility mode item. In this case, I don't think it is a popular nor
important compatibility item, sorry.
Regards,
Thomas
On Wednesday, March 7, 2012, Joe Parsons wrote:
I was under the impression that the
I was under the impression that the purpose of a compatibility mode was
to make the product more compatible and to better support the syntax of a
specific RDBMS. Why would adding this change under the PostgreSQL
compatibility mode affect MySQL?
-Joe
--
You received this message because you
Hi,
I'm sorry but H2 can't be 100% compatible with every other database. If I
would change the behavior, it would be no longer compatible with MySQL in
this area.
Could you use SELECT getNextIdAndUpdate() AS getNextIdAndUpdate or
resultSet.getString(1) instead?
Regards,
Thomas
--
You received
Hi,
Referencing the column like this:
id = resultSet.getString(getNextIdAndUpdate);
Is not going to work when the column is named this:
PUBLIC.GETNEXTIDANDUPDATE()
Ah, I guess the main problem is the () at the end. I didn't see that
first, sorry.
Could you change the query to:
Ah, I guess the main problem is the () at the end. I didn't see that
first, sorry.
Could you change the query to:
SELECT getNextIdAndUpdate() AS getNextIdAndUpdate
I certainly could, but my goal was to change nothing in the code to
accommodate my unit testing. Referencing the column by
Thomas,
There is no error message. I thought I worded the question quite
well. I will summarize as best I can.
Java code that I do not wish to change is calling a stored function in
H2 in PostgreSQL mode. Java is pulling the value by name instead of
by index.
My question is, is there any way
Hi,
Sorry, but I don't understand the problem. Is there some error message and
stack trace? If yes could you post it? Do you have a simple reproducible
test case?
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this
I am using H2 in embedded mode to unit test some DAO classes. I found
one of the DAOs calls a user-defined function in the PostgreSQL
database. I tried to mock the function by writing a java method under
an alias in H2. I used this simple class for my test:
public class UserDefinedDbFunctions
Correction to my above column name. The column name includes the
function parenthesis:
PUBLIC.GETNEXTIDANDUPDATE()
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To