I believe you will be limited to char and varchar .
2010/9/17 marwa El-said <melsaid2...@hotmail.com>
> ok, I got this link before,
> what is the alternative data type to use instead of (nchar,nvarchar) to get
> the rest of features loaded during publishing layers into
> geoserver?
>
>
> Thanks,
>
> *Marwa Elsaid*
>
> ------------------------------
> Date: Wed, 15 Sep 2010 14:22:25 -0600
> Subject: Re: [Geoserver-users] Error creating datastore to SQL Server 2008
> From: jdeol...@opengeo.org
> To: melsaid2...@hotmail.com
> CC: geoserver-users@lists.sourceforge.net; ahmed.ashm...@gt-egypt.com
>
>
> Currently nvarchar is not supported as a type mapping. The reason being
> that the JDBC Types constant is only available in java 1.6, and
> geotools/geoserver is still stuck on java 5. There is an open issue for
> this:
>
> http://jira.codehaus.org/browse/GEOS-3842
>
> -Justin
>
> 2010/9/15 marwa El-said <melsaid2...@hotmail.com>
>
>
> Hi,
>
> I am using GeoServer 2.0.2 , SQL Server 2008 , Microsoft SQL Server JDBC
> Driver 3.0 and a java 1.4 SDK
> I successfully connected to the sql server, but have a problem with type
> "nvarchar" that didn't appear during publishing my layers
> as a property to be loaded
>
> I tried alot of solutions, the last one was to upgrade the java SDK to java
> 1.6 SDK,
> but when I do that I couldn't create a SQL Server data store again
> and have an error while trying to create it.
>
> After the previous error with java 1.6 SDK I removed all java versions from
> my PC and setup the 1.6 SDk version only
> then, i tried to log on to geoserver but i found the geoserver down
> "inernet explorer can not display the web page...."
>
> It seems that java 1.6 SDK has some issues with geoserver
> If it is right, I need to know what is the solution to get my server work
> again ?
>
> and if i revert to use the java 1.4 SDK how can i resolve the "nvarchar" type
> disappearnce from all layers during
> publishing them on geoserver.
>
>
>
>
>
> Thanks,
> *Marwa Elsaid*
>
>
>
>
> ------------------------------------------------------------------------------
> 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.
>
>
--
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
