Dynamic DSN

dev google-group-archive
1

I am looking for a way to setup a DSN for an application to use - but I
need to assign the information (database type, db name, credentials, port,
etc) from an external source (info from another registry). I can pull in
and parse the info from the other registry - I just need to know how (if
there is a way) to create a DSN from inside my application code (like in
the Application.cfc’s onApplicationStart method).

2

Hi Sid,

Mark Drew blogged about that feature in Railo.

If you want to change the DSN on the fly, you should be able to do
something like this:

SethOn Thu, Apr 9, 2015 at 3:14 PM, Sid Wing <@Sid_Wing> wrote:

I am looking for a way to setup a DSN for an application to use - but I
need to assign the information (database type, db name, credentials, port,
etc) from an external source (info from another registry). I can pull in
and parse the info from the other registry - I just need to know how (if
there is a way) to create a DSN from inside my application code (like in
the Application.cfc’s onApplicationStart method).

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

3

That is my preferred method too. You can then wrap all that up in
environment detection and your app becomes more portable so you can deploy
and not fiddle around with Admin settings first before it starts working.On Friday, April 10, 2015 at 4:52:15 AM UTC-5, Chris Blackwell wrote:

You can set the datasource directly in your Application.cfc

// Application.cfc
component {

this.name = “myapp”
this.datasources = {
“mydsn”: {
“class”: “org.gjt.mm.mysql.Driver”
,“connectionString”: “jdbc:mysql://127.0.0.1:3306/test”
,“username”: “user”
,“password”: “password”
}

//  add as many as you like here

}

// set the default datasource used for queries or orm
this.datasource = “mydsn”;

}

On 10 April 2015 at 06:00, Seth Johnson <cfx...@gmail.com <javascript:>> wrote:

Hi Sid,

Mark Drew blogged about that feature in Railo.

Railo Technologies - Open Source CFML - Professional Services, Consulting and Support

If you want to change the DSN on the fly, you should be able to do
something like this:

Seth

On Thu, Apr 9, 2015 at 3:14 PM, Sid Wing <sid....@gmail.com <javascript:> wrote:

I am looking for a way to setup a DSN for an application to use - but I
need to assign the information (database type, db name, credentials, port,
etc) from an external source (info from another registry). I can pull in
and parse the info from the other registry - I just need to know how (if
there is a way) to create a DSN from inside my application code (like in
the Application.cfc’s onApplicationStart method).

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

4

absolutely, yes you can
you need to replace /@ with your values.
I’m not familiar with oracle, so i’m not sure about the exact format of the
connection string.
take a look here →
http://docs.oracle.com/cd/B28359_01/java.111/b31224/jdbcthin.htm
theres an example that shows a connection string like
“jdbc:oracle:thin:@prodHost:1521:ORCL”;On 10 April 2015 at 16:19, Sid Wing <@Sid_Wing> wrote:

Chris -

Can I omit all the “allowed_” attributes and simply let the DB Server
handle permissions then?

That would give me something like this:

Would that be correct?

On Fri, Apr 10, 2015 at 9:47 AM, Chris Blackwell <@Chris_Blackwell> wrote:

you probably want

classname=“oracle.jdbc.OracleDriver”
dsn=“jdbc:oracle:thin:/@”

I would also caution against setting insert/update/delete/etc = false
when you create the datasource, for two reasons.

  1. this places an overhead on Lucee, that it must parse every sql
    statement and try and determine if it is allowed, this could be a real
    performance hit
  2. Lucee’s parsing is not fool-proof and you should not assume that these
    settings make your connection truly readonly.

implement the correct security settings on the database server, if you
want readonly, create a readonly user.

Chris

On 10 April 2015 at 15:37, Sid Wing <@Sid_Wing> wrote:

What would the classname value be for an Oracle DB? org.Oracle.Driver?
I’m not finding a place to find a list of classname values for that CFAdmin
tag…

On Fri, Apr 10, 2015 at 9:06 AM, Dan Kraus <@Dan_Kraus> wrote:

That is my preferred method too. You can then wrap all that up in
environment detection and your app becomes more portable so you can deploy
and not fiddle around with Admin settings first before it starts working.

On Friday, April 10, 2015 at 4:52:15 AM UTC-5, Chris Blackwell wrote:

You can set the datasource directly in your Application.cfc

// Application.cfc
component {

this.name = “myapp”
this.datasources = {
“mydsn”: {
“class”: “org.gjt.mm.mysql.Driver”
,“connectionString”: “jdbc:mysql://127.0.0.1:3306/test”
,“username”: “user”
,“password”: “password”
}

//  add as many as you like here

}

// set the default datasource used for queries or orm
this.datasource = “mydsn”;

}

On 10 April 2015 at 06:00, Seth Johnson cfx...@gmail.com wrote:

Hi Sid,

Mark Drew blogged about that feature in Railo.
Railo Technologies - Open Source CFML - Professional Services, Consulting and Support
datasources-in-application-cfc

If you want to change the DSN on the fly, you should be able to do
something like this:

Seth

On Thu, Apr 9, 2015 at 3:14 PM, Sid Wing sid....@gmail.com wrote:

I am looking for a way to setup a DSN for an application to use -
but I need to assign the information (database type, db name, credentials,
port, etc) from an external source (info from another registry). I can
pull in and parse the info from the other registry - I just need to know
how (if there is a way) to create a DSN from inside my application code
(like in the Application.cfc’s onApplicationStart method).

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-
4b39-b403-34466f1ae0f2%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%
40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries
of laser and circuit, crystal and scanner, holographic demons and
invocations of equations. These are the tools we employ, and we know many
things.” - Elric

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAB%3DtfTqXicFxTva3VLF7RX4Eq2QRW5kynw2MhD6WmSbaN%3DC7dw%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAB%3DtfTqXicFxTva3VLF7RX4Eq2QRW5kynw2MhD6WmSbaN%3DC7dw%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries of
laser and circuit, crystal and scanner, holographic demons and invocations
of equations. These are the tools we employ, and we know many things.” -
Elric

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7uLhWC%2BefzUXif7biFULXHB0xk%2BUo3hhUOk-gauh_Hs-Q%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7uLhWC%2BefzUXif7biFULXHB0xk%2BUo3hhUOk-gauh_Hs-Q%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

5

you probably want

classname=“oracle.jdbc.OracleDriver”
dsn=“jdbc:oracle:thin:/@”

I would also caution against setting insert/update/delete/etc = false when
you create the datasource, for two reasons.

  1. this places an overhead on Lucee, that it must parse every sql statement
    and try and determine if it is allowed, this could be a real performance hit
  2. Lucee’s parsing is not fool-proof and you should not assume that these
    settings make your connection truly readonly.

implement the correct security settings on the database server, if you want
readonly, create a readonly user.

ChrisOn 10 April 2015 at 15:37, Sid Wing <@Sid_Wing> wrote:

What would the classname value be for an Oracle DB? org.Oracle.Driver?
I’m not finding a place to find a list of classname values for that CFAdmin
tag…

On Fri, Apr 10, 2015 at 9:06 AM, Dan Kraus <@Dan_Kraus> wrote:

That is my preferred method too. You can then wrap all that up in
environment detection and your app becomes more portable so you can deploy
and not fiddle around with Admin settings first before it starts working.

On Friday, April 10, 2015 at 4:52:15 AM UTC-5, Chris Blackwell wrote:

You can set the datasource directly in your Application.cfc

// Application.cfc
component {

this.name = “myapp”
this.datasources = {
“mydsn”: {
“class”: “org.gjt.mm.mysql.Driver”
,“connectionString”: “jdbc:mysql://127.0.0.1:3306/test”
,“username”: “user”
,“password”: “password”
}

//  add as many as you like here

}

// set the default datasource used for queries or orm
this.datasource = “mydsn”;

}

On 10 April 2015 at 06:00, Seth Johnson cfx...@gmail.com wrote:

Hi Sid,

Mark Drew blogged about that feature in Railo.
Railo Technologies - Open Source CFML - Professional Services, Consulting and Support
datasources-in-application-cfc

If you want to change the DSN on the fly, you should be able to do
something like this:

Seth

On Thu, Apr 9, 2015 at 3:14 PM, Sid Wing sid....@gmail.com wrote:

I am looking for a way to setup a DSN for an application to use - but
I need to assign the information (database type, db name, credentials,
port, etc) from an external source (info from another registry). I can
pull in and parse the info from the other registry - I just need to know
how (if there is a way) to create a DSN from inside my application code
(like in the Application.cfc’s onApplicationStart method).

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%
40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries of
laser and circuit, crystal and scanner, holographic demons and invocations
of equations. These are the tools we employ, and we know many things.” -
Elric

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

6

@Sid These settings will be removed from the admin as database security
should be handled by the DB server.
So yes, you can omit the allowed parameters or just set them all to true.2015-04-10 17:25 GMT+02:00 Chris Blackwell <@Chris_Blackwell>:

absolutely, yes you can
you need to replace /@ with your values.
I’m not familiar with oracle, so i’m not sure about the exact format of
the connection string.
take a look here →
Features Specific to JDBC Thin
theres an example that shows a connection string like
“jdbc:oracle:thin:@prodHost:1521:ORCL”;

On 10 April 2015 at 16:19, Sid Wing <@Sid_Wing> wrote:

Chris -

Can I omit all the “allowed_” attributes and simply let the DB Server
handle permissions then?

That would give me something like this:

Would that be correct?

On Fri, Apr 10, 2015 at 9:47 AM, Chris Blackwell <@Chris_Blackwell> wrote:

you probably want

classname=“oracle.jdbc.OracleDriver”
dsn=“jdbc:oracle:thin:/@”

I would also caution against setting insert/update/delete/etc = false
when you create the datasource, for two reasons.

  1. this places an overhead on Lucee, that it must parse every sql
    statement and try and determine if it is allowed, this could be a real
    performance hit
  2. Lucee’s parsing is not fool-proof and you should not assume that
    these settings make your connection truly readonly.

implement the correct security settings on the database server, if you
want readonly, create a readonly user.

Chris

On 10 April 2015 at 15:37, Sid Wing <@Sid_Wing> wrote:

What would the classname value be for an Oracle DB? org.Oracle.Driver?
I’m not finding a place to find a list of classname values for that CFAdmin
tag…

On Fri, Apr 10, 2015 at 9:06 AM, Dan Kraus <@Dan_Kraus> wrote:

That is my preferred method too. You can then wrap all that up in
environment detection and your app becomes more portable so you can deploy
and not fiddle around with Admin settings first before it starts working.

On Friday, April 10, 2015 at 4:52:15 AM UTC-5, Chris Blackwell wrote:

You can set the datasource directly in your Application.cfc

// Application.cfc
component {

this.name = “myapp”
this.datasources = {
“mydsn”: {
“class”: “org.gjt.mm.mysql.Driver”
,“connectionString”: “jdbc:mysql://127.0.0.1:3306/test”
,“username”: “user”
,“password”: “password”
}

//  add as many as you like here

}

// set the default datasource used for queries or orm
this.datasource = “mydsn”;

}

On 10 April 2015 at 06:00, Seth Johnson cfx...@gmail.com wrote:

Hi Sid,

Mark Drew blogged about that feature in Railo.
Railo Technologies - Open Source CFML - Professional Services, Consulting and Support
datasources-in-application-cfc

If you want to change the DSN on the fly, you should be able to do
something like this:

Seth

On Thu, Apr 9, 2015 at 3:14 PM, Sid Wing sid....@gmail.com wrote:

I am looking for a way to setup a DSN for an application to use -
but I need to assign the information (database type, db name, credentials,
port, etc) from an external source (info from another registry). I can
pull in and parse the info from the other registry - I just need to know
how (if there is a way) to create a DSN from inside my application code
(like in the Application.cfc’s onApplicationStart method).

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-
4b39-b403-34466f1ae0f2%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/
CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%
40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries
of laser and circuit, crystal and scanner, holographic demons and
invocations of equations. These are the tools we employ, and we know many
things.” - Elric

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAB%3DtfTqXicFxTva3VLF7RX4Eq2QRW5kynw2MhD6WmSbaN%3DC7dw%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAB%3DtfTqXicFxTva3VLF7RX4Eq2QRW5kynw2MhD6WmSbaN%3DC7dw%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries of
laser and circuit, crystal and scanner, holographic demons and invocations
of equations. These are the tools we employ, and we know many things.” -
Elric

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7uLhWC%2BefzUXif7biFULXHB0xk%2BUo3hhUOk-gauh_Hs-Q%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7uLhWC%2BefzUXif7biFULXHB0xk%2BUo3hhUOk-gauh_Hs-Q%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAB%3DtfTrDZKpCK_Bkkv9Yog%3DrhxEqVbppnM2NNTaRHaeagq7UfQ%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAB%3DtfTrDZKpCK_Bkkv9Yog%3DrhxEqVbppnM2NNTaRHaeagq7UfQ%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
Michael van Leest

7

Michael -

Thanks for the heads up! I always thought that it was best to let the DB
server handle as much of the weight as possible (as that is what they are
designed for).On Saturday, April 11, 2015 at 3:43:21 AM UTC-5, Michael van Leest wrote:

@Sid These settings will be removed from the admin as database security
should be handled by the DB server.
So yes, you can omit the allowed parameters or just set them all to true.

2015-04-10 17:25 GMT+02:00 Chris Blackwell <ch...@team193.com
<javascript:>>:

absolutely, yes you can
you need to replace /@ with your values.
I’m not familiar with oracle, so i’m not sure about the exact format of
the connection string.
take a look here →
http://docs.oracle.com/cd/B28359_01/java.111/b31224/jdbcthin.htm
theres an example that shows a connection string like
“jdbc:oracle:thin:@prodHost:1521:ORCL”;

On 10 April 2015 at 16:19, Sid Wing <sid....@gmail.com <javascript:>> wrote:

Chris -

Can I omit all the “allowed_” attributes and simply let the DB Server
handle permissions then?

That would give me something like this:

Would that be correct?

On Fri, Apr 10, 2015 at 9:47 AM, Chris Blackwell <ch...@team193.com <javascript:>> wrote:

you probably want

classname=“oracle.jdbc.OracleDriver”
dsn=“jdbc:oracle:thin:/@”

I would also caution against setting insert/update/delete/etc = false
when you create the datasource, for two reasons.

  1. this places an overhead on Lucee, that it must parse every sql
    statement and try and determine if it is allowed, this could be a real
    performance hit
  2. Lucee’s parsing is not fool-proof and you should not assume that
    these settings make your connection truly readonly.

implement the correct security settings on the database server, if you
want readonly, create a readonly user.

Chris

On 10 April 2015 at 15:37, Sid Wing <sid....@gmail.com <javascript:>> wrote:

What would the classname value be for an Oracle DB?
org.Oracle.Driver? I’m not finding a place to find a list of classname
values for that CFAdmin tag…

On Fri, Apr 10, 2015 at 9:06 AM, Dan Kraus <dsk...@gmail.com <javascript:>> wrote:

That is my preferred method too. You can then wrap all that up in
environment detection and your app becomes more portable so you can deploy
and not fiddle around with Admin settings first before it starts working.

On Friday, April 10, 2015 at 4:52:15 AM UTC-5, Chris Blackwell wrote:

You can set the datasource directly in your Application.cfc

// Application.cfc
component {

this.name = “myapp”
this.datasources = {
“mydsn”: {
“class”: “org.gjt.mm.mysql.Driver”
,“connectionString”: “jdbc:mysql://127.0.0.1:3306/test”
,“username”: “user”
,“password”: “password”
}

//  add as many as you like here

}

// set the default datasource used for queries or orm
this.datasource = “mydsn”;

}

On 10 April 2015 at 06:00, Seth Johnson cfx...@gmail.com wrote:

Hi Sid,

Mark Drew blogged about that feature in Railo.
Railo Technologies - Open Source CFML - Professional Services, Consulting and Support
datasources-in-application-cfc

If you want to change the DSN on the fly, you should be able to do
something like this:

Seth

On Thu, Apr 9, 2015 at 3:14 PM, Sid Wing sid....@gmail.com wrote:

I am looking for a way to setup a DSN for an application to use -
but I need to assign the information (database type, db name, credentials,
port, etc) from an external source (info from another registry). I can
pull in and parse the info from the other registry - I just need to know
how (if there is a way) to create a DSN from inside my application code
(like in the Application.cfc’s onApplicationStart method).

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-
4b39-b403-34466f1ae0f2%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b4ae5e0f-6256-4b39-b403-34466f1ae0f2%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/
CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%
40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAE8ZmabUMQ8oQw9JnemcSVKJcBcRJmK4R%3DKy0NHFJKgYyf%2Bm3w%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in
the Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b968fa44-b972-4f73-9956-4c59149ed387%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries
of laser and circuit, crystal and scanner, holographic demons and
invocations of equations. These are the tools we employ, and we know many
things.” - Elric

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vt3b%3DtdKmM%2B-i3mNNffJeviODWa80iCpta9LAe-311wg%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/XeOQJV8kSSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAB%3DtfTqXicFxTva3VLF7RX4Eq2QRW5kynw2MhD6WmSbaN%3DC7dw%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAB%3DtfTqXicFxTva3VLF7RX4Eq2QRW5kynw2MhD6WmSbaN%3DC7dw%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sid Wing
“We are dreamers, shapers, singers, and makers. We study the mysteries
of laser and circuit, crystal and scanner, holographic demons and
invocations of equations. These are the tools we employ, and we know many
things.” - Elric

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7uLhWC%2BefzUXif7biFULXHB0xk%2BUo3hhUOk-gauh_Hs-Q%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7uLhWC%2BefzUXif7biFULXHB0xk%2BUo3hhUOk-gauh_Hs-Q%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAB%3DtfTrDZKpCK_Bkkv9Yog%3DrhxEqVbppnM2NNTaRHaeagq7UfQ%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAB%3DtfTrDZKpCK_Bkkv9Yog%3DrhxEqVbppnM2NNTaRHaeagq7UfQ%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

–
Michael van Leest