Newb and unsure if this can be done:
1.) I installed OBD for GAE into eclipse -- works fine at
http://localhost:8888/
2.) Trying to connect to a local instance of mysql (test db working
fine at port 3306) I then copied the <datasource> info below into the
<cfquery> section of bluedragon.xml
3.) When I attempt to
<cfquery name="xyz" datasource="mysql">
select *
from test
</cfquery>
<cfdump var="xyz">
the CFML Runtime Error informs it expected "select from <kind>"
I understand GAE datastore works and frankly this MySql connect is
purely an interim step for development ease/practice but if it can be
done am I missing a big step (quite likely as a noob fwiw)
----------------------------------------
<datasource name="mysql">
<password>xxxxx</password>
<connectionretries>0</connectionretries>
<sqlupdate>true</sqlupdate>
<sqldelete>true</sqldelete>
<username>root</username>
<drivername>org.gjt.mm.mysql.Driver</drivername>
<sqlstoredprocedures>true</sqlstoredprocedures>
<perrequestconnections>true</perrequestconnections>
<sqlinsert>true</sqlinsert>
<sqlselect>true</sqlselect>
<connectiontimeout>120</connectiontimeout>
<databasename>temp</databasename>
<initstring></initstring>
<logintimeout>120</logintimeout>
<hoststring>jdbc:mysql://localhost:3306/myDatabaseName?
useUnicode=true</hoststring>
<maxconnections>24</maxconnections>
<name>mysql</name>
</datasource>
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en