For Oracle developers:

In ..\Apache Software Foundation\Tomcat 6.0\conf\server.xml

<!-- CDBC configuration -->

    <Environment name="cdbc/database"

        type="java.lang.String"

        value="oracle"

    />

    <Environment name="cdbc/transaction-control"

        type="java.lang.String"

        value="oracle"

    />

    <Environment name="cdbc/table-type"

        type="java.lang.String"

        value="TABLE,VIEW,SYNONYM"

    />

   <Resource name="cdbc-mysql"  

     auth="Container"

     type="javax.sql.DataSource"

     factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"

     driverClassName="oracle.jdbc.OracleDriver"

     url="jdbc:oracle:thin:@<ip-adress>:<port>:SID"

     username="scott"

     password="tiger"

     maxActive="20"

     maxIdle="10"

  />

In ..\Apache Software Foundation\Tomcat 6.0\lib

Oracle driver: „ojdbc14.jar"

??? Ressource name

<Resource name="cdbc-oracle" produces the following error:

com.curl.cdbc.CdbcException: javax.naming.NameNotFoundException: Name cdbc-mysql is not bound in this ContextAlso for use with Oracle it has to be "cdbc-mysql". A bug?

???

With Resource name "dbs-mysql"  it works for Oracle and outputs:

http://localhost:8080/cdbc-server/CdbcServlet

This is class com.curl.cdbc.CdbcServlet

Servlets: 0

transaction-control: oracle

Init param:null

op=null

CDBC 1.1.0 2007-05-01 0000

http://localhost:8080/cdbc-server/CdbcServlet?op=getdbinfo

This is class com.curl.cdbc.CdbcServlet

Servlets: 0

transaction-control: oracle

Init param:null

op=getdbinfo

<CDBC>  <DBATTR NAME="allProceduresAreCallable">false</DBATTR>

...

The following CURL hangs in the browser without error messages.

{curl 7.0 applet}

{curl-file-attributes character-encoding = "iso-latin-2"}

{import * from CURL.DATA-ACCESS.BASE}

{import * from CURL.DATA-ACCESS.CONNECTED}

{let connection:Connection =

    {BasicConnection {url "http://localhost:8080/cdbc-server/CdbcServlet"}}

}

{RecordGrid

    record-source = {connection.create-record-set "cdbc-mysql","select * from emp"}}

Don't know if "cdbc-mysql" is the correct database-name in the CURL notation. Tried also "oracle" and the Oracle SID without success.

Any ideas?

Thanks ,

changed to your advice:

{connection.create-record-set "scott", "select * from emp"}}

After

waiting 10 minutes the applet throws an error:

Call Stack

CommitFailed:

StandardDateDomain failed to parse String: '12/17/2080 0:0:0'.

….

RecordGrid.default

(constructor)  ??:??

Applet:

c:\Curl\Ora1.curl

CommitFailed:

StandardDateDomain failed to parse String: '12/17/2080 0:0:0'.

#0

BasicConnection.fill-record-set-from-stream ??:??

#1

BasicConnection.fill-record-set-using-xml ??:??

#2

BasicConnection.fill-record-set ??:??

#3

BasicConnectedRecordSet.load ??:??

#4

RecordSetDisplay.default (constructor) ??:??

#5

RecordGrid.default (constructor) ??:??

#6

Ora1.curl:11

After

"Continue" got message in Browser:

<Error>

• An error occurred while loading this applet.

CommitFailed:

StandardDateDomain failed to parse String: '12/17/2080 0:0:0'.

Call Stack: Applet is running

Applet Manager: State = active

RTE Console: no messages

What’s about: server.xml

&lt;Resource name="cdbc-oracle" produces the following error: </span>

com.curl.cdbc.CdbcException: javax.naming.NameNotFoundException: Name cdbc-mysql is not bound in this Context

Here my environment:

CURL 7.0.1000 beta

Build: 7.0.0.  beta kendall/0-34

Supported API Versions: 7.0.0,6.0.2

Debuggebale API Versions: 7.0

Apache Tomcat 6.0.16

JAVA_HOME: C:\Programme\Java\jre1.6.0_05

MS Windows XP Pro, Ver. 2002, Service Pack 2

Yes, installed is:

C:\Programme\Apache Software Foundation\Tomcat 6.0\conf\Catalina\localhost\cdbc-server.xml

and reads:

&lt;Context path="/cdbc-server" reloadable="false"&gt;

&lt;Logger className="org.apache.catalina.logger.SystemOutLogger"

verbosity="4" timestamp="true"/&gt;

&lt;ResourceLink name="cdbc/transaction-control"

global="cdbc/transaction-control"

type="java.lang.String" /&gt;

&lt;ResourceLink name="cdbc/table-type" global="cdbc/table-type"

type="java.lang.String" /&gt;

&lt;ResourceLink name="jdbc/cdbc" global="cdbc-mysql"

type="javax.sql.DataSource" /&gt;

&lt;ResourceLink name="jdbc/cdbc-mysql" global="cdbc-mysql"

type="javax.sql.DataSource" /&gt;

&lt;ResourceLink name="jdbc/cdbc-oracle" global="cdbc-oracle"

type="javax.sql.DataSource" /&gt;

&lt;ResourceLink name="cdbc/default-schema/oracle/en"

global="cdbc/default-schema/oracle/en"

type="java.lang.String" /&gt;

&lt;ResourceLink name="cdbc/default-schema/oracle/ja"

global="cdbc/default-schema/oracle/ja"

type="java.lang.String" /&gt;

&lt;/Context&gt;

Changed:

&lt;ResourceLink name="jdbc/cdbc" global="cdbc-mysql"

to

&lt;ResourceLink name="jdbc/cdbc" global="cdbc-oracle"

but same error.

With RDBMS ORACLE the CURL documentation should better read:

create-record-set (method)

public 

{BasicConnection.create-record-set

schema_name:String,

query:String,

request-modifiable?:bool = false,

size-limit:int = -1,

...:EventHandler

}:BasicConnectedRecordSet

&lt;schema_name&gt; instead of &lt;database_name&gt;

ORACLE &lt;schema_name&gt; is identical to &lt;user_name&gt;

Our Database environment:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

Database Server on:

HP-UX oracle B.11.23 U ia64 (ta)

Do you have CURL installations with DBMS Oracle 10gR2 ???

Sorry for the:

&lt;!if !supportEmptyParas&gt; &lt;!endif&gt; and ...

I pasted the text from MS WinWord 2000 and did no preview.

tried:

def conn =

    {BasicConnection {url "http://localhost:8080/cdbc-server/CdbcServlet"}, serialize?=true}

{RecordGrid record-source =

    {conn.create-record-set ...

throws exception:

def conn = BasicConnection @0x04271030

&lt;Error&gt; - An error occurred while loading this applet.

SyntaxError: file:Ora1.curl:10[5]: 'conn' is not recognized.

The following program worked, but showed (also with serialize) the RecordGrid in Browser firefox 2.0.0.14

only after 10 minutes:

{curl 7.0 applet}

{curl-file-attributes character-encoding = "windows-latin-1"}

{import * from CURL.DATA-ACCESS.BASE}

{import * from CURL.DATA-ACCESS.CONNECTED}

{let conn =

    {BasicConnection {url "http://localhost:8080/cdbc-server/CdbcServlet"}, serialize?=true}

}   

{RecordGrid record-source =

    {conn.create-record-set "scott", "select empno,ename from emp"}}

To simplify no DATE column was selected.

Tried also to select a modifiable Grid-Data:

{RecordGrid record-source =

    {conn.create-record-set "scott", "select empno,ename from emp"}, request-modifiable?=true}

but got message:

Error: Option name 'request-modifiable?' is not defined for RecordGrid @0x04137204.

Documentation reads:

request-modifiable? (field)

public-get protected-set request-modifiable?:bool

Class: ConnectedRecordSet

Package: CURL.DATA-ACCESS.CONNECTED

If true, an attempt will be made to return a modifiable RecordSet.

Some subclasses may be unable to create a modifiable RecordSet if

the query is too complex or if the Connection does not allow it for any reason.

Does this mean that CURL has no updateable RecordGrid?

A simple query running against an Oracle database already with these problems

1. select Date problem

2. Time problem, waiting 10 minutes to see the Grid, also after serialize?=true

3. Grid data not modifiable

4. CPU utilization with 99% by surge.exe, for the whole 10 minutes (other programs are nearly unusable)

   After Grid display CPU utilization is again normal (surge.exe falls below 1%).

Please read about your "fit-client".

http://developers.curl.com/blogs/community_blog/2008/06/30/curl-customer-presents-at-catalyst-conference-san-diego-june-26-2008

Curl customer presents at Catalyst Conference, San Diego, June 26, 2008

Are there any complete ORACLE CRUD-examples with a modifiable DataGrid and modifiable TreeView ?

(C)reate    INSERT

(R)ead      SELECT

(U)pdate   UPDATE

(D)elete    DELETE

Thanks for your patience.

&gt; 1. select Date problem

Probably, it will work, if you set serialize? = true.

&gt; 2. Time problem, waiting 10 minutes to see the Grid, also after serialize?=true

As Oracle has large datas, which are data dictionaries and such, in just one database/instance, you should set "default-schema" to filter datas. You will should add a few elements in the server.xml and cdbc-server.xml like this:

server.xml

    &lt;Environment name="cdbc/default-schema/oracle" type="java.lang.String" value="SCOTT" /&gt;

cdbc-server.xml

   &lt;ResourceLink name="cdbc/default-schema/oracle" global="cdbc/default-schema/oracle" type="java.lang.String" /&gt;

   &lt;ResourceLink name="cdbc/database" global="cdbc/database" type="java.lang.String" /&gt;

&gt; 3. Grid data not modifiable

&gt; {RecordGrid record-source = {conn.create-record-set "scott", "select empno,ename from emp"}, request-modifiable?=true}

request-modifiable? is not the argument of RecordGrid, it is the argument of create-record-set method. So you have to write the following.

&gt; {RecordGrid record-source = {conn.create-record-set "scott", "select empno,ename from emp", request-modifiable?=true}}

&gt; 4. CPU utilization with 99% by surge.exe, for the whole 10 minutes (other programs are nearly unusable)

  Probably, this problem is the same as No.2 issue.

&gt; CRUD examples

You can use BasicConneciton.execute like this:

{conn.execute "SCOTT", "UPDATE EMP SET COL = 1"}

And also, you can modify records on the RecordGrid and call commit method.

You can use BasicConnectedRecordSet.commit method, after you modified cell datas on RecordGrid.

def rs = {conn.create-record-set "scott", "select * from emp", request-modifiable? = true}

.....

{CommandButton label = "commit",

{on Action do

{rs.commit} || After you modified cell datas, please press this button.

}

}