Compare the "Advanced" settings in the datasource setup from your
working CF server to the OpenBD settings.
For example, it could be the "Per-Request Connections" setting.
Outside the Administrator applications, OpenBD and Adobe CFML both store
their datasource settings in a xml file. Comparing those directly might
give you some insight.
It's also possible that the two CFML servers use different Oracle JDBC
driver versions, or some custom Connection or Initialization strings may
be needed.
HTH,
Al
On 3/14/2013 6:40 AM, Manuel Reimer wrote:
Hello,
I have an application, which does something like this:
In the first cfml file (file1.cfm), a new database entry is created
where the sequence number is created using ".nextval" in the SQL query.
A few following SQL queries in the same file use ".currval" to reference
the same number and insert values to other tables.
After finishing this task. A popup window will be opened with a second
cfml file (file2.cfm), which directly uses ".currval" to reference back
to the created database entry.
In this popup window, I now get a SQL Error:
ORA-08002: sequence T_REQUEST_SEQ.CURRVAL is not yet defined in this session
This application worked well with Adobe Coldfusion. For me it seems like
Coldfusion somehow opened one "global session" on the database which
exists between requests but OpenBD opens one session per page request,
right?
Is it possible to change this configuration, so a global DB session is
created on OpenBD or is it better to rewrite my code to pass the
database ID via HTTP GET parameter?
Mit freundlichen Grüßen / Best regards
Manuel Reimer
Tel. 09352/18-1578
--
--
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/groups/opt_out.
