<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">2017-03-15 4:13 GMT+01:00 jenny_han <span dir="ltr"><<a target="_blank" href="mailto:hanyuxinbnu@gmail.com">hanyuxinbnu@gmail.com</a>></span>:<br><blockquote style="margin-top:0px;margin-bottom:0px" class="gmail_quote">Hello, everyone!<br>
<br>
After adding "org.gvsig.mysql.app.<wbr>mainplugin" file to gvSIG\extension, I<br>
have successfully imported a layer from mysql database. However, when export<br>
to database, I met problem like the picture shows. And I really lost with<br>
gvSIG's function about connecting to database.<br>
<<a target="_blank" rel="noreferrer" href="http://osgeo-org.1560.x6.nabble.com/file/n5312372/2.png">http://osgeo-org.1560.x6.<wbr>nabble.com/file/n5312372/2.png</a><wbr>><br>
<br>
<<a target="_blank" rel="noreferrer" href="http://osgeo-org.1560.x6.nabble.com/file/n5312372/3.png">http://osgeo-org.1560.x6.<wbr>nabble.com/file/n5312372/3.png</a><wbr>><br>
<br>
Do you have any idea about what result in this?<br>
<br></blockquote><div><br><span class="gmail-" id="gmail-result_box" lang="en"><span>Hello Jenny,</span><br><span class="gmail-">The
MySQL data provider for gvSIG 2 was never completed, and it does not
work on the latest versions of gvSIG (2.2 and 2.3), so it is not
included in those distributions.</span><br><br><span class="gmail-">For gvSIG
2.4, which I hope will not be late, it is planned to have data providers
for PostgreSQL, MSSQLserver, and SpatiaLite on an experimental basis.</span> <span class="gmail-">At the moment, we do not plan to develop a provider for MySQL.</span> <span class="gmail-">Without financing or external collaboration will depend on the free time you have.</span><br><br><span class="gmail-">a greeting</span><br><span>Joaquin</span></span><br> </div><blockquote style="margin-top:0px;margin-bottom:0px" class="gmail_quote">
Thank you!<br>
<br>
I attach the log in the following.<br>
<br>
INFO [Thread-15] (DefaultJExporttoServicePanel.<wbr>java:272) - Exporting<br>
'country.sld' using 'org.gvsig.exportto.swing.<wbr>prov.jdbc.ExporrtoJDBCService'<br>
(C:\Users\Administrator\<wbr>Desktop\country.sld.shp).<br>
WARN [Thread-15] (ExporrtoJDBCService.java:336) - Can't export data.<br>
java.lang.ClassCastException:<br>
org.gvsig.fmap.dal.store.<wbr>mysql.MySQLNewStoreParameters cannot be cast to<br>
org.gvsig.fmap.dal.store.jdbc.<wbr>JDBCNewStoreParameters<br>
at<br>
org.gvsig.exportto.swing.prov.<wbr>jdbc.ExporrtoJDBCService.<wbr>createTable(<wbr>ExporrtoJDBCService.java:133)<br>
at<br>
org.gvsig.exportto.swing.prov.<wbr>jdbc.ExporrtoJDBCService.<wbr>export(ExporrtoJDBCService.<wbr>java:196)<br>
at<br>
org.gvsig.exportto.swing.impl.<wbr>DefaultJExporttoServicePanel$<wbr>Export.run(<wbr>DefaultJExporttoServicePanel.<wbr>java:274)<br>
WARN [Thread-15] (DefaultJExporttoServicePanel.<wbr>java:276) - Problems<br>
exporting the data (layer=country.sld).<br>
org.gvsig.exportto.<wbr>ExporttoServiceException: An error has been produced<br>
exporting a store<br>
at<br>
org.gvsig.exportto.swing.prov.<wbr>jdbc.ExporrtoJDBCService.<wbr>export(ExporrtoJDBCService.<wbr>java:338)<br>
at<br>
org.gvsig.exportto.swing.impl.<wbr>DefaultJExporttoServicePanel$<wbr>Export.run(<wbr>DefaultJExporttoServicePanel.<wbr>java:274)<br>
Caused by: java.lang.ClassCastException:<br>
org.gvsig.fmap.dal.store.<wbr>mysql.MySQLNewStoreParameters cannot be cast to<br>
org.gvsig.fmap.dal.store.jdbc.<wbr>JDBCNewStoreParameters<br>
at<br>
org.gvsig.exportto.swing.prov.<wbr>jdbc.ExporrtoJDBCService.<wbr>createTable(<wbr>ExporrtoJDBCService.java:133)<br>
at<br>
org.gvsig.exportto.swing.prov.<wbr>jdbc.ExporrtoJDBCService.<wbr>export(ExporrtoJDBCService.<wbr>java:196)<br>
... 1 more<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a target="_blank" rel="noreferrer" href="http://osgeo-org.1560.x6.nabble.com/Connecting-to-database-tp5312372.html">http://osgeo-org.1560.x6.<wbr>nabble.com/Connecting-to-<wbr>database-tp5312372.html</a><br>
Sent from the gvSIG desarrolladores mailing list archive at Nabble.com.<br>
______________________________<wbr>_________________<br>
gvSIG_desarrolladores mailing list<br>
<a href="mailto:gvSIG_desarrolladores@listserv.gva.es">gvSIG_desarrolladores@<wbr>listserv.gva.es</a><br>
Para ver histórico de mensajes, editar sus preferencias de usuario o darse de baja en esta lista, acuda a la siguiente dirección: <a target="_blank" rel="noreferrer" href="https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_desarrolladores">https://listserv.gva.es/cgi-<wbr>bin/mailman/listinfo/gvsig_<wbr>desarrolladores</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature">--------------------------------------<br>Joaquin Jose del Cerro Murciano<br>Development and software arquitecture manager at gvSIG Team<br><a target="_blank" href="mailto:jjdelcerro@gvsig.com">jjdelcerro@gvsig.com</a><br><a target="_blank" href="mailto:jjdelcerro@gvsig.org">jjdelcerro@gvsig.org</a><br>gvSIG Association<br><a target="_blank" href="http://www.gvsig.com">www.gvsig.com</a><br><a target="_blank" href="http://www.gvsig.org">www.gvsig.org</a></div>
</div></div>