Comments (6)
I am using fitnesse version "v20151230"
from jdbcslim.
Hi Bhatt,
happy to help.
Can you send me the wiki page you try to test.
from jdbcslim.
Hey,
Thanks for the reply! Here is what i am trying to do:
!define orderNumber {123456789}
!** Setup jdbcSlim
|import |
|six42.fitnesse.jdbcslim|
|define table type |
|SQLCommand as Table|
**!
!** Driver Specific Setup
!path plugins\jdbcslim\ojdbc6-11.jar
!|Define Properties|TestDatabase |
|key |value |
|jdbcDriver |oracle.jdbc.OracleDriver |
|#DBURL |jdbc:h2:~/h2db |
|DBURL |jdbc:oracle:thin:@mydb:1521:mysid|
|DBUSER |user |
|DBPASSWORD |pwd |
|#DBAUTOCOMMIT |true |
|CMD | |
**!
!|Define Properties|GETORDERSTATUS |
|key |value |
|.include |TestDatabase|
|DBConnection |OLDBConnection |
!|SQLCommand |TestDatabase|SELECT af.flowableid as ORDER_NUMBER, tk.description as TASK_DESCRIPTION, DECODE(tk.status, 0, 'NOT_STARTED', 1, 'IN_PROGRESS', 2, 'SUCCEEDED', 3, 'FAILED',5,'NA', tk.status) as STATUS from abstractflowable af, workflow wf, activity act, task tk where af.id=wf.flowable_id(+) and wf.id=act.workflow_id(+) and act.id=tk.activity_id(+) and af.flowableid = '%X%' and tk.description like 'Receive Transport Request from OMS' order by tk.starttime desc|RETRY=50:60000|
|X |ORDER_NUMBER? |TASK_DESCRIPTION? |STATUS? |
|${orderNumber}|${orderNumber} |Receive Transport Request from OMS |SUCCEEDED |
from jdbcslim.
Hi Bhatt,
thanks for sharing.
One pipe symbol is missing:
|define table type |
|SQLCommand | as Table|
from jdbcslim.
Thanks!! It worked!!
from jdbcslim.
Pleasure!
Please 'STAR' jdbcslim if you find it useful.
from jdbcslim.
Related Issues (20)
- Add method to do simple single query
- Issues integrating JDBC Slim into FitNesse HOT 2
- `getRowCount()` should return 0 if first non-header row does not have values HOT 1
- List version 1.2.1 as release on GitHub HOT 2
- Jdbcslim tests are failing on the H2 driver when using maven HOT 9
- result should be empty (no records)
- Question: Connecting to SAP Hana DB using JdbcSlim HOT 12
- SQLCommand - dbExecute:Method not supported HOT 2
- Problem to use SQLCommand HOT 1
- Surplus and Missing rows not reported HOT 2
- Empty row when no records returned in Table:SQLCommand HOT 5
- JdbcSlim not working with CsvDriver
- Show / use resultsheet without header columns HOT 2
- SQLCommand ends in IndexOutOfBoundsException HOT 5
- Trouble with installation regarding root page and suite setup page HOT 3
- JDBC slim with cassandra
- hi Is,this jdbslim support connect hive?
- I'd like a select where you can store the returned value of a cell in a variable HOT 2
- SQLServer binary data column when queried value misses 0x prefix HOT 5
- [CI/CD pipeline] java.lang.Exception: java.lang.RuntimeException: decrypt of *** failed. Wrong Key Store used? HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jdbcslim.