I am new to Servoy. I recently installed version 5.2.6 which uses the postgresql database as the default. I was interested in trying the i-Phone application builder solution using our database which is Sybase ASA version 7.0.
When I Save the “New server” connection information with the following URL:
jdbc:sybase:Tds:00.000.00.000:2638?ServiceName=dev&CHARSET=utf8 (actual ip address replaced with zeros)
this message is displayed: “Cannot get a connection, pool error Could not create a validated object”
The jconn2.jar and jconn3.jar files are in the drivers directory under the Servoy\application_server directory.
What should I do?
The IP is not neccesary.
jdbc:sybase:Tds:localhost:2638?ServiceName=DB_Name&CHARSET=utf8
Bob,
The log file (/path/to/servoy/application_server/servoy_log.txt) probably gives more information on the error.
Which driver have you configured in the server editor?
Rob
Thanks for your reply Rob.
I am not sure what you are refering to regarding the server editor.
Where would I configure the driver? (I see jconn2 and jconn3 available jar files under the servoy\application_server\drivers directory.
What I am trying to do is use our database and data with the sample i-Phone solution that I installed. Our database is an ASA database hosted on our network and not a local DB. The i-Phone solution works with the included sample database which uses the installed Postgre DB engine. Do I need to unistall the i-Phone solution and Postgre DB and then install the ASA database connection prior to re-installing the i-Phone soultion?
Thank you,
Bob Olsen
Bob,
The driver editor (the one where you entered the jdbc url) also has a Driver field.
You have placed the jconn2 and jconn3 driver jars in the drivers dir which makes them available to the class path, but you have to tell Servoy which driver class to use.
I think jconn2 and jconn3 are both sybase drivers, of different versions.
You should select the driver class that matches your db and keep the driver jar that contains that driver.
Remove the other one from the drivers dir to prevent clashes.
Rob
Rob,
I went with jconn2. I still receive the same Error message when I enter the jdbc URL and try to connect. Any other suggestions please?
Bob
Well what does the driver field show?
Rob
Rob,
I tried both com.sybase.jdbc2.jdbc.SybDriver as well as com.sybase.jdbc.SybDriver in the driver field.
Bob
Bob,
com.sybase.jdbc2.jdbc.SybDriver should indeed be the one if you are using the jconn2.jar.
Does the /path/to/servoy/application_server/servoy_log.txt give more detail (like sqlexception stacks)?
Rob
Rob,
I am going to uninstall and reinstall Servoy. Then I will try to setup the Sybase ASA database connection before I install the i-Phone solution. I have been trying too many things and I want to start clean.
Then I will look at the servoy_log.txt file along the way and let you know what I see.
Bob
Rob,
Here is the only contents int the servoy_log.txt file after attempting to setup a Sybase ASA database connection:
2011-03-30 14:58:07,640 ERROR [main] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server new_sybase in 1 times
Bob
There is no stacktrace in the same file following that error message?
Rob
No Rob, I started with a clean install and that was the only entry in the log after the connection failure.
Could the problem be with our database setup / parms?
Thanks,
Bob
Hi
We have the same problem now. We created a new SQL Anywhere 12 database. We then created tables and filled the tables with data. The database starts up as well as the Servoy application server. With Sybase Central, we can connect to the newly created database and everything is ok.
But the Servoy application server can NOT put the database server connection online - In menu Database Servers, under the corresponding database server connection, it says: Server status: ERROR: NOT ONLINE. See log for details.
If I look in the log, the errot is: 2011-04-19 16:28:37,632 ERROR [http-8080-1] com.servoy.j2db.server.Zc.Zo - org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object
I am lost - can’t find what’s the problem. I get the error as well when I put the jdbc driver delivered with the SQL Anywhere 12 installation into /Applications/Servoy/application_server/drivers
What does this error message tell me?
Best regards,
Robert,
I just downloaded sybase ianywhere 12, created the demo db and could connect fine, both with the servoy-bundled jconn3.jar and the downloaded one from sybase.
Could it be that your db is not prepared for jconnect, like discussed here?
http://dcx.sybase.com/1101/en/dbprogram … -jdbc.html
Rob
Robert,
How did you manage to connect now?
Rob
Rob
Sorry, I am still busy with the set rowcount n problem. I couldn’t continue with the connection problem, as we first have to resolve the set rowcount n problem. As soon as possbible I will continue on the db connection and report.
Regards, Robert
rgansevles:
Robert,
How did you manage to connect now?
Rob
