In looking through more archives, I found a reference to this error message, but the user was utilizing mysql. I knew for a fact that I wasn't using mysql, but a text search of my conf subdirectory turned up a reference to it in torque.properties and template. Apparently you have to change these yourself.
Anyway, I hope this information can help someone somewhere down the line. ----- Original Message ----- From: "Jeff Owens" <[EMAIL PROTECTED]> To: "Turbine Torque Users List" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 10:50 AM Subject: ERROR: function last_insert_id() 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(AutoIncre mentIdGenerator.java:194) at org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncreme ntIdGenerator.java:127) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:754) ... <snip> -- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
