hmm, Here is the DB. But as I mentioned before, it has no data, because it's a Linked DB, so its call the data from other DBs (and the other ones are too large to upload.. about 400mb each).
As I said, the program gives me the warnings with just the connection, I'm not even doing querys or calling the data (at that moment, the program stops with errors, because they can't find the connection to the DB).
Hi Gord, you're right , the exception reported depends on the xls tables. Also the way some queries are writen (e.g. [OSS13_RBSW14_RbsLocalCell.localCellId]
instead of
OSS13_RBSW14_RbsLocalCell.localCellId or [OSS13_RBSW14_RbsLocalCell].[localCellId]
is not compatible with ucanaccess but they could be easly made compatible with. Thus no one query is loaded.
Alexis, I'm sorry, for the xls dependent queries, nothing to be done... ucanaccess isn't an xls driver yet.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After I closing this topic, can you tell me Marco how to fix the tables? You told me that UCanAccess don't recognize the way I wrote the queries? How should I put them?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You just have to avoid [tablename.columnname] that isn't recognizable
You can use [tablename].[columnname] or [tablename].columnname or tablename.[columnname] or tablename.columnname(if squre brackets aren't needed). Cheers M.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It's because you can do
select len('ciao') from dual
but not
select len(25) from dual;
workaround when yo use len(integer): select len(25&'') from dual;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi.
I'm getting this warnings:
WARNING:Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.Its a "linked" access db (it calls tables from other dbs). The method to stablish the conection is this one:
Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\Users\P_AApablaza\Documents\NetBeansProjects\EntelGE\DBvinculanteBasica.accdb;singleconnection=true");And obviusly, after those warnings, errors come up..
"net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.3.1 usuario no tiene privilegios suficientes o objeto no encontrado: CONSULTABASEGSM"
Thanks for the help
Last edit: Alexis 2016-01-25
Does Access prompt you for a password if you try and open the .accdb file there?
Last edit: Gord Thompson 2016-01-25
Nope. No password. I made the .accdb
Can you upload that .accdb file so we can try to reproduce the issue?
hmm, Here is the DB. But as I mentioned before, it has no data, because it's a Linked DB, so its call the data from other DBs (and the other ones are too large to upload.. about 400mb each).
As I said, the program gives me the warnings with just the connection, I'm not even doing querys or calling the data (at that moment, the program stops with errors, because they can't find the connection to the DB).
I can't see CONSULTABASEGSM in this db. May you open the db with the ucanaccess console and copy/post the logs that come out?
Inside that base, CONSULTABASE is QBasicaOSS13_2G (I just renamed it).
How do I open the db with ucancacces console? (I will search in the forum, but If I don't find it..)
PS: My problem is very simmilar to this one: https://sourceforge.net/p/ucanaccess/discussion/help/thread/85e8e178/
Last edit: Alexis 2016-01-26
Just click on the console.bat (or console.sh, on linux ) in the distribution after having unzipped it, and edit the full database file path
My tests suggest that the "WARNING:Decoding not supported." messages are related to the table links that point to Excel documents:
[Activos_2G]
[Activos_LTE]
[Avtivos_3G]
... which point to "Listado_Red_Nacional_2G_3G_LTE.xlsx", and
[Planet_Antennas]
[Planet_Sectors]
... which point to "export_Planet_activos_W03.xls".
Console:
Last edit: Alexis 2016-01-26
Hi Gord, you're right , the exception reported depends on the xls tables. Also the way some queries are writen (e.g. [OSS13_RBSW14_RbsLocalCell.localCellId]
instead of
OSS13_RBSW14_RbsLocalCell.localCellId or [OSS13_RBSW14_RbsLocalCell].[localCellId]
is not compatible with ucanaccess but they could be easly made compatible with. Thus no one query is loaded.
Alexis, I'm sorry, for the xls dependent queries, nothing to be done... ucanaccess isn't an xls driver yet.
Ok, so no xls =(
Much thanks both!!!
After I closing this topic, can you tell me Marco how to fix the tables? You told me that UCanAccess don't recognize the way I wrote the queries? How should I put them?
You just have to avoid [tablename.columnname] that isn't recognizable
You can use [tablename].[columnname] or [tablename].columnname or tablename.[columnname] or tablename.columnname(if squre brackets aren't needed). Cheers M.
Dear Marco and Gord,
I removed the xls files from the DB. Also I looked all the querys removing the [xxx.xx] format. But I still get the wernings. =/
The Console:
As I can see, the queries are not being loaded. And I don't understand why =/
Last edit: Alexis 2016-01-27
It's because you can do
select len('ciao') from dual
but not
select len(25) from dual;
workaround when yo use len(integer): select len(25&'') from dual;
You might also want to do a "Compact and Repair Database" operation in Access to remove any artifacts related to the objects you deleted.
Much thanks guys! No errors now. **Topic Solved ** =)