Sybase sql anywhere

[dusky]

Hi friends.
Im going to try setup connection between Mango and Sybase SQL Anywhere. Do you some experiences with ? I dont know what to fill in
Data source form.

[mlohbihler]

Hi Dusky,

Check out this link: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect. You'll need to put the driver jar file into Mango's WEB-INF/lib directory for the reference to the driver class name to work. Check out the contextual documentation for more details.

[dusky]

Hi ...

I have done sucessful connection to my Sybase SQL Anywhere database.
Now I need to know some example how to create data points. For example I have table width 2 columns (room number, actual temperature). How to setup all other necessary fields to get this data into Mango ?

Thanx

[mlohbihler]

Check the documentation. Look for the

[dusky]

Hi mlohbihler

First I would like to thank you for your support.

Now I have correct configuration of sql data source. I can execute
SQL select but after save or data source enabling I receive warning message "Object required". Despite I can create and add data points
but I don't see it in data point list but only in watch list. I can send you
backup of my project if my information aren't sufficient.

BR
Dusky from Slovakia

[mlohbihler]

Hi Dusky,

We can't recreate the problem. What version of Mango are you using, and with which browser?

[dusky]

Hi mlohbihler

I reinstalled all part of Mango and now I able to connect to my sybase database, create and manage data points.

Now I use last stable free wersion 1.4.2, last version of Firefox and last
version of Apache tomcat web server 6.0.18.

After sort time of using Mango in combination with Sybase sql database I have question about sql connections.

Now I have 4 data sources (DS) because I select 4 types of datapoints from one database table (for example: 1st DS [index + 1st column], 2nd [index + 2nd column], and so on).
In my SQL database it consume 4 connection clients of my sql database license.
Is there any way how to do 4 different select from one table in one data source ?

Thanx

[mlohbihler]

Hi Dusky,

It's hard to say without knowing more about the queries you are doing. (If, however, you are asking if there are connection pooling facilities available, the answer currently is no.)

It sounds like you are doing row-bases querying. If so, it may be possible for you to use "union" clauses to combine your queries into one. This should work if your data types are all the same.

For example, you might do something like this:

select id, value from table1
union
select id, value from table2
union...