I would really like to use is as part of DataSourceCreate().
as an example ...
ds = {
username : "dbUser",
password : "Password",
databasename : "MyDB",
drivername : "com.mysql.jdbc.Driver",
hoststring :
"jdbc:mysql://mydb.host.com:3306/MyDB?cacheResultSetMetadata=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull",
sqldelete : "false",
sqlinsert : "false",
sqlupdate : "false"
};
DataSourceCreate( "mydsRO", ds );
On Thursday, June 5, 2014 12:53:27 AM UTC-7, Matthew Roach wrote:
>
> If you are using the bluedragon.xml you can use the <sqldelete> /
> <sqlupdate> / <sqlinsert> and <sqlselect> settings
>
> Example:
>
> <datasource name="mysql">
> <password></password>
> <connectionretries>0</connectionretries>
> <sqlupdate>true</sqlupdate>
> <sqldelete>true</sqldelete>
> <username></username>
> <drivername>com.mysql.jdbc.Driver</drivername>
> <sqlstoredprocedures>true</sqlstoredprocedures>
> <perrequestconnections>true</perrequestconnections>
> <sqlinsert>true</sqlinsert>
> <sqlselect>true</sqlselect>
> <connectiontimeout>120</connectiontimeout>
> <databasename>myDatabaseName</databasename>
> <initstring></initstring>
> <logintimeout>120</logintimeout>
> <hoststring>jdbc:mysql://localhost:3306/myDatabaseName?useUnicode=true</hoststring>
>
>
> <maxconnections>24</maxconnections>
> <connectionperpage>false</connectionperpage>
> <name>mysql</name>
> </datasource>
>
>
> > Skellington <mailto:[email protected] <javascript:>>
> > 05 June 2014 04:17
> > Hello,
> > How do I go about reading the advanced settings of a datasource? My
> > second part to the question is, how do I set them?
> >
> > What I'm looking to do is setup and readonly datasource by only
> > selecting the "Select" SQL operation.
> >
> > Thanks,
> > Charlie
> >
> >
> >
> >
> >
> >
> > --
> > --
> > online documentation: http://openbd.org/manual/
> > http://groups.google.com/group/openbd?hl=en
> >
> > ---
> > You received this message because you are subscribed to the Google
> > Groups "Open BlueDragon" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> > an email to [email protected] <javascript:>
> > <mailto:[email protected] <javascript:>>.
> > For more options, visit https://groups.google.com/d/optout.
>
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
