JDBC Receiver Adapter

[Former Member]

Hellow experts,

I am doing a JDBC to Mail Scenario.

In my JDBC Adapter I need to check the current time in the where caluse.

For eample, in the configuration channel, I need to use an sql statement like the following

select a, b from table

<b>where time > currentTime.

or where date > currentDate</b>

Now, I have troubles to define currentTime or Date in the where caluse.

Can someone please point me to the currect syntax.

thank you.

[Former Member]

U can do one thing....create one mor coloumn in ur DB table that will take store Current time and date.

Like if new field in the DB table is <b>CurrentTImeDAte</b>

then in your SQL qurry u can mention that

SELECT a,b from XYZ where CurrentTImeDAte = (current DB time and date.)

Thanks

Farooq

*Reewards Points if u find it useful*

[Former Member]

Hi,

Check Below links for JDBC Sender and receiver adapter

JDBC ADAPTER

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

To install oracle drive in XI server, just check these links,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

http://msdn2.microsoft.com/en-us/library/ms177523.aspx

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20with%20multiple%20tables&cat=sdn_all

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

JDBC RECEIVER ADAPTER

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

phani

Reward points if Helpful

[Former Member]

Sabbir,

Your thread heading is : <b>JDBC Receiver Adapter</b>

and your scenario is :<b> I am doing a JDBC to Mail Scenario. </b>

I didn't get this thing....

Regards,

[VijayKonam]

You would need to mention the SQL query exactly as you mention on the database machine. You can check this in the SQL Query Analyzer. As this query gets executed on SQL server, better to contact your DB conterpart developers for help.

I belive the function to get current date and time is GetDate() in sql.

VJ