Jeff, I've seen this before.
The function referred to is a mysql function for setting the autoIncrement. The postgres alternative does work, so I think you have a configuration problem where torque is looking to its default setup of mysql. Torque.properties is rewritten from Torque.Template or some such on each 'ant init' so have you changed the database settings in Torque.Properties and not in Torque.Template? I have postgres native sequences working in 2.2-b3 so you should be able to get it working. Regards, Peter On Thu, 2002-11-07 at 19:16, Jeff Owens wrote: > 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> -- 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>
