Oracle generated entities failure

[ipazmino]

Hi,

I'm trying to generate via JBoss Tools in eclipse the entities in my database. I created a Seam project and configured the access to the DB, unfortunately when testing the connection all it does is a ping, and then tried to generate the entities but the following error is shown:

Can't generate seam entities
 org.hibernate.exception.DataException: Error while reading column meta data for SYS.SYSNTwcNCdfWFTEK/T61J7dxvoA==
 Error while reading column meta data for SYS.SYSNTwcNCdfWFTEK/T61J7dxvoA==
 org.hibernate.exception.DataException: Error while reading column meta data for SYS.SYSNTwcNCdfWFTEK/T61J7dxvoA==
 Error while reading column meta data for SYS.SYSNTwcNCdfWFTEK/T61J7dxvoA==
 java.sql.SQLException: ORA-01424: missing or illegal character following the escape character

 ORA-01424: missing or illegal character following the escape character

any ideas why this could be happening?

[maxandersen]

oracle exposes many weird things in their default metadata ;)

you can work around it by setting hibernate.default_schema and we will only look at that.

[ipazmino]

Hi,

I tried adding the database name in the Generate entities dialog box, and also modified the connection string to TESTUSER@localhost:1521:XE

But, as you can see, there is not exactly a db name, but a user that can access some tables in a table space.

So, I'm not really sure what should I set on the database field: the tablespace, the user, or, modifying the connection string.

[maxandersen]

In oracle username == schema

[ipazmino]

Thanks for your time. I still can't get it to function, but I get the error notification much faster than before.

I have set the following config for the driver:

conn url = jdbc:oracle:thin:@localhost:1521:XE
db name = TESTUSER
driver class = oracle.jdbc.driver.OracleDriver
user id = TESTUSER

and for the jdbc conn properties

db = TESTUSER
url = jdbc:oracle:thin:@localhost:1521:XE
user = TESTUSER

the jar where is pointing to the driver is oracles ojdbc14.jar

[maxandersen]

im not talking about the database connection - i'm talking about the default schema setting in hibernate.

hibernate.default_schema in cfg.xml or persistence.xml.

[ipazmino]

Thank you a lot!!!

I didn't understand it was a property,



but now it worked perfectly!!!

[maxandersen]

glad to be of help