| Author |
Curious question JDBC - Mobilink
|
|
| handheldmaster 2006-01-20, 8:24 pm |
| Can mobilink get to the Consolidated using a JDBC type connection (JConnect)
?
9.0.2.3137
| |
| Greg Fenton 2006-01-20, 8:24 pm |
| handheldmaster wrote:
> Can mobilink get to the Consolidated using a JDBC type connection (JConnect)
> ?
>
ML is an ODBC application, it depends on an ODBC driver.
Can you explain what it is you are hoping to do and why the particular
type of driver is important? There may be another way to accomplish it
as ML does have the capability of running Java synchronization scripts.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2006-01-26, 5:00 pm |
| Also note that in Jasper, you'll have the ability to store the upload in a
"upload object" that can be accessed through a Java and .Net API. In
Jasper, you'll be able to access the "upload object" (which contains the
data in the upload) in a Java class. Now that you can do this, you could
define a JDBC connection to your consolidated DB and use jConnect to upload
your data. Note that the same idea applies to download as well. You can
generate your "download object" in a Java class that could be connected to
whatever you want.
PS : Congrats to Greg Fenton and his wife on the birth of their second child
yesterday.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:43d160a9$1@foru
ms-2-dub...
> handheldmaster wrote:
(JConnect)[color=dar
kred]
>
> ML is an ODBC application, it depends on an ODBC driver.
>
> Can you explain what it is you are hoping to do and why the particular
> type of driver is important? There may be another way to accomplish it
> as ML does have the capability of running Java synchronization scripts.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| handheldmaster 2006-01-27, 1:24 pm |
|
> ML is an ODBC application, it depends on an ODBC driver.
>
> Can you explain what it is you are hoping to do and why the particular
> type of driver is important? There may be another way to accomplish it as
> ML does have the capability of running Java synchronization scripts.
>
When using mobilink to synchronize non-ASA and ASA database was thinking if
using Native Java Drivers it will allow mobilink to talk better compared to
an ODBC driver to non-ASA database (DB2 on AS400 iSeries)
| |
| handheldmaster 2006-01-27, 1:24 pm |
| > Jasper, you'll be able to access the "upload object" (which contains the
> data in the upload) in a Java class. Now that you can do this, you could
> define a JDBC connection to your consolidated DB and use jConnect to
> upload
> your data. Note that the same idea applies to download as well. You can
> generate your "download object" in a Java class that could be connected to
> whatever you want.
>
Did not really get what is the working or advantage of this new Jasper
functionality .... are you saying one could completely remove
dbmlsync/mobilink ... and have following data links for synchronization.
Consolidated non-asa db <-- java app with upload & download classes --> asa
remote database
| |
| David Fishburn 2006-01-31, 11:24 am |
| "handheldmaster" <abc@456.com> wrote in news:43da5c7d$1@foru
ms-1-dub of
sybase.public.sqlanywhere.mobilink:
h>> Jasper, you'll be able to access the "upload object" (which contains
h>> the data in the upload) in a Java class. Now that you can do this,
h>> you could define a JDBC connection to your consolidated DB and use
h>> jConnect to upload
h>> your data. Note that the same idea applies to download as well. You
h>> can generate your "download object" in a Java class that could be
h>> connected to whatever you want.
h>>
h> Did not really get what is the working or advantage of this new Jasper
h> functionality .... are you saying one could completely remove
h> dbmlsync/mobilink ... and have following data links for
h> synchronization.
h>
h> Consolidated non-asa db <-- java app with upload & download classes
h> --> asa remote database
No, ML is still there. Instead of writing SQL-based events which use
SELECT/INSERT/UPDATE/DELETE statements whic ML then converts into a data
stream to be downloaded, you can write a .Net or Java script (still
running inside of ML) but it allows you to create the data stream in any
way you want.
So Reg is saying you could use a JDBC driver running inside the ML
server to connect to DB2 and use the API we provide to generate the
download stream on your own.
This effectively allows you to use any JDBC driver (or .Net managed
provider) you like inside of MobiLink.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| handheldmaster 2006-01-31, 1:24 pm |
|
> No, ML is still there. Instead of writing SQL-based events which use
> SELECT/INSERT/UPDATE/DELETE statements whic ML then converts into a data
> stream to be downloaded, you can write a .Net or Java script (still
> running inside of ML) but it allows you to create the data stream in any
> way you want.
>
> So Reg is saying you could use a JDBC driver running inside the ML
> server to connect to DB2 and use the API we provide to generate the
> download stream on your own.
>
> This effectively allows you to use any JDBC driver (or .Net managed
> provider) you like inside of MobiLink.
>
So almost like a proxy table concept... where by controlling the upload &
download streams one can pretty much synchronize with any database. Thinking
the consolidated will remain as "ASA" acting as a repository for ML info and
reaction point for java scripts which are actually interacting with non-ASA
(db2 on iSeries) data.
And of course the next question would be any timelines for when their will
be a community preview download or sorts for Jasper ? and final production
release ?
| |
| David Fishburn 2006-02-01, 9:26 am |
| "handheldmaster" <abc@456.com> wrote in news:43dfb448$1@foru
ms-2-dub of
sybase.public.sqlanywhere.mobilink:
h> And of course the next question would be any timelines for when their
h> will be a community preview download or sorts for Jasper ? and final
h> production release ?
You can sign up for the beta (which should be out in a few months) at:
http://www.ianywhere.com/promos/sqlanybeta/index.html
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| handheldmaster 2006-02-01, 11:25 am |
| > You can sign up for the beta (which should be out in a few months) at:
> http://www.ianywhere.com/promos/sqlanybeta/index.html
Had signed up long back yet to receive any software. Last email I got was
they wanted the .db files as Jasper will require to rebuild these as part
of the upgrade. Did not get any download links yet. Anything else I missed ?
| |
| Chris Keating(iAnywhere Solutions) 2006-02-01, 11:25 am |
| The Beta has not yet started but is expected to start in Q1 2006.
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com
********************
********************
********************
*****************
|
|
|
|