Greetings all, I've been using TDK 2.2b3 (under Java JDK 1.3.1_04) for some time with MySQL, and I've been satisfied with the results. However, I am always in the process of testing different ways of doing the same thing. This has led me to start messing around with running my application under PostgreSQL 7.2.3 (using Cygwin on NT 4). Basically I'm just interested in seeing the basic differences as well as what I would have to do with some of the direct sql calls I'm making using BasePeer.executeStatement.
HOWEVER - I can't seem to get past the problems I'm having using idMethod="native". I don't get any problems during the init, and everything looks cool in the Is anyone running idMethod="native" using PostgreSQL 7.2, TDK2.2, and pgjdbc2.jar? Thanks! -jeff No matter what I try, I can't get past this: java.lang.reflect.InvocationTargetException: java.sql.SQLException: ERROR: Function 'last_insert_id()' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94) at org.postgresql.Connection.ExecSQL(Connection.java:398) at org.postgresql.jdbc2.Statement.execute(Statement.java:130) at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54) at com.workingdogs.village.QueryDataSet.(Unknown Source) at org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsVillageValue(AutoIncrementIdGenerator.java:194) at org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncrementIdGenerator.java:127) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:754) ... <snip>
