I think your version mismatch is the best culprit :) It can be related to the way the JDBC plugin detect the encoding of the DB and apply it to the Java side. For Oracle and MySQL there is a way to enforce the encoding of the JDBC driver, but it looks like this issue is irrelevant for a PostgreSQL environment. Most of PostgreSQL encoding issue are related to the fact that the DB was not installed/configured to support UTF-8.
Hope you'll manage to unify the versions, or rollback the PostgreSQL DB version. Good luck, Fred. On Wed, Apr 14, 2010 at 7:55 PM, shawn_ayers <[email protected]> wrote: > > I have verified that both the JVM and the database are using UTF-8 encoding. > > Could this be related to using an outdated jdbc driver against the new Alpha > version of the Postgres database? > > Currently using this jdbc driver : postgresql-8.4-701.jdbc4.jar > Database: PostgreSQL 9.0alpha4 > > Thank you, > > > > Yoav Landman-3 wrote: >> >> Hi Shawn, >> >> You'd need to verify that the JVM and the database encodings are aligned. >> So >> if, for example, chars are stored in the PostgreSQL tables as UTF-8, force >> the Tomcat JVM to start with -Dfile.encoding=UTF-8. >> >> Regards, >> >> Yoav >> >> On Fri, Apr 9, 2010 at 3:52 PM, shawn_ayers <[email protected]> wrote: >> >>> >>> Any suggestions on possible workarounds for this issue? >>> >>> Thank you, >>> >>> Shawn >>> >>> Yoav Landman-3 wrote: >>> > >>> > A quick guess by looking at the stack is this is probably related to >>> the >>> > default encoding used by the database or to a conflict between this >>> > encoding >>> > and the encoding used by the JVM used for running Artifactory. >>> > >>> > HTH, >>> > >>> > Yoav >>> > >>> > On Thu, Apr 8, 2010 at 11:41 PM, shawn_ayers <[email protected]> >>> > wrote: >>> > >>> >> >>> >> I am testing some new features in the Alpha PostgreSQL 9 database and >>> am >>> >> having some trouble configuring Artifactory to connect to the >>> database. >>> >> >>> >> I do have artifactory configured with PostgreSQL 8.4 running in our >>> >> environment without any problems. >>> >> >>> >> Each time I attempt to startup Artifactory, whether stand-alone or >>> >> through >>> >> Tomcat I am receiving the following error: >>> >> >>> >> >>> > >>> > >>> ------------------------------------------------------------------------------ >>> > Download Intel® Parallel Studio Eval >>> > Try the new software tools for yourself. Speed compiling, find bugs >>> > proactively, and fine-tune applications for parallel performance. >>> > See why Intel Parallel Studio got high marks during beta. >>> > http://p.sf.net/sfu/intel-sw-dev >>> > _______________________________________________ >>> > Artifactory-users mailing list >>> > [email protected] >>> > https://lists.sourceforge.net/lists/listinfo/artifactory-users >>> > >>> > >>> >>> -- >>> View this message in context: >>> http://old.nabble.com/Artifactory-Not-Starting-with-PostgreSQL-9.0-Database-tp28184293p28190834.html >>> Sent from the Artifactory-Users mailing list archive at Nabble.com. >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Download Intel® Parallel Studio Eval >>> Try the new software tools for yourself. Speed compiling, find bugs >>> proactively, and fine-tune applications for parallel performance. >>> See why Intel Parallel Studio got high marks during beta. >>> http://p.sf.net/sfu/intel-sw-dev >>> _______________________________________________ >>> Artifactory-users mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/artifactory-users >>> >> >> ------------------------------------------------------------------------------ >> Download Intel® Parallel Studio Eval >> Try the new software tools for yourself. Speed compiling, find bugs >> proactively, and fine-tune applications for parallel performance. >> See why Intel Parallel Studio got high marks during beta. >> http://p.sf.net/sfu/intel-sw-dev >> _______________________________________________ >> Artifactory-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/artifactory-users >> >> > > -- > View this message in context: > http://old.nabble.com/Artifactory-Not-Starting-with-PostgreSQL-9.0-Database-tp28184293p28245312.html > Sent from the Artifactory-Users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Artifactory-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/artifactory-users > -- Co. Founder and Chief Architect JFrog Ltd http://www.jfrog.org/ http://twitter.com/freddy33 ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Artifactory-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/artifactory-users
