Hi Wally, I don't know if the workaround would work for mysql, using a different version of mysql connector. Perhaps anyone else can help? I only tried sqlserver. Your best bet is to upgrade to the latest beta release (2.1-beta2) where the bug should be fixed.
Cheers Rini wallyatkins wrote: > > How do you specify the previous version (JDBC 2.0) for MySQL with > GeoServer? > > Regards, > Wally Atkins > > > Rini Angreani wrote: >> >> This looks like the same problem I reported: >> http://jira.codehaus.org/browse/GEOT-3263 >> It's been introduced (accidentally) since VARBINARY mapping was added to >> SQLDialect. >> The workaround was not to use JDBC 3.0 (use previous versions instead). >> >> Cheers >> Rini >> >> >> Justin Deoliveira-6 wrote: >>> >>> Odd... another user had this same problem but with sql server. In that >>> case >>> it had something to do with the jdbc driver version being used. Are you >>> using the jdbc driver shipped with geoserver? Also are you running on >>> java 5 >>> or java 6. >>> >>> I am still looking into that issue so hopefully will have some info >>> soon. >>> Any info you can provide about your environment would help though. >>> >>> -Justin >>> >>> On Sun, Sep 19, 2010 at 7:15 PM, nyem <nye...@gmail.com> wrote: >>> >>>> It seems that my geoserver 2.1 beta1 installation cannot detect >>>> geometry >>>> type from mysql datastore. It shows the feature type as byte[] instead >>>> of Geometry. Is this a known issue with beta1? >>>> >>>> I'm running geoserver/mysql on Windows and the mysql plugin is from >>>> >>>> http://downloads.sourceforge.net/geoserver/geoserver-2.1-beta1-mysql-plugin.zip >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> _______________________________________________ >>>> Geoserver-users mailing list >>>> Geoserver-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users >>>> >>> >>> >>> >>> -- >>> Justin Deoliveira >>> OpenGeo - http://opengeo.org >>> Enterprise support for open source geospatial. >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Geoserver-users mailing list >>> Geoserver-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/geoserver-users >>> >>> >> >> > > -- View this message in context: http://old.nabble.com/geoserver-2.1-beta1%3A-cannot-detect-mysql-geometry-tp29755561p30469989.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
