Could you send the jar to me, please? Jacob Vennervald
-----Original Message----- From: Colm McCartan [mailto:[EMAIL PROTECTED]] Sent: 16. januar 2002 16:54 To: Turbine Users List Subject: Fixed! Re: postgres and turbine Rhys Dixon wrote: > hi guys, > > if your jdbc driver returns Types.OTHER (1111) then village will convert > that hashtable to a string. if it returns Types.BINARY (-2) then it > converts it to a byte[]. the "Unterminated quoted string" error is > probably a result of the driver reporting Types.OTHER (1111). > > i built village from source after adding some debugging printouts at the > part where it decides how to store a particular object. > i moved the original village.jar out of the way and added this jar to my > WEB-INF/lib > > http://www.dyxn.net/public/village-debug.jar Rhys - Thanks for the info. Eventually I was forced to build my own version of the jar because, even with yours I was getting strange errors: java.lang.reflect.InvocationTargetException: java.sql.SQLException: ERROR: Attribute 'objectdata' is of type 'bytea' but expression is of type 'int4' You will need to rewrite or cast the expression 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.executeUpdate(Statement.java:73) at org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.j ava:113) at com.workingdogs.village.Record.saveWithUpdate(Record.java:272) I copied what you had done to the village source to get some visibilty and was seeing this from the messages: [Wed Jan 16 15:38:05 GMT 2002] -- INFO -- *** DMS *** null - objectdata is a bytea (-2) When I built the postgres.jar from the 7.2b3 src I noticed that it is only 93K in size - yours is 190K. Is there a possibility that you have the wrong one at the url (http://www.dyxn.net/public/postgresql.jar)? I would post a url for mine but I don't have convenient access to a web area - anyone who would like me to mail it to them please contact me. Perhaps it could go onto the jakarta site somewhere after further testing? To anyone interested, I am using my jar to connect to postgres server 7.1.2-4 and I have modified my db.props as per Rhys's instructions (mapping VARBINARY to bytea). Should these changes be committed to the 2.1 TDK tree? I'd be happy to offer the patches and some changes to the postgres howto. colm -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
