SQL Anywhere database - JavaObjectsEnabled

Author

JavaObjectsEnabled

Gouvian V. Bautista B.

2005-10-27, 7:40 am

Hi

I have a data base in asa 9,0 and this contains objects
java, but when putting it to work it says that not this
qualified the option of objects java since I make it work?

Greg Fenton

2005-10-27, 7:40 am

Gouvian V. Bautista B. wrote:
> I have a data base in asa 9,0 and this contains objects
> java, but when putting it to work it says that not this
> qualified the option of objects java since I make it work?

When you say "contains java objects", do you mean you have a column
defined as a Java class or that you have Java stored procedures?

"Java in the database" in SQLAnywhere changed in version 9.x, where
storing Java objects in a column is no longer supported. Java stored
procedures are fully supported still.

Can you post the *exact* error message that you are getting and tell us
where you are seeing it?

Can you also post the exact version and build number of SQLAnywhere that
you are using? (use the command "dbeng9 -v")

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Gouvian V. Bautista B.

2005-10-27, 7:40 am

Hi Greg.

Thanks for your commentaries.

I have columns within the tables in the data base for
information storage, and my version is 9.0.2.3137. If you
comment that no longer she is supported as I can migrate of
8.x to 9.x to work with
ASA and this quality??

> When you say "contains java objects", do you mean you have
> a column defined as a Java class or that you have Java
> stored procedures?
>
> "Java in the database" in SQLAnywhere changed in version
> 9.x, where storing Java objects in a column is no longer
> supported. Java stored procedures are fully supported
> still.
>
> Can you post the *exact* error message that you are
> getting and tell us where you are seeing it?
>
> Can you also post the exact version and build number of
> SQLAnywhere that you are using? (use the command "dbeng9
> -v")
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Greg Fenton

2005-10-27, 7:40 am

Gouvian V. Bautista B. wrote:
>
> I have columns within the tables in the data base for
> information storage, and my version is 9.0.2.3137. If you
> comment that no longer she is supported as I can migrate of
> 8.x to 9.x to work with
> ASA and this quality??
>

Sorry, I am not sure from your response. Do you mean that you are
storing Java objects in one or more columns?

For the announcement of the change of "Java in the database", see:

http://tinyurl.com/7bcr8 [shortcut to docs in ianywhere.com]

Serialized Java objects can still be *stored* as blobs (varbinary) in
the database, but you cannot directly use those objects via SQL (e.g.
"SELECT my_object>>getName() FROM my_table").

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links