From: Pizza Al T. <to...@ya...> - 2004-09-22 15:40:42
|
Hi, I am pretty new to this stuff and i have created successfully my first shapfile maps. Now i would like to switch to a MySQL DB DataStore, but i really do not know how to start. Can anyone help me, or give me some good advice, link to visit?? Thanks Martin _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com |
From: Rueben S. <r_j...@ya...> - 2004-09-24 05:32:28
|
Hi, Take a look at: http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore This does not cover mysql, but the same technique can be used. Unfortunately the parameters needed by mysql are not yet described at: http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters so you will need to hunt for them in the mysqlDataStore code. Rueben P.S. Once you find the parameters, please place them on the DataSterFinder parameters wiki page (if you have time). On Wed, 2004-09-22 at 08:19, Pizza Al Tonno wrote: > Hi, > I am pretty new to this stuff and i have created > successfully my first shapfile maps. Now i would like > to switch to a MySQL DB DataStore, but i really do not > know how to start. Can anyone help me, or give me some > good advice, link to visit?? > > Thanks > Martin > > > > _______________________________ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 > Project Admins to receive an Apple iPod Mini FREE for your judgement on > who ports your project to Linux PPC the best. Sponsored by IBM. > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php > _______________________________________________ > Geotools-gt2-users mailing list > Geo...@li... > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users |
From: Herve C. <her...@it...> - 2004-10-05 08:43:46
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> I would like, as martin, to use mySQL DataStore. <br> I had follow Rueben schulz advice so I read and try to adapt the How+to+use+a+PostGISDataStore but I did not succed ...<br> <span class="java-quote"><br> the code I have is <br> <br> java.util.Map params = new HashMap();<br> params.put("dbtype", "mysql"); //I had also try with "postgis"<br> params.put("host", "localhost"); <br> params.put("port", new Integer(3306)); <br> params.put("database", "test"); //the name of the database to connect to.<br> params.put("user", "testuser"); //the user to connect with<br> params.put("passwd", ""); //no password for this user<br> <br> DataStore mySQLpgDatastore = DataStoreFinder.getDataStore(params);<br> FeatureSource fsBC = mySQLpgDatastore.getFeatureSource("bc");<br> int nb = fsBC.getCount(Query.ALL);<br> System.out.println("bc count: " + nb);<br> <br> <br> the program halt on the folowing line :</span><br> <span class="java-quote"></span><br> <span class="java-quote"> FeatureSource fsBC = pgDatastore.getFeatureSource("</span>bc<span class="java-quote">"); </span><br> <span class="java-quote"></span><br> <span class="java-quote">where bc is the name of a table of my database</span><br> <span class="java-quote">the table bc contain one Geometry column, did this column should have a particular name ?</span><br> <span class="java-quote">did the table should contain other information (like an feature identifier) ?<br> may I have other column wich are not user by the GIS without interfering ?<br> did I had to respect a particular order in table colubm to make it work ?<br> </span><span class="java-quote">... </span><br> please, any one can help me ?<br> <span class="java-quote"><br> </span><br> <br> <br> Rueben Schulz wrote: <blockquote cite="mid1095996817.14580.4.camel@localhost.localdomain" type="cite"> <pre wrap="">Hi, Take a look at: <a class="moz-txt-link-freetext" href="http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore">http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore</a> This does not cover mysql, but the same technique can be used. Unfortunately the parameters needed by mysql are not yet described at: <a class="moz-txt-link-freetext" href="http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters">http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters</a> so you will need to hunt for them in the mysqlDataStore code. Rueben P.S. Once you find the parameters, please place them on the DataSterFinder parameters wiki page (if you have time). On Wed, 2004-09-22 at 08:19, Pizza Al Tonno wrote: </pre> <blockquote type="cite"> <pre wrap="">Hi, I am pretty new to this stuff and i have created successfully my first shapfile maps. Now i would like to switch to a MySQL DB DataStore, but i really do not know how to start. Can anyone help me, or give me some good advice, link to visit?? Thanks Martin _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! <a class="moz-txt-link-freetext" href="http://vote.yahoo.com">http://vote.yahoo.com</a> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: <a class="moz-txt-link-freetext" href="http://sf.net/ppc_contest.php">http://sf.net/ppc_contest.php</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </pre> </blockquote> <pre wrap=""><!----> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: <a class="moz-txt-link-freetext" href="http://sf.net/ppc_contest.php">http://sf.net/ppc_contest.php</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </pre> </blockquote> <br> </body> </html> |
From: Philippe S. <phi...@ma...> - 2004-10-05 09:04:42
|
Hello, I think you must have params.put("port", "3306"); In source file, param 'port' is declared like String.class regards Suray Philippe -----Message d'origine----- De : geo...@li... [mailto:geo...@li...]De la part de Herv= e Cros Envoy=E9 : mardi 5 octobre 2004 10:43 =C0 : geo...@li... Objet : Re: [Geotools-gt2-users] how to mysql + shapefile I would like, as martin, to use mySQL DataStore. I had follow Rueben schulz advice so I read and try to adapt the How+to+use+a+PostGISDataStore but I did not succed ... the code I have is java.util.Map params =3D new HashMap(); params.put("dbtype", "mysql"); //I had also try with "postgis" params.put("host", "localhost"); params.put("port", new Integer(3306)); params.put("database", "test"); //the name of the database to connect to. params.put("user", "testuser"); //the user to conne= ct with params.put("passwd", ""); //no password for t= his user DataStore mySQLpgDatastore =3D DataStoreFinder.getDataStore(params); FeatureSource fsBC =3D mySQLpgDatastore.getFeatureSource("b= c"); int nb =3D fsBC.getCount(Query.ALL); System.out.println("bc count: " + nb); the program halt on the folowing line : FeatureSource fsBC =3D pgDatastore.getFeatureSource("bc"); where bc is the name of a table of my database the table bc contain one Geometry column, did this column should have a particular name ? did the table should contain other information (like an feature identifier) ? may I have other column wich are not user by the GIS without interferin= g ? did I had to respect a particular order in table colubm to make it work= ? ... please, any one can help me ? Rueben Schulz wrote: Hi, Take a look at: http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore This does not cover mysql, but the same technique can be used. Unfortunately the parameters needed by mysql are not yet described at: http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters so you will need to hunt for them in the mysqlDataStore code. Rueben P.S. Once you find the parameters, please place them on the DataSterFinder parameters wiki page (if you have time). On Wed, 2004-09-22 at 08:19, Pizza Al Tonno wrote: Hi, I am pretty new to this stuff and i have created successfully my first shapfile maps. Now i would like to switch to a MySQL DB DataStore, but i really do not know how to start. Can anyone help me, or give me some good advice, link to visit?? Thanks Martin _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ Geotools-gt2-users mailing list Geo...@li... https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ Geotools-gt2-users mailing list Geo...@li... https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users ------------------------------------------------------- This SF.net ema= il is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Geotools-gt2-users mailin= g list Geo...@li... https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users |
From: Herve C. <her...@it...> - 2004-10-05 09:47:35
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> Thanks a lot !!!!<br> you are right, now it work fine. <br> <br> Thanks you <br> <br> Philippe Suray wrote: <blockquote cite="mid008601c4aab9$59949d40$a60...@ma..." type="cite"> <meta http-equiv="Content-Type" content="text/html; "> <meta content="MSHTML 6.00.2800.1126" name="GENERATOR"> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">Hello,</span></font></div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004"></span></font> </div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">I think you must have <font color="#000000" face="Times New Roman" size="3">params.put("port", "3306"); </font></span></font><font><span class="673225508-05102004">In source file, param 'port' is declared like String.class</span></font></div> <div><font><span class="673225508-05102004"></span></font> </div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">regards</span></font></div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004"></span></font> </div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">Suray Philippe</span></font></div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004"></span></font> </div> <blockquote> <div class="OutlookMessageHeader" align="left" dir="ltr"><font face="Tahoma" size="2">-----Message d'origine-----<br> <b>De :</b> <a class="moz-txt-link-abbreviated" href="mailto:geo...@li...">geo...@li...</a> [<a class="moz-txt-link-freetext" href="mailto:geo...@li...">mailto:geo...@li...</a>]<b>De la part de</b> Herve Cros<br> <b>Envoyé :</b> mardi 5 octobre 2004 10:43<br> <b>À :</b> <a class="moz-txt-link-abbreviated" href="mailto:geo...@li...">geo...@li...</a><br> <b>Objet :</b> Re: [Geotools-gt2-users] how to mysql + shapefile<br> <br> </font></div> I would like, as martin, to use mySQL DataStore. <br> I had follow Rueben schulz advice so I read and try to adapt the How+to+use+a+PostGISDataStore but I did not succed ...<br> <span class="java-quote"><br> the code I have is <br> <br> java.util.Map params = new HashMap();<br> params.put("dbtype", "mysql"); //I had also try with "postgis"<br> params.put("host", "localhost"); <br> params.put("port", new Integer(3306)); <br> params.put("database", "test"); //the name of the database to connect to.<br> params.put("user", "testuser"); //the user to connect with<br> params.put("passwd", ""); //no password for this user<br> <br> DataStore mySQLpgDatastore = DataStoreFinder.getDataStore(params);<br> FeatureSource fsBC = mySQLpgDatastore.getFeatureSource("bc");<br> int nb = fsBC.getCount(Query.ALL);<br> System.out.println("bc count: " + nb);<br> <br> <br> the program halt on the folowing line :</span><br> <span class="java-quote"></span><br> <span class="java-quote"> FeatureSource fsBC = pgDatastore.getFeatureSource("</span>bc<span class="java-quote">"); </span><br> <span class="java-quote"></span><br> <span class="java-quote">where bc is the name of a table of my database</span><br> <span class="java-quote">the table bc contain one Geometry column, did this column should have a particular name ?</span><br> <span class="java-quote">did the table should contain other information (like an feature identifier) ?<br> may I have other column wich are not user by the GIS without interfering ?<br> did I had to respect a particular order in table colubm to make it work ?<br> </span><span class="java-quote">... </span><br> please, any one can help me ?<br> <span class="java-quote"><br> </span><br> <br> <br> Rueben Schulz wrote: <blockquote cite="mid1095996817.14580.4.camel@localhost.localdomain" type="cite"> <pre wrap="">Hi, Take a look at: <a class="moz-txt-link-freetext" href="http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore">http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore</a> This does not cover mysql, but the same technique can be used. Unfortunately the parameters needed by mysql are not yet described at: <a class="moz-txt-link-freetext" href="http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters">http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters</a> so you will need to hunt for them in the mysqlDataStore code. Rueben P.S. Once you find the parameters, please place them on the DataSterFinder parameters wiki page (if you have time). On Wed, 2004-09-22 at 08:19, Pizza Al Tonno wrote: </pre> <blockquote type="cite"> <pre wrap="">Hi, I am pretty new to this stuff and i have created successfully my first shapfile maps. Now i would like to switch to a MySQL DB DataStore, but i really do not know how to start. Can anyone help me, or give me some good advice, link to visit?? Thanks Martin _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! <a class="moz-txt-link-freetext" href="http://vote.yahoo.com">http://vote.yahoo.com</a> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: <a class="moz-txt-link-freetext" href="http://sf.net/ppc_contest.php">http://sf.net/ppc_contest.php</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </pre> </blockquote> <pre wrap=""><!----> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: <a class="moz-txt-link-freetext" href="http://sf.net/ppc_contest.php">http://sf.net/ppc_contest.php</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </pre> </blockquote> <br> ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more <a class="moz-txt-link-freetext" href="http://productguide.itmanagersjournal.com/guidepromo.tmpl">http://productguide.itmanagersjournal.com/guidepromo.tmpl</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </blockquote> </blockquote> <br> </body> </html> |
From: Herve C. <her...@it...> - 2004-10-12 07:36:43
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> Hello again,<br> For sure, my question is stupid but ....<br> I' ve got an function that construct a layer from a database : <br> <br> <i> /**<br> *this function create an layer given an MySQL Table and a style.<br> *If an error occurs, return null<br> **/<br> public DefaultMapLayer makeLayer(String tableName,Style style){<br> //setting up params<br> java.util.Map params = new HashMap();<br> params.put("dbtype", "mysql");<br> params.put("host", "localhost"); //the name or ip address of the machine running MySQL<br> params.put("port","3306"); //the port that PostGIS is running on (generally 3306)<br> params.put("database", "mydb");//the name of the database to connect to.<br> params.put("user", "theuser"); //the user to connect with<br> params.put("passwd", "thepassword"); //the user's password.<br> <br> try{<br> DataStore mySQLpgDatastore = DataStoreFinder.getDataStore(params);<br> FeatureSource fs = mySQLpgDatastore.getFeatureSource(tableName);<br> return(new DefaultMapLayer(fs, style));<br> }<br> catch(Exception e){<br> System.err.println(e.getMessage());<br> return null;<br> }<br> }<br> </i><br> This function work fine, but I need also to make a layer from a SQL Query. <br> The query would be something like <br> <br> <i>SELECT House.id, House.geom, House.name FROM House, Town<br> Where Town.name="LakeCity"<br> AND House.town = town.id<br> </i><br> Is it possible to do this ?<br> I'd try innocently to replace in my function <i>tableName</i> with an sql query, but it didn't work :-)<br> <br> Herve Cros wrote: <blockquote cite="mid...@it..." type="cite"> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> Thanks a lot !!!!<br> you are right, now it work fine. <br> <br> Thanks you <br> <br> Philippe Suray wrote: <blockquote cite="mid008601c4aab9$59949d40$a60...@ma..." type="cite"> <meta http-equiv="Content-Type" content="text/html; "> <meta content="MSHTML 6.00.2800.1126" name="GENERATOR"> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">Hello,</span></font></div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004"></span></font> </div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">I think you must have <font color="#000000" face="Times New Roman" size="3">params.put("port", "3306"); </font></span></font><font><span class="673225508-05102004">In source file, param 'port' is declared like String.class</span></font></div> <div><font><span class="673225508-05102004"></span></font> </div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">regards</span></font></div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004"></span></font> </div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004">Suray Philippe</span></font></div> <div><font color="#0000ff" face="Arial" size="2"><span class="673225508-05102004"></span></font> </div> <blockquote> <div class="OutlookMessageHeader" align="left" dir="ltr"><font face="Tahoma" size="2">-----Message d'origine-----<br> <b>De :</b> <a class="moz-txt-link-abbreviated" href="mailto:geo...@li...">geo...@li...</a> [<a class="moz-txt-link-freetext" href="mailto:geo...@li...">mailto:geo...@li...</a>]<b>De la part de</b> Herve Cros<br> <b>Envoyé :</b> mardi 5 octobre 2004 10:43<br> <b>À :</b> <a class="moz-txt-link-abbreviated" href="mailto:geo...@li...">geo...@li...</a><br> <b>Objet :</b> Re: [Geotools-gt2-users] how to mysql + shapefile<br> <br> </font></div> I would like, as martin, to use mySQL DataStore. <br> I had follow Rueben schulz advice so I read and try to adapt the How+to+use+a+PostGISDataStore but I did not succed ...<br> <span class="java-quote"><br> the code I have is <br> <br> java.util.Map params = new HashMap();<br> params.put("dbtype", "mysql"); //I had also try with "postgis"<br> params.put("host", "localhost"); <br> params.put("port", new Integer(3306)); <br> params.put("database", "test"); //the name of the database to connect to.<br> params.put("user", "testuser"); //the user to connect with<br> params.put("passwd", ""); //no password for this user<br> <br> DataStore mySQLpgDatastore = DataStoreFinder.getDataStore(params);<br> FeatureSource fsBC = mySQLpgDatastore.getFeatureSource("bc");<br> int nb = fsBC.getCount(Query.ALL);<br> System.out.println("bc count: " + nb);<br> <br> <br> the program halt on the folowing line :</span><br> <span class="java-quote"></span><br> <span class="java-quote"> FeatureSource fsBC = pgDatastore.getFeatureSource("</span>bc<span class="java-quote">"); </span><br> <span class="java-quote"></span><br> <span class="java-quote">where bc is the name of a table of my database</span><br> <span class="java-quote">the table bc contain one Geometry column, did this column should have a particular name ?</span><br> <span class="java-quote">did the table should contain other information (like an feature identifier) ?<br> may I have other column wich are not user by the GIS without interfering ?<br> did I had to respect a particular order in table colubm to make it work ?<br> </span><span class="java-quote">... </span><br> please, any one can help me ?<br> <span class="java-quote"><br> </span><br> <br> <br> Rueben Schulz wrote: <blockquote cite="mid1095996817.14580.4.camel@localhost.localdomain" type="cite"> <pre wrap="">Hi, Take a look at: <a class="moz-txt-link-freetext" href="http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore">http://docs.codehaus.org/display/GEOTOOLS/How+to+use+a+PostGISDataStore</a> This does not cover mysql, but the same technique can be used. Unfortunately the parameters needed by mysql are not yet described at: <a class="moz-txt-link-freetext" href="http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters">http://docs.codehaus.org/display/GEOTOOLS/DataStoreFinder+Parameters</a> so you will need to hunt for them in the mysqlDataStore code. Rueben P.S. Once you find the parameters, please place them on the DataSterFinder parameters wiki page (if you have time). On Wed, 2004-09-22 at 08:19, Pizza Al Tonno wrote: </pre> <blockquote type="cite"> <pre wrap="">Hi, I am pretty new to this stuff and i have created successfully my first shapfile maps. Now i would like to switch to a MySQL DB DataStore, but i really do not know how to start. Can anyone help me, or give me some good advice, link to visit?? Thanks Martin _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! <a class="moz-txt-link-freetext" href="http://vote.yahoo.com">http://vote.yahoo.com</a> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: <a class="moz-txt-link-freetext" href="http://sf.net/ppc_contest.php">http://sf.net/ppc_contest.php</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </pre> </blockquote> <pre wrap=""><!----> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: <a class="moz-txt-link-freetext" href="http://sf.net/ppc_contest.php">http://sf.net/ppc_contest.php</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </pre> </blockquote> <br> ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more <a class="moz-txt-link-freetext" href="http://productguide.itmanagersjournal.com/guidepromo.tmpl">http://productguide.itmanagersjournal.com/guidepromo.tmpl</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </blockquote> </blockquote> <br> ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more <a class="moz-txt-link-freetext" href="http://productguide.itmanagersjournal.com/guidepromo.tmpl">http://productguide.itmanagersjournal.com/guidepromo.tmpl</a> _______________________________________________ Geotools-gt2-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Geo...@li...">Geo...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users">https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users</a> </blockquote> <br> </body> </html> |
From: Jody G. <jga...@re...> - 2004-10-12 08:11:13
|
Herve Cros wrote: > Hello again, > For sure, my question is stupid but .... > I' ve got an function that construct a layer from a database : > - snip - > This function work fine, but I need also to make a layer from a SQL > Query. > The query would be something like > > /SELECT House.id, House.geom, House.name FROM House, Town > Where Town.name="LakeCity" > AND House.town = town.id > / > Is it possible to do this ? Sigh - not yet. We have been trying to figure out how to do a "Join" for a while now. With a normal query (one table) - you can ask the question (ie an OGC Filter). With a Join you need two .. The best example right now is here: - http://svn.geotools.org/geotools/trunk/gt/ext/validation/src/org/geotools/validation/relate/OverlapsIntegrity.java Not that it is a very good example :-P Jody |